Data Integration Lead

Years of Exp – 5 - 9 years JD with primary and secondary skills – Datawarehouse Developer with strong ETL and MS SQL skills

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 • 5-9 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 environment.

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