About the role
Position: PL/SQL Developer
Experience: 6 to 8 Years
Location: Chennai
Mode: Walk-in Interview
Interview Type: In-person
Key Responsibilities:
- Collaborate with business analysts, project managers, and stakeholders to understand functional requirements.
- Design, develop, and maintain PL/SQL code including Functions, Procedures, Packages, Views, Triggers, and Jobs.
- Ensure data integrity, security, and adherence to organizational coding standards.
- Perform independent development and unit testing of new functionalities.
- Monitor and resolve performance issues, focusing on performance tuning of SQL queries.
- Maintain and review standard PL/SQL code for scalability and reusability.
- Proactively monitor critical functionalities and provide timely resolutions.
- Participate in code reviews and follow industry best practices.
Skills Required:
- Strong hands-on experience in Oracle SQL and PL/SQL.
- Experience with Oracle Triggers, Views, Packages, Procedures, Functions, and Jobs.
- Understanding of Siebel CRM Workflows is preferred.
- Knowledge of ODI/OBIEE is an added advantage.
- Ability to analyze business requirements and deliver independently.
- Excellent communication skills to interact with end-users and stakeholders.
- Proficiency in SQL performance tuning techniques.