Job Description
Experience and Skillset Requirements
Mandatory Requirements
- 7+ years of experience in developing data conversion and migration
- Experience working in ETL tools such as Azure Data Factory, Informatica, etc.
- Knowledge and experience in development of business case, data migration strategy and plan
- Knowledge and understanding of Information Management principles, concepts, policies and practices
- Excellent understanding of master data and transactional data concepts and interdependencies
Desired Skills and Experience
- Full life-cycle data conversion experience with enterprise systems, including deployment experience.
- Experience working with all steps of data migration activities such as data profiling, data mapping, developing data migration solutions, data validation and audit.
- Proficiency in query languages such as SQL, PL-SQL.
- Familiarity with and construction of complex query statements.
- Knowledge of various database structures and RDMS like Oracle DB and MS SQL Server, Azure SQL Database, and write complex SQL queries.
- Experience ensuring the data migration solution is scalable.
- Data analysis, investigative and logic skills with high attention to detail
- Experience with migrating file attachments from legacy applications to new solution.
- Experience in migrating document attachments from legacy solution to a new modernized solution.
- Experience with data conversion scripts and various ETL tools such as Informatica, Azure Data Factory, etc.
- Experience with overseeing /completing all tasks involved in the conversion process including data extraction, cleansing, transformation and loading
- Experience liaising with teams to understand to-be migration requirements.
- Establish a strong working relationship with all groups, interact effectively with all levels of client personnel, and provide conversion support.
- Experience completing mapping, interfaces, conversion work, documentation and verifying completeness and accuracy of converted data.
- Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
- Experience providing support through the cutover process
- A team player with a track record for meeting deadlines, managing competing priorities and client relationship management experience
- Communication, facilitation, negotiation, consensus building, and problem-solving skills
Resumes Evaluation/Criteria:
Criteria 1: Data Knowledge Expertise Skills - 35 Points
- Experience working with migrating data from different legacy platforms to a new solution.
- Full life-cycle data conversion experience with enterprise systems, including deployment experience.
- Data analysis, investigative and logic skills, including the ability to troubleshoot and solve complex technical problems.
- Experience with overseeing /completing all tasks involved in the conversion process including data extraction, profiling, cleansing, import data, manipulate data, transformation and loading.
- Knowledge and understanding of Information Management principles, concepts, policies and practices.
- Experience providing support through the cutover process.
- Knowledge of data model of case management solutions and experience in data migration/conversion of large case management applications.
- Experience with migrating attachment files from legacy applications to new solution.
- Experience with document migration
Criteria 2: Experience with Document Migration - 35 Points
- Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server, etc.,
- Exceptional level of knowledge on relationships between tables to perform and construct complex query statements from multiple data sources.
- Knowledge of various database structures and RDMS like Oracle, MS SQL Server, etc., Azure SQL Database, and write complex SQL queries.
- Knowledge and understanding of mainframe data formats, data types, segments and non-relational data structures
- Data analysis, investigative and logic skills with high attention to details, including ability to troubleshoot and solve complex technical problems.
- Experience with data conversion scripts and tools.
- Experience with industry leading ETL tools such as Informatica, Azure Data Factory and cloud technologies.
- Experience with file migration from different file storages such as Azure BLOB, Azure file share, SharePoint, Oracle BLOBs.
- Experience completing mapping, interfaces, conversion work, data exclusion and inclusion, documentation and verifying completeness and accuracy of converted data, including data dictionary development and updates.
- Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
Criteria 3: Communication Skills - 25 Points
- Communication, facilitation, negotiation, consensus building, and problem-solving skills
- Provide periodic status reports, present data migration strategy and approach to executives and other stakeholders
- Experience liaising with teams to understand to-be migration requirements.
Criteria 4: Public Sector Experience - 5 Points
- Previous experience working in Government or Public Sector organizations
Knowledge Transfer
What needs to be KT
- All documentation relating to the technology designs and technology knowledge specific to the candidate's assignment All information gathered while working with vendors and internal solutions to be shared Any best practices, work around, lessons learned must be documented
To whom
- Project Manager / Team members
When
- 1:1 meetings / team meetings / documentation on SharePoint site, throughout the duration of the project life cycle etc.
MUST HAVES:
- 7+ years of experience in developing data conversion and migration
- Experience working in ETL tools such as Azure Data Factory, Informatica, etc.
- Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server, etc.,
Nice to Have:
- Knowledge and experience in development of business case, data migration strategy and plan
- Knowledge and understanding of Information Management principles, concepts, policies and practices
- Excellent understanding of master data and transactional data concepts and interdependencies
Job Tags