Data Engineer - DataStage ETL IV

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.

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

Requirements:

• 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
• 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
• nCindo Experience
• Experience with cloud data platforms (Snowflake/Azure/AWS) for staging/pre-processing
• Familiarity with CI/CD for scheduling DataStage/ETL pipelines
• Experience in banking, regulatory, or compliance-driven data migrations