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