ETL Senior Engineer

Honeybee Tech Solutions; Mumbai; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Honeybee Tech Solutions is seeking an experienced ETL Developer to design, build, optimize, and maintain robust data pipelines and enterprise data warehouses using ODI, NiFi, and SQL across Oracle, Sybase, MySQL, and PostgreSQL.

You will collaborate with business stakeholders, data architects, and QA teams to ensure scalable migrations, data quality, CDC implementations, and thorough documentation of mappings and runbooks.

Qualifications

• 4+ years of ODI experience in ETL development and migrations.
• Strong SQL and Oracle PL/SQL proficiency.
• Experience with Oracle, Sybase, MySQL, and PostgreSQL migrations.
• Knowledge of Change Data Capture (CDC) mechanisms.
• Experience in data modeling and schema conversion is a plus.

Responsibilities

• Design and implement ETL pipelines across multiple databases.
• Develop schema conversion strategies and transformation logic.
• Optimize migration performance with partitioning, indexing, and bulk loading.
• Plan migration cutovers with rollback strategies and validation checks.
• Collaborate with DBAs, developers, and QA for migration success.

Skills

ETL development

SQL

Data migration

Data integration

Data transformation

Data quality

CDC

Oracle PL/SQL

Performance tuning

Education

Bachelor's degree in Engineering/Computer Science/IT

Post-graduation in related disciplines

Tools

Oracle Data Integrator (ODI)

Apache NiFi

Sybase ASE

Job description

We are looking for a skilled ETL Developer to design, develop, optimize, and maintain robust data integration pipelines and enterprise data warehousing solutions. The ideal candidate should have strong expertise in ETL tools, SQL, data transformation, data quality, and cloud/data engineering practices.

The role requires close collaboration with business stakeholders, data architects, analytics teams, and application developers to enable efficient and scalable data movement across systems.

Required Skills

• Minimum 4 years of experience in Oracle Data Integrator (ODI).
• Strong experience in Sybase ASE to Oracle Data Migration using Oracle Data Integrator (ODI).
• 4-7 years of hands-on experience in ETL development and large-scale data migrations across heterogeneous databases such as Oracle, Sybase, and MySQL.
• Advanced proficiency in SQL and Oracle PL/SQL.
• Strong expertise in Database Performance Tuning for large data volumes.
• Proven experience in end-to-end Sybase ASE to Oracle migration projects.
• Experience handling high-volume historical and incremental data loads.
• Strong implementation knowledge of Change Data Capture (CDC) mechanisms.
• Deep expertise in Oracle Data Integrator (ODI) and Apache NiFi.
• Extensive experience in:Schema Conversion
• Data Mapping Definitions
• Automated Data Reconciliation across diverse RDBMS environments
• Experience with data modeling tools, including:Logical and Physical Data Modeling
• ER Diagrams
• Normalization and Denormalization

Key Responsibilities

• Design and implement ETL pipelines for migrating data across Oracle, Sybase, MySQL, and PostgreSQL databases.
• Develop schema conversion strategies and transformation logic.
• Optimize migration performance using partitioning, indexing, bulk loading, and query tuning techniques.
• Plan and execute migration cutovers with rollback strategies.
• Perform validation and reconciliation activities, including row counts, checksums, and referential integrity checks.
• Collaborate with DBAs, application owners, and QA teams to ensure successful migration execution.
• Document migration artifacts, mapping documents, runbooks, test plans, and validation reports.
• Support governance and metadata management activities, ensuring data lineage and master data integrity.

Preferred Certifications

• Oracle Certified Professional (OCP)
• Relevant database or data engineering certifications

Educational Qualification

• Bachelor's Degree in Engineering, Computer Science, Information Technology, or a related field.
• Post-graduation in the above disciplines is an added advantage.