Oracle Developer

PAN INDIA candidates can apply. Would need to travel to Pune for co-location at agreed frequency. Immediate joiner preferred.

Engagement: Hybrid

Location: Pune

Experience: 5+ years

Required Technical Skills:

• Strong hands-on expertise in Oracle PL/SQL, SSIS, and ODI.
• Proven experience in developing and maintaining Oracle database packages, stored procedures, and functions.
• Experience converting ODI SQL, mappings, and procedures into Oracle PL/SQL packages and procedures.
• Hands-on experience developing and maintaining SSIS packages, including Control Flow, Data Flow, loops, variables, connections, and configurations.
• Strong understanding of ETL processes, data migration, and data transformation.
• Experience in troubleshooting, debugging, and optimizing PL/SQL code and database jobs.
• Knowledge of unit testing, system integration testing (SIT), data validation, and defect resolution.
• Ability to prepare test summary reports, technical specifications, ETL documentation, and process flows.

Preferred Skills:

• Practical knowledge of Oracle Data Integrator (ODI) job conversion and migration.
• Experience in ETL modernization, legacy code migration, and database performance tuning.

Key Competencies:

• Strong analytical and problem-solving skills.
• Excellent verbal and written communication.
• Ability to work independently and collaborate with technical and testing teams.
• Strong attention to detail and commitment to code quality and documentation.

Ideal Candidate: A hands-on ETL and database developer with 5+ years of experience in Oracle PL/SQL and SSIS, capable of converting ODI jobs into native Oracle database packages and procedures, optimizing existing code, resolving defects, and supporting end-to-end testing and documentation.