Informatica Pl/Sql Developer

Hyderabad & Chennai

Shift - 3 PM 12 AM (Office: 3pm7pm, work at Home: remaining hours)

Hybrid work model (Mon to Wed only work at Office)

Exp - 6 Yrs to 15 Yrs

Note - Please apply if you are only robust in PL/SQL. The client is specifically looking for candidates with proficient expertise in PL/SQL and intermediate-level skills in Informatica ETL.

Role & responsibilities
Design, Develop, and Maintain ETL Processes: Create and manage ETL workflows using Informatica PowerCenter, IICS, and other related technologies.
Strong proficiency in Oracle SQL, Joins, Sub-queries, Analytical functions
Basic to moderate knowledge in PL/SQL - Procedures, Functions, Packages, Triggers, Cursors
Good understanding of Oracle Database architecture, Tables, Indexes, Views, Materialized Views
Experience in Performance Tuning and Query Optimization (Explain Plan, Hints)




Knowledge of Unix/Linux and shell scripting basics
Experience working with tools like Toad, SQL Developer, PL/SQL Developer

Preferred candidate profile -
Robust knowledge of:
Complex SQL Queries
Stored Procedures
Packages
Functions
Triggers
Cursors
Collections
Dynamic SQL
Exception Handling
Expertise in query optimization and performance tuning.
Experience with execution plans, indexing strategies, and partitioning concepts.
Strong understanding of relational database concepts and data modelling.
Experience working with large-volume transactional databases.
Familiarity with Unix/Linux commands and shell scripting.
Experience with Git or other version control systems.
Robust analytical and problem-solving skills

📌 Informatica Pl/sql Developer Hyderabad
🏢 Innova Solutions
📍 Hyderabad