SSIS Developer

Key Skills :

SSIS, ETL, SQL, T-SQL, Data Warehouse, Data Mart, Data Modeling, Data Cleansing, Data Migration, Data Transformation, OLAP, OLTP

Description :

This role involves designing and building robust ETL solutions using Microsoft SSIS, with a focus on handling various data types and sources. The position requires strong SQL skills for writing complex queries and stored procedures, as well as expertise in data analysis and troubleshooting. Experience in the healthcare domain and proficiency in data warehouse concepts and data modeling. Additionally, the role entails supporting and enhancing existing SSIS ETL processes to ensure robustness and efficiency.

Key Qualifications :

Designing ETL solutions using Microsoft stack SSIS – Around 6-8 yrs of experience.

Design and build end to end robust ETL solutions that can handle different data types, like XML using XSLT, csv, txt, web services, database sources.

Strong SQL technical skills

Strong Data Analysis / troubleshooting skills.

Writing complex T-SQL queries and SQL Stored Procedures.

Experience of the Healthcare domain would be beneficial.

Support existing SSIS ETLs, proactively fine-tune and enhance existing codes to increase robustness and error monitoring.

Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models Having depth knowledge of large database design techniques.

Experience in data analysis, data cleansing, and data transformation and migration using ETL tools.