ETL Developer - SQL Server/Data Warehousing (5-7 yrs)

Mandatory Skills:ETL,SSIS,DW Concepts,SQL,Stored Procedures.

Responsibilities :

- 5+ Years of ETL experience working with a large-scale MS SQL server data warehouse databases by using SSIS and reports are built through MS SSRS reports good experience in managing

- Data ware house as part of data management principles has a techno functional knowledge (Data Governance, Data architecture, Data profiling, Data analysis, Storing and managing data, data quality validation, ETL through SSIS and T-SQL, SSRS reports development)

- Design, develop, and maintain ETL processes using SSIS or any other ETL tool to extract data from various sources, transform it according to business rules, and load it into target databases or data warehouses.

- Develop and optimize SQL queries, stored procedures, and functions.

- Experience in both forward engineering (Requirements to a SQL logic) and a Reverse Engineering (converting a SQL logic to a business requirement document)

- Should be proficient in troubleshooting and resolving production issue

- Having skills in documenting data flows by using a Visio, business requirement in a word and source to target mapping documents in an Excel.

- Should have worked on documenting ETL processes, source to target mappings, etc

- Strong communication skills

- Good Data warehousing concept

- SSIS hands on experience

- Strong hands on experience with Stored Procedure

- Design, develop, and maintain ETL processes using SSIS or any other ETL tool to extract data from various sources, transform it according to business rules, and load it into target databases or data warehouses.

- Develop and optimize SQL queries, stored procedures, and functions.

- Experience in both forward engineering (Requirements to a SQL logic) and a Reverse Engineering (converting a SQL logic to a business requirement document)Should be proficient in troubleshooting and resolving production issue

- Having skills in documenting data flows by using a Visio, business requirement in a word and source to target mapping documents in an Excel.

- Should have worked on documenting ETL processes, source to target mappings, etc

- Strong communication skills

- Good Data warehousing concept

- SSIS hands on experience

- Strong hands on experience with Stored Procedure