36+ PL/SQL Jobs in Bangalore (Bengaluru) | PL/SQL Job openings in Bangalore (Bengaluru)

• Should adhere to SDLC processes and Oracle standard documentation /Operating Procedures
• Develop Reports, Charts and Forms using built-in UI components
• Add HTML5 and CSS3 scripting to improve the User Interface thereby providing a better user experience
• Include custom scripting (JavaScript/JQuery/AJAX) as per the business requirement
• Prepare Test cases/reports. Perform Unit , Peer and System Testing on the same
• Inspect / Debug the code logic using the browser developer tools
• Deploy Authentication and Authorization for the modules as per requirement
• Build features and applications with a mobile responsive design (Not mandatory)
• Migrate application and DB objects from DEV to TEST/PROD environments.
• Mandatory to work from Bosch Bangalore office from the start

Mandatory and Optional Skills

Sr. No.

Technical Skills

Mandatory /Good to have

Min Years of hands on Exp in this skill

1

Oracle Apex

Mandatory

3 Yrs

2

Oracle SQL, PL/SQL, Oracle DB Models/Objects

Mandatory

3-5 Yrs

3

Extensive project experience in developing Interactive Reports/Grids, Charts/Graphs, Forms (version > 20.x)

Mandatory

3

4

JavaScript, JQuery, AJAX, CSS and HTML5

Knowledge

1-2 Yrs

5

Data and UI integration with external (Oracle & Non-Oracle) systems 

Knowledge

3 Yrs

• Should adhere to SDLC processes and Oracle standard documentation /Operating Procedures
• Develop Reports, Charts and Forms using built-in UI components
• Add HTML5 and CSS3 scripting to improve the User Interface thereby providing a better user experience
• Include custom scripting (JavaScript/JQuery/AJAX) as per the business requirement
• Prepare Test cases/reports. Perform Unit , Peer and System Testing on the same
• Inspect / Debug the code logic using the browser developer tools
• Deploy Authentication and Authorization for the modules as per requirement
• Build features and applications with a mobile responsive design (Not mandatory)
• Migrate application and DB objects from DEV to TEST/PROD environments.
• Mandatory to work from Bosch Bangalore office from the start

Mandatory and Optional Skills

Sr. No.

Technical Skills

Mandatory /Good to have

Min Years of hands on Exp in this skill

1

Oracle Apex

Mandatory

3 Yrs

2

Oracle SQL, PL/SQL, Oracle DB Models/Objects

Mandatory

3-5 Yrs

3

Extensive project experience in developing Interactive Reports/Grids, Charts/Graphs, Forms (version > 20.x)

Mandatory

3

4

JavaScript, JQuery, AJAX, CSS and HTML5

Knowledge

1-2 Yrs

5

Data and UI integration with external (Oracle & Non-Oracle) systems 

Knowledge

3 Yrs

About Merchandise Operation (Merch Ops): Merchandise Operations (Merch Ops) is a merchandise management system, it is positioned as a host system in the retail solutions, it has ability to maintain the Master/Foundation data, create and manage Purchase Orders, create, and manage Prices & Promotions, perform Replenishment, effective inventory control and financial management. Merc Ops provides Business users with consistent, accurate, and timely data across an enterprise by allowing them to get the:

Right Goods in the...

• Right Silhouettes, Sizes and Colors; at the...

• Right Price; at the...

• Right Location; for the...

• Right Consumer; at the...

• Right Time; at the...

• Right Quantity.

About Team:

• Proven, passionate bunch of disruptors providing solutions that solve real-time supply chain problems.

• Well mixed experienced team with young members and experienced in product, domain, and Industry knowledge.

• Gained Expertise in designing and deploying massively scalable cloud native SaaS products

• The team currently comprises of associates across the globe and is expected to grow rapidly.

Our current technical environment:

• Software: React JS, Node JS, Oracle PL/SQL, GIT, Rest API. Java script.

• Application Architecture: Scalable three tier web application.

• Cloud Architecture: Private cloud, MS Azure (ARM templates, AKS, HD insight, Application gateway, Virtue Networks, Event Hub, Azure AD) • Frameworks/Others: Tomcat Apache, RDBMS, Jenkins, Nginx, Oracle Type ORM, Express.

What you'll be doing:

• As a Staff Engineer you will be responsible for the design of the features in the product roadmap

• Creating and encouraging good software development practices engineering-wide, driving strategic technical improvements, and mentoring other engineers.

