Data Engineer

Posted Yesterday
Be an Early Applicant
2 Locations
In-Office or Remote
Entry level
Information Technology
The Role
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.
Summary Generated by Built In

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

Responsibilities

Key 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
Strong Expertise
  • 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
Good to Have
  • 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
QualificationsPreferred Candidate Profile
  • 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.
Screening Focus Areas
  1. Advanced SQL/PLSQL
  2. ETL & Data Pipeline Design
  3. BigQuery Concepts
  4. Data Debugging & Root Cause Analysis
  5. Airflow DAG Development
  6. Python Basics
  7. Data Migration & Data Validation
  8. 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.

Skills Required

  • Strong expertise in SQL and PL/SQL, including complex joins, CTEs, analytical functions, query optimization, and performance tuning
  • Knowledge of data modeling and database concepts
  • Experience with BigQuery, including query development, optimization, partitioning, clustering, data loading, and transformations
  • Experience designing ETL and data ingestion pipelines using batch and incremental patterns
  • Experience with data transformations, validation, quality checks, and reconciliation
  • Experience analyzing and debugging data discrepancies, pipeline issues, and root causes
  • Experience with data lineage and source-to-target traceability
  • Experience in cloud data lake or data warehouse environments
  • Apache Airflow DAG development and troubleshooting
  • Python scripting for data processing and automation
  • Experience with Google Cloud Platform services, Cloud Storage, BigQuery, or Cloud Composer
  • Strong analytical and problem-solving skills
  • Ability to independently investigate and resolve data issues
  • Good communication and stakeholder management skills
  • Experience with customer, transactional, or enterprise-scale datasets
  • Experience supporting data migration and modernization initiatives

Zensar Technologies Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Zensar Technologies and has not been reviewed or approved by Zensar Technologies.

  • Retirement Support — A 401(k) with company match and immediate vesting is highlighted, with broad fund options available.
  • Wellbeing & Lifestyle Benefits — Work-life balance, remote/hybrid flexibility, and supportive teams are emphasized as strengths that enhance the overall experience.
  • Parental & Family Support — Inclusive policies such as parental leave and access to EAP and dependent medical coverage are promoted across regions.

Zensar Technologies Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Pune, Maharashtra
10,000 Employees
Year Founded: 2001

What We Do

Zensar is a leading experience, engineering, and technology solutions company. We conceptualize, build, and manage digital products for Forbes Global 2000 clients across the hi-tech engineering, banking and financial services, insurance, manufacturing and consumer services verticals. With proven excellence across five core areas, including experience services, advanced engineering services, data engineering and analytics, foundation services, and application services, our solutions leverage industry-leading platforms to help our clients be competitive, agile, and disruptive while moving with velocity through change and opportunity. Zensar’s expansive ecosystem of 60+ technology partners, including Oracle, Salesforce, SAP, Guidewire, Automation Anywhere, Adobe, and UiPath, enables us to deliver comprehensive solutions to clients, facilitating seamless integration and allowing them to leverage cutting-edge technologies and tools for enhanced business outcomes. Zensar is part of the USD 4.4 billion RPG Group. With headquarters in Pune, India, our 10,500+ employees, representing over 50 nationalities, work from 30+ locations across North America, UK/Europe, and South Africa. Visit us at www.zensar.com

Similar Jobs

Zensar Technologies Logo Zensar Technologies

Data Engineer

Information Technology
In-Office or Remote
2 Locations
10000 Employees

Zensar Technologies Logo Zensar Technologies

Data Engineer

Information Technology
In-Office or Remote
2 Locations
10000 Employees

Sago Logo Sago

Data Engineer

Marketing Tech
In-Office or Remote
Gurugram, Haryana, IND
876 Employees

Atlassian Logo Atlassian

Principal Software Engineer

Cloud • Information Technology • Productivity • Security • Software • App development • Automation
In-Office or Remote
560071, Domlur, Karnataka, IND
11000 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account