19+ PL/SQL Jobs in Chennai | PL/SQL Job openings in Chennai

·      Problem-Solving Skills, should be able to convert Idea on Paper to Code

·      Bachelor’s degree in computer science or related field, or equivalent professional experience.

·      0 - 4 years of database experience (Oracle SQL, PL/SQL)

·      Proficiency in Oracle, with Hands-on experience in database design

·      Creation & implementation of data models.

·      Strong experience with Oracle functions, procedures, triggers, packages.

·      Willing to learn, grasp & quickly adapt needed cutting-edge tools & technologies in shorter timeframe.

·      Should be able to write basic Procedures & Functions.

We are looking "Fusion Technical Consultant (OIC)" for Reputed client @ Chennai Permanent Role.

Experience: 7+ Yrs

• Proven experience as a Fusion Technical Consultant with strong expertise in Oracle Integration Cloud (OIC),

• Strong hand on experience generating BI reports (strictly Mandatory)

• Proficiency in Java, PL/SQL, Web Services, and other relevant programming languages.

• Strong problem-solving skills and the ability to troubleshoot complex technical issues independently.

• Prior experience in a customer-facing technical support role is a plus resolving P1/P2 tickets in a close deadline.

• Hands-on experience with Oracle Fusion Middleware technologies, including Oracle SOA Suite, Oracle Service Bus, and ADF. 

• Excellent communication skills, both written and verbal, to effectively interact with clients and team members.

• Oracle certifications in Fusion Middleware and OIC are highly desirable.

Good To Have Skills:

• Good to have functional knowledge of AR, AP, GL,CM, Expense, FA, Procurement side.

Key Responsibilities: 

• Collaborate with clients to understand their technical requirements and challenges related to Oracle Fusion applications and Oracle Integration Cloud (OIC).

• Provide expert-level support and troubleshooting for technical issues, system outages, and integration bottlenecks in a timely and efficient manner.

• Diagnose and resolve complex technical problems related to Fusion applications, OIC integrations, interfaces, and extensions.

• Perform root cause analysis and implement preventive measures to avoid future technical glitches.

• Collaborate with cross-functional teams, including developers, functional consultants, and business analysts, to ensure seamless integration and functionality.

• Develop and maintain technical documentation, including troubleshooting guides, best practices, and solution implementation details.

• Participate in regular status meetings with clients to address support requests, provide updates, and offer recommendations for process improvement.

• Stay updated with the latest releases, patches, and updates related to Oracle Fusion applications and OIC.

Professional Attributes: 

• Flexibility

• Willing to work in shifts

• Willing to learn attitude

Educational Qualification: ANY

#HiringAlert

We are looking " Oracle APEX " for Reputed Client @ Permanent Role.

Must Have Skills:

1.Experience in Oracle APEX, SQL / PLSQL concepts, collections, function, procedure, package and types - Mandatory

2. Experience in JASPER / OBIEE reports

Good To Have Skills:

1.Knowledge in Oracle Forms and Reports, JavaScript, HTML, CSS or any other web-based programming language is added advantage (Optional)

2.Key Responsibilities: Design develop test and implement features and code using Oracle Application Express APEX

3. Perform requirements analysis development design test and deployment of custom Oracle applications.

4. Writing SQL queries Views Materialized views PLSQL procedures functions packages triggers cursors collections Ref cursor cursor variables System reference cursor Dynamic SQL

5. Debug code and maintain PL SQL procedures and functions.

6.Optimize existing applications and scripts for both usability and performance.

7. Adherence to policies processes and procedures within your areas of responsibility

8.Evaluate new features and technologies overseeing their implementation into the environment as appropriate.

9.Ability to prioritize, manage, deliver and report on multiple projects simultaneously highly motivated and able to work against aggressive deadlines schedules.

Professional Attributes:

1. Ability to work with minimal supervision.

2. Exhibits strong ethics, positive attitude, and calm demeanor under pressure.

3. Flexible, organized and possesses the ability to work in a fast-paced environment.

Location : Chennai

#HiringAlert

We are looking "Java Fullstack Developer" for Reputed Client @ Chennai Permanent Role.

Experience: 2 - 5 Yrs

Responsibilities:

• Strong fundamentals – OOPS concepts, Exception Handling, Coding Standards, Logging

• Proven skills in Java, Spring, Spring MVC, Hibernate, Spring boot, Microservices, REST webservices, Java Script, JQuery, Angular, HTML5, CSS, Bootstrap, Spring Security, Oracle, PL/SQL, Ant, Maven, Log4J

• Strong experience in object-oriented design and development

