ETL Developer

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 issueHaving 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, etcStrong communication skillsGood Data warehousing conceptSSIS hands on experienceStrong hands on experience with Stored ProcedureDesign, 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 issueHaving 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, etcStrong communication skillsGood Data warehousing conceptSSIS hands on experienceStrong hands on experience with Stored Procedure