2,351,589open jobs
147,302companies
280,761added this week
Browse all
Location
In office (Phoenix)
Seniority
Architect · 5+ years exp
Visa
H-1B filings in 12 months: 13 · for this role: 11 · green card filings: 6
Employment
Contractor

Confirmed on the employer's own hiring board on Nov 17, 2026. First seen by Alion on Nov 17, 2026.

Overview
Company
Impact
Profile match
Novalink Solutions is an IT consulting and staffing company based in Suwanee, Georgia, that provides contract and direct-hire IT staff, managed IT services, cybersecurity, cloud, ERP and application development to government and commercial clients. Founded in 2003, the firm places consultants with state transportation, revenue and technology agencies in Virginia, Wisconsin, South Carolina, Tennessee, Pennsylvania and Florida. It recruits database administrators, mainframe and full-stack developers, project managers, business and data analysts, network engineers, help desk technicians and administrative assistants.

We are seeking an experienced Salesforce Data Migration Architect / Conversion Lead to drive the end-to-end data transformation for modernizing our core mainframe application, into a modern Salesforce architecture.

This role requires a hybrid skill set: deep technical understanding of legacy mainframe data structures (DB2, flat files) paired with hands-on expertise in relational database staging environments and modern Salesforce data architecture (Bulk API 2.0, complex relational modeling, and data loading best practices). You will be responsible for designing and executing the entire conversion pipeline-from mainframe staging extraction through intermediate staging transformations (Staging 0 to Staging 1) to target loading in Salesforce.

Key Roles & Responsibilities

Mainframe Data Extraction & Intermediate Staging

Decode and extract legacy case management records from AZCCATS (handling fixed-width files, EBCDIC formats, packed decimals, and COBOL copybook layouts).

Design and manage the relational database staging architecture:

Staging 0 (Raw Layer): Direct ingestion and structural alignment of raw mainframe extracts.

Staging 1 (Transformation Layer): Cleansing, standardization, de-duplication, cross-referencing legacy case IDs, and constructing target-ready data structures.

Write performant SQL transformations, stored procedures, and staging scripts to validate data sanity prior to target ingestion.

2. ETL Development with Informatica

Build, optimize, and maintain Informatica mappings, mapplets, sessions, and workflows to transform AZCCATS data structures into normalized Salesforce objects.

Implement error handling, surrogate key lookups, rejection routing, and audit-logging routines directly within Informatica.

Maintain field-level Source-to-Target Mapping (STTM) documentation, ensuring complete tracing from legacy AZCCATS case histories to Salesforce fields.

3. Workload Orchestration with Atomic Scheduler

Build, schedule, and maintain complex job chains, dependencies, and event triggers using Atomic Workload Automation.

Automate the sequence of operations: trigger mainframe file transfers, execute intermediate database staging scripts, run Informatica workflows, and initiate target load scripts.

Implement automated alerting, error monitoring, and checkpoint-restart procedures within Atomic to guarantee automated recovery of interrupted conversion jobs.

4. Target Ingestion & MuleSoft Coordination

Architect and execute high-volume data loads into Salesforce Case Management (Cases, Contacts, Accounts, Case History, Notes, Docket Records, and Custom Objects) using Salesforce Bulk API 2.0.

Establish and populate External ID fields across Salesforce objects to ensure idempotent, upsert-capable, and repeatable data conversions.

Temporarily bypass and reactivate Salesforce automations (Apex Triggers, Record-Triggered Flows, Validation Rules) during bulk loads to optimize throughput and preserve historical audit timestamps.

Coordinate with the MuleSoft integration team to align data mapping schemas with active APIs and avoid payload conflicts during cutover windows.

5. Quality Assurance, Reconciliation & Cutover

Develop automated data reconciliation scripts comparing source AZCCATS record counts and field checksums against target Salesforce entities.

Execute iterative mock conversions, validate data integrity with business and audit teams, and build a time-sequenced production cutover runbook.

Mandatory Technical Experience

