Oracle PLSQL Developer_N

Infosys; Hyderabad, Pune District, Bengaluru; Hybrid; INR 70,000 - 100,000; Full time

Job summary

Infosys in Hyderabad seeks an experienced PL/SQL developer to design and optimize database solutions for enterprise data processing. You will work on Oracle PL/SQL, SQL optimization, and ETL components across distributed databases.

You will analyze production issues, implement robust data models, develop reporting schemas, and collaborate with cross-functional teams to deliver reliable BI platforms.

Qualifications

• 4 or more years Oracle PL/SQL experience.
• Highly proficient in RDBMS concepts and Oracle SQL.
• 7+ years Engineering or MCA degree with strong software development background using Oracle/PL/SQL.
• Experience with complex SQL (Dynamic, Stored Procedures and Triggers).
• Informatica MDM is nice to have.

Responsibilities

• Plan and coordinate security measures to ensure data integrity and maximize database efficiency.
• Define indexes for tables.
• Manage schema properties.
• Develop data processing and ETL components on distributed database systems.
• Design logical and physical databases or review description of changes to database design to understand impact on physical storage.
• 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

Data analysis

RDBMS concepts

Oracle SQL

Dynamic SQL

Stored Procedures

Education

Engineering or MCA First class

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

• 4 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)