Qualifications -- Knowledge, Skills and Abilities

• Extensive experience designing and deploying data integration (ETL) solutions in a data warehousing, BI environment involving complex data transformations, change, data capture, and error handling.
• Advanced experience with SQL Server ETL Development and its related tools (SSIS, SSRS, SSMS, Visual Studio), including extracting, transforming, and loading data from various data sources and APIs.
• Advanced experience with production SSIS packages troubleshooting and development.
• Solid hands-on experience and knowledge of ETL technology in use in projects.
• Strong coding expertise with extensive knowledge and understanding of the systems development life cycle (SDLC).
• Excellent SQL programming is required as well (SQL, PowerShell, JavaScript, HTML, etc)
• Solid hands-on experience and knowledge of database concepts of data modeling and mapping including normalization, dimensionality, referential integrity, indexes, keys, master data, and metadata.
• Advanced knowledge in applying appropriate test methodologies and QA processes which includes writing test plans and test cases
• Experience with source code controls such as GIT or ADO

Desired Qualifications:

• Experience in Python or other programming languages