Oracle & PL SQL Developer

Job Title: Oracle & PL SQL developer

Job Location: Pan India

Job Role:

We are seeking a skilled Oracle & PL SQL developer with hands-on experience in Informatica PowerCenter to join our data integration and backend development team. The ideal candidate will be responsible for developing, optimizing, and maintaining complex PL/SQL queries and data mappings using Informatica.

Roles & Responsibilities:

• Must have a capability to gather requirements from Client
• Capable enough to own and manage the delivery from Start to end.
• Develop and deliver the requirement in the efficient manner.
• Design, develop, and optimize PL/SQL packages, procedures, functions, and triggers.
• Develop ETL processes using Informatica PowerCenter to extract, transform, and load data across systems.
• Perform data analysis and troubleshoot data-related issues.
• Ensure performance tuning and query optimization.
• Collaborate with business analysts, data architects, and QA teams.
• Develop technical documentation and support deployment efforts.

Experience Required:

• 3+ years of experience with Oracle PL/SQL development.
• Strong experience in Informatica PowerCenter (Designer, Workflow Manager, Monitor).
• Deep understanding of relational databases and data warehousing concepts.
• Performance tuning and query optimization experience.
• Experience with Unix/Linux scripting is a plus.
• Knowledge of job scheduling tools like Autosys or Control-M is an advantage.

Mandatory skill:

• Strong skill in Oracle PL SQL

Desired Skills:

• Exposure to Informatica power centre