Develop and support batch and incremental data pipelines, ETL workflows, SQL transformations, and Airflow orchestration. Investigate data quality issues, perform lineage and reconciliation analysis, support cloud data migrations, validate datasets, resolve production incidents, and build reusable data engineering components. Collaborate with stakeholders and technical teams on data requirements, modernization, monitoring, and process improvements.
ETL/ELT Pipeline Development: Build and maintain data pipelines extracting from Martech Platforms.
MarTech & CDP Integration: Manage Customer Data Platforms (CDPs) and associated tools
Identity Resolution & Attribution: Manage user stitching, PII-compliant data handling
Data Quality & Governance: Ensure data lineage, schema validation, and reliable monitoring using orchestration tools like Apache Airflow
ResponsibilitiesKey Responsibilities
- Design, develop, and support batch and incremental data ingestion pipelines into the data lake.
- Develop and optimize complex SQL queries, data transformations, and ETL workflows.
- Build, maintain, and monitor Airflow DAGs for orchestration and workflow automation.
- Analyze and troubleshoot data quality, data reconciliation, and pipeline execution issues.
- Perform end-to-end data lineage analysis and trace data from source systems to downstream consumers.
- Debug data discrepancies by investigating source systems, transformation logic, and target datasets.
- Support data migration and modernization initiatives from legacy platforms to cloud-based data platforms.
- Work closely with business stakeholders, architects, and upstream/downstream teams to understand data requirements.
- Validate data completeness, accuracy, and consistency across multiple systems.
- Participate in production support activities and resolve data-related incidents within SLA timelines.
- Develop reusable data engineering components and recommend process improvements.Required Skills
- SQL / PL/SQL
- Complex joins, CTEs, analytical functions
- Query optimization and performance tuning
- Data modeling and database concepts
- BigQuery
- Query development and optimization
- Partitioning and clustering concepts
- Data loading and transformation techniques
- ETL/Data Engineering
- Data ingestion patterns (Batch and Incremental)
- Data transformations and validations
- Data quality checks and reconciliation
- Apache Airflow
- Developing and troubleshooting DAGs
- Scheduling, monitoring, and dependency management
- Python
- Basic to intermediate scripting
- Data processing and automation
- Cloud Platforms (Preferably GCP)
- Cloud Storage
- BigQuery
- Composer/Airflow
- Strong analytical and problem-solving skills.
- Ability to independently investigate and resolve data issues.
- Good communication and stakeholder management skills.
- Experience in cloud data lake or warehouse environments.
- Exposure to customer, transactional, or enterprise-scale datasets is preferred.
- Advanced SQL/PLSQL
- ETL & Data Pipeline Design
- BigQuery Concepts
- Data Debugging & Root Cause Analysis
- Airflow DAG Development
- Python Basics
- Data Migration & Data Validation
- Source-to-Target Traceability and Data Lineage
Must Have: SQL/PLSQL, BigQuery/Cloud Data Warehouse, ETL, Data Analysis & Debugging
Good to Have: Airflow DAG Development, Python, GCP Services
Kafka, Pub/Sub optional
About UsAt Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.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.
Zensar Technologies Pune, Mahārāshtra, IND Office
Zensar Knowledge Park, Kharadi, Plot # 4, MIDC, Pune, Maharashtra, India, 411014
Zensar Technologies Pune, Maharashtra, IND Office
Pune, India
Similar Jobs
Information Technology
Designs and manages scalable data platforms, pipelines, ETL/ELT frameworks, data warehouses, data lakes, and lakehouse architectures. Develops batch and real-time processing solutions using cloud-native services and big data technologies. Ensures data quality, governance, security, and compliance while optimizing large-scale data performance. Supports analytics, reporting, and AI/ML initiatives, contributes to architecture reviews, automates deployments through CI/CD, provides technical leadership, and mentors junior engineers.
Top Skills:
Amazon EmrAmazon RedshiftAmazon S3Apache KafkaSparkAws GlueAzure Data FactoryAzure Data Lake StorageAzure DatabricksAzure DevopsAzure Sql DatabaseAzure Synapse AnalyticsCi/CdDelta LakeGitGoogle BigqueryGoogle Cloud StorageGoogle DataflowHadoopJenkinsAzureMicrosoft FabricMySQLOraclePostgresPysparkPythonScalaShell ScriptingSnowflakeSQLSQL Server
Information Technology
Build and support batch and incremental data pipelines, ETL workflows, Airflow DAGs, and BigQuery transformations. Ensure data quality, lineage, reconciliation, and governance across source and downstream systems. Troubleshoot pipeline failures and data discrepancies, support cloud migration initiatives, collaborate with stakeholders, and provide production support while developing reusable engineering components.
Top Skills:
Apache AirflowBigQueryCdpCloud ComposerEltETLGoogle Cloud PlatformGoogle Cloud StorageMartech PlatformsPl/SqlPythonSQL
Marketing Tech
Design, build, and maintain scalable ETL and ELT pipelines, data transformations, and analytics-ready datasets. Integrate data from databases, APIs, files, SharePoint, and cloud storage. Implement quality checks, monitoring, logging, alerts, and production troubleshooting. Optimize processing performance, cost, and reliability while documenting data mappings and operational procedures. Collaborate with BI analysts, application teams, and stakeholders to deliver dependable data solutions.
Top Skills:
Apache AirflowSparkApache SupersetAws AthenaAws EmrAws S3CsvDelta LakeDremioEltEmr ServerlessETLGitJSONParquetPower BIPysparkPythonRest ApisSharepointSQLTrino
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.

