Mainframe Data Conversion Lead
6 Months
Phoenix, AZ 85007
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
Previous experience in Mainframe data conversion (This must be on Resume)
Salesforce Expert
Informatica Expert
SQL Server Expert
Preferred Skills
Informatica Data Quality (IDQ)
MuleSoft
Salesforce Service Cloud
Mainframe Data Conversion Lead - Phoenix, AZ (Hybrid) • Phoenix, Arizona, United States
Dallas, Texas, United States Or refer someone Job Openings Data Governance Lead.Data Governance Lead (Collibra OR Alation).Hybrid (3 days onsite, 2 days work from Home).Pittsburgh / Cleveland / Dal... Show more
Software Guidance & Assistance, Inc.SGA), is searching for an IT Business Analyst / Sys Admin for a short -month contract assignment with one of our premier Infrastructure services clients.Desi... Show more
Job Title:Quality Assurance Plant Monitor/Truck Sampler-De-linterJob Location:Bapchule, AZJob Duration:12 Months on W2This position is responsible for assisting the Quality Control group to conduct... Show more
GenAI Business Analyst/Product Owner.Locations: Phoenix AZ, Chicago, IL.Onsite expectation: Hybrid 3x/week onsite.Note: We are unable to consider C2C or third-party submissions.Seeking a dynamic an... Show more
AI Enablement & Field Intelligence Lead (AEC) - Phoenix.Location: Remote (US only) + 6080% travel to jobsites nationwide.A Note Before You Read Further.The world is changing fast, and so is this ro... Show more
Define data platform vision, OKRs and outcome-based roadmaps for many agile teams.Build influential relationships with partners, stakeholders, and user groups to drive outcomes including platform a... Show more
Get a maximum of $400 in bonuses in Phoenix.Earn $100 for every 10 rides in 7 days (limit 4).Lyft is a flexible earning opportunity and a platform that connects drivers with individuals that need r... Show more
Senior Power BI DeveloperLocation :RemoteMust support Phoenix based hoursGC / USC only!!!RESPONSIBILITIES :Collaborates and partners with business and technology experts to establish the technical ... Show more
Earn up to $400/week, depending on the number and type of studies you complete.Share honest feedback on products and services from independent brands.Assignments include short online surveys (10–20... Show more
AlgoFace Enterprise Sales Director.AlgoFace, the Ethical FaceAI enablement company, seeks an entrepreneurial Enterprise seller to expand existing and break into new business relationships with Glob... Show more
Grand Canyon Bu - Region 01 - Market 01.N John Wayne Pkwy, Maricopa, Arizona 85139.Full time Flexible Availability.Directly supervises the activities of 2 or more full-time employees which may incl... Show more
Job Title Technology Lead Big Data - NoSQL MarklogicWork Location: Scottsdale AZ 85251Vendor Rate market rate/hrContract duration (in months) 12Job Details:Must Have Skills (Top 3 technical skills ... Show more
Base+Commission/year Position Type Full Time.My Wireless Assistant Retail Store Manager, an AT&T Authorized National Retailer, is currently looking for an Assistant Retail Store Manager to join its... Show more
Registered Behavior Technician (RBT).Casa Grande, Arizona, Oracle, Arizona, Florence, Arizona, Maricopa Arizona, Coolidge Arizona.The Registered Behavior Technician (RBT) is responsible for impleme... Show more
Registered Client Associate/Branch Service ManagerAs a Registered Client Associate (RCA)/Branch Service Manager (BSM) at RBC Wealth Management, you will embrace our core values and inclusive cultur... Show more
Hi Mainframe System Programmer Location :100% remote Duration :12 Months Contract Job Responsibilities Perform standard system programming activities like configuration, installation & maintena... Show more
Opening Soon: Treetop ABA ClinicHybrid BCBA Role $95,000“$110,000 Sign-On Bonus Diverse CaseloadOur new Treetop ABA clinic is opening soon, and we're looking for a passiona... Show more
At National Bank of Arizona, we're a community of professionals with relationships at our core.We strive to promote an engaging environment with accessible leadership and on-going employee developm... Show more
Discover The System Surveoo That’s Helping Newbies Earn Daily.Turn your free time into daily earnings by answering simple surveys.No product or tech skills needed.Join For Free And Start Earn... Show more
Product Manager, Data Platform (BI Tools).This Sr Product Manager role is at an individual contributor level meaning it is a manager of things, not people.To be considered candidates must have cons... Show more