• You will write code as we expect our technical leadership to be in the trenches alongside junior engineers, understanding root causes and leading by example

• You will mentor engineers

• You will own relationships with other engineering teams and collaborate with other functions within Blue Yonder

• Drive architecture and designs to become simpler, more robust, and more efficient.

• Lead designs discussion and come up with robust and more efficient designs to achieve features in product roadmap

• Take complete responsibility of the features developed right from coding till deployments

• Introduce new technology and tools for the betterment of the product

• Guides fellow engineers to look beyond the surface and fix the root causes rather than symptoms.

What we are looking for:

• Bachelor’s degree (B.E/B.Tech/M.Tech Computer science or related specialization) and minimum 7 to 10 years of experience in Software development, has been an Architect, within the last 1-2 years minimum. • Strong programming experience and background in Node JS and React JS.

• Hands-on development skills along with architecture/design experience.

• Hands-on experience on designing, building deploying and maintenance of enterprise cloud solutions.

• Demonstrable experience, thorough knowledge, and interests in Cloud native architecture, Distributed micro-services, Multi-tenant SaaS solution and Cloud Scalability, performance, and High availability

• Experience with API management platforms & providing / consuming RESTful APIs

• Experience with varied tools such as REST, Hibernate, RDBMS, Docker, Kubernetes, Kafka, React.

• Hands-on development experience on Oracle PL/SQL.

• Experience with DevOps and infrastructure automation.

Skill for BI Backend developer -

-SQL development (Snowflake preferred but any other version of SQL would work)

- ETL

- Stored Procedures

- Creating jobs and work flows in SQL

- some business knowledge

•  Be a team player and strive for the success of the team and the client
• Preparation of Technical Design documents
• Work independently and progress the build of a CEMLI/RICE object from a technical design document
• Capable of working in a fast paced, dynamic, team-oriented environment
• Understanding functional documents of FIN (GL, Fixed Assets, Cash management, AP/AR) and SCM (procurement, Inventory, Order Management).

• Minimum a Bachelor’s degree.
• Oracle Apps Technical with 5+ years of Experience in development, testing and deployment of RICE components and financial modules
• Good Experience on Oracle Forms & Reports, XML / BI Publisher Reporting Tools, Interfaces (outbound /Inbound) and Workflow.
• Must have a strong experience and knowledge of Oracle E-Business Suite
• Must have strong technical experience on PL/SQL, XML Publisher reports, Java, Oracle Applications Framework (OAF)
• Knowledge on ADF
• Must be able to work independently with business users and external users and responsible for design, development, Testing support, production deployment and production support.
• Excellent organization and communication skills

CLIENT: MNC PRODUCT-BASED COMPANY

ROLE: REACT JS

LOCATION: BANGALORE CANDIDATES ONLY APPLY.

EXPERIENCE:4 YEARS TO 7 YEARS

CTC: up to 30 LPA

NOTE: Candidates from Bangalore should only apply.

Serving notice periods (30 days)/ Immediate Joiner.

• Hands-on working knowledge and experience are required in:

.Typescript, JavaScript, HTML5, CSS

. Deep Knowledge of Frameworks like React.

.Deep Knowledge of tools like Yarn, Grunt, Gulp, npm etc.

.Knowledge of Restful APIs, JWT, and OAuth2.

.Relational Databases (PostgreSQL, MySQL, SQL, PLSQL, etc.)

.Agile Methodologies (Scrum, TDD, BDD, etc.)

.Knowledge of Benchmarking and Optimization Frameworks

.Translating designs and wireframes into high-quality and optimized code

.Knowledge of JavaScript MV-VM/MVC frameworks

.GIT/Bit Bucket, Jira, Maven/Gradle, Jenkins, Visual Studio Code.

• Experience with several of the following tools/technologies is desirable:

.Microservices Architecture

.Cloud Platforms (AWS, Azure, GCP), preferably AWS

.NoSQL Databases (Redis, Elastic Search, Mongo etc.)

.Optimizing components for maximum performance across a vast array of web-capable devices and browsers d. Knowledge of CDN will be a Bonus

• Knowledge of the following technologies is a plus:

.Other Programming Languages (Java, etc.)

. Unix/Linux environments

. Continuous Integration and Continuous Delivery Tools like Jenkins, Git, etc

• 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.

The Position Summary

