Data Engineer - DataStage ETL IV

Overview

Data Engineer - Data Stage ETL IV (Remote)

Primary

Location:

Remote

V-Soft Consulting is currently hiring for a Data Engineer - Data Stage ETL IV (Remote) for our premier client.

• 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.

• nCino Experience
• Experience with cloud data platforms (Snowflake/Azure/AWS) for staging/pre-processing.
• Familiarity with CI/CD for scheduling Data Stage/ETL pipelines.
• Experience in banking, regulatory, or compliance-driven data migrations.

Core Technical Expertise:

• Expert-level experience designing and overseeing ETL workflows using IBM Data Stage.
• 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).

Salesforce Migration Expertise:

• 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.

Leadership & Delivery:

• Proven experience leading data migration work streams or teams.
• Ability to drive technical decisions and mentor engineers.
• Strong communication and stakeholder alignment skills.

Technical Leadership & Ownership

• 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 Data Stage/Python ETL design.
• Provide guidance, reviews, and signoff on mapping documents, data cleansing rules, and ETL workflows developed by senior and mid-level engineers.

Execution Leadership:

• 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 Data Stage ETL issues, load failures, and Salesforce API constraints.

Cross-Team Coordination:

• 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.

Quality, Governance & Controls:

• 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.

Documentation & Repeatability:

• 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.

Mentorship & Team Leadership:

• Mentor Data Stage 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.

Qualified candidates should send their resumes to s.

V-Soft Consulting Group is recognized among the top 100 fastest growing staffing companies in North America. V-Soft Consulting Group is headquartered in Louisville, KY with strategic…