Lead MS SQL Developer

About the job

• 7+ Years of experience on MS SQL Server. 5+ Years of experience on SQL Server Integration Services (SSIS).
• Experience working with DWH to build scalable solutions. Data warehousing and ETL concepts/experience is preferred.
• Have good experience & provides support for projects like designing and maintaining metadata models and complicated SSIS packages or OLAP cubes.
• Pipeline execution and Triggers based on the data model designed.
• Need to be expert in SQL and follows best practices for coding and performance tuning and iterative development approach.
• Strong technical skills in Database and scripting ( T-SQL, and Stored procedures )
• Needs to be able to understand the logical mapping and data models provided and design and develop ETL mappings as per available patterns & business requirements.