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.