Description

You will design and implement database solutions, focusing on data migration, validation, and optimization within the Oracle ecosystem.

This role is hybrid.

Responsibilities

• Convert business rules into technical requirements and software designs.
• Create SQL*Loader control files to load data from flat files into staging tables.
• Develop SQL and PL/SQL scripts for database migration tasks.
• Perform Oracle database testing using test data loaded via SQL queries and PL/SQL procedures.
• Optimize SQL statements and PL/SQL programs for efficiency.

Required Skills

• 5+ years of experience with Oracle 11g.
• Strong proficiency in SQL and PL/SQL development.
• Experience with SQL Developer and TOAD.
• Hands-on experience with Informatica 9.x.
• Proficiency in UNIX environment and Perl scripting.
• Experience developing with Oracle Forms 10g and Reports 10g.
• Ability to program using stored procedures, triggers, views, and user-defined functions.

Preferred Skills

• Experience validating XML files against application and database tables.

Key Skills

Education

Any Graduate