Description

Job Summary: We are looking for a skilled Data Warehousing Developer to design, develop, and optimize data warehouse solutions supporting business analytics and reporting needs. The ideal candidate will have a strong background in MS SQL, and data modeling, with experience in building efficient ETL processes and ensuring data integrity across systems.

Key Responsibilities • Design, develop, and maintain data warehouse schemas, tables, views, and materialized views.

- Write complex MS SQL scripts for data extraction, transformation, and loading (ETL).
- Optimize database performance through query tuning, indexing, and partitioning.
- Develop and maintain stored procedures, functions, triggers, and packages.
- Collaborate with data architects, business analysts, and BI teams to translate business requirements into technical solutions.
- Ensure data accuracy, consistency, and security across the warehouse environment.
- Support production systems by monitoring jobs, troubleshooting failures,



and resolving issues promptly.
- Participate in code reviews and contribute to improving data development standards and best practices.
- Document ETL workflows, data mappings, and database structures.

Required Skills &

Qualifications • Bachelor’s degree in Computer Science, Information Technology, or a related field.

- 8+ years of hands-on experience in MS SQL Server development.
- Solid understanding of data warehouse concepts, star/snowflake schema, and dimensional modeling.
- Experience with Python is a plus.
- Strong analytical and troubleshooting skills.
- Experience in performance tuning and query optimization.
- Good communication skills and ability to work collaboratively in a team setting.

Preferred Skills (Nice to Have) • Good understanding of Capital Markets domain is a plus.

📌 Data Integration Lead (India)
🏢 Hexaware
📍 India