SQL, DWH, Data Steward

Infosys; Maharashtra; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Infosys is seeking a seasoned data governance and data warehousing professional to lead SQL-driven analysis and design scalable structures supporting enterprise reporting. This role emphasizes data stewardship, governance policies, metadata management, and data quality across systems.

Collaborate with ETL teams and business stakeholders to translate requirements into governed data solutions, optimize Power BI reporting, and drive trusted datasets for governance metrics.

Qualifications

• BTECH, MTECH, MCA, or MSC are required.
• 5–8 years of experience in SQL, DWH, and data stewardship in enterprise environments.
• Strong hands-on SQL skills for data profiling, validation, reconciliation, and performance tuning.
• Experience supporting ETL processes and validating end-to-end data movement into a warehouse.
• Working knowledge of data governance concepts, data quality practices, and stewardship operating models.
• Experience building or supporting Power BI reporting with a focus on consistent metrics and trusted datasets.

Responsibilities

• Lead SQL-driven analysis and development to support enterprise reporting, governance, and stewardship needs.
• Design, enhance, and maintain DWH structures (fact/dimension models) for scalability and performance.
• Own data stewardship activities including data definitions, glossary alignment, metadata management, and stewardship workflows.
• Implement and monitor data quality rules, issue management processes, and remediation tracking with stakeholders.
• Partner with ETL teams to define source-to-target mappings, validate transformations, and ensure reliable data pipelines.
• Drive data governance practices including policy adherence, access controls, and standardization of key data elements.
• Develop and support Power BI datasets, semantic layers, and dashboards aligned to governed metrics and definitions.
• Conduct root-cause analysis for data issues across source systems, ETL, and warehouse layers; recommend corrective actions.
• Collaborate with business and technical teams to gather requirements and translate them into governed data solutions.
• Provide technical guidance and reviews for SQL, ETL logic, and DWH design to ensure best practices and consistency.

Skills

SQL

Data Warehousing

Data Governance

ETL

Power BI

Data Quality

Metadata Management

Dimensional Modeling

Data Lineage

Education

BTECH/MTECH/MCA/MSC

Job description

• Lead SQL-driven analysis and development to support enterprise reporting, governance, and stewardship needs.
• Design, enhance, and maintain DWH structures (fact/dimension models), ensuring scalability, performance, and consistency.
• Own data stewardship activities including data definitions, business glossary alignment, metadata management, and stewardship workflows.
• Implement and monitor data quality rules, issue management processes, and remediation tracking with stakeholders.
• Partner with ETL teams to define source-to-target mappings, validate transformations, and ensure reliable data pipelines.
• Drive data governance practices including policy adherence, access controls, and standardization of key data elements.
• Develop and support Power BI datasets, semantic layers, and dashboards aligned to governed metrics and definitions.
• Conduct root-cause analysis for data issues across source systems, ETL, and warehouse layers; recommend corrective actions.
• Collaborate with business and technical teams to gather requirements and translate them into governed data solutions.
• Provide technical guidance and reviews for SQL, ETL logic, and DWH design to ensure best practices and consistency. Minimum Qualifications:
• BTECH, MTECH, MCA, or MSC.
• 5–8 years of experience working with SQL, data warehousing (DWH), and data stewardship in enterprise environments.
• Strong hands-on SQL skills for data profiling, validation, reconciliation, and performance tuning.
• Experience supporting ETL processes and validating end-to-end data movement into a warehouse.
• Working knowledge of data governance concepts, data quality practices, and stewardship operating models.
• Experience building or supporting Power BI reporting with a focus on consistent metrics and trusted datasets. Preferred Qualifications:
• Proven experience defining and operationalizing data governance frameworks (standards, controls, stewardship processes).
• Strong understanding of dimensional modeling, data marts, and enterprise reporting patterns.
• Experience with data lineage, metadata management, and business glossary implementation in collaboration with stakeholders.
• Ability to lead cross-functional discussions, influence data standards adoption, and drive closure on data quality issues.
• Experience optimizing ETL workflows and improving reliability, auditability, and reconciliation of warehouse loads.
• Advanced Power BI experience including data modeling, DAX measures, and performance optimization of reports/datasets.