ETL Developer
The ETL Developer builds and executes the Oracle-to-PostgreSQL data migration workstream — extraction, transformation, load, and validation logic — as part of the dedicated Data Migration pod working alongside the Data Architect's migration design. Databases: Strong SQL across both Oracle and PostgreSQL. ETL: Hands-on ETL/data-pipeline development. Practices: Unit/integration testing habit and Git workflow familiarity.
Experience · 4–8 years in data engineering or database development, with hands-on ETL/migration work.
Development
Thiruvananthapuram, Kerala
Contract
Work from office
Immediate
About the role
What you’ll be working on and why this role matters.
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.
Working closely with the Data Architect, Data Migration team, Business Analysts, QA, and application development teams, the ETL Developer ensures data quality, integrity, completeness, and consistency throughout the migration process. The role also focuses on ETL performance and automation, optimising queries, batch processing, bulk loading, and migration jobs to support large data volumes and repeatable migration cycles across development, testing, UAT, and production environments.
Ultimately, the ETL Developer converts the Data Architect's migration design into a reliable, automated, and auditable data migration capability, ensuring that data is accurately extracted, transformed, loaded into PostgreSQL, and validated before being made available to the new platform.
Responsibilities
Day-to-day ownership and impact areas.
Develop ETL pipelines and scripts for migrating data from Oracle source systems to PostgreSQL targets.
Other open roles
Explore more opportunities at Triwinz
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
Skills and experience that will help you succeed.
Experience: 4–8 years in data engineering or database development, with hands-on ETL/migration work.
Databases: Strong SQL across both Oracle and PostgreSQL; understanding of schema differences between the two.
ETL: Hands-on ETL/data-pipeline development (scripted or tool-based).
Data quality: Experience building reconciliation and validation checks for migrated data.
Practices: Unit/integration testing habit and Git workflow familiarity.
Attitude: Methodical, detail-oriented approach to data integrity and cutover risk.
Qualifications and certifications
Education and credentials that support this role.
Bachelor's degree in Computer Science, IT, or related field.
Relevant database certification preferred.
Nice to have
Bonus strengths — not required, but valued.
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.
Interested in this role?
Submit your application and our team will get back to you soon.
Code Review Expert
Thiruvananthapuram, Kerala · WFH · Contract
