No more applications are being accepted for this job
- A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution DELIVERABLES:
- Provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution.
- Establish a strong working relationship with clients, interact effectively at all levels and analyses legacy data and files stored in a variety of data sources and formats.
- Analyze and complete data profiling and suggest any pre migration data cleansing activities.
- Complete data migration strategy, data mapping, define interfaces, perform mock conversion, define enhancements and perform actual conversion.
- Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
- Resolve and troubleshoot technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations
- Work with importing files from heterogeneous platforms and coordinates data file migration.
- Define testing strategy, plan and conducts testing to ensure data integrity and data comparisons.
- Perform post migration audit and data reconciliation.
- Generate data migration exception reporting and perform data cleansing as required.
- Provides pre- and post-effective conversion support to business clients SKILLS AND KNOWLEDGE:
- 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
- Knowledge and understanding of mainframe data formats, data types, segments and non-relational data structures
- 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 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 Must haves:
- Data migration in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutions
- Experience working in ETL tools such as Azure Data Factory, Informatica, etc.
- Experience in migrating document attachments from legacy solution to a new modernized solution
- Experience working in cloud DB technologies (such as Azure SQL)
- 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
Senior ETL Software Developer - Toronto, Canada - NR Consulting
Description
Title :: Senior ETL Software Developer (- Days Onsite/Hybrid)Location :: Toronto, ON, Canada
Duration : Contract
SCOPE:
• + years of experience in developing data conversion and migration
• Demonstrates extensive experience with the following:
• Demonstrates knowledge and experience with the following: