Jobs

Interviews
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home

Jobs

Home
>
Jobs in Bengaluru East
>
Infosys
>
PLSQL Developer

PLSQL Developer

Infosys

3 - 5 years

0 Lacs

Bengaluru East Karnataka India

Posted:2 days ago| Platform:

Apply

Skills Required

developer oracle sql development writing database data indexes constraints tuning optimization toad git svn reports scripting unix linux automation agile scrum etl design retrieval reporting software analysis coding testing deployment code integration analyze monitoring resolve indexing strategies documentation support collaboration technology communication

Work Mode

On-site

Job Type

Full Time

Job Description

Technical Requirements: Must-Have: 3-5 years of hands-on experience in Oracle PL/SQL development. Strong proficiency in writing and optimizing complex SQL queries, stored procedures, functions, packages, and triggers. Solid understanding of Oracle database concepts, including data types, indexes, constraints, and views. Experience with SQL tuning and performance optimization techniques. Familiarity with Oracle development tools such as SQL Developer or Toad. Experience with version control systems (e.g., Git, SVN). Good to Have: Basic understanding of data modeling principles. Exposure to Oracle Forms and Reports is a plus. Familiarity with shell scripting (Unix/Linux) for database automation. Knowledge of Agile/Scrum development methodologies. Experience with large-scale transactional systems. Understanding of data warehousing concepts or ETL processes.
Roles and Responsibilities: Development and Implementation: Design, develop, and implement efficient and scalable PL/SQL stored procedures, functions, packages, triggers, and views. Write and optimize complex SQL queries for data retrieval, manipulation, and reporting. Collaborate with business analysts and solution architects to understand requirements and translate them into technical designs. Participate in the full software development lifecycle (SDLC), including requirements analysis, design, coding, testing, and deployment. Code Quality and Standards: Ensure adherence to established coding standards, best practices, and architectural guidelines. Perform thorough unit testing of developed code and assist with integration testing. Identify and debug issues in existing PL/SQL code, providing timely and effective solutions. Performance Tuning and Optimization: Analyze and optimize the performance of existing PL/SQL code and SQL queries. Utilize Oracle performance monitoring tools (e.g., Explain Plan, SQL Trace) to identify and resolve performance bottlenecks. Contribute to discussions on database design improvements and indexing strategies to enhance application performance. Documentation and Support: Create and maintain clear, concise technical documentation for developed modules and features. Provide support for production issues, analyzing and resolving database-related problems. Collaborate with DBAs on schema changes, data migrations, and other database-related activities. Collaboration and Mentorship (Junior Developers): Work effectively within a team environment, actively participating in team meetings and discussions. Potentially mentor junior developers, offering guidance on PL/SQL coding best practices and problem-solving techniques. Communicate technical concepts clearly to both technical and non-technical stakeholdersAdditional Information: Education: Bachelor's degree in Computer Science, Information Technology, or a related field. Soft Skills: Excellent analytical and problem-solving skills. Strong attention to detail and commitment to quality. Good communication and interpersonal skills. Ability to work independently and collaboratively in a team environment. Proactive and eager to learn new technologies and concepts. Ability to manage time effectively and handle multiple tasks.

More Jobs at Infosys

Automation Test Engineer_Java with Selenium

Chennai, Bengaluru, Hyderabad

3 - 8 yrs

INR 5 - 13 Lacs

Api Tester

Chennai, Pune, Bengaluru

6 - 8 yrs

INR 0 - 1 Lacs

Azure Developer- Bengaluru

Chennai, Bengaluru, Hyderabad

2 - 7 yrs

INR 5 - 15 Lacs

Python Developer-Bengaluru

Chennai, Bengaluru, Hyderabad

2 - 5 yrs

INR 4 - 8 Lacs

Scala Developer

Chennai, Bengaluru, Hyderabad

5 - 10 yrs

INR 6 - 14 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Developer Interview Now

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Infosys

IT Services and IT Consulting

Bangalore Karnataka

10001 Employees

3459 Jobs

Key People

Salil Parekh

CEO & Managing Director
Richard Lobo

Executive Vice President and Head of Human Resources
Kiran Kumar

Senior Vice President and Head of Digital Services

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

PLSQL Developer