ZT
Hiring companyZensar Technologies
Verified today
Data Engineer
Bangalore, Karnataka, India
About the role
Data Engineer role based in Bangalore, Karnataka, India, focused on building and maintaining enterprise data pipelines and the Google BigQuery data lake. Day-to-day work includes designing schemas and partitioning strategies, developing batch and streaming pipelines between BigQuery, Oracle CDP, Adobe CDP, and advertising feeds, optimizing SQL queries, and supporting Looker dashboard data models with data reconciliation and SLA monitoring.
What you’ll do
- Built and maintained Google BigQuery as the enterprise data lake, designing schemas, partitioning strategies, data quality frameworks, and access controls
- Developed batch sync pipelines between BigQuery, Oracle CDP, and Adobe CDP to enable profile, audience, and event data exchange
- Implemented Web SDK streaming pipelines feeding real-time behavioral data into Adobe CDP
- Developed schema-aligned, optimized SQL queries delivering fast execution and efficient data retrieval across BigQuery workloads
- Ingested intent data provider and advertising platform feeds into BigQuery and onward to Adobe CDP for activation
- Built feedback pipelines from Adobe CJA and Oracle CX Analytics into BigQuery to enable unified cross-channel reporting
- Supported Looker dashboard data models, monitored pipeline SLAs, and led data reconciliation across source and target systems
What you’ll bring
- Working experience on data pipeline, BigQuery, and DataLake
- Experience working with large data models and queries
- Ability to design BigQuery schemas, partitioning strategies, data quality frameworks, and access controls
- Experience developing batch sync pipelines between BigQuery, Oracle CDP, and Adobe CDP
- Experience implementing Web SDK streaming pipelines for real-time behavioral data
- Ability to develop schema-aligned, optimized SQL queries for fast execution
- Experience ingesting intent data provider and advertising platform feeds into BigQuery
- Experience building feedback pipelines from Adobe CJA and Oracle CX Analytics into BigQuery
Skills
Data pipelineBigQueryDataLakeSQL queriesLooker dashboard data modelsData reconciliationWeb SDK streaming pipelinesBatch sync pipelines