In this role, you will work with Huron and client team members throughout the entire implementation lifecycle, including planning, configuration, design, build, testing, training, change management, go-live, and post-production support.  The Consulting Associate will be responsible for all aspects of Oracle EPM Cloud system implementation including requirement gathering, application design, application configuration, and implementation.

Must have skill: Require

Java: Core Java, Spring Framework, RESTful API

Front End: Angular, React js

Database: Oracle, PL/SQL

Application Server: WebLogic

**Should be Aware of**

CI/CD pipeline

Good to have the Testing Tools knowledge

Sonarqube, Junit, Mockito

Interested kindly share cv at adityawadhera(dot)cw@ hcg(dot)com

• Basic knowledge of Oracle Forms and reports - (Must)
• Good experience on SQL*Loader.
• Should Knowledge on Agile / Scrum.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Using SQL developer tool we debugged the code and unit test
• Knowledge of oracle programming
• MySQL, Oracle,
• Knowledge of Unix platform
• PostgreSQL
• advance database knowledge.
• Writing PL/SQL and PL/MySQL
• Coding support
• Debugging & Project module management
• Deployment and fine-tuning as per team lead.

1. We need strong SOL and PL/SQL skills
2. UI – any like Javascript, HTML, CSS. Oracle Apex is nice to have.
3. The candidates should have worked on live projects that have given them exposure to write code, unit test and deliver.
4. Having WebServices experience is a value add.
5. Exposure to complex enterprise applications, integrations etc would be really needed.

We are an early stage start-up, building new fintech products for small businesses. Founders are IIT-IIM alumni, with prior experience across management consulting, venture capital and fintech startups. We are driven by the vision to empower small business owners with technology and dramatically improve their access to financial services. To start with, we are building a simple, yet powerful solution to address a deep pain point for these owners: cash flow management. Over time, we will also add digital banking and 1-click financing to our suite of offerings.

We have developed an MVP which is being tested in the market. We have closed our seed funding from marquee global investors and are now actively building a world class tech team. We are a young, passionate team with a strong grip on this space and are looking to on-board enthusiastic, entrepreneurial individuals to partner with us in this exciting journey. We offer a high degree of autonomy, a collaborative fast-paced work environment and most importantly, a chance to create unparalleled impact using technology.

Reach out if you want to get in on the ground floor of something which can turbocharge SME banking in India!

Technology stack at Velocity comprises a wide variety of cutting edge technologies like, NodeJS, Ruby on Rails, Reactive Programming,, Kubernetes, AWS, NodeJS, Python, ReactJS, Redux (Saga) Redis, Lambda etc. 

Key Responsibilities

• Responsible for building data and analytical engineering pipelines with standard ELT patterns, implementing data compaction pipelines, data modelling and overseeing overall data quality

• Work with the Office of the CTO as an active member of our architecture guild

• Writing pipelines to consume the data from multiple sources

• Writing a data transformation layer using DBT to transform millions of data into data warehouses.

• Implement Data warehouse entities with common re-usable data model designs with automation and data quality capabilities

• Identify downstream implications of data loads/migration (e.g., data quality, regulatory)

What To Bring

• 3+ years of software development experience, a startup experience is a plus.

• Past experience of working with Airflow and DBT is preferred

• 2+ years of experience working in any backend programming language. 

• Strong first-hand experience with data pipelines and relational databases such as Oracle, Postgres, SQL Server or MySQL

• Experience with DevOps tools (GitHub, Travis CI, and JIRA) and methodologies (Lean, Agile, Scrum, Test Driven Development)

• Experienced with the formulation of ideas; building proof-of-concept (POC) and converting them to production-ready projects

• Experience building and deploying applications on on-premise and AWS or Google Cloud cloud-based infrastructure

• Basic understanding of Kubernetes & docker is a must.

• Experience in data processing (ETL, ELT) and/or cloud-based platforms

• Working proficiency and communication skills in verbal and written English.

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

Position Overview

Oracle Apex Engineer with good experience building reports using the latest versions of Oracle Apex

and experience in Apex Upgrade. Should have a good working knowledge of Oracle

Applications(R12).

Skills

1-2 end to end implementation/development project

Strong detail, quality, and solution orientation

5+ years of experience designing and implementing technical solutions that are aligned with

business strategy

5 years of applications development experience with Oracle APEX, Oracle SQL, PL/SQL

5+ years of Oracle APEX experience

5+ years experience in Oracle Databases

5+ years experience using PL/SQL

5+ years of JavaScript, HTML, CSS, and REST services

Oracle APEX 4.2 experience is a must and ability to Upgrade to higher versions

