ETL Developer Department: Development

Location: Thiruvananthapuram, Kerala

Job Type: Contract

Experience: 4-8 years

Work Mode: Work from Office

Joining Period: Immediate About the Role 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 current platform.



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 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 Bachelor//'s degree in Computer Science, IT, or a related field.

Relevant database certification preferred. 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.

📌 ETL Developer_Trivandrum (Kochi)
🏢 VGreen Technology Solutions (VGreenTEK)
📍 Kochi