Job Title: Azure Data Factory (ADF) Engineer

Employment Type: Full-time (FTE with HMG)

Location: Remote (India)

Experience: 5+ years

Working Hours: UK Shift (UK Working Hours)

Salary: ₹10.0 – ₹14.0 Lakhs per annum

Job Overview

We are looking for an experienced Azure Data Factory Engineer to join our team on a full-time basis. In this role, you will design, build, and optimize data integration solutions using Azure Data Factory, Azure Data Lake, SQL Server, and related cloud data stack services. Experience with UiPath / Robotic Process Automation (RPA) is a strong added advantage.

Key Responsibilities

- ETL/ELT Pipeline Development: Design, build, test, and maintain enterprise data pipelines using Azure Data Factory (ADF).
- Data Integration & Storage: Integrate disparate data sources (SQL, API, Flat Files, NoSQL) into Azure Data Lake / Azure SQL / Synapse.
- Database & Query Optimization: Write complex SQL scripts, stored procedures, and optimize query performance.
- RPA & Automation (Preferred): Leverage UiPath where applicable to automate data ingestion from legacy web portals or desktop workflows.
- Monitoring & Maintenance: Monitor daily data pipeline executions, troubleshoot pipeline failures, and optimize pipeline execution time and cost.




- CI/CD & Deployment: Implement data pipeline deployment using Azure DevOps, version control, and CI/CD practices.
- Stakeholder Collaboration: Work closely with cross-functional teams and UK stakeholders during UK business hours.

Required Qualifications & Skills

- Experience: 5+ years of total experience in data engineering/ETL development.
- Core Azure Tech Stack: Hands-on expertise in Azure Data Factory (ADF), Azure Data Lake Storage (ADLS Gen2), and Azure SQL Database.
- SQL Mastery: Strong command over SQL, stored procedures, schema design, and performance tuning.
- Cloud Architecture: Clear understanding of data warehousing concepts, ETL design patterns, and cloud data architecture.
- Communication: Excellent verbal and written English communication skills for effective collaboration with international stakeholders.

Valuable to Have / Bonus Skills

- UiPath: Working knowledge or hands-on experience with UiPath / RPA automation tools.
- DevOps: Experience with Azure DevOps pipelines, Git version control, and ARM/Bicep templates.
- Transformation Tools: Experience with Databricks, PySpark, or Azure Synapse Analytics.

📌 Azure Data Factory (ADF) Engineer (India)
🏢 HMG America
📍 India