GCP Data Engineer

Zensar; Pune District; On-site; INR 1,400,000 - 2,000,000; Full time

Job summary

Zensar is seeking a data engineer to design, develop, and optimize ETL/ELT pipelines on Google Cloud. You will build and manage BigQuery data warehousing, design schemas, and optimize queries, while enabling batch and streaming ingestion from diverse sources.

The role emphasizes data quality, monitoring, and alerting, along with implementing event-driven workflows using Pub/Sub, Cloud Storage, and Cloud Functions. Collaboration with global teams and onshore partners is required.

Qualifications

• Hands-on experience designing and building ETL/ELT pipelines on Google Cloud Platform.
• Strong experience with BigQuery schema design, partitioning, and query optimization.
• Experience with data ingestion from structured and unstructured sources (batch and streaming).
• Familiarity with data quality checks, monitoring, and alerting across pipelines.
• Ability to translate business requirements into scalable data architectures.

Responsibilities

• Design, develop, and optimize ETL/ELT pipelines using GCP-native tools (Dataflow, Dataproc, Cloud Composer/Airflow).
• Build and manage data warehousing solutions on BigQuery, including schema design, partitioning, and query optimization.
• Develop data ingestion frameworks from structured and unstructured sources (batch and streaming).
• Implement data quality checks, monitoring, and alerting across pipelines.
• Collaborate with data architects to translate business requirements into technical designs.
• Work with Pub/Sub, Cloud Storage, and Cloud Functions to build event-driven data workflows.
• Support CI/CD practices for data pipeline deployments (Cloud Build, Terraform).
• Ensure data security, access controls, and governance compliance across platforms.
• Participate in code reviews, sprint planning, and technical documentation.
• Coordinate with onshore teams across time zones for delivery alignment.

Skills

ETL/ELT pipelines

GCP

BigQuery

Data Warehousing

CI/CD

Data security & governance

SQL

Tools

Dataflow

Dataproc

Cloud Composer/Airflow

BigQuery

Pub/Sub

Cloud Storage

Cloud Functions

Terraform

Job description

Responsibilities

• Design, develop, and optimize ETL/ELT pipelines using GCP-native tools (Dataflow, Dataproc, Cloud Composer/Airflow)
• Build and manage data warehousing solutions on BigQuery, including schema design, partitioning, and query optimization
• Develop data ingestion frameworks from structured and unstructured sources (batch and streaming)
• Implement data quality checks, monitoring, and alerting across pipelines
• Collaborate with data architects to translate business requirements into technical designs
• Work with Pub/Sub, Cloud Storage, and Cloud Functions to build event-driven data workflows
• Support CI/CD practices for data pipeline deployments (Cloud Build, Terraform)
• Ensure data security, access controls, and compliance with governance standards
• Participate in code reviews, sprint planning, and technical documentation
• Coordinate with onshore teams across time zones for delivery alignment

• Design, develop, and optimize ETL/ELT pipelines using GCP-native tools (Dataflow, Dataproc, Cloud Composer/Airflow)
• Build and manage data warehousing solutions on BigQuery, including schema design, partitioning, and query optimization
• Develop data ingestion frameworks from structured and unstructured sources (batch and streaming)
• Implement data quality checks, monitoring, and alerting across pipelines
• Collaborate with data architects to translate business requirements into technical designs
• Work with Pub/Sub, Cloud Storage, and Cloud Functions to build event-driven data workflows
• Support CI/CD practices for data pipeline deployments (Cloud Build, Terraform)
• Ensure data security, access controls, and compliance with governance standards
• Participate in code reviews, sprint planning, and technical documentation
• Coordinate with onshore teams across time zones for delivery alignment

Good to have

• GCP Professional Data Engineer certification
• Experience with dbt for transformation workflows
• Exposure to Looker or other BI/visualization tools
• Prior experience in a client-facing offshore delivery model
• Familiarity with Kafka or other streaming platforms

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.