Data Product Implementation Consultant (Data Engineer + Data Modeler)
Location: Bangalore
Experience: 6–10 Years
Choosing Capgemini means choosing a place where you'll be empowered to shape your career, supported by a collaborative global community, and inspired to reimagine what's possible. Join us in delivering next-generation data products and enterprise-scale data platforms for leading Energy & Utilities organizations across the globe.
Role Overview
We are seeking a Data Product Implementation Consultant to support the development, integration, and deployment of data products for Exploration & Production (E&P) initiatives. This role combines Data Engineering, Data Modeling, Data Integration, and DataOps practices to deliver scalable, reliable, and business-driven data solutions.
The ideal candidate will have strong hands-on experience in SQL, Python, ETL/ELT development, data modeling, and enterprise data integration.
Key Responsibilities
Implement data products based on business and technical requirements.
Design, develop, and maintain data ingestion, transformation, and integration pipelines.
Create source-to-target mappings and implement logical and physical data models.
Develop and optimize SQL transformations, reconciliations, and data validation processes.
Build automation frameworks, utilities, and integrations using Python.
Integrate enterprise and operational systems through APIs and ETL/ELT frameworks.
Work closely with architects, business analysts, and stakeholders to deliver scalable data solutions.
Contribute to DataOps, CI/CD, DevOps, and operational monitoring practices.
Mandatory Skills
Experience in Data Engineering, ETL Development, Data Integration, or Analytics Engineering.
Strong Python programming skills.
Experience in developing ETL/ELT pipelines and integration frameworks.
Good understanding of Data Modeling concepts and Source-to-Target Mapping.
Experience with Git and version control practices.
Understanding of CI/CD pipelines and deployment processes.
Preferred Skills
Hands-on experience with: Azure Data Factory (ADF),Azure Synapse,Databricks,Apache Spark
Experience with DataOps, DevOps, and Infrastructure as Code (IaC).
Understanding of Oil & Gas Exploration & Production business processes.
Exposure to cloud-native data architectures and scalable data platforms.
Ideal Candidate Profile
Data Engineering, Data Integration, or Data Platform development.
Strong expertise in SQL and Python development.
Experience building enterprise-scale data pipelines and data products.
Strong understanding of dimensional modeling, metadata management, and data governance.
Ability to work in fast-paced Agile delivery teams.
What You'll Love About Working Here
Opportunity to work on large-scale Energy & Utilities transformation programs.
Exposure to modern cloud, data, and AI technologies.
Flexible work environment and collaborative culture.
About Capgemini
At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world's most innovative companies unleash their potential. We combine deep industry expertise with cutting-edge technologies across cloud, data, AI, and digital engineering to deliver sustainable business outcomes.