Oracle PLSQL

Infosys; Hyderabad, Chennai District, Bengaluru; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Infosys in Hyderabad is seeking a senior PL/SQL developer with 7+ years of experience to design, implement, and optimize database solutions across distributed systems. You will work on PL/SQL development, complex SQL, and ETL components to support BI applications.

Responsibilities include database schema management, indexing, data integrity, reporting, and data warehouse ETL processes, with emphasis on scalable, secure data operations in a distributed environment.

Qualifications

• 2 or more years Oracle PL/SQL experience.
• Highly proficient in RDBMS concepts and Oracle SQL.
• Ability to perform in-depth data analysis of production issues.
• Engineering or MCA First class Graduate from a reputed University with a strong technical background in the software application development using Oracle, PL/SQL with a minimum experience of 7+ years.
• Experience with complex SQL (Dynamic, Stored Procedures and Triggers).
• Informatica MDM (Nice to have).

Responsibilities

• Plan and coordinate security measures to ensure data integrity and maximize database efficiency.
• Define indexes for tables.
• Manage schema properties.
• Developing data processing and ETL components on distributed database systems.
• Developing database application schemas for business intelligence applications.
• Developing scripting to support the production operation of data processing applications.
• Design logical and physical databases or review description of changes to database design to understand how changes to be made affect physical database (how data is stored in terms of physical characteristics such as location, amount of space, and access method).
• Development and programming in PL/SQL technology.
• Design and develop multiple reporting applications.
• Design, develop and implement ETL processes to update the data warehouse.

Skills

Oracle PL/SQL

SQL

Data analysis

ETL development

Scripting

Database design

Education

Engineering degree or MCA

Tools

Informatica MDM

Job description

Key Skills:

• Plan and coordinate security measures to ensure data integrity and maximize database efficiency
• Define indexes for tables
• Manage schema properties
• Developing data processing and ETL components on distributed database systems
• Developing database application schemas for business intelligence applications
• Developing scripting to support the production operation of data processing applications
• Design logical and physical databases or review description of changes to database design to understand how changes to be made affect physical database (how data is stored in terms of physical characteristics such as location, amount of space, and access method)
• Development and programming in PL/SQL technology
• Design and develop multiple reporting applications
• Design, develop and implement ETL processes to update the data warehouse

Qualifications for PL SQL developer

• 2 or more years Oracle PL/SQL experience
• Highly proficient in RDBMS concepts and Oracle SQL
• Ability to perform in-depth data analysis of production issues
• Engineering or MCA First class Graduate from a reputed University with a strong technical background in the software application development using Oracle, PL/SQL with a minimum experience of 7+ years
• Experience with complex SQL (Dynamic, Stored Procedures and Triggers)
• Informatica MDM (Nice to have)