Cincinnati, OH, 45217, USA
7 hours ago
Data Engineer
Job Description We are seeking a Senior Data Engineer to execute end to end Salesforce data migrations. Data will be moved from Snowflake to on premise systems to DataStage and then to Salesforce. This role focuses on source to target mapping, IBM DataStage–driven ETL development, data cleansing and validation, mock migration runs, cutover execution, and post load reconciliation. You will collaborate closely with Salesforce administrators, solution architects, product owners, and SMEs to deliver repeatable, auditable, and automation ready migration processes. Key Responsibilities include: • 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. • Provide source data assessment, data quality issues, implement cleansing and standardization routines. • Support mock migration runs, capture error logs, perform root cause analysis, and implement remediation steps. • Perform final migration including cutover activities with business sign off. • Document data mapping rules, data lineage, quality completeness, and referential integrity checkpoints. • Author a comprehensive migration runbook covering workflows, schedules, controls, rollback, and support processes. • Apply migration governance, including quality checks aligned to governance and compliance requirements. • Partner with Salesforce teams to inspect object relationships, loader jobs, and error remediation. • Optimize ETL performance by improving ETL performance and automation. We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/. Skills and Requirements · 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. • Python • Salesforce • Snowflake
Confirm your E-mail: Send Email