Informatica PLSQL Developer

About the Role :

Complex SQL, PL/SQL (procedures, functions, packages, triggers, cursors, collections, dynamic SQL, exception handling), Query Optimization & performance tuning (execution plans, indexing, partitioning), Relational Data Modeling, large volume transactional databases, Unix/Linux Scripting, Git/Version Control, Informatica PowerCenter/IICS ETL workflows, Oracle SQL, debugging, and strong analytical/problem solving skills.

Specialization :

• Good to have : informatica, SQL

Key Responsibilities :

Informatica + SQL: Key Skills: Complex SQL, PL/SQL (procedures, functions, packages, triggers, cursors, collections, dynamic SQL, exception handling), Query Optimization & performance tuning (execution plans, indexing, partitioning), Relational Data Modeling, large-volume transactional databases, Unix/Linux Scripting, Git/Version Control, Informatica PowerCenter/IICS ETL workflows, Oracle SQL, debugging, and strong analytical/problem-solving skills. Strong knowledge of:Complex SQL QueriesStored ProceduresPackagesFunctionsTriggersCursorsCollectionsDynamic SQLException HandlingExpertise 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.Strong analytical and problem-solving skills

Informatica Power Center & IICS:

Design, Develop, and Maintain ETL Processes: Create and manage ETL workflows using Informatica PowerCenter, IICS, and other related technologies.
Data Integration: Collaborate with business analysts and data architects to translate business requirements into technical specifications and implement efficient data integration solutions.
Performance Optimization: Optimize ETL processes for performance and efficiency, ensuring minimal downtime and maximum throughput.
Data Quality and Integrity: Ensure data quality and integrity throughout the ETL process, implementing data validation and cleansing routines.
Testing and Troubleshooting: Conduct unit and integration testing of ETL processes, troubleshoot issues, and provide post-production support.
Documentation: Maintain comprehensive documentation of ETL processes, data mappings, and workflows.
Collaboration: Work closely with cross-functional teams to define data requirements and contribute to database design decisions Oracle & Shell scripting:
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
Good debugging and problem-solving skills

• Strong 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.

• Strong analytical and problem-solving skills

  Informatica Power Center & IICS:
  Design, Develop, and Maintain ETL Processes: Create and manage ETL workflows using Informatica PowerCenter, IICS, and other related technologies.
  Data Integration: Collaborate with business analysts and data architects to translate business requirements into technical specifications and implement efficient data integration solutions.
  Performance Optimization: Optimize ETL processes for performance and efficiency, ensuring minimal downtime and maximum throughput.
  Data Quality and Integrity: Ensure data quality and integrity throughout the ETL process, implementing data validation and cleansing routines.
  Testing and Troubleshooting: Conduct unit and integration testing of ETL processes, troubleshoot issues, and provide post-production support.
  Documentation: Maintain comprehensive documentation of ETL processes, data mappings, and workflows.
  Collaboration: Work closely with cross-functional teams to define data requirements and contribute to database design decisions

Oracle & Shell scripting:

• 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
• Good debugging and problem-solving skills