Data Migration Specialist (ETL/SSIS, Data Mapping)
Posted Updated
Description
You will design and implement complex client-focused data mapping in line with the migration SDLC. You will produce data models, mapping definitions and validation rules, build and maintain SSIS packages and ETL workflows, resolve data and technical issues, complete unit testing and documentation, and provide post-implementation support.
Responsibilities
- Work with internal and client SMEs to provide complex data mapping solutions
- Produce data models, data mapping definitions and data validation rules
- Design, create and maintain SSIS packages to migrate data to FNZ databases
- Design and develop ETL workflows with re-usable components
- Provide solutions and recommendations for technical issues
- Support changes through testing, resolve data issues, complete unit testing and system documentation
- Provide post implementation support
Requirements
- Confident and able to take initiative in a client and delivery-focused environment
- Good team communication skills with internal and external clients
- Highly developed written and oral communication skills
- Strong relational database design experience with MS SQL Server
- Proficient in data mapping and profiling techniques
- Experience using ETL tools such as SSIS or Informatica
- Experience working on Business Intelligence projects
- Superior analytical thinking
- Able to prioritise workload and meet aggressive deadlines with minimal supervision
Skills
Sign in to read and join the discussion.