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