Salesforce (5+ years):

Proven experience migrating complex case management data into Salesforce (Service Cloud or Custom Case Architecture).

In-depth expertise with Salesforce Bulk API / Bulk API 2.0, Data Loader, SOQL, and relational object modeling.

Practical knowledge of governor limits, bulk storage limits, and automation bypass techniques.

Informatica (5+ years):Extensive hands-on experience developing enterprise data conversion mappings and workflows using Informatica (PowerCenter Or IICS)

Expertise with complex transformations, parameter files, performance tuning, and error recovery.

Atomics (Atomic) Scheduler (3+ years): Direct experience designing, configuring, and monitoring batch workflows, calendar schedules, and multi-systems dependencies with Atomic/UC4.

Database & SQL (5+ years): Advanced SQL skills, schema design, performance indexing, and transformation logic with relational database environments (SQL server, Oracle, PostgreSQL or DB2).

Mainframe AZCCATS Conversion: Direct experience working with mainframe extracts (EBCDIC conversion, sequential files, VSAM/DB2 data, and COBOL copybooks).

MuleSoft: Practical understanding of MuleSoft APIs, integration patterns, and data contract alignment between migration bathc process and real-time interfaces.

Requirements

Required Skills

Skill Type

Skill Name

5+ years Salesforce experience

5+ years Informatica experience

MuleSoft experience

Preferred Skills

There are currently no preferred skills to display. Please review job description.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,351,589 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Enterprise Apps
Remote, many countries
Similar stack
Same company
Phoenix
Equity · In office · Full-Time · 8+ years exp · Bellevue · Arlington
Java
AI/ML
AWS Bedrock
Amazon SageMaker
Machine Learning
DevOps
Terraform
Ansible
AWS CDK
AWS
Configuration Management
Amazon EC2
Amazon S3
Management
Agile
Scrum
Apply
$194k – $231k per year · In office · Full-Time · Chicago · Milwaukee · Dallas · Columbus · Kirkland
AI/ML
Copilot
Copilot Studio
DevOps
Azure
Apply
$194k – $231k per year · In office · Full-Time · Chicago · Milwaukee · Dallas · Columbus · Kirkland
AI/ML
Copilot
Copilot Studio
DevOps
Azure
Management
Power Automate
Power Apps
Apply
In office · Full-Time · 5+ years exp · Bachelor's Degree · New York
ABAP
ABAP
SAP BTP
DevOps
Rest API
SOAP
Apply
$144k – $223k per year · In office · Full-Time · 6+ years exp · Bachelor's Degree · Salt Lake City
Python
Java
TypeScript
C#
Apex
Apex
Lightning Web Components
Databases
Apache Kafka
DevOps
Rest API
AWS
SOAP
Management
ServiceNow
Apply
Remote (likely EAEU) · 5+ years exp · Moscow
SQL
1C
Databases
MS SQL
DevOps
Rest API
Prometheus
Grafana
SOAP
Apply
$66k per year (net) · Remote (likely EAEU) · Moscow
1C
DevOps
Rest API
SOAP
Apache HTTP Server
Apply
Remote (EAEU) · 6+ years exp · Moscow
1C
Apply
$50k per year (net) · Remote (likely EAEU) · Moscow
1C
Apply
Remote (likely EAEU) · Bachelor's Degree · Nizhny Novgorod
1C
Apply
Production Operator 9 hours ago
$36k per year · In office · Full-Time · Phoenix
Apply
Group Room Coordinator 10 hours ago
In office · Full-Time · 1+ year exp · PhD · Phoenix
Apply
In office · Full-Time · 5+ years exp · Bachelor's Degree · Phoenix · Milwaukee · Kansas City · Philadelphia · Charlotte
Apply
Equity · In office · Full-Time · Bachelor's Degree · Phoenix
Apply
In office · Full-Time · High School Diploma · Phoenix
Apply
See all jobs
This is one of many
2,351,589 more open roles from verified company boards, updated every day.