Job Title : ETL Developer (Azure & On-Premises)
Work Location : Remote
Experience : 5-9 Yrs
Job Mode : Remote
We are seeking an experienced ETL Developer with expertise in building and managing ETL processes across Azure and on-premises environments. The ideal candidate will have a strong background in data integration,
transformation, and migration processes, specifically within hybrid environments, and will be comfortable using Python alongside other ETL tools.
This role requires hands-on experience in creating efficient, robust ETL solutions that support both operational and analytical needs.
Design, develop, and maintain ETL processes to extract, transform, and load data between on-premises SQL Server databases and Azure-based solutions.
Collaborate with data engineers, database administrators, and data analysts to ensure data consistency and availability.
Optimise ETL jobs for performance and ensure best practices in data quality and integrity.
Utilise Python for data transformation, automation scripts, and custom data processing tasks.
Manage data pipelines and workflows in a hybrid cloud environment, integrating on-premises and Azure resources.
Monitor ETL processes, troubleshoot failures, and implement failover and recovery strategies.
Document ETL procedures and solutions thoroughly to ensure transparency and continuity across the team.
Required Skills and Qualifications:
Bachelor’s degree in Computer Science, Data Engineering, or a related field.
3+ years of experience developing ETL processes, including experience with both on-premises and cloud-based (Azure) ETL solutions.
Proficiency in Python for ETL scripting and automation.
Strong experience with SQL Server and familiarity with replication, indexing, and optimisation techniques.
Knowledge of Azure services like Azure Data Factory, Azure SQL Database, and Data Lake.
Experience with ETL tools such as SSIS, Azure Data Factory, or other relevant platforms.
Understanding of data warehousing concepts and data modelling, particularly in hybrid and cloud environments.
Excellent problem-solving skills and attention to detail.
Experience in health data operations and familiarity with related processes.
Knowledge of Power BI and experience in data visualisation.
Familiarity with DevOps practices and CI/CD pipelines for ETL process deployment.
