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
What's Under the HoodDriveTime Family of Brands is the largest privately owned used car sales finance & servicing company in the nation.Headquartered in Tempe, Arizona and Dallas, Texas, we cre... Show more
Tired of rigid Communications, PR, and Advertising roles that hold you back?Pivot into a remote opportunity that offers flexibility, autonomy, and uncapped growth.If you're a senior communications ... Show more
Right at Home – Certified Great Place to Work 2024–2026.Flexible Days, Days, Evenings & Weekends | Full-time / Part-time.Right at Home is seeking a compassionate caregiver to join our team.As a car... Show more
Get AI-powered advice on this job and more exclusive features.Cognitive Medical Systems, Inc.Pay RangeThis range is provided by Cognitive Medical Systems, Inc.Your actual pay will be based on your ... Show more
Are you a dedicated and passionate Board Certified Behavior Analyst (BCBA) seeking a fulfilling opportunity to lead a team and make a profound impact in a community-focused setting? Join us at The ... Show more
Premier ABA Provider for Children with AutismWe are a Responsive Employer - we will be in touch with you within 24 hours of applyingWhy Traveling BCBAs Choose ABC :Full Time, Permanent PositionRemo... Show more
Investor Services Quality Assurance Analyst.Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889.Nor... Show more
DataAnnotation is committed to creating high-quality AI.Enjoy the flexibility of remote work and the freedom to set your own schedule.This is an opportunity to work with us as an independent contra... Show more
Senior Product Designer (Remote) in Phoenix, AZ at LennarLennar is one of the nation's leading homebuilders, dedicated to making an impact and creating an extraordinary experience for homeowners, c... Show more
Job Summary :We are looking for a highly experienced AV Programmer to support and execute control system programming for commercial AV projects across multiple branches.This remote-based role requi... Show more
Branch Manager & Senior Escrow Officer.We are looking for a highly driven Branch Manager & Senior Escrow Officer to lead our Scottsdale office.In this dual-role capacity, you will be the cornerston... Show more
Leadership Education Consultant (Remote) job at THRIVE BEYOND DREAMS.Are you a retired professional or a person exploring a career transition seeking a flexible and purpose-driven role that allows ... 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
Job DescriptionJob DescriptionKyo is a leading provider of Applied Behavior Analysis (ABA) therapy, dedicated to empowering children with autism and their families to achieve meaningful outcomes.Si... Show more
We are urgently seeking people interested in taking market research studies for well known brands.If you are a self-starter, looking for flexible hours throughout the week, this may be for you! Ear... Show more
Registered Behavior Technician (RBT).The Registered Behavior Technician (RBT) is responsible for implementing client-specific behavior intervention plans and skill acquisition programs under the su... Show more
Job Search keyword location :Enter any keyword including company name, job title in the search box.CA, IL) or enter city name, state code (e.Disclaimer :Jobs listed on h1bgrader.It is up to the dis... Show more
AI data lab for training frontier models and evaluating AI agents.Experts contribute their diverse subject matter knowledge across domains such as finance, healthcare, STEM engineering, and more.AI... Show more
Excellent opportunity to join a leading, national credit card processing company that has over a decade of industry experience.Slice Merchant Services offers innovative payment processing solutions... Show more
JOB DESCRIPTIONJob SummaryThe Molina Healthcare Internship Program shares an objective to create a stepping stone for students who aim to be professionals and future leaders in the healthcare busin... Show more
