Description

SQL Server (EDW architecture, performance tuning, indexing)
Advanced SQL (complex joins, window functions, stored procedures)
Data warehousing concepts (star schema, data marts, dimensional modeling)Informatica PowerCenter / IICS
SSIS (advanced pipeline development, orchestration)
ETL performance tuning & optimization
Exposure to Databricks / Spark (preferred)
Cloud data platforms (Azure Fabric / Lakehouse concepts) 
Batch + streaming ingestion concepts                                                                                  SSRS, Tableau (understanding of reporting layer integration)
Data provisioning for dashboards and SL reporting                                                   Data quality frameworks, reconciliation
Metadata and lineage awareness                                                                                                  Git/version control
CI/CD basics for ETL deployments
Job scheduling tools

Provide end to end ownership of EDW/data platform operations across SQL Server, data marts, and reporting layers
Lead design and optimization of data pipelines (ETL/ELT) using Informatica / SSIS 
Drive modernization roadmap towards cloud data platforms (Fabric/Databricks) 
Ensure data quality, integrity, and reconciliation across clinical, financial, and operational datasets
Design and support high volume reporting architectures (SSRS/Tableau/BI reporting ecosystem) 
Act as SME for stored procedures, business logic, and EDW transformations
Collaborate with stakeholders to translate business KPIs into scalable data models and dashboards
Drive automation, performance tuning, and capacity optimization of EDW environments

Key Skills

Education

Any Gradute