Job Description :
3 yrs of experience in Microsoft SQL Server (2016 and later)

Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.

Hands on experience in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.

Proficient in developing ETL SSIS Packages for integrating data using various sources and targets (Excel, CSV, flat file, tables) by using multiple transformations provided by SSIS and Analysis Services.

Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS

Experience in configuring Data Quality Services, (DQS), Master Data Services

Experience in handling Master Data Management (MDM) services and setting up the Master Data Services (MDS) to integrate and maintain various entities.

Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP.