IDMS Data Integration Specialist

Client: Miami DadeCounty

Department: Information Technology Department (ITD)

Job Title: IDMS Data Integration Specialist

Location: Miami-Dade County, FL

Onsite/Remote/Hybrid: Hybrid

Duration: 6 months

No of positions: 1

Additional Information:

1. WORK MODE: (Expected to come in person for meetings and/or workshops). Must be located in South Florida.
2. CONSULTANT REQUESTED: The six months will start on the date the consultants are hired.

Project Scope:

The Court Case Management System (CCMS) implementation is a transformative initiative aimed at replacing outdated legacy systems with a modern, integrated platform to improve court operations, data accessibility, and public service delivery. A critical component of this effort involves the migration of legacy data from IDMS-based mainframe systems and the integration of COBOL applications with modern distributed systems via APIs. 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.

Roles/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 legacy 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

Mandatory Skills:

1. Deep experience with IDMS databases, COBOL, and JCL in a mainframe environment.
2. Ability to analyze and understand complex legacy data structures and workflows.
3. Proficiency in designing and implementing ETL processes for data migration.
4. Experience with data validation, cleansing, and reconciliation techniques.
5. Strong understanding of API development and integration strategies.
6. Experience with API gateways (e.g., Apigee, MuleSoft) or middleware/ESB platforms to connect legacy and modern systems.
7. Ability to develop and maintain COBOL and JCL scripts for data extraction and formatting.
8. Familiarity with scripting for automation and integration support.
9. Strong collaboration skills to work with data architects, business analysts, vendors, and IT teams.
10. Excellent documentation and communication skills for technical procedures and integration workflows.
11. Ability to troubleshoot and resolve complex data and integration issues during migration and post-go-live phases.

Desirable Skills:

1. Bachelor's degree in Computer Science, Information Systems, or a related field.
2. 7+ years of experience working with IDMS databases and COBOL in a mainframe environment.
3. Strong experience with JCL, VSAM, data extraction, and legacy system analysis.
4. Experience with API development, API gateways (e.g., Apigee, MuleSoft), or ESB platforms.
5. Proven experience integrating legacy systems with modern applications using APIs or middleware.
6. Solid understanding of relational and hierarchical data models.
7. Strong analytical, troubleshooting, and problem-solving skills.
8. Experience with court systems, justice applications, or public sector IT projects.
9. Familiarity with modern CCMS platforms (e.g., Tyler Odyssey, Journal Technologies).
10. Knowledge of ETL tools (e.g., Informatica, Talend, SSIS) and scripting languages (Python, Shell).
11. Understanding of data governance, quality assurance, and compliance standards.

Experience working in Agile or hybrid project environments