
PL/SQL Developer
*Exposure to create and maintain large database with complex requirement
*Deep Understanding on procedures, functions and collections
*Hands on experience in analytical and aggregate functions
*Ability to create and manage triggers
*Experience in database transaction management
*Provide support to java developers on need
*understanding on agile methodologies
*Good written and oral communication skills.
Qualifications for PL SQL developer
- 3 or more years Oracle PL/SQL experience
- Highly proficient in RDBMS concepts and Oracle SQL(advance queries, tuning)
- Good knowledge and understanding of Oracle API’s
- Strong understanding of relational databases (including tables, views, indexes, table spaces )
No of opening :5
Work Location: Madurai
Industry
- Information Technology & Services
Employment Type

Similar jobs
About the client:
In 2019 the Frontrol team did an extensive review of the current landscape of project management tools and found that any given tool enabled anywhere from 1-4 functions of project management to the exclusion of the rest. We then envisioned the need for a single platform that combines all project functions and actors as opposed to currently available solutions that focused on one or two aspects of project management. The founders sold their vision to one of the biggest and most admired Engineering firms in the world (Fortune 500 company). This organization has tasked Frontrol to develop and deploy this platform for its 80K employees/partners/customers across 80+ countries. Frontrol then envisions taking this offering to other engineering firms globally before moving on to other industries including Utilities, Energy, State & Local Governments, Mining, Aerospace & Defense, Engineer to Order/Assemble to Order, Bio-Medical, etc.
About the project:
The project is to develop Frontrols product PACE. PACE is envisioned to be a cloud based SAAS platform that provides project delivery organizations to enable all project functions across the entire project lifecycle from initiation to planning, execution and closeout and brings together all project participants involved from project managers, planners, team members (employees and partners), finance, operations management, regulators, sales and customers.
Responsibilities:
- Write extracts for Data from Oracle EBS Projects.
- Debug issues in data in source and target applications.
- Write technical design documents for extracts based on the business requirements given by users.
- Participate in test case prep for data validation
Requirements:
- At least 4 years of experience in Building extracts, data conversion scripts, and reporting on EBS Oracle projects module.
- Strong experience in addressing performance issues in SQL queries.
- Should have experience in at least one end to end data conversion cycle for Oracle EBS ( Or fusion PPM) projects module.
Will be a plus:
- Scripting Skills (Bash, Powershell, Python, etc.)
- Strong understanding of data structures & algorithms
#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
This is Nivetha Shankar from People First Consultants.
Please get to know about us by visiting http://www.peoplefirst.co.in/" target="_blank">www.peoplefirst.co.in
We have a job opportunity for the role of "Outsystems Developer" in one of the fast-growing Japanese-based Start-Up Companies.
Job Location: Chennai / Coimbatore / Bhubaneswar
Job Description:
• Develop high quality and scalable enterprise applications with Outsystem using modern engineering practices
• Integrate application with existing tools used in the company
• Work closely with the design team on creating the solution which improves business value
• Mentor developers on high quality standards
• Advocate LowCode Outsystem development approach and develop best practices
Required Qualifications:
• 1+ years of experience with Outsystem development and programming
experience of at least 3 years’ experience
• Knowledge of databases; NoSQL, MySQL, MongoDB etc.
• Knowledge of API technologies such as REST and JSON
• Knowledge of HTML, CSS and JavaScript
• Knowledge on .NET C# is a bonus
• Knowledge of database structures and design
• Hands on experience with Cordova plugins and CSS custom development
• Ability to follow instructions and work in a team environment
Desired Qualifications:
• Outsystems Associate Reactive Developer or higher certificate
• Knowledge of other Low Code platforms
• Deep knowledge in web-based languages (JavaScript, JQuery, CSS, HTML)
• Proficiency with Oracle SQL and ASP.NET
• Knowledge of web services (REST and SOAP)
• Knowledge of Atomic Design methodology
• Knowledge of Agile practices
• JLPT or NAT certification added advantage
Thanks & Regards,
Nivetha Shankar
People First Consultants
Overall 5+ years of experience required in Finacle Development/Support |
Key Responsibilities & Job Duties
● To provide functional support for our ERP
Finance applications (Oracle eBusiness Suite)
○ Assist users in case of question
○ Manage functional requests
● Train users to keep the right level of skill
○ To organize audits of the use of systems
○ Detect and collect issues
○ Implement action plan and coordinate actions
● To manage enhancements in accordance with the procedures which apply in the department
○ Collect enhancements from users
○ Challenge the user requirements
● Define priorities
○ Write functional specifications and coordinate developments with the technical team
● Test and train the users
○ Regularly communicate to the users the status of the enhancement
○ Report activity to the management
○ Collaborate with functional support in other zones to share information
○ Optionally, may manage some projects
Key Technical & Functional Competencies
● Functional competencies
○ Strong Business processes: Finance
● Technical competencies
○ Good Knowledge of Oracle SQL
○ Strong Oracle eBusiness Suite
Modules: AP, AR, GL, FA (At least at a professional for two Modules)
○ Basic knowledge of Oracle eBusiness Suite Modules: INV, PO, OE, WSH is preferable
- 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.
smartShift Technologies is looking for a seasoned Database Administrator - Oracle to join our Bangalore team.
Responsibilities
- Perform regular Database administration tasks.
- Perform HA and DR setup maintenance tasks
- Analyze the performance metrics and provide tuning recommendations
- Analyze the repetitive support requests and provide the automation feasibility
- Handle incidents and problems
- Perform trend analysis of the incidents/events and help in finding the resolution
Skills & Experience
- Strong experience in Database Administration in Oracle database
- Have strong knowledge on Oracle SQL and PL/SQL
- Expertise in writing and analysing Stored procedure , packages and triggers.
- Exposure to AWS Cloud RDS is required
- Experience in Database Patching/Upgrade/Migrations
- Experience in managing the HA and DR setups ( Standby, DataGuard)
- Experience in performance tuning ,query optimisation
- Experience with client interaction is preferred
- Exposure to other MySQL database is preferred
- Excellent written and verbal communication skills.
- Real time experience in DB administration (Installation/Tablespace Management/Object Management
- Expertise in RMAN and other backup(Expdp/Impdp) methodology implementations
- Experience in Database Patching/Upgrade/Migrations
- Knowledge on GoldenGate is desirable
- Knowledge on Oracle 12C/19C new features
- Experience with client interaction is preferred
- Knowledge on RAC & ASM is desirable
- Exposure to AWS Cloud is desirable
- Excellent written and verbal communication skills
ESSENTIAL DUTIES AND RESPONSIBILITIES
Actively participate in the exchanging of ideas and information within the department
Participate in rollout of new business system integrations.
Serve as escalation point for system and troubleshooting issues, assist in resolving production issues.
Participate in or lead solution design sessions.
Ability to work effectively under pressure with changing priorities and tight deadlines
Provide technical advice, code reviews and assistance to other programmers.
Write complex integration solutions, optimized data extracts, updates and interfaces.
Interface with functional specialists to ensure solution design and integrity.
Devise sample input data to test accuracy of program.
Observe or runs test of program using sample or actual data, assist in user acceptance training.
Understand and embrace the global IT strategic direction
Adhere to all safety and health rules and regulations associated with this position and as directed by
superior.
Proactively organize verbal and written ideas clearly and use an appropriate business style
Be effective and consistent in providing regular updates to appropriate managers
Communication:
Ask questions; encourage input from team members
Able to work with and participate within a small multicultural professional team.
Provide regular updates to appropriate managers
Confer with reporting manager on complex or unusual situations
Maintain a thorough knowledge and in-depth field experience regarding emerging or job technologies
required to fulfill the job, this could include formal or self paced professional development. Participate in
the exchange of ideas and information within the department
Offer new ideas and suggestions for improvement. Identify and implement new practices and
processes that are “best in field”
Requirements:
KNOWLEDGE REQUIREMENTS
Experience in analysis, design, coding, and implementation of enterprise integration solutions.
Experience with webMethods components: Integration Server, Broker, Trading Networks, and SAP
Adapter. webMethods 10.x version preferred.
Experience with RosettaNet PIP’s and standards.
Experience with EDI Standards (ANSI X12) and AS2 protocols
Experience with XML/JSON and webservices (SOAP/REST).
Experience with PL/SQL.
Experience with FlatFile processing & SFTP
General understanding of scalability and high-availability systems.
Excellent communication/documentation skills
Experience in system administration a plus.
Experience with environment upgrading a plus (eg. version 9.X to 10.X)
EDUCATION & EXPERIENCE REQUIREMENTS
B.E./B.Tech/M.Tech/MCA
7 to 8 years experience in a relevant IT position OR equivalent external work experience
WORKING CONDITIONS
Location: Nodia
Travel requirements: Domestic and/or International, up to 10%.
Climate controlled office environment during normal business hours.
SDLC life cycle work, including analysis, design, development,
enhancement, testing, maintenance and technical support for this
project. Your primary focus is to enhance and maintain the OFSAA
application.
Result Areas
OFSAA Platform: In-depth knowledge of the OFSAA platform, and various
components, namely OFSAA ALM, PFT and FTP modules
Coordinate with client teams, Infra and vendors product issues Monitor client
ticketing tool and maintain service levels OFSAA Incident acceptance from
L1
Troubleshooting/ resolution collaborate with technical teams.
Perform Root Cause Analysis for problem tickets OFSAA Bug fixes
Functional Testing and release
Must be experienced in Informatica PowerCenter
Must have exposure of SQL, PL/ SQL complex queries, Functions, Procedures
Understanding of standard n-tier systems architecture systems processes and
principles
Configuration and operation of Web application servers WebLogic,
WebSphere, Tomcat is an added advantage
Good communicator and ensuring good understanding of business
requirements and able to prepare functional requirement
documents.
Candidate must have
Strong analytical and problem-solving skills
Strong Knowledge in OFSAA ALM, PFT and FTP modules & Oracle Database
using PL_SQL.
Possess strong verbal and written communication skills
5 Knowledge, Skills and Experience
Overall 5+ years of experience in OFSAA
5+ years of hands-on experience in SQL/PL_SQL.
Cross border team management experience.
Strong organizational, team building and leadership qualities.
Strong understanding of SDLC process /Agile Methodology
Strong interpersonal communication skills
Experience of Banking Operations in particular Core Banking, General
Ledger, Loans,
- Excellent knowledge with proven implementation experience of:
- Axiom Controller View V9 / V10 (2+ years’ experience).
- Building and configuring Axiom workflows to solve complex business problems and mapping to Axiom data dictionaries.
- XBRL and template disclosure submission including taxonomy, data point model and validations experience.
- Knowledge of EU regulatory reporting requirements (COREP/Statistical) with strong Capital knowledge.
- Packaging, deploying, branching Axiom solution including upgrades as part of the software development lifecycle.
- Oracle PL/SQL.

