Data Engineer - DataStage ETL IV

Data Engineer - DataStage ETL IV (Remote) Primary Location: Remote V-Soft Consulting is currently hiring for a Data Engineer - DataStage ETL IV (Remote) for our premier client. Education And Experience » • 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. Nice to Have: • 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. Knowledge, Skills And Abilities » Core Technical Expertise: • 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). 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 workstreams or teams. • Ability to drive technical decisions and mentor engineers. • Strong communication and stakeholder alignment skills. What You’ll Do Job Responsibilities: 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 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. 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 DataStage 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 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. Interested? Qualified candidates should send their resumes to spedapalli@vsoftconsulting.com 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 locations in India, Canada and the U.S. V-Soft is known as an agile, innovative technology services company holding several awards and distinctions and has a wide variety of partnerships across diverse technology stacks. As a valued V-Soft Consultant, you’re eligible for full benefits (Medical, Dental, Vision), a 401(k) plan, competitive compensation and more. V-Soft is partnered with numerous Fortune 500 companies, exceptionally positioned to advance your career growth. V-Soft Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. For more information or to view all our open jobs, please visit www.vsoftconsulting.com or call (844) 425-8425.