Ability to work on SQL performance issues

Ability to think critically and solve complex issues

Ability to work independently, while engaging the customer and providing information to the team

Strong ability to communicate both verbally and in writing with internal and external teams

Ability to prioritize across multiple projects and meet deadlines

Experience adapting in a dynamic work environment

Experience working in a customer-focused environment

Ability to troubleshooting issue

Proficiency in analysis, design, development, testing, implementation, and maintenance of

applications in Oracle Application Express (APEX).

Excellent conceptual knowledge of Oracle 11g.

Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions,

packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor,

Dynamic SQL.

Good knowledge of using PL/SQL Wrappers to protect the PL/SQL procedures and packages.

• 7 years of hands-on experience on database development
• Very strong and hands-on in Oracle Database and PL/SQL development
• Hands on experience in designing solutions and developing for data migration projects using Oracle PL/SQL
• Experience with Oracle Argus Safety, ArisG and other Safety/Clinical systems
• Working experience in development of ETL process, DB Design and Data Structures
• Excellent knowledge of Relational Databases, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) , Object type, Stored Procedures, Functions, Packages and Triggers, Dynamic SQL, Set transaction, pl/sql Cursor variables with Ref Cursor
  Excellent written and verbal communication skills

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.

Essential duties and responsibilities include the following.

• Design, create and maintain databases through multiple product lifecycle environments, from development to production systems
• Configure and maintain database servers and processes, monitor system health and performance, to ensure high levels of performance, availability, and security.
• Convert complex business requirements into technical specifcations to build scalable and reliable data solutions 
• Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyse, solve, and correct issues in real time on production, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Develop complex query, performance tuning, stored procedures and triggers, scheduled jobs, schema refinement.
• Flexibility to work after office hours for any production issue or production deployment.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Qualifications include:

• 4+ years of database and backend development experience
• Good understanding of database systems and architectures
• Expertise in writing complex SQL queries and stored procedures
• Hands on experience with RDBMS and NoSQL data stores like  MySQL and MongoDB
• Experience working with Python scripting and application development
• Experience working with Cloud applications and data stores like AWS RDS is a plus
• In-depth understanding of data management and ETL processes

Reporting and Business Intelligence

Minimum of 8 to 10 years of experience in Report building and Business Intelligence with

Profound knowledge on Oracle BI Publisher and BI Analytics with Oracle Fusion HCM domain especially in Core HR, Payroll and Absences modules

Primary skill:

• Experience generating BI publisher reports, dashboards and drill-down reports
• BI Publisher (RTF design/ eText/ Scheduling/ Parameter Handling/Bursting/backup and migration of reports to different pods)
• Design Oracle BI Publisher Data Models, Data sets and Templates/sub-templates
• Strong PL/SQL and Advanced PL/SQL experience
• Solid understanding of performance tuning best practices and experience improving end-to-end processing times
• Knowledge on the data models related to Fusion HCM (Core HR, Absence and Payroll modules)

Nice to have skills:

• Experience generating BI publisher reports, dashboards and drill-down reports
• Strong OBI Administrator activity
• Create mobile applications with Oracle Business Intelligence Mobile App Designer
• Use BI Mobile to access BI Content
• Create and modify Interactive Dashboards
• Knowledge of additional reporting tools viz. HCM Extract / OTBI / Analysis Dashboard would be an added advantage

Behavioural and Process Skills

• Experience working in Agile teams
• Self-motivated and self-directed abilities to prioritize and execute tasks in a high-pressure environment with "time-critical" deadlines
• Proven analytical, evaluative, and problem-solving abilities
• Possesses a team and customer service provision orientation

• 2-5 years of experience in Manual and Automation testing for Cloud based Web and Mobile Application
• Experience with automation design, scripting, and execution
• An understanding of requirements analysis, design, coding, and unit testing of scalable, distributed, Cloud based applications
• Familiar with agile or other rapid application development
• Expertise in testing API's and debug application issues through API
• Exposure in Continuous integration process implementation by building CI / CD Pipeline using Jenkins and Integrate with Mavens
• Expertise of coding and programming skills in Java / Python
• Solid understanding of software design principles for Building Test Frameworks;
• Think out of the box coming up with creative test design automation frameworks to build / utilities plus tools to develop
• Knowledge of professional software engineering practices & best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations
• Ability to work in a results-oriented, rapidly changing, dynamic and fast-paced environment that requires collaboration across multiple stakeholders and constituents