• Designed and developed web applications using Spring framework - preferably Spring boot

• Experience in developing REST services using Spring framework

• Experience in Hibernate - JPA Annotations

• Experience in Angular, CSS, HTML5 and UI designing

• Developed scheduler jobs using Quartz framework

• Knowledge in unit testing frameworks – preferably JUnit

• Good understanding of RDBMS concepts and experience in SQL

Qualifications:

• Graduation / Post Graduation in Science / Engineering

• 6 to 8 years of strong development experience in Java both in Client side & Server-Side frameworks.

• Knowledge in Agile methodologies

• Experience in Oracle/SQL database

• Apache Tomcat. Monitoring and tuning application servers

• Exposure to ETL tools

• Knowledge in continuous integration systems

• Git version control system

• Must have worked on a large-scale product development effort and has experience working with geographically dispersed teams.

• Collaborate with SME, product managers and other members of the project team in requirements specification and detailed engineering analysis.

• Lead technical design, development and delivery of the product

• Should be willing to contribute 100% of time coding

• Review code and maintain the code quality

• Over all 2-4 years’ experience in Inventory Management System and customization with third party systems,
• Atleast 2  years of hands on experience in Cramer 8 or Above version and customisations using Cramer integrations.
• Java/PL SQL Development hands on experience.

- Writing queries used for front- end applications (websites, desktop applications)

- Designing and coding database tables to store the application data

.- Data modeling to visualize database structure.

- Reviewing query performance and optimizing code.

• 4-15 year experience in Application Support
• Must have good knowledge in Java/J2EE, Microservices, PL/SQL, Unix
• Good to have knowledge in Agile, JIRA, Splunk, Service Now
• Good understanding and hands-on experience in Incident, Problem and Change Management
• Provide technical leadership to the team & contribute in the skill development within team
  Interact with internal teams and client stakeholders to trouble shoot the tickets/incident and manage other support activities
• Good communications skills are necessary, must be team player and inquisitive.
• Strong customer service and support focus with a desire to deliver a high-quality service
• Ability to multi-task, work under pressure and to tight deadlines
• Flexible in working outside of office business hours at short notice (as required)
• Should be able to examine the system and identify the areas for Service Improvements & Value adds.

Job Description:
7+ years of experience as a Techno-Functional specialist supporting a finance organization with an emphasis on project management.

Must have 2-3 Project implementation and more than one support experience in Oracle EBS R12.

Expert level knowledge of Oracle Applications Framework, Oracle Workflow, Oracle Forms, Oracle Report, XML Report, PLSQL

Functional knowledge in financial module like, GL,AP, AR PO, Project is must Extensive use of oracle APIs and interfaces Experience in performance tuning of the code Experience in shell scripting.

Worked on Oracle Alert, AME, OAM ,DFF etc Good to have ADF experience Good to have ORDS experience Good to have exposure in cloud technology.

Responsibilities:
Act as a senior liaison between Business partners and IT communities Facilitate cross-functional teams through business process and application initiatives from requirements definition to prototyping, design, development, testing, training, and deployment.

Create technical designs to support business requirements.

Lead the development of technical solutions. Communicate project status and escalate issues to management. Develop and execute system test plans and scenarios.

Assist in preparing training materials for deployment of applications, modules, enhancements and bug fixes.

Assist in developing baseline datasets and reports to support testing of technical solutions.

Education: BE / B.Tech- EEE/ECE/E&I/ Instrumentation and Control
Experience: 3-6 years in the graduates.
Minimum 3+ years of experience in Industrial Automation applications for manufacturing environment.

Domain knowledge: In areas of Industrial Automation technology tools – PLC/DCS/SCADA/HMI for Manufacturing in one or more of the following verticals: Chemicals, Glass, Construction products, Automotive, Abrasives, ceramics industries.

Requirements:

• To be part of Digital Manufacturing and Industry 4.0 projects across Saint Gobain group of companies
• Design and develop Industrial automation applications for discrete, process and hybrid Manufacturing
• Experience in working with various Automation OEM or systems Integrators- Rockwell/Siemens/Schneider
• Experience in providing the network architecture for connectivity of PLC/DCS/OPC/HMI for software integration
• Experience in Industrial automation tools- feature selection, product evaluation for cost effective solution
• Expertise in Industrial automation - Best Practices, Industry Standards and integration methodologies
• Experience in various SCADA platforms such as - GE Proficy, Wonderware, Siemens Win CC, RA Factory Talk
• Collaborate with multi-functional teams to provide Industrial Automation solutions for Digital Manufacturing
• Part of end to end project of automation right from design to delivery of the project.

