Location: Dubai, United Arab Emirates
Job Category: IT & Software
Job Role: ETL Developer
Experience Required: 9+ years
Notice Period: Immediate to 30 days
Qualification: Bachelor’s Degree in IT, Computer Science, or a related field
Job Overview
An opportunity is available for an experienced ETL Developer in Dubai, UAE. The role focuses on building and maintaining enterprise data pipelines and Data Warehouse solutions across on-premises and cloud environments.
Candidates should have strong hands-on expertise in SSIS, Azure Data Factory (ADF), Microsoft SQL Server, and Microsoft Fabric, along with advanced SQL and Data Warehousing knowledge.
Key Responsibilities and Technical Expertise
- Build and maintain enterprise data pipelines and Data Warehouse solutions.
- Integrate and orchestrate SSIS packages through Azure Data Factory.
- Work with Microsoft Fabric technologies, including Data Warehouse, Lakehouse, OneLake, and Data Pipelines.
- Develop and optimize advanced T-SQL queries and stored procedures.
- Perform indexing and database performance tuning.
- Implement dimensional data modelling using Star and Snowflake schemas.
- Work with Slowly Changing Dimensions (SCD) Types 1 and 2.
- Manage data storage using Azure Data Lake Storage Gen2 and Azure Blob Storage.
- Implement incremental loading, data validation, reconciliation, and error handling.
Mandatory Requirements
- 9+ years of relevant experience.
- Strong hands-on expertise in SSIS, Azure Data Factory (ADF), and Microsoft SQL Server.
- Experience integrating and orchestrating SSIS packages through ADF.
- Practical experience with Microsoft Fabric:
- Data Warehouse
- Lakehouse
- OneLake
- Data Pipelines
- Advanced T-SQL, stored procedures, indexing, and performance tuning.
- Data Warehousing and dimensional modelling.
- Knowledge of Star and Snowflake schemas and SCD Types 1 and 2.
- Experience with Azure Data Lake Storage Gen2 and Azure Blob Storage.
- Expertise in incremental loading, data validation, reconciliation, and error handling.
Good-to-Have Skills
- PySpark and Spark.
- Power BI.
- Data governance.
- Migration of on-premises Data Warehouses to Azure or Microsoft Fabric.
Educational Qualifications
- Bachelor’s degree in IT, Computer Science, or a related field.
- Microsoft Azure or Fabric certifications are an advantage.
Job Details
- Position: ETL Developer
- Location: Dubai, UAE
- Experience: 9+ years
- Notice Period: Immediate to 30 days
- Mandatory Tools: SSIS, ADF, SQL Server, Microsoft Fabric
- Cloud Storage: ADLS Gen2, Azure Blob Storage
- Qualification: Bachelor’s Degree in a related field