ETL DeveloperTrivandrum
Job Summary
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 Architects 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 Architects 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 pods 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
- Bachelors 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.
Required Skills:
Data EngineeringDatabase DevelopmentETLSQLPostgreSQLData Quality