Data Warehouse Lead Developer

Role: Data Warehouse Lead Developer

Experience:

6 to 8 years

Key Responsibilities:

• Design, develop, and maintain complex SQL queries, stored procedures, functions, and views.
• Optimize SQL queries and database performance (indexing, execution plans, tuning).
• Support data extraction, transformation, and reporting requirements.
• Work closely with applications, BI, and data teams to understand data needs.
• Ensure data accuracy, consistency, and integrity across systems.
• Troubleshoot and resolve database-related issues.
• Troubleshooting and resolving job failures or alert triggers
• Support production issues and perform root cause analysis.
• Work independently and collaborate with business, BI, and reporting teams. Required

Skills:

• Strong hands-on

experience

in Data Warehousing concepts and architecture.

• in Data Warehousing concepts and architecture.
• Strong knowledge of Stored Procedures, Functions, Views, and Triggers
• Hands‑on

experience

with SQL Server Jobs for scheduling and automation

• with SQL Server Jobs for scheduling and automation
• Ability to configure and manage Alerts & Notifications for proactive monitoring
• Design, develop, and maintain Data Warehouse solutions.
• Design star/snowflake schemas, fact and dimension tables.
• Ensure data quality, integrity, and performance optimization.
• Support data extraction, transformation, and loading from multiple source systems.
• Expertise in writing complex joins, subqueries, CTEs, and window functions. ·

Experience

in performance tuning and query optimization.

• in performance tuning and query optimization.
• Good understanding of relational database design and normalization. ·

Experience

with stored procedures, triggers, and functions.

• with stored procedures, triggers, and functions.
• Familiarity with ETL concepts and data warehousing basics. ·

Experience

with cloud data platforms Good to Have: ·

Experience

with Power BI and semantic models. ·

Experience

in performance optimization and large data volumes.

• in performance optimization and large data volumes.
• Knowledge of CI/CD for data pipelines. ·

Experience

working in client-facing or onsite–offshore models. Soft

Skills:

• Strong analytical and problem-solving skills.
• Ability to work independently with minimal supervision.
• Good communication and stakeholder management skills.

.

Work closely with applications, BI, and data teams to understand data needs.

Ensure data accuracy, consistency, and integrity across systems.

Troubleshoot and resolve database-related issues.

Troubleshooting and resolving job failures or alert triggers

Support production issues and perform root cause analysis.

Work independently and collaborate with business, BI, and reporting teams. Required

Skills:

• Strong hands-on

experience

in Data Warehousing concepts and architecture.

• in Data Warehousing concepts and architecture.
• Strong knowledge of Stored Procedures, Functions, Views, and Triggers
• Hands‑on

experience

with SQL Server Jobs for scheduling and automation

• with SQL Server Jobs for scheduling and automation
• Ability to configure and manage Alerts & Notifications for proactive monitoring
• Design, develop, and maintain Data Warehouse solutions.
• Design star/snowflake schemas, fact and dimension tables.
• Ensure data quality, integrity, and performance optimization.
• Support data extraction, transformation, and loading from multiple source systems.
• Expertise in writing complex joins, subqueries, CTEs, and window functions. ·

Experience

in performance tuning and query optimization.

• in performance tuning and query optimization.
• Good understanding of relational database design and normalization. ·

Experience

with stored procedures, triggers, and functions.

• with stored procedures, triggers, and functions.
• Familiarity with ETL concepts and data warehousing basics. ·

Experience

with cloud data platforms Good to Have: ·

Experience

with Power BI and s