Design and support batch and incremental data ingestion pipelines, ETL workflows, SQL transformations, and Airflow orchestration. Troubleshoot data quality, reconciliation, lineage, discrepancies, and production incidents. Support cloud data migrations, validate data across systems, collaborate with stakeholders, and develop reusable engineering components using BigQuery, SQL, Python, Airflow, and GCP services.
Key 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, 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.
- 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
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
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Principal Software Engineer role focused on building and developing Atlassian’s Trusted Data Platform. The position is full-time and based in Bengaluru, India, with remote flexibility. The provided description emphasizes Atlassian’s distributed-first work model, virtual interviews and onboarding, and location flexibility for eligible employees.
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Lead the technical evolution of Atlassian’s data engineering capabilities by architecting scalable batch and streaming data solutions. Direct complex engineering efforts, improve data quality and productivity, establish technical direction, and coordinate implementation across teams. Mentor and coach data engineers while partnering cross-functionally to support data-driven business decisions and long-term platform scalability.
Top Skills:
Apache AirflowApache FlinkApache HiveApache KafkaSparkAws AthenaAws EmrAws RedshiftDatabricksKappa ArchitectureLambda ArchitectureMaster Data ManagementMicroservicesSQL
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Build and operate Atlassian’s high-scale data platform across streaming ingestion and MPP query systems. Develop production-quality code, own features and fixes, participate in on-call support, debug production issues, tune performance and data quality, review code, document systems, and collaborate with partner teams. The role requires distributed-systems fundamentals, strong programming skills, cloud data infrastructure experience, and familiarity with Flink or MPP query engines.
Top Skills:
Apache DorisApache PinotAWSDruidFlinkGCPJavaPythonScalaStarrocksTrino
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.