Requirements:

• Retrieve Data from Databases

SSRS developers optimize SQL server queries to retrieve data efficiently and quickly. As

teams submit requests for different ways of doing things, SSRS developers work with them to find solutions that meet their needs.

• Design Data Solutions

To create and design best-practice data warehouse solutions that support business reporting tasks. This is achieved using different programs and software, such as Microsoft Excel, MS SQL Server, and Tableau.

• Create and Maintain Reporting Processes

To maintain a record of the different reporting processes in place. Evolve ways & means for a more effective data management.

• Resolve IT and Data Issues
• Provide Delivery Plans and Estimates for Projects

Job Description:

• To resolve the tickets raised as per the defined standards of time, cost, and quality for increased customer satisfaction.

Skills and Experience

• Good SQL & PLSQL knowledge.
• Good Unix basic commands knowledge.
• Good Unix scripting knowledge will be an advantage.
• ANSI SQL
• Unix - Others/
• Experience - Fresher

Position: Big Data Engineer

What You'll Do

Punchh is seeking to hire Big Data Engineer at either a senior or tech lead level. Reporting to the Director of Big Data, he/she will play a critical role in leading Punchh’s big data innovations. By leveraging prior industrial experience in big data, he/she will help create cutting-edge data and analytics products for Punchh’s business partners.

This role requires close collaborations with data, engineering, and product organizations. His/her job functions include

• Work with large data sets and implement sophisticated data pipelines with both structured and structured data.
• Collaborate with stakeholders to design scalable solutions.
• Manage and optimize our internal data pipeline that supports marketing, customer success and data science to name a few.
• A technical leader of Punchh’s big data platform that supports AI and BI products.
• Work with infra and operations team to monitor and optimize existing infrastructure 
• Occasional business travels are required.

What You'll Need

• 5+ years of experience as a Big Data engineering professional, developing scalable big data solutions.
• Advanced degree in computer science, engineering or other related fields.
• Demonstrated strength in data modeling, data warehousing and SQL.
• Extensive knowledge with cloud technologies, e.g. AWS and Azure.
• Excellent software engineering background. High familiarity with software development life cycle. Familiarity with GitHub/Airflow.
• Advanced knowledge of big data technologies, such as programming language (Python, Java), relational (Postgres, mysql), NoSQL (Mongodb), Hadoop (EMR) and streaming (Kafka, Spark).
• Strong problem solving skills with demonstrated rigor in building and maintaining a complex data pipeline.
• Exceptional communication skills and ability to articulate a complex concept with thoughtful, actionable recommendations.

• Strong Knowledge in Oracle Forms and Reports
• Should be familiar with various triggers, events , canvas, master child forms, record groups , build-ins, properties etc., in Forms and reports
• Strong Knowledge in SQL / PLSQL concepts
• Strong in Analytical and Aggregate functions
• Strong in writing Procedure / Function / Packages
• Strong knowledge in the user of Cursors / Collections / Exception handling
• Strong in Datatypes, Constrainsts , index
• Having exposure to JavaScript and ReactJS will be an added advantage

Essential Duties:

• Work directly with clients to provide rapid and accurate analysis of production issues (including solution tracking).
• Answer customer questions, file bugs, and reproduce, troubleshoot, resolve, and escalate issues as necessary.
• Own and drive customer issues from start to finish.
• Become an expert on a given product domain from both a business and technical standpoint.
• Handle urgent escalation issues, ensuring we accurately prioritize based on severity and customer impact.

Minimum Requirements:

• BS or MS in Computer Science, Engineering, or related. We will also consider other significant technical experience.
• Minimum of 7 years of application support experience. 
• Strong Oracle SQL, PL/SQL skills required.
• Order-To-Cash (O2C) or Procure-To-Pay (P2P) cycle experience in Oracle EBS (Financials). Other ERPs can also be considered. 
• Excellent spoken and written English. All customer communications are in English.
• Strong communication skills, including the ability to adjust to the technical level of the audience and explain complex ideas clearly and concisely.
• Ability to work with a global teams and build strong cross-functional relationships.
• Positive attitude and the ability to overcome adversity; ability to stay calm under pressure.
• Strong desire and ability to continually learn new skills, processes, technologies, and product knowledge. You will learn something new every day!
• Problem-solving capabilities as well as excellent customer service skills.
• Ability to take ownership and follow through on client issues until resolution.
• Ability to effectively communicate and coordinate with peers and senior management as required.
• Strong organizational skills, attention to detail and technical judgment.