IDMS Data Integration Specialist

Overview

On Site
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 6 month(s)

Skills

Data Integration
UI
Information Technology
Network
Microsoft
Tier 1
Cloud Computing
Recruiting
Training
Partnership
Data Mapping
RESTful
Adapter
Testing
Acceptance Testing
Mapping
System Integration
Data Structure
Data Migration
Data Validation
Collaboration
Documentation
Communication
Workflow
Migration
Computer Science
Information Systems
IDMS
Database
COBOL
Mainframe
JCL
VSAM
Data Extraction
API
MuleSoft
Enterprise Service Bus
Legacy Systems
Middleware
Analytical Skill
Conflict Resolution
Problem Solving
Public Sector
Extract
Transform
Load
Informatica
Talend
Microsoft SSIS
Scripting
Python
Shell
Data Governance
Quality Assurance
Regulatory Compliance
Agile
Oracle Linux

Job Details

CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.
we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.
We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.
If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.

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.
  12. Experience working in Agile or hybrid project environments.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About CCS Global Tech