Overview
Skills
Job Details
We have an opening for IDMS Data Integration Specialist
Location - Miami, FL (Remote)
Required local candidate
Duration - 12+ months
Key Responsibilities:
-Analyze and understand legacy IDMS database structure, schemas and relationships.
-Design and implements ETL processes to extract, transform and load (ETL) data from IDMS into the CCMS.
-Collaborate with business analyst 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 structure, 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.
Qualification Required
-Bachelor degree in computer science, information system or related field
-7+ years of experience working with IDMS database 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