Data Engineer-DataStage

Encore Talent Solutions has partnered with a client in the Cincinnati, OH area to identify a Data Engineer on a contract need through 2026, including extensions/options to hire. This role will require FULL ONSITE WORK in the Cincinnati, OH area. • Must be W2 eligible without any visa transfer/sponsorship restrictions • C2C/1099 and 3rd party profiles will not be considered or reviewed at this time Job Description We are seeking a Senior Data Engineer to join our dynamic team. In this role, you will play a key part in executing end-to-end Salesforce data migrations. You will collaborate with cross-functional teams and stakeholders to deliver high-quality solutions in a fast-paced environment. Key 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 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 Qualifications: • Proficiency in: IBM DataStage, SQL, Python. • Relevant certifications: Bachelor’s degree in Computer Science, Information Systems, or equivalent practical experience. • Strong problem-solving and analytical skills. • Excellent communication and teamwork abilities. • 7+ years of data engineering experience, including 3+ years building production ETL pipelines. • 3+ years of experience in ETL space. • 3+ years of proven experience with IBM DataStage. • Business Intelligence - Systems/ETL. • 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. Preferred Qualifications • Experience with: Python, Salesforce, Snowflake. • 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. • Prior delivery of at least one enterprise CRM or Salesforce migration is strongly preferred. Work Environment & Location: • Location: Onsite in Cincinnati. • Collaborative team environment with opportunities for professional growth.