Job Description :
Hands on experience in developing ETL jobs using SSIS.

- Should be able to do source to target mapping with minimum inputs and from scratch

- Hands on experience in MS SQL 2008 or higher versions

- Experience in SSIS error handling process and Performance Tuning

- Analyze and understand source to target mapping

- Design, build and deploy effective SSIS packages

- Implement stored procedures and effectively query a database

- Perform unit testing

- Ensure the best possible performance and quality in the packages

- Issue resolution if there are any

- Knowledge of datawarehouse concepts, star schema, facts and dimensions.



SSRS



- Experience in any Reporting tool and understands the data visualization

- Worked on creating dashboards

- Hands on experience in SSRS

- Analyze Report Requirements

- Design, build and deploy Reports

- Implement stored procedures and effectively query a database

- Perform unit testing

- Ensure the best possible performance and quality in the Report queries

Issue resolution if there are any]"