Role Overview
The ETL Developer is responsible for developing and executing the Oracle-to-PostgreSQL data migration processes within the dedicated Data Migration pod, working in line with the migration architecture and data-mapping strategy defined by the Data Architect. The role develops extraction, transformation, and loading (ETL) logic, including migration scripts, data mappings, transformation rules, validation routines, error handling, and reconciliation processes required to move data accurately from the legacy Oracle environment to PostgreSQL.
Responsibilities
- Develop ETL pipelines and scripts for migrating data from Oracle source systems to PostgreSQL targets.
- Implement data transformation, cleansing, and validation logic per the Data Architect's migration design.
- Build reconciliation and data-quality checks to verify migrated data integrity against source systems.
- Support incremental/delta migration and cutover planning for production migration windows.
- Write unit and integration tests for migration/ETL components.
- Collaborate with the pod's QA Engineer on migration test coverage and defect resolution.
- Document migration mappings, transformation rules, and runbooks for each migrated dataset.
- Coordinate with application-development pods on data dependencies affecting their subsystems.
Requirements
- 4-8 years in data engineering or database development, with hands-on ETL/migration work.
- Strong SQL across both Oracle and PostgreSQL; understanding of schema differences between the two.
- Hands-on ETL/data-pipeline development (scripted or tool-based).
- Experience building reconciliation and validation checks for migrated data.
- Unit/integration testing habit and Git workflow familiarity.
- Bachelor's degree in Computer Science, IT, or a related field.
Skills
- Oracle
- PostgreSQL
- SQL
- ETL
- Git
Nice to Have
- Prior Oracle-to-PostgreSQL migration project experience specifically.
- Python or shell scripting for migration automation.
- Exposure to large-scale, regulated, or government data migration projects.