Pl/Sql Developer | Chennai | Immediate Joiner

About the Company:

We are the leading specialty e-retailer offering consumer products, vacations, and online education services through an easy and convenient payment plan.

About the Role:

Title: PL/SQL Developer

Location: Chennai

The developer has an important role to play in enhancing, developing and maintaining the Financial and SCM functionality for various business requirements of the organization. The engineer will work with other team members based out of our India office & USA in the day-to-day deliverables and projects.  

The ideal candidate will have Oracle PL/SQL development experience and optionally Oracle EBS modules. In addition, great attention to detail, as well as a drive and passion for creating a world-class customer experience, are essential. This position is best for a self-starter who likes to take initiative for self. This individual may be required to provide input to or participate in various projects and will perform other duties as requested.

What you will do:

• Work with technical leads to develop/write software requirements and design specifications for CRs / New requirement.
• Work with project managers and technical leads to create a development / CR plan and delivery timeline.
• Responsible for coding and unit testing application software across all production support, enhancements and projects
• Maintain current applications which includes, but is not limited to, bug fixes, feature enhancements and performance tuning
• Understand current solution through reverse engineering techniques and ensure all batch jobs are executed without any delays and quality issues
• Troubleshoot and debug complex issues; Identify and implements solutions
• Research and implement new technologies to enhance current processes, security and performance
• Develop technical solutions to a pre-defined requirement and develop components including extensions, views, customizations, modifications, reports and workflows independently or as a part of a team.
• Work in a cross-functional environment, develop solutions that integrate information technology & business process changes to support strategic business needs
• Work closely with IT leaders to ensure decisions are meeting long term needs
• Identify, communicate, and mitigate risks  
• Maintain and support various modules of the Oracle EBS Financials & SCM modules.

Skill Requirements:

• Strong PL/ SQL development experience  
• Role requires primarily hands-on coding
• Strong Development, design, test and implement complex database programs using Oracle.
• Require Strong debugging / problem analysis skills.
• Strong experience writing complex SQL's, stored procedures and calculations is a must.
• In-depth knowledge of Cursors, Ref-Cursors, Packages, Procedures, Functions, Triggers, Index and SQL Loader.
• Should have good knowledge of Collections Objects and advanced PL SQL Concepts.
• Experience in database design, modeling and implementation using Oracle, TOAD, PL/SQL Developer and SQL Developer.