Senior Data Engineer with Python & SQL
Core
Designing and executing data migration and ETL/ELT workflows to move and transform data into Salesforce environments.
Role type
Senior Data Engineer (ETL/Migration)
Builds
Automated ETL pipelines and data migration solutions for Salesforce
Domain
Data Engineering, Cloud Data Warehousing, CRM
Required skills
IBM DataStage, SQL, Python, Data Governance, Data Quality, ETL Process Optimization, Data Mapping, Data Cleansing, Validation, Root Cause Analysis
Preferred skills
Salesforce, Snowflake
Technologies
IBM DataStage, SQL, Python, Salesforce, Snowflake
Responsibilities
Develop specifications for source-to-target mappings including field transformations and validation criteria. Build and configure ETL workflows utilizing IBM DataStage, SQL, and Python to automate data extraction, transformation, and loading into Salesforce. Analyze source data, identify quality issues, and implement cleansing and standardization routines. Conduct mock migration runs, document error logs, perform root cause analysis, and apply remediation steps. Execute final production data loads and confirm verifications with business approval. Generate reconciliation reports to validate the accuracy and completeness of the data after migration.
Seniority
Senior, hands-on IC