ETL Developer_Trivandrum

VGreenTek; Ernakulam; On-site; INR 1,200,000 - 1,800,000; Part time

Job summary

VGreenTek seeks an ETL Developer in Thiruvananthapuram, Kerala to design and execute Oracle-to-PostgreSQL data migrations within the Data Migration pod, aligned to architecture and mappings.

You will build ETL logic, migration scripts, mappings, validation routines, and automation to move data accurately, collaborating with the Data Architect, QA, and development teams for repeatable migrations across environments.

Qualifications

• 4–8 years in data engineering or database development with hands-on ETL/migration work.
• Strong SQL across Oracle and PostgreSQL; understanding of schema differences.
• 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.
• Methodical, detail-oriented approach to data integrity and cutover risk.

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.

Skills

ETL/migration

SQL (Oracle & PostgreSQL)

Data quality checks

Unit/integration tests

Git workflow

Data pipeline development

Python scripting

Education

Bachelor's degree in Computer Science/IT

Tools

Git

Oracle

PostgreSQL

Job description

Overview

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 new 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.

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.