Informatica Pl/Sql Developer

Innova Solutions; Hyderabad, Chennai; Hybrid; INR 1,100,000 - 1,900,000; Full time

Job summary

Innova Solutions is seeking an Informatica PL/SQL Developer for a Hyderabad/Chennai based role with a hybrid work model. Shift - 3 PM to 12 AM (Office: 3pm-7pm, work at Home: remaining hours). Mon to Wed in-office.

Ideal candidate has 6–15 years of experience, strong PL/SQL, and hands-on expertise in Informatica ETL (PowerCenter/IICS) with Oracle DB fundamentals and Unix/Linux scripting.

Qualifications

• 6–15 years of experience in ETL and Oracle databases.
• Strong PL/SQL development and performance tuning.
• Hands-on Informatica PowerCenter and IICS experience.
• Experience with Unix/Linux and shell scripting.
• Experience with version control (Git).

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

Skills

PL/SQL

SQL

Unix/Linux

Shell scripting

Git

Tools

Informatica PowerCenter

IICS

Toad

SQL Developer

PL/SQL Developer

Job description

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 strong 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 -

• Strong knowledge of:
  • Complex SQL Queries

1. Stored Procedures
2. Packages
3. Functions
4. Triggers
5. Cursors
6. Collections
7. Dynamic SQL
8. Exception Handling

1. Expertise in query optimization and performance tuning.
2. Experience with execution plans, indexing strategies, and partitioning concepts.
3. Strong understanding of relational database concepts and data modelling.
4. Experience working with large-volume transactional databases.
5. Familiarity with Unix/Linux commands and shell scripting.
6. Experience with Git or other version control systems.
7. Strong analytical and problem-solving skills