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:

Robust 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

📌 Informatica PLSQL Developer (Chennai)
🏢 Innova Solutions
📍 Chennai