Senior Data Pipeline Engineer and Data Integration Engineer / API Developer
Capgemini
5 - 10 years
Hyderabad
Posted: 23/06/2025
Job Description
Job Description
Role Overview:Develop efficient SQL queries and maintain views, models, and data structures across federated and transactional DB to support analytics and reporting.
• SQL (Advanced)
• Python – for data exploration and scripting
• Shell scripting – for lightweight automationKey Responsibilities:
• Write complex SQL queries for data extraction and transformations
• Build and maintain views, materialized views, and data models
• Enable efficient federated queries and optimize joins across databases
• Support performance tuning, indexing, and query optimization effortsPrimary:
• Expertise in MS SQL Server / Oracle DB / PostgresSQL , Columnar DBs like DuckDB , and federated data access
• Good understanding of Apache Arrow columnar data format, Flight SQL, Apache Calcite
• Secondary: Experience with data modelling, ER diagrams, and schema design
• Familiarity with reporting layer backend (e.g., Power BI datasets)
• Familiarity with utility operations and power distribution is preferred
• Experience with cloud-hosted databases is preferred
• Exposure to data lake in cloud ecosystems is a plusOptional
• Familiar with Grid CIM (Common Information Model; IEC 61970, IEC 61968)
• Familiarity with GE ADMS DNOM (Distribution Network Object Model)
• GE GridOS Data Fabric
About Company
Capgemini is a global leader in consulting, technology services, and digital transformation. Headquartered in Paris, France, Capgemini provides a wide range of services, including IT consulting, managed services, business process outsourcing, and digital transformation solutions. With over 360,000 employees across more than 50 countries, the company focuses on helping organizations innovate and transform their businesses to remain competitive in a rapidly changing digital landscape. Capgemini is known for its expertise in cloud computing, AI, cybersecurity, and other emerging technologies, working closely with clients to develop sustainable and cutting-edge solutions.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).