Software Developer - ETL - Senior

A Note on Assignment Type:

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.

Experience and Skill Set Requirements

A Note on the VOR Master Service Agreement:

The VOR Master Service Agreement expires on April 5, 2027, and includes a six (6)-month survival clause, allowing the Statement of Work (SOW) to continue, if operationally required, until October 5, 2027. Extension(s) are only allowed using unused days and/or funds remaining on the contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW.

JTS may exercise its option(s) to extend the SOW beyond April 5, 2027, in accordance with the survival clause.

The start date is subject to change based on security clearances and contract signing timelines.

Experience and Skillset Requirements

Mandatory Requirements

• 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.

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
• 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

Resumes Evaluation/Criteria:

Criteria 1:
Data Knowledge Expertise Skills - 35 Points

• 7+ years of experience in developing data conversion and migration
• At least one experience of working with migrating data from different legacy…