Backend Developer (SQL, Oracle, R, Python) - Contract
Summary
Designs and maintains ETL pipelines, writes SQL queries, and cleans/integrates data for utility systems using Oracle, MS SQL, R, and Python.
Qualifications:
- ETL Developer with more than 3 years working experience and has skills in in SharePoint, Oracle, MS SQL, R, and Python development.
- The consultant shall have working experience and/or certifications related to Software Engineering Body of Knowledge (SWEBOK), software development lifecycle, ICT disciplines, Sharepoint.
- At least 2-3 years working experience in implementing power utility systems
Having Front-End knowledge is a plus: PowerBI, PowerApps, Power Automate
Job Description:
The Back-end (ETL) Developer shall design, build, and implement extraction, transformation, and loading data pipelines. Key duties include writing SQL queries, cleaning data, data integration, and troubleshooting pipeline performance.
Data Extraction: Pulling raw data from various sources: operational systems, apps, databases, and flat files
Data Transformation and Integration: Cleaning, reformatting, standardizing, and combining data to deliver business needs
Data Loading: Storing the processed, ready-to-use data into a target data repository.
Pipeline Monitoring: Tracking automated job runs, finding errors, and fixing failed data flows.
Optimization: Tuning SQL queries and improving process speed for large datasets.