Job Description :
Our direct client is looking for a consulting who is a Senior SQL Server ETL Developer. The candidate will be able to work independently to develop and test very complex data cleansing scripts, SSIS data migration/conversion packages, SSIS Data Bridging programs and SSRS reports in support of a multi-phase legacy system replacement effort.
THE DAY TO DAY:
Bring SQL Server development expertise and participate in design sessions with application engineers, ETL designers, Data Analysts and Quality Assurance resources.
Perform advanced, in-depth analysis of database models, data integrity issues and programming requirements.
THE SKILLS YOU NEED TO GET THE JOB:
8+ years of development experience with MS SQL Server, SSIS, SSRS is required
Design, develop and deploy SSIS Packages
Design Complex ETL using loop containers and data transformation tasks
Write complex T-SQL queries and also able to do data cleansing writing the same
Provide expert technical feedback to functional spec designers / business analysts
Tuning T-SQL queries to improve performance
Develop complex program logic using T-SQL
Lead and make design decisions to create simple, elegant and re-usable software components as a part of larger enterprise application framework
Demonstrated skill in understanding relational table design and applying optimized indexes
Detailed knowledge of Data Modeling, both relational and dimensional
Strong grasp of ETL protocols
Strong analytical and data management skills
Exposure to Data Profiling Best Practices
Unit Testing that yields very low defect code
Develop reports in SQL Server Reporting Services
Experience in Data Modeling and Data Analysis in MS SQL Server 2012/2008
Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution
Analyze & translate functional specifications & change requests into technical specifications.
Solid written and verbal communication skills
Preferred experience with legacy data migrations is greatly
Experience with DB2 legacy systems is a plus
Advanced analytical and problem-solving ability is required for this position