Senior Data Engineer

Zensar Technologies; Bengaluru South; On-site; INR 1,200,000 - 1,900,000; Full time

Job summary

Zensar Technologies in Bengaluru seeks a Senior Data Engineer to design, build, and own end-to-end production pipelines powering analytics and decision-making. The role emphasizes deep Python and SQL expertise, transaction-level fact tables, and rigorous data quality and auditability, ideally in finance, risk, or compliance domains.

Internal candidates familiar with Uber's data stack will be prioritized. Responsibilities include owning data architecture, end-to-end pipeline deployment, and

Qualifications

• 6+ years in data engineering.
• End-to-end production ownership of data pipelines.
• Expert-level Python + SQL with cross-dialect capabilities.
• Experience with finance, risk or compliance data.
• Design and build transaction/fact tables.
• Strong data quality and auditability practices.

Responsibilities

• Own data architecture and system design decisions for pipelines and data models.
• Take end-to-end ownership of pipelines in production: design, build, deploy, monitor, and operate.
• Design and build transaction tables alongside standard models using medallion architecture.
• Build and support pipelines for finance, risk, or compliance use cases requiring auditability.
• Implement data quality controls, validation, reconciliation, and audit trails.
• Write complex, cross-dialect SQL (MySQL + PostgreSQL).
• Build idempotent reload patterns and templated SQL for late-arriving data.
• Orchestrate DAGs with secure credential handling via uSecret.
• Build Python ETL tooling with pandas, SQLAlchemy, and type hints.
• Integrate with Google Drive/Sheets; build YAML-driven pipeline configs.
• Own CI/CD for pipelines via standard Git workflows.
• Use Uber's internal stack day-to-day: OneETL, Piper/uWorc, Databook, uSecret, DSW, SourceGraph, Query Builder.

Skills

Python & SQL

Data architecture

End-to-end pipelines

Cross-dialect SQL

Auditability

Airflow-like orchestration

Pandas / ETL tooling

CI/CD of pipelines

Tools

Piper/uWorc

Databook

uSecret

DSW notebooks

SourceGraph

Query Builder

OneETL

Job description

We're looking for a Senior Data Engineer with strong data architecture and system design skills to design, build, and own end-to-end production pipelines powering analytics and decision-making across the org. The role centers on deep Python + SQL expertise, robust transaction-level fact tables, and rigorous data quality and auditability, ideally within a finance, risk, or compliance data domain. Internal candidates familiar with Uber's data platform stack (Piper/uWorc, Databook, uSecret, DSW, SourceGraph, Query Builder, OneETL) will be prioritized.

We're looking for a Senior Data Engineer with strong data architecture and system design skills to design, build, and own end-to-end production pipelines powering analytics and decision-making across the org. The role centers on deep Python + SQL expertise, robust transaction-level fact tables, and rigorous data quality and auditability, ideally within a finance, risk, or compliance data domain. Internal candidates familiar with Uber's data platform stack (Piper/uWorc, Databook, uSecret, DSW, SourceGraph, Query Builder, OneETL) will be prioritized.

Responsibilities

• Own data architecture and system design decisions for pipelines and data models - grain, partitioning, schema evolution, and scalability tradeoffs.
• Take end-to-end ownership of pipelines in production: design, build, deploy, monitor, and operate.
• Design and build transaction tables (append-only, immutable event/transaction-grain fact tables) alongside standard fact/dimension models using medallion (bronze/silver/gold) architecture.
• Build and support pipelines for finance, risk, or compliance use cases where accuracy, auditability, and data lineage are critical.
• Implement data quality and auditability controls: validation checks, reconciliation logic, anomaly detection, and audit trails for every pipeline you own.
• Write complex, cross-dialect SQL (MySQL + PostgreSQL): window functions, multi-layered CTEs, CASE-driven logic, COALESCE/NULLIF, type casting, and date/timestamp handling.
• Build idempotent reload patterns (DELETE+INSERT), UNION ALL/set operations, and templated (Jinja-style) SQL including handling for late-arriving/corrected transaction records without double-counting.
• Orchestrate Airflow-style DAGs (Pipeline/BaseTask, ExternalTaskSensor for cross-pipeline deps) with secure credential handling via uSecret.
• Build Python ETL tooling: pandas (CSV DB), SQLAlchemy + raw drivers (MySQLdb, psycopg2), type hints/dataclasses, class-based pipeline design.
• Integrate with Google Drive/Sheets APIs; build YAML-driven pipeline configs; handle Piper staging/user_staging quirks.
• Own CI/CD for pipelines via standard Git workflows.
• Use Uber's internal stack day-to-day: OneETL for pipeline authoring, Piper/uWorc for scheduling, Databook for lineage, uSecret for credentials, DSW notebooks for CSV/table work, SourceGraph for code search, Query Builder for ad hoc SQL.

Qualifications

• 6+ years in data engineering.
• Strong data architecture and system design skills to make sound tradeoffs on modeling, partitioning, and scalability, not just write queries.
• Demonstrated end-to-end production ownership of data pipelines from design through deployment, monitoring, and operational support.
• Expert-level Python + SQL as the primary toolset. Hive/Hadoop is a nice-to-have only.
• Robust data quality and auditability practices - validation, reconciliation, anomaly detection, audit trails.
• Experience working with finance, risk, or compliance data - comfort with the heightened accuracy, auditability, and data-lineage requirements typical of these domains.
• Proven experience designing and building transaction/fact tables.
• Expert SQL (window functions, CTEs, CASE logic, cross-dialect MySQL/PostgreSQL).
• Strong Python (pandas, SQLAlchemy, type hints/dataclasses, class-based pipelines).
• Airflow-like orchestration experience (Piper/uWorc a plus).
• Solid data modeling fundamentals (fact/dim, normalization, medallion architecture).
• YAML-based config experience; standard CI/CD and Git workflows.

About Us

At 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.