Software Developer - ETL - Senior

Position Summary

Justice Technology Services is seeking a Senior Software Developer – ETL to lead and execute data and document migration activities from legacy applications to modernized solutions. The successful candidate will develop and implement data migration strategies, design ETL processes, analyze and profile legacy data, perform data cleansing and transformation, and ensure the accuracy, integrity, and completeness of migrated data.

The role requires extensive experience with relational databases, cloud database technologies, ETL tools, complex SQL queries, and full-lifecycle enterprise data conversion. The candidate will collaborate with business stakeholders, technical teams, and project management to support migration planning, testing, deployment, cutover, reconciliation, and post-migration activities.

Key Responsibilities

A. Data Migration and ETL Development

• Develop, document, and implement ETL solutions for data conversion and migration from legacy applications to modernized systems.
  
• Plan and execute end-to-end data migration activities, including extraction, profiling, cleansing, transformation, loading, and validation.
  
• Analyze legacy data stored across heterogeneous platforms, databases, file systems, and formats.
  
• Develop data migration strategies, data mappings, interfaces, conversion scripts, and load programs.
  
• Migrate document attachments and files from legacy applications to modernized solutions.
  
• Ensure migration solutions are scalable, reliable, and aligned with business and technical requirements.
  

B. Database Development and Data Analysis

• Work with Oracle, Microsoft SQL Server, Azure SQL Database, and other relational database management systems.
  
• Develop and optimize complex SQL and PL/SQL queries across multiple tables and data sources.
  
• Analyze database structures, relationships, master data, transactional data, and data dependencies.
  
• Understand and process mainframe data formats, data types, segments, and non-relational data structures.
  
• Conduct data profiling and identify data quality issues, inconsistencies, and required cleansing activities.
  
• Develop and maintain data dictionaries, ETL mappings, and technical documentation.
  

C. Testing, Validation, and Reconciliation

• Define migration testing strategies, plans, and procedures.
  
• Conduct mock conversions, data validation, and data comparison exercises.
  
• Verify the completeness, accuracy, and integrity of converted data.
  
• Perform post-migration audits, reconciliation, and exception reporting.
  
• Investigate migration errors, resolve technical issues, and implement corrective actions.
  
• Support pre- and post-conversion activities, deployment, and production cutover.
  

D. Stakeholder Collaboration and Support

• Work with business stakeholders and technical teams to understand migration requirements and target-state data needs.
  
• Establish effective working relationships with client personnel and project stakeholders at all organizational levels.
  
• Provide technical assistance during implementation, conversion, migration, and cutover.
  
• Prepare and present migration strategies, approaches, progress updates, and status reports to executives and stakeholders.
  
• Collaborate with development teams and dedicated conversion teams to deliver required system changes and data-loading programs.
  
• Provide knowledge transfer to the project manager and team members throughout the project lifecycle.
  

Mandatory Qualifications and Experience

Candidates must demonstrate the following:

1. ETL and Data Migration: At least 7 years of experience developing and documenting ETL processes for data conversion and migration.
   
2. Legacy System Modernization: Extensive experience planning and executing data migrations from legacy applications to modernized solutions as part of digital transformation initiatives.
   
3. Database Technologies: Extensive experience with Oracle, Microsoft SQL Server, Azure SQL Database, and relational database structures.
   
4. SQL Development: Strong proficiency in complex SQL queries, PL/SQL, data analysis, data validation, and troubleshooting.
   
5. Document and Attachment Migration: Experience migrating document attachments and files from legacy systems to modernized applications.
   
6. Cloud Database Technologies: Experience working with cloud-based database technologies, such as Azure SQL.
   
7. ETL Tools: Hands-on experience with ETL tools such as Azure Data Factory, Informatica, or equivalent technologies.
   
8. Technical Documentation: Experience preparing ETL mappings, data dictionaries, business cases, data migration strategies, and migration plans.
   
9. Information Management: Knowledge of information management principles, concepts, policies, and practices.
   
10. Data Management: Strong understanding of master data, transactional data, and their interdependencies.
    

Preferred Qualifications and Additional Skills

• Full-lifecycle enterprise data conversion experience, including deployment.
  
• Experience with all phases of migration, including data profiling, mapping, cleansing, transformation, loading, validation, and auditing.
  
• Knowledge of mainframe data formats, data types, segments, and non-relational data structures.
  
• Experience migrating files across storage platforms such as Azure Blob Storage, Azure File Share, SharePoint, and Oracle BLOBs.
  
• Experience with data conversion scripts and automated ETL processes.
  
• Experience defining data inclusion and exclusion rules and validating converted data.
  
• Familiarity with case management data models and migration of large-scale case management applications.
  
• Experience coordinating migration requirements with business stakeholders and technical teams.
  
• Experience supporting deployment, cutover, and post-migration reconciliation.
  
• Strong analytical, investigative, logical reasoning, and problem-solving skills.
  
• Excellent communication, facilitation, negotiation, consensus-building, and client relationship management skills.
  
• Ability to manage competing priorities, meet deadlines, and work effectively within a team.
  
• Previous experience working in government or public-sector organizations.
  

Requirements

Evaluation Criteria

Criterion 1: Data Knowledge and Expertise

• 7+ years of experience in data conversion and migration.
  
• Experience migrating data from legacy platforms to new solutions.
  
• Full-lifecycle enterprise data conversion, including deployment.
  
• Data extraction, profiling, cleansing, transformation, loading, and validation.
  
• Data analysis, troubleshooting, and resolution of complex technical issues.
  
• Understanding of information management principles and practices.
  
• Experience with migration cutover and large-scale case management applications.
  
• Experience migrating document attachments and files.
  
• Ability to gather and interpret target-state migration requirements.
  

Criterion 2: Technical Skills

• Experience with ETL tools such as Azure Data Factory and Informatica.
  
• Proficiency in Oracle SQL, PL/SQL, SQL Server, and complex queries.
  
• Strong understanding of relational database structures and relationships across multiple data sources.
  
• Knowledge of Azure SQL Database and cloud technologies.
  
• Familiarity with mainframe data formats and non-relational structures.
  
• Experience with data conversion scripts and file migration across storage platforms.
  
• Experience with data mapping, interfaces, documentation, and data dictionaries.
  
• Ability to specify and deliver data-loading programs and verify conversion accuracy.
  

Criterion 3: Communication Skills

• Strong communication, facilitation, negotiation, and consensus-building skills.
  
• Ability to work effectively with technical teams, business stakeholders, and executives.
  
• Experience preparing status reports and presenting data migration strategies and approaches.
  
• Strong client relationship management and problem-solving capabilities.
  

Criterion 4: Public-Sector Experience

• Previous experience working with government or public-sector organizations.
  

Knowledge Transfer Requirements

The successful candidate will be responsible for transferring knowledge of assigned code, ETL processes, migration solutions, and project documentation to the project manager and team members.

Knowledge transfer will occur throughout the project lifecycle through:

• One-on-one meetings.
  
• Team meetings and technical walkthroughs.
  
• Documentation of code, migration processes, and technical solutions.
  
• Maintaining and sharing relevant documentation through the project’s SharePoint site.