#HiringAlert
We are looking " Oracle Forms & Reports Developer " for Reputed Client @ Permanent Role.
Work Experience: 8+ yrs.
Must Have Skills
1.Experience in Oracle Forms and Reports
2. Should be familiar with various triggers, events, canvas, master child forms, record groups, build-ins, properties etc., in Forms and reports.
3.Experience in SQL / PLSQL concepts
4. Experience in writing Procedure / Function / Packages Datatypes, Constraints, index
5.Experience in the user of Cursors / Collections / Exception handlingGood to Have Skills
1.Experience in production support and troubleshooting will be an added advantage.
2. Having exposure to JavaScript and ReactJS will be an added advantage.Key Responsibilities
1.Participate in meetings / discussions for business requirements.
2.Ensuring Documentation and on time delivery of the development works
3.Coordinate with business user for UAT support and resolutions
4.Provide weekly / monthly development and support status report.Professional Attributes
1.Should be able to work independently with minimal supervision.
2.Should be willing to work in EST timing based on project requirements.
3.Communication should be excellent as the position requires direct interaction with business users from the US.
Educational Qualification: B. E, B. TECH, master’s or Any graduation
Location : Chennai

About Reqroots
Similar jobs
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
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
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
Application development:
Development of forms and reports.
Creation of SQL packages, functions and procedures etc.
Should have extensively worked on oracle EBS implementation/ upgrade/ support projects/ tools JIRA.
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
- Minimum 3 years of working experience in database related projects.
- Working experience on any of the leading Database management systems viz., Oracle,SQL-Server, etc. (Experience on Postgres database systems will be an added advantage).
- Adequate Database Development skills & should be proficient in SQL coding.
- Working experience in Database SQL Optimization/Performance Tuning.
- Working experience on any of the Database Programming languages viz., PL/SQL, PL/pgSQL,T-SQL,etc.
- Flexible to learn, adopt & scale to any data centric technologies as per the evolving Organizational product strategies.
Ability to troubleshoot Database related issues.
- Good to have skill sets of the Candidate:
- Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts.
- Working experience on Data Analytics/Reporting/ETL or exhibits sound knowledge over the concepts.
- Database agnostic approach to data/database solutions.
- Exhibits sound knowledge on Big-data/Hadoop, Kafka, Map-Reduce programming, NoSQL,etc.
• Strong knowledge of SQL and ETL Testing
• Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing
• Hands-on back-end testing skills and strong RDBMS and testing methodologies.
• Expertise in test management tools and defect tracking tools i.e HP Quality Center, Jira
• Proficient experience of working on SDLC & Agile Methodology
•Excellent Knowledge of Database Systems Vertica /Oracle/ Teradata
• Knowledge in security testing will be an added advantage.
• Experience in Business Intelligence testing in various reports Using Tableau
• Strong comprehension, analytical, and problem-solving skills
•Good interpersonal and communication skills, quick learner, and good troubleshooting capabilities.
• Good knowledge of Python Programming language.
• Working knowledge of AWS
REQUIRED CITIZENSHIP / WORK PERMIT / VISA STATUS:
Should be currently based in Japan with Valid work visa
MUST HAVES:
- * Mandatory Skills - Mainframe, Cobol, JCL ,DB2
- * Should have working knowledge on at least one database – MS SQL server, Oracle, DB2, PostgreSQL, MongoDB, Firebird SQL diagnose
- * Language Skills - JLTP N3 would be fine if the
Requirements:
- · Graduate with 6+ years of experience in Mainframe based applications development, maintenance & run mode operations.
- · Ability to collaborate with a diversity of customer's teams to address important issues and to resolve them.
- · Experienced in collaborating with internal and external stakeholders, adaption and learning of the business processes.
- · Should have experience working with Mainframe, Cobol, JCL ,DB2.
- · Working knowledge on at least one database – MS SQL server, Oracle, DB2, PostgreSQL, MongoDB, Firebird SQL diagnose, troubleshoot and fix complex issues.
Only Japan based candidates with relevant experience can apply.
Oracle Apps Technical :
Experience Required : 2 - 6 Years
Job Location : Thane
Role and Responsibilities :
- Check the Cmg's and take the requirements from functional consultants and users.
- As per business logic (MD50) do change existing reports and develop the new reports.
- Developing new packages, procedures, functions and updating existing packages and procedures, functions.
- Developing the workflows.
- Developing the API's as per business logic's for data updates.
- Developing the data extraction automation programs (.sql files developments) for data extractions.
- Prepare the test cases and migration documents for migrating objects.
Education and experience :
- Bachelor's Degree in IT/ Computers/ Science or Master's in Computer required.
- 2 - 5 years of relevant experience on Oracle Apps Technical.
- Candidates must have hands on experience on Oracle RDF/XML/Pl-SQL Reports, D2k Forms, Workflow, OAF, And functional knowledge on O2C & P2P.

