Data warehouse + SQL

Dear candiate,

Greetings from Hexaware!

Location: Chennai / Bangalore
Experience: 4-6 Years
Work Mode: Hybrid

Shift timing - 12 - 9pm

Job Summary

We are looking for a Data Warehouse Developer with strong ETL and MS SQL skills to join our team. The ideal candidate should have hands-on experience in data warehouse development, dimensional modeling, ETL processes, and database performance optimization.

Key Skills (Mandatory)

• Data Warehouse Development
• ETL Development
• MS SQL Server
• SQL Query Optimization
• Stored Procedures, Functions, Triggers
• Data Modeling (Star Schema / Snowflake Schema)
• Performance Tuning
• Database Development

Roles & Responsibilities

• Design, develop, and maintain data warehouse schemas, tables, views, and materialized views.
• Develop and support ETL processes using MS SQL.
• Write complex SQL queries, stored procedures, functions, and triggers.
• Perform query tuning, indexing, and database performance optimization.
• Collaborate with business analysts, architects, and BI teams.
• Ensure data quality, consistency, and security across the warehouse.
• Troubleshoot production issues and support scheduled jobs.
• Document ETL workflows, mappings, and database structures.

Required Qualifications

4-6 years of experience in MS SQL Server Development
Strong ETL Development experience
Good understanding of Data Warehousing Concepts
Experience with Star/Snowflake Schema and Dimensional Modeling
Strong analytical and troubleshooting skills
Good communication and stakeholder management skills

If your skills is matching with all mandatory skills, kindly drop your resume to [email protected]