Title: Mainframe Data Conversion Lead - Hybrid
Mandatory skills:
Mainframe Data Conversion, mainframe data,
IBM z/OS, DB2, VSAM, IMS, COBOL-based systems,
Salesforce, Informatica, ETL tool, SQL Server, mainframe data structures, data mapping, cleansing, transformation,
Salesforce, Service Cloud, data accuracy, data conversion,
hypercare, DB2 tables, VSAM files, IMS databases, flat files, COBOL copybooks, data mapping documents, source-to-target mappings,
mainframe sources, ETL processes, Informatica PowerCenter, IICS, SQL Server, SSIS, SQL scripts,
Salesforce APIs, Bulk API, Data Loader, Informatica Salesforce,
data profiling, data quality assessment, data validation, reconciliation, data conversion progress
Description:
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
Previous experience in Mainframe data conversion
Salesforce Expert
Informatica Expert
SQL Server Expert
Preferred Skills
Informatica Data Quality (IDQ)
MuleSoft
Salesforce Service Cloud
Notes:
This is a Hybrid position and expected to be in office once a week.
Hours/Week: 40
VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at hr@viva-it.com for any complaints, comments and suggestions.
Contact Details :
Account co-ordinator: Ramadas Kumaresan, Phone No: (847) 786-5904, Email: staffing10@viva-it.com
VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008
staffing10@viva-it.com | http://www.viva-it.com