Data Engineer - DataStage ETL III

V-Soft Consulting Group, Inc. is currently hiring for a Data Engineer - DataStage ETL III. The role involves developing ETL workflows, performing data quality assessments, and collaborating with Salesforce teams to ensure successful data migrations.

Responsibilities:

• Develop source to target mapping specifications including field level transformations, deduplication logic, and validation rules
• Build and configure ETL workflows using IBM DataStage, SQL, and Python to automate extraction, transformation, and loading into Salesforce
• Profile source data; assess data quality issues; implement cleansing and standardization routines
• Execute mock migration runs, capture error logs, perform root cause analysis, and implement remediation steps
• Perform final production data loads and verifications with business signoff
• Partner with Salesforce teams to respect object relationships, load order, and platform limits during migrations
• Author a comprehensive migration runbook covering workflows, schedules, controls, rollback, and support procedures
• Implement quality checks, lineage notes, and audit artifacts aligned to governance and compliance requirements
• Contribute to continuous improvement by optimizing ETL performance and automating repetitive validation tasks
• Produce reconciliation reports to validate accuracy, completeness, and referential integrity postmigration
• Validated data extraction files from source Salesforce org (or legacy systems)
• MOCK (3) data loads into target Salesforce org with verification

Requirements:

• Bachelor's degree in Computer Science, Information Systems, or equivalent practical experience
• 7+ years of data engineering experience, including 3+ years building production ETL pipelines
• Hands-on experience with IBM DataStage for ETL/ELT development
• Strong SQL with proven performance tuning on large datasets
• Demonstrated ability to perform data mapping, cleansing, deduplication, and validation
• Working understanding of data governance, quality checks, lineage, and compliance
• Experience optimizing ETL jobs and troubleshooting data load issues
• 3 + years of experience in ETL space
• 3+ years of proven experience with IBM DataStage
• Business Intelligence - Systems/ETL
• SQL
• Prior delivery of at least one enterprise CRM or Salesforce migration is strongly preferred
• Knowledge of the Salesforce data model (objects, relationships, metadata, constraints)
• Experience with Salesforce Data Loader or comparable migration tools
• Familiarity with Snowflake or another cloud data warehouse for staging/landing zones
• Exposure to CI/CD for scheduling and deploying DataStage jobs and Python scripts
• Proficiency in Python (or similar scripting language) for data manipulation and automation
• Python
• Salesforce
• Snowflake