Technical Skills:

• MS SQL Server, ETL and data analysis technique

Mandatory Skills:

• 4-6 years of experience in MS SQL and ETL. Knowledge of handling large datasets. Well versed in RDBMS databases and extensive experience in SQL
• Advance level knowledge on SQL Query optimization, writing complex SQL queries, functions, procedures, triggers, and RDBMS data modelling
• Knowledge of Data warehouse concepts (Implementation of ETL/ELT pipelines, data integration components (SSIS).
• knowledge of data analysis tools. Interpret Business requirements /information and translate to technical solutions – from data warehouse to analysis services, tabular models
• Hands-on experience in Data Model design, Schema representation, DB structures, and other table/object-related properties.
• Build and maintain stateful data pipelines, and fault tolerant complex ETL/ELT jobs. Using Data Factory and SSIS.

Preferred Skills:

• Knowledge in DBT (Data build tool)
• Experience with scrum / agile development methodology.
• Good written and oral communication skills.