Software Developer - ETL - Senior
Senior Software Developer ETL required to provide best-practice migration solutions and oversee migration of data and files from a legacy application to a new solution.
- Organization
- Justice Technology Services
- Location
- Toronto, Ontario
- Work arrangement
- On-site
- Employment type
- Compensation
- $723/day
- Reference
- RQ10575
Overview
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.
This position is currently listed as "Onsite", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified.
Responsibilities
• 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.
• Provide periodic status reports and present data migration strategy and approach to executives and other stakeholders.
• Complete knowledge transfer of code and all documentation assigned for this role to the Project Manager and team members through 1:1 meetings, team meetings, and documentation on the SharePoint site throughout the project life cycle.
Mandatory Qualifications
• 7+ years of experience in developing and documenting ETL for data conversion and migration.
• Extensive experience in data migration and migration planning in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutions.
• Extensive experience with various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, conduct data analysis, data validation, and solve complex technical problems.
• Experience in migrating document attachments from legacy solution to a new modernized solution.
• Experience working in cloud DB technologies (such as Azure SQL).
• Experience working with ETL tools such as Azure Data Factory, Informatica, etc.
• Experience in development of documentation such as ETL mappings, data dictionaries, 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.
Must haves:
• 7+ years of experience developing and documenting ETL processes for data conversion and migration projects.
• Extensive experience with data migration and migration planning for digital transformation initiatives.
• Extensive experience migrating data from legacy applications to modernized solutions using ETL methodologies.
• Extensive experience with relational databases such as Oracle, MS SQL Server, and Azure SQL Database.
• Extensive experience with complex SQL development, data analysis, data validation, and technical problem resolution.
• Experience migrating document attachments from legacy systems to modernized solutions.
• Experience with cloud database technologies (e.g., Azure SQL).
• Experience with ETL tools such as Azure Data Factory, Informatica, or similar technologies.
• Experience developing ETL and data migration documentation, including ETL mappings, data dictionaries, business cases, data migration strategies and plans.
Preferred Qualifications
• 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.
• Previous experience working in Government or Public Sector organizations.
Skills and Experience
Resume evaluation criteria:
• Data Knowledge Expertise Skills (35 points): 7+ years of data conversion and migration experience; migration from different legacy platforms to a new solution; full life-cycle enterprise data conversion and deployment; data analysis, troubleshooting and complex technical problem solving; conversion activities including extraction, profiling, cleansing, import, manipulation, transformation and loading; to-be migration requirements; Information Management principles; cutover support; case management data models and large case management application conversion; attachment file migration.
• Technical Skills (35 points): Informatica, Azure Data Factory and cloud technologies; Oracle SQL, PL-SQL and SQL Server; complex multi-source query statements and table relationships; Oracle, MS SQL Server and Azure SQL Database; mainframe data formats, data types, segments and non-relational structures; data conversion scripts and tools; file migration from Azure BLOB, Azure file share, SharePoint and Oracle BLOBs; mapping, interfaces, conversion work, data exclusion/inclusion, documentation, converted-data validation, and data dictionary development and updates; specifying load programs with a development or dedicated conversion team.
• Communication Skills (25 points): Communication, facilitation, negotiation, consensus building and problem-solving; periodic status reporting and presentation of data migration strategy and approach to executives and stakeholders.
• Public Sector Experience (5 points): Previous Government or Public Sector experience.