ata, including billion-row tables, into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools such as Oracle Data Pump and SQL Server BCP.
. Design and develop dbt transformation models based on Informatica mapping logic, incorporating dbt best practices including model layering, macros, incremental strategies, and snapshot patterns.
. Develop dbt-native tests as well as custom Python unit tests to validate transformation correctness and data quality.
. Develop Airflow DAGs to orchestrate Python EL and dbt scripts end-to-end, producing output that is functionally equivalent to the source Informatica workflows.
. Contribute to GitLab CI/CD pipeline for dbt and Airflow code, including lint gates, automated testing, and deployment to shared NAS.
. Perform peer code reviews and provide constructive technical feedback to fellow engineers.
. Troubleshoot performance issues and data discrepancies during SIT and UAT, including row-count reconciliation between source Oracle/SQL Server systems and the target warehouse.
. Contribute to technical documentation, runbooks, and handover materials.

1a:T571,Technical

Experience/ Knowledge in Data Exchange Servers, Teamcenter or any PLM, Vis Mockup, Vehicle systems & Assembling conditions.
MS Office tools.
Automation experience, Catia/3DX experience - added advantage.

General

Open to learn new topics to help project/company requirements.
Must have: Very Good communication & Presentation skills, Continuous improvement mindset.
Demonstrate good customer & cross functional relationships.
Ability to manage multiple tasks simultaneously; Self- motivated & enthusiastic.
Ability to work under tight schedules.

SEGULA Technologies is a global engineering group, boosting the competitiveness of all major industrial sectors: automotive, aerospace, energy, rail, naval, li

Data Migration Engineer (Fall 2026)

FVA Data Migration