Design and build scalable data pipelines and architectures on Azure using ADF, Databricks, and Synapse. Implement Kimball/Data Vault modeling, write ETL in Python and T-SQL, ensure data governance (Azure Purview), automate tests, troubleshoot issues, document processes, and collaborate across teams.
As a Data Engineer, you will play a crucial role in designing and developing data-driven solutions for our clients. Your expertise in data exploration, Python, and SQL will be utilized to create efficient and scalable data pipelines. With a focus on Azure, you will leverage its data products and services to build robust and secure data architectures. Your role is key in ensuring data integrity, performance, and governance, while also contributing to the overall success of our data-centric projects.
Responsibilities
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
- Design and develop data pipelines and architectures using Azure Data Factory, Databricks, and Synapse Analytics.
- Implement data warehouse modeling methodologies, including Kimball and Data Vault 2.0, to ensure efficient data storage and retrieval.
- Write automated tests for data pipelines to maintain data integrity and quality.
- Utilize Python and T-SQL for ETL development and data wrangling, especially in Databricks.
- Collaborate with cross-functional teams to understand business requirements and translate them into technical data solutions.
- Ensure data governance practices are followed, including the use of Azure Purview or similar tools.
- Stay updated with the latest data engineering technologies and best practices, and contribute to the continuous improvement of our data practices.
- Document and communicate data-related processes and decisions to stakeholders.
- Troubleshoot and resolve data-related issues, and provide timely support to the team.
- Actively participate in code reviews and provide constructive feedback to ensure high-quality data engineering work.
- Bachelor's or Master's degree in Computer Science, Engineering, or a related field.
- 8+ years of experience in data engineering or a similar role, with a strong focus on Azure technologies.
- Proficiency in Python for ETL development and data wrangling, and experience with Databricks.
- Excellent knowledge of SQL programming, including stored procedures and functions.
- Experience with data warehouse modeling methodologies, such as Kimball or Data Vault 2.0.
- Familiarity with Azure Data Factory, Databricks, Synapse Analytics, and ADLS Gen2 is a must.
- Strong analytical and problem-solving skills, with the ability to work independently and manage multiple tasks.
- Excellent communication skills, both written and verbal, to effectively collaborate with cross-functional teams.
- A proactive and self-motivated attitude, with a passion for data engineering and a desire to stay updated with industry trends.
- Experience with source control (e.g., Git) and ADO is preferred.
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
Similar Jobs
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Design, build, and maintain cloud-native data pipelines and ETL/ELT workflows for high-volume trade lifecycle data. Integrate DTCC sources (RTTM, Settlement Web) into a Unified Trade Record, process ISO 15022 messages, manage trade exception databases, optimize SQL Server performance, and ensure data quality, lineage, governance, and observability while collaborating with business stakeholders.
Top Skills:
AWSDockerDtcc RttmDtcc Settlement WebEksEltETLFixFxmlIbm MqIndexingIso 15022KafkaKubernetesRdsRest ApiS3SQLSQL ServerStored ProceduresUnified Trade Record (Utr)
Information Technology
Design and develop data-driven solutions and scalable data pipelines using Python and SQL. Leverage Azure data products to build robust, secure architectures, ensuring data integrity, performance, and governance while supporting data-centric client projects.
Top Skills:
AzurePythonSQL
Information Technology
Design, build, and maintain scalable ETL/data pipelines and data management blueprints. Ingest, transform, and curate large complex datasets for analytics, support cloud (AWS) implementations, enable downstream consumers, and provide technical leadership and operational support to ensure data governance, quality, and automation.
Top Skills:
APIsAWSBashCronDb2DevOpsDynamoDBEtl FrameworksIbm VsamJavaJSONKanbanPsqlPythonRSafeSASScrumSparkSQLSsisSsrsTsqlXML
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.

