Portfolio Details

Daimler Financial Services, Tokyo, Japan

Project information

  • Category: Automobile and Finance
  • Client: Daimler Financial Services, Tokyo, Japan
  • Tools Used: SQL Server Integration Services (SSIS) · Microsoft SQL Server · Extract, Transform, Load (ETL)
  • Project date: Jun 2022 - Dec 2022
  • Project URL: N/A

Daimler Financial Services, Tokyo, Japan

Worked as the Lead for development of the Master data part of the ETL solutions, carrying out following responsibilities:

  • Designed and finalized the staging database schema to support data migration, ensuring compatibility with the new system's data model.
  • Conducted comprehensive GAP analysis to identify differences between the old and new systems, ensuring data integrity and alignment with business requirements.
  • Analyzed and mapped legacy data to the new structure, addressing data quality issues and resolving anomalies through transformation logic.
  • Developed and implemented robust ETL pipelines for seamless data extraction, transformation, and loading processes.
  • Delivered client workshops and training sessions to guide technical teams on the schema, migration logic, and ETL enhancements.