Mainframe Data Conversion Lead
Contract W2
No Travel Required
Hybrid
Depends on Experience
Abacus Service Corporation
Fitment
Dice Job Match Score™
⏳ Almost there, hang tight...
Job Details
Skills
- Mainframe
- COBOL
- Z/OS
- DB2
- VSAM
- IMS
- ETL
- SQL Server
- Data conversion
- migration
- Salesforce
- IICS
- Informatica
- Informatica PowerCenter
- Legacy Modernization
Summary
Position Description:
This is a Hybrid position and expected to be in office once a week. Local candidates only.
We are seeking an experienced Mainframe Data Conversion Lead to lead the complex migration of legacy mainframe data (primarily IBM z/OS, DB2, VSAM, IMS, and COBOL-based systems) into Salesforce using Informatica as the primary ETL tool and SQL Server as the staging and transformation platform.
The ideal candidate will have deep expertise in mainframe data structures, data mapping, cleansing, transformation, and loading into Salesforce (Service Cloud, and custom objects). This role is critical in ensuring data accuracy, integrity, and compliance during large-scale data conversion initiatives.
Key Responsibilities:
Lead end-to-end mainframe data conversion projects from discovery through go-live and hypercare.
Analyze and document mainframe data structures including DB2 tables, VSAM files, IMS databases, flat files, and COBOL copybooks.
Design and develop data mapping documents, source-to-target mappings, and transformation rules from mainframe sources to Salesforce objects.
Build, optimize, and maintain robust ETL processes using Informatica PowerCenter / IICS for extraction, cleansing, transformation, and loading.
Use SQL Server (stored procedures, SSIS, SQL scripts) as an intermediate staging, cleansing, and reconciliation platform.
Work closely with Salesforce architects and developers to ensure data is loaded efficiently using Salesforce APIs, Bulk API, and Data Loader (or Informatica Salesforce Connector).
Perform data profiling, data quality assessment, cleansing, deduplication, and enrichment.
Develop and execute data validation, reconciliation, and cutover plans with business and technical teams.
Mentor junior team members.
Establish and enforce data conversion best practices, standards, and governance.
Provide regular status reporting to project management and stakeholders on data conversion progress, risks, and issues.
10+ years of overall data integration / ETL experience with at least 5+ years specifically in Mainframe to Modern Platform data migrations.
Strong experience migrating data from IBM Mainframe environments (z/OS, DB2, VSAM, IMS, COBOL, JCL).
Expert-level hands-on experience with Informatica Intelligent Cloud Services (IICS).
Strong proficiency in SQL Server development (T-SQL, stored procedures, performance tuning).
Solid experience with Salesforce data migration (Salesforce objects, Data Loader, Bulk API, Salesforce Connect, External Objects).
Deep understanding of data modeling, normalization, hierarchical vs relational data structures, and mainframe-to-relational conversion techniques.
Experience in large-scale Data Conversion / Legacy Modernization projects (highly preferred).
Strong knowledge of data quality frameworks and tools.
Excellent analytical, problem-solving, and communication skills.
Ability to work independently and lead cross-functional teams.
Required Skills
Skill Type
Skill Name
Previous experience in Mainframe data conversion (This must be on Resume)
Salesforce Expert
Informatica Expert
SQL Server Expert
Preferred Skills
Skill Type
Skill Name
Informatica Data Quality (IDQ)
MuleSoft
Salesforce Service Cloud
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.
- Dice Id: 10122208
- Position Id: 8968473
- Posted 1 hour ago
Company Info
Abacus Service Corporation is a full service employment solutions firm designed around the ability to provide agile contingent workforce solutions.
Formed in 2004 by industry veterans, Abacus Service Corporation implemented guiding principles with best in industry processes and innovative technologies, to form an influential force in employment solutions. Abacus Service Corporation was founded in Farmington Hills, Michigan and has grown to become a nationwide presence with offices in 18 locations and two international offices. Through our locations, Abacus has been able to offer our clients cost effective and quality employment solutions regardless of the geographic coverage based on our successful strategies. Abacus is a privately held company with employees in 27 US states and four Canadian Provinces. Abacus is MBE and WBE certified nationally and upholds our commitment to diversity by adhering to a philosophy of recruiting employees from diverse backgrounds. Our extensive experience, passion to deliver the best in class solutions, and dedication to customer service has allowed Abacus to become the workforce ally of our clientele.
Formed in 2004 by industry veterans, Abacus Service Corporation implemented guiding principles with best in industry processes and innovative technologies, to form an influential force in employment solutions. Abacus Service Corporation was founded in Farmington Hills, Michigan and has grown to become a nationwide presence with offices in 18 locations and two international offices. Through our locations, Abacus has been able to offer our clients cost effective and quality employment solutions regardless of the geographic coverage based on our successful strategies. Abacus is a privately held company with employees in 27 US states and four Canadian Provinces. Abacus is MBE and WBE certified nationally and upholds our commitment to diversity by adhering to a philosophy of recruiting employees from diverse backgrounds. Our extensive experience, passion to deliver the best in class solutions, and dedication to customer service has allowed Abacus to become the workforce ally of our clientele.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs