Astrosoft Technologies - Senior ODI Developer (5-10 yrs)

Senior ODI Developer (Data Engineer)

Location: Hyderabad (Work from Office) Hybrid Model

Experience: 5 to 10 Years

Notice Period: Immediate to 30 Days Preferred

Work Timings: 12:30 PM to 9:30 PM IST

Work Mode: Hybrid (Work from Home on Mondays & Fridays)

Job Overview:

We are seeking a highly skilled and experienced Senior ODI Developer (Data Engineer) to join our dynamic team in Hyderabad. The ideal candidate should have a strong background in ETL development, Oracle Data Integrator (ODI), and PL/SQL, with hands-on experience in building and managing robust data pipelines. Candidates should be quick joiners and actively available for the interview process.

Key Responsibilities:

- Design, develop, and maintain ETL processes using Oracle Data Integrator (ODI) 12c.

- Develop, optimize, and troubleshoot complex PL/SQL and SQL queries.

- Work with ODI components such as interfaces, packages, scenarios, variables, and repositories.

- Implement and monitor change data capture (CDC) strategies and control workflows using Control-M.

- Develop and maintain stored procedures, functions, cursors, indexes, external tables, and GTTs.

- Optimize query performance using advanced PL/SQL techniques including bulk collect, hints, etc.

- Ensure high data availability and reliability through proactive monitoring and error handling.

- Collaborate with cross-functional teams to understand business requirements and deliver scalable

data solutions.

- Document development work, troubleshoot production issues, and participate in code reviews.

Required Skills & Qualifications:

- Minimum of 5+ years of hands-on experience in ETL development.

- Expertise in PL/SQL, SQL, and advanced Oracle database concepts.

- Strong proficiency in Oracle Data Integrator (ODI) 12c and related components.

- Experience with Control-M and Change Data Capture (CDC).

- Proficient in PL/SQL concepts such as stored procedures, functions, cursors, performance tuning, and query optimization.

- Excellent understanding of data warehousing concepts and data integration techniques.

- Strong verbal and written communication skills.

- Ability to work independently in a hybrid work environment.

Preferred Candidates:

- Immediate to 30-day joiners.

- Candidates who are proactive and responsive throughout the interview process