Data Stage ETL Developer

21 Sep 2024

Vacancy expired!

Role Title: Mid-level Data Stage ETL DeveloperLocation: Lansing, MI (Remote possible for hybrid level)Duration: 1+ yearRequired Skills: 4+ years of strong and experienced in Data Stage and familiar with full life cycle of transactional data conversion from multiple systemsIBM InfoSphere DataStage ETL Development1. Create ETL jobs/scripts in IBM DataStage for the following:- extracting data from source (Oracle DB) and dumping in staging database (Oracle DB) - cleansing, deduplication, and transformation of the data in the staging database - loading final data to target (Salesforce)2. Understand the mapping documents (provided by the functional team) and develop scripts/jobs based on that.3. Prepare automated scripts/jobs for validation of transformed data in staging database (Oracle) and loaded data in target (Salesforce)4. Produce reports of the data migration (error records, reconciliation, etc.,) after every ETL cycle.Preferred Skills:Experience with IBM DataStage connector for Salesforce will be a plusConverting into Salesforce

  • ID: #45873480
  • State: Michigan Lansing 48901 Lansing USA
  • City: Lansing
  • Salary: $40 - $60
  • Job type: Contract
  • Showed: 2022-09-21
  • Deadline: 2022-11-10
  • Category: Et cetera