Data Engineer - DataStage ETL III
BC Forward
Cincinnati, OH(remote)
Job Title: Data Engineer - DataStage ETL III
Location: Remote (Onshore)
Duration: Contract - 8 months
Pay Range: $62.07/hr (W2)
Job ID: 372327
About BCforward
BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.
Job Description
We are seeking a Senior Data Engineer to join our team and execute end-to-end Salesforce data migrations. The ideal candidate will have strong experience in IBM DataStage-driven ETL, SQL, and Python and a proven ability to deliver repeatable, auditable, automation-ready migration processes across Snowflake, on-prem systems, DataStage, and Salesforce.
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, and 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 sign-off.
- Produce reconciliation reports to validate accuracy, completeness, and referential integrity post-migration.
- 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.
- Partner with Salesforce teams to respect object relationships, load order, and platform limits during migrations.
- Contribute to continuous improvement by optimizing ETL performance and automating repetitive validation tasks.
Required Skills & Qualifications:
- Hands-on experience with IBM DataStage for ETL/ELT development.
- Strong SQL with proven performance tuning on large datasets.
- Demonstrated ability in 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.
- 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.
Preferred Skills:
- Knowledge of the Salesforce data model, including objects, relationships, metadata, and constraints.
- Experience with Salesforce Data Loader or comparable migration tools.
- Familiarity with Snowflake or another cloud data warehouse for staging and 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.
- Prior delivery of at least one enterprise CRM or Salesforce migration is strongly preferred.
Why BCforward?
At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to:
- Competitive compensation and benefits.
- Opportunities for growth with global clients.
- A supportive, inclusive culture that values innovation and people.
- Exposure to cutting-edge technologies and projects.
About Our Commitment
BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status.
Interested? Apply Now!
If this sounds like the right opportunity for you, please apply with your most recent resume.
Email:
Phone: