Apply on Employer Site

V-Soft Consulting Group, Inc. · 11 hours ago

Data Engineer - DataStage ETL IV

United States

Contract

Remote

Senior Level, Lead/Staff

10+ years exp

V-Soft Consulting Group, Inc. is currently hiring for a Data Engineer - DataStage ETL IV to support their premier client. The role involves technical leadership in designing and overseeing ETL workflows, particularly for Salesforce migrations, while also providing mentorship and driving technical decisions.

Artificial Intelligence (AI)ConsultingInformation TechnologySoftware

Growth Opportunities

H1B Sponsor Likely

Responsibilities

Own the end-to-end technical design of Salesforce migration pipelines, including load strategy, dependency sequencing, staging architecture, and data quality controls

Serve as the primary technical decision-maker for mapping logic, transformation patterns, validation strategies, and DataStage/Python ETL design

Provide guidance, reviews, and signoff on mapping documents, data cleansing rules, and ETL workflows developed by senior and mid-level engineers

Oversee and coordinate all migration phases: profiling, mapping, extraction, transformation, cleansing, mock runs, remediation, final load, and post load reconciliation

Lead the creation of repeatable migration templates (mapping patterns, validation scripts, transformation libraries, reconciliation frameworks)

Troubleshoot the most complex DataStage ETL issues, load failures, and Salesforce API constraints

Partner closely with Salesforce architects to determine object load order, relationship handling, and platform constraints

Work with business SMEs to validate mapping logic, resolve data issues, and approve reconciliation reports

Coordinate across Salesforce, infrastructure, release management, and governance teams to align dependencies and cutover planning

Define and enforce data validation rules, DQ acceptance thresholds, rejection criteria, and reconciliation metrics

Ensure compliance with metadata, lineage, audit, and regulatory standards

Drive defect management workflows for mock runs and ensure timely root-cause resolution

Oversee and approve the migration runbook, including workflows, controls, schedules, rollback strategies, and support procedures

Ensure all engineers document mappings, transformation rules, cleansing logic, and validation designs to project standards

Mentor DataStage developers, senior engineers, and analysts on transformation logic, debugging, and best practices in migration engineering

Lead technical reviews and provide ongoing coaching to uplift the team’s maturity and consistency

Qualification

IBM DataStageSalesforce migrationAdvanced SQLPythonCloud data platformsData governanceTechnical leadershipCommunication skillsMentorship

Required

Bachelor's degree or equivalent experience

10+ years in data engineering; 3+ in technical leadership roles

Successful delivery of at least one large-scale Salesforce (or enterprise CRM) migration

Expert-level experience designing and overseeing ETL workflows using IBM DataStage

Advanced SQL, including performance tuning, complex joins, windowing, and large-volume optimization

Strong Python skills for automation, validation scripting, data corrections, and transformation logic

Deep experience performing mapping, cleansing, deduplication, validation, and reconciliation for large datasets

Strong command of data governance (DQ rules, lineage, controls, audit requirements)

Strong understanding of Salesforce data model (objects, relationships, lookups, constraints, metadata)

Experience leading migrations using Data Loader, Bulk API, or other Salesforce ingestion tooling

Experience designing load ordering strategies and resolving hierarchical or relational dependencies

Proven experience leading data migration workstreams or teams

Ability to drive technical decisions and mentor engineers

Strong communication and stakeholder alignment skills