fb_pixel
back
Back
Location:
Hyderabad, Pakistan
Department: Information Technology
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 automation

    • Key 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 efforts

    • Primary:

  • 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 plus

    • Optional

  • Familiar with Grid CIM (Common Information Model; IEC 61970, IEC 61968)

  • Familiarity with GE ADMS DNOM (Distribution Network Object Model)

  • GE GridOS Data Fabric


    • Job Id: VJo3iQDWbdDKRYRtC7RSBK99EcDZ44z72W72ShwKU/rp7ydBvQFXncCa/ktWlQDV9fVoT4UJRbVq0S1Qv/xJdd78eB553c/hCYcYjQcBkv12NwFIyZaExQqcWpXb
    companyLogo
    Capgemini Engineering
    Senior Data Pipeline Engineer and Data Integration Engineer | 4 to 9 Years | Pan India