Informatica Pl/Sql Developer

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

9. Expertise in query optimization and performance tuning.

10. Experience with execution plans, indexing strategies, and partitioning concepts.

11. Strong understanding of relational database concepts and data modelling.

12. Experience working with large-volume transactional databases.

13. Familiarity with Unix/Linux commands and shell scripting.

14. Experience with Git or other version control systems.

15. Strong analytical and problem-solving skills