No more applications are being accepted for this job
- Contract Duration 2+ years
- 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
- Provide best practice migration solutions and oversee all facilities of the data and files migration from a legacy application to a new solution.
- Establish a strong working relationship with clients, interact effectively at all levels, and analyze 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 that arise during the use and operation of software packages, including technical assistance in implementation, conversion, and migrations
- Senior Software Developer ETL works with importing files from heterogeneous platforms and coordinating data file migration.
- Define testing strategy, plan and conduct 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
- 7+ years of experience in developing data conversion and migration
- Demonstrates extensive experience with the following:
- 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)
- Demonstrates knowledge and experience with the following:
- 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
- 7+ years of experience in developing data conversion and migration
- At least one experience of 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, importing data, manipulating data, transformation, and loading.
- Experience liaising with teams to understand to-be migration requirements.
- Knowledge and understanding of Information Management principles, concepts, policies, and practices.
- Experience providing support through the cutover process.
- Knowledge of data models 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 solutions.
- Experience with document migration
- Experience with industry-leading ETL tools such as Informatica, Azure Data Factory, and cloud technologies.
- Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server, etc.,
- Exceptional level of knowledge of 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, Azure SQL Database, and write complex SQL queries, etc.,
- 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 detail, including the ability to troubleshoot and solve complex technical problems.
- Experience with data conversion scripts and tools.
- Experience with file migration from different file storages such as Azure BLOB, Azure file share, SharePoint, and 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 load programs.
- Communication, facilitation, negotiation, consensus-building, and problem-solving skills
- Provide periodic status reports, present data migration strategy and approach to executives and other stakeholders
- Previous experience working in Government or Public Sector organizations
- Hybrid role- 3 days per week in the office required.
Senior Software Developer ETL - Toronto, Canada - GTT, LLC
Description
Senior Software Developer ETL
Scope:
Deliverables:
Must Haves:
Evaluation Criteria:
Criteria 1 - Data Knowledge Expertise Skills (35 Points)
Criteria 2 - Technical Skills (35 Points)
Criteria 3 - Communication Skills (25 Points)
Criteria 4 - Public Sector Experience (5 Points)
Note:
#gttca
#LI-GTT