Job Description

We have immediate opening for ETL SSIS Developerr r Exp : 3+ Yearsr r Job Location : Mumbai / Kolkata (WFH but ready to relocate)
r
r Requirements:r r Z Experience in ETL - 3 yrsr r Z Experience in SSIS (Min 2 Yrs)r r Z Experience in DWH.(Min 1 Yrs)r r r r Primary responsibility is the development of ETL processes:
r
r - Technologies required: SSIS, MS SQL Server 2008
r - SSIS Advanced component experience is required (transformation objects in data flow).
r
r Responsibilities:
r
r - Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness.
r - Develop cross validation rules to ensure mapping accuracy.
r - Meet all defined requirements of the project.
r - Provide production support of existing ETL processes.
r - Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production.
r - Provide regular project updates to Information Analysts and management as needed.
r - Communicate issues, risks, and concerns proactively to management.
r - Document ETL process thoroughly to allow peers to assist with support as needed.
r - Self-sufficient and strong communication skills (must be able to work with external groups/departments).
r - Data Warehousing experience is preferred.Exposure to various BI tools(ETL,Reporting,Analytics)r r

• r
• r Create and maintain SQL scripts and packages using SSISr r
• r experience of advanced knowledge of T-SQL and/or ANSI SQL, ETL and Data Warehousingr r
• r Ability to create complex scripts to identify and address data quality issues correct the mismatched datar r
• r Experience building appropriate data models and designing tables to effectively support large data volumesr r
• r Demonstrate ability to pull together a well-designed, end-to-end process with knowledge of the MS-SQL product-stackr r
• r Ability to troubleshoot and tune database configurations, ETL processes and SQL code for optimal performancer r
• r Experience with warehousing best practices and methodologiesr r
• r Build database/ETL developer responsible for building relational and data warehousing applications , unit test, document the ETL processr r
• r Proficiency in the development of complex technical solutions and scripts using SSIS SQL Serverr r
• r Developing data links and data loading scripts, including data transformations, reconciliations and accuraciesr r
• r Have a participated in all phases of Software Development Lifecycle (SDLC)r r
• r Support ETL processing in support of transforming and loading data into the data warehouser r
• r Support analysis of Database schema, Tables and Viewsr r

r r r r If interested kindly revert with following detailsr r

• r
• r Total Experience:r r
• r Relevant Experience :r r
• r CCTC:r r
• r Notice Period:r r
• r Reason For Change:r r
• r Current Location:r r
• r DOB:r r

r r Thanks & Regards,
r Pranjali
r IT Recruiter-TL
Education: Any Graduate
Industry: IT-Software

Skills Required