Design, develop, and maintain scalable ETL/ELT pipelines and data integration solutions using Azure Databricks, ADF, and SSIS. Optimize performance, ensure data quality and governance, support reporting/analytics, monitor production pipelines, and migrate legacy ETL to Azure platforms while collaborating with stakeholders.
This role is for one of the Weekday's clients
Salary range: Rs 500000 - Rs 2000000 (ie INR 5 - 20 LPA)
Min Experience: 5+ years
Location: Mumbai, Maharashtra, India
JobType: full-time
We are looking for an experienced Data Engineer to design, develop, and maintain scalable data pipelines and enterprise-grade data integration solutions. The ideal candidate will have strong expertise in Microsoft Azure data services, particularly Azure Databricks, Azure Data Factory (ADF), and SQL Server Integration Services (SSIS). You will work closely with data architects, analysts, and business stakeholders to build reliable data platforms that support reporting, analytics, and business intelligence initiatives.
This role requires hands-on experience in data transformation, ETL/ELT development, cloud-based data engineering, and performance optimization. The ideal candidate should be passionate about building high-quality, scalable, and efficient data solutions while ensuring data accuracy, security, and governance.
RequirementsKey Responsibilities
- Design, develop, and maintain robust ETL/ELT pipelines for ingesting, transforming, and loading data from multiple sources.
- Build and optimize scalable data processing solutions using Azure Databricks and Apache Spark.
- Develop and manage workflows using Azure Data Factory for orchestrating enterprise data movement and transformation.
- Create, maintain, and enhance SQL Server Integration Services (SSIS) packages for on-premises and hybrid data integration requirements.
- Develop optimized SQL queries, stored procedures, views, and database objects to support reporting and analytics.
- Collaborate with business teams to understand data requirements and translate them into technical solutions.
- Ensure data quality through validation, cleansing, reconciliation, and monitoring processes.
- Optimize pipeline performance, troubleshoot bottlenecks, and implement best practices for scalability and reliability.
- Integrate structured and semi-structured data from multiple enterprise systems.
- Monitor production data pipelines, resolve failures, and implement proactive monitoring mechanisms.
- Participate in code reviews, documentation, and knowledge-sharing initiatives.
- Follow data governance, security, compliance, and best practices throughout the data lifecycle.
- Support migration of legacy ETL processes to modern Azure-based data platforms where applicable.
- 5–8 years of experience in Data Engineering or ETL Development.
- Strong hands-on expertise in Azure Databricks.
- Extensive experience with Azure Data Factory (ADF).
- Proficiency in SQL Server Integration Services (SSIS).
- Strong SQL programming skills with experience in query optimization and performance tuning.
- Experience developing scalable ETL/ELT pipelines.
- Good understanding of Azure Data Lake Storage and cloud-based data architectures.
- Experience with Apache Spark using PySpark or Spark SQL.
- Strong knowledge of relational databases and data warehouse concepts.
- Familiarity with data modeling, data transformation, and data integration techniques.
- Experience with source control systems such as Git.
- Strong analytical, troubleshooting, and problem-solving skills.
- Experience with Azure Synapse Analytics.
- Knowledge of Azure SQL Database or SQL Server administration.
- Familiarity with Delta Lake architecture.
- Experience with CI/CD pipelines for Azure data solutions.
- Exposure to Power BI or other business intelligence tools.
- Understanding of DevOps practices for data engineering.
- Experience working with REST APIs and data ingestion from external systems.
- Knowledge of data governance, security, and compliance standards.
- Familiarity with Agile/Scrum development methodologies.
- Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.
- Microsoft Azure Data Engineer certification is an added advantage.
- Excellent communication and stakeholder management skills.
- Ability to work independently while collaborating effectively within cross-functional teams.
- Strong commitment to delivering high-quality, scalable, and maintainable data engineering solutions.
Similar Jobs
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Develop, test, and maintain Python- and SQL-based data pipelines and ETL/ELT processes on Google Cloud Platform. Build BigQuery transformations, support data warehouse modeling, troubleshoot data quality issues, document solutions, and collaborate with engineers and analysts. The role requires strong GCP data engineering experience, including BigQuery and Pub/Sub, with preferred experience in Cloud Composer, Dataflow, Cloud Functions, Git, and Google Cloud certification.
Top Skills:
Apache AirflowBigQueryCloud ComposerCloud FunctionsDataflowGitGoogle Cloud Platform (Gcp)Pub/SubPythonSQL
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Administer and optimize Cloudera CDP/CDH environments and enterprise data-processing workloads. Develop PySpark and Python solutions, build CI/CD pipelines with Jenkins and Git repositories, integrate security and code-quality tools, optimize Hive and Impala SQL, monitor platform health, perform upgrades, troubleshoot issues, and implement security, access management, governance, and high-availability practices.
Top Skills:
BitbucketCdeCheckmarxCi/CdCloudera CdhCloudera CdpGitHadoopHdfsHiveHueImpalaJenkinsLinuxPysparkPythonSastSparkSQLYarn
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Analyze business and user requirements across financial services value streams, define technical requirements, develop cloud solution options, and manage business and IT stakeholders. The role requires understanding existing framework capabilities, complex data models, cross-functional solution design, clear documentation, team coordination across regions, and familiarity with the SDLC from design through testing and implementation.
Top Skills:
Google Cloud Platform
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
