IDMS Data Integration Specialist

IDMS Data Integration Specialist

WORK LOCATION: TBD Miami, FL

NUMBER OF POSITION AVAILABLE: 1 Position

WORK MODE (ON SITE, REMOTELY OR HYBRID) HYBRID. (Expected to come in person for meetings and/or workshops).

Must be located in South Florida.

CONSULTANT REQUESTED FOR 6 MONTHS The six months will start on the date the consultants are hired.

Key Responsibilities:

• Analyze and understand legacy IDMS database structures, schemas, and relationships.
• Design and implement ETL processes to extract, transform, and load (ETL) data from IDMS into the ccMs.
• Collaborate with business analysts and data architects to define data mapping and transformation rules.
• Develop COBOL and JCL scripts to support data extraction, formatting, and legacy system interactions.
• Design and implement integration solutions to enable communication between IDMS/COBOL systems and modern distributed platforms using RESTful APIs or middleware.
• Support the development of API gateways, adapters, or connectors to bridge legacy and modern systems.
• Perform data validation, cleansing, and reconciliation to ensure accuracy and completeness.
• Participate in integration and migration testing, including mock conversions and user acceptance testing (UAT).
• Document data structures, mapping logic, integration workflows, and technical procedures.
• Troubleshoot and resolve data and integration-related issues during migration and post-go-live phases.
• Collaborate with CCMS vendors, internal IT teams, and external partners to ensure successful data and system integration.

Minimum Skills Required:

• Deep experience with IDMS databases, COBOL, and JCL in a mainframe environment.
• Ability to analyze and understand complex legacy data structures and workflows.
• Proficiency in designing and implementing ETL processes for data migration.
• Experience with data validation, cleansing, and reconciliation techniques.
• Strong understanding of API development and integration strategies.
• Experience with API gateways (e.g., Apigee, MuleSoft) or middleware/ESB platforms to connect legacy and modern systems.
• Ability to develop and maintain COBOL and JCL scripts for data extraction and formatting.
• Familiarity with scripting for automation and integration support.
• Strong collaboration skills to work with data architects, business analysts, vendors, and IT teams.
• Excellent documentation and communication skills for technical procedures and integration workflows.
• Ability to troubleshoot and resolve complex data and integration issues during migration and post-golive phases.
• We are seeking a highly skilled IDMS Data Integration Specialist to support the migration and integration of legacy mainframe systems into a modern Court Case Management System (CCMS). This role will focus on both data migration from IDMS databases and the real-time integration of COBOL-based legacy applications with modern distributed systems using APIs. The ideal candidate will have deep experience with IDMS, COBOL, and mainframe environments, along with a strong understanding of API-based integration strategies.

Qualifications:

Required:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 7+ years of experience working with IDMS databases and COBOL in a mainframe environment.
• Strong experience with JCL, VEGA, data extraction, and legacy system analysis.
• Experience with API development, API gateways (e.g., Apigee, MuleSoft), or ESB platforms.
• Proven experience integrating legacy systems with modern applications using APIs or middleware.
• Solid understanding of relational and hierarchical data models.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent documentation and communication skills.

Preferred:

• Experience with court systems, justice applications, or public sector IT projects.
• Familiarity with modern CCMS platforms (e.g., Tyler Odyssey, Journal Technologies).
• Knowledge of ETL tools (e.g., Informatica, Talend, SSIS) and scripting languages (e.g., Python, Shell).
• Understanding of data governance, quality assurance, and compliance standards.
• Experience working in Agile or hybrid project environments.