Oracle PL/SQL Developer

Job Description

Build and maintain bots on Azure platform.  Integration with Active directory, WEB API based integration with external systems. Training and Integrate bots as per users’ requirements. Work in line with design guidelines, best practices and standards of bot deliverable. Creative approach to the conversation flow design, human aspects in the bot responses and sentiments

Qualifications

1. a) 5 years of experience in software development with clear understanding of the project life cycle
   b) Min 2-3 years of hands-on experience in Microsoft Azure Bot Framework, LUIS and other Cognitive services offered by Azure
   c) Hands on experience with Machine Learning based chat bots
   d) Experience with Azure bot services like Text Analytics etc.
   e)Strong database skills and hands-on experience on databases like SQL Server/Oracle
2. f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.
3. g) Strong experience designing and working with

with service-oriented architectures (SOA) and WebAPIs.

1. h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C#/VBNET
2. i) Knowledge of Python and NodeJS is a plus
3. j) Ability to design and optimize SQL Server 2008 stored procedures.
4. k) Experience with JQuery, CSS3, HTML5 or similar technologies.
5. l) Ability to adapt quickly to an existing, complex environment.

Work Details: approx. 3-4 Months of development work and require support for next 3 months.

Job Role:

The selected professional/company will be responsible for:

1. Understanding our software's API structure and Oracle SOA framework.
2. Developing and implementing API integrations to connect our software with the specified Oracle SOA modules.
3. Ensuring seamless functionality and data synchronization between systems.
4. Performing rigorous testing to validate the integrations.
5. Providing ongoing support, troubleshooting, and resolving any issues during and after the integration process.
6. Setup the Development/UAT environment for the Oracle SOA integrations.

Modules to Integrate:

• Purchasing
• Payables
• Supplier
• Inventory
• General Ledger (GL)

Scope of Work:

1. API Integration: Establish seamless integration of APIs between our software and the above-mentioned Oracle SOA modules.
2. Data Flow & Functionality: Ensure smooth data flow and consistent functionality between systems.
3. Support & Troubleshooting: Provide support and resolve any issues arising during the integration process.
4. Relevant Experience: Demonstrate prior experience with Oracle SOA integrations.

We are looking for professionals or organizations capable of delivering on these requirements effectively.

Qualifications Required:

Education: Relevant degree in software engineering fields; training in principles and techniques of software development.

Experience: 1-5 years of relevant software architecture, software development and software testing experience.

Skills:

• Strong technical skills in .Net, C#, VB, SQL Server 2008, Oracle, AJAX, Web Services. Strong English reading and writing communication skills, with an ability to express and understand complex technical concepts. Strong analytical, problem-solving, and conceptual skills. Ability to work in teams and has strong interpersonal skills. Ability to work under pressure and meet tight deadlines. Ability to deal with clients and travel to project sites. Possess good organizational skills. Demonstrated ability to lead a moderate group of software engineers and also able to work independently. Ability to anticipate potential problems, determine and implement solutions.

Responsibilities: Responsible for software development activities throughout the project, including key phases of process such as development, testing, implementation.

Other: Be familiar with systems concepts design and standards. Good awareness and practical approach of standard SDLC and be quickly able to understand adhere to coding standard followed by Ember Technologies Pvt. Ltd.

Job Role-12 months(contract) which is extendable /permnanent

Required Skills:

• Advanced Java skills, Spring, Spring Boot, REST APIs,
• Intermediate in Design Patterns and Principles
• Application is moving into PCF  any cloud native experience is helpful
• DB:  Oracle, SQL Server, RDBMS
• Network Infrastructure knowledge is helpful (work with network support team to troubleshoot)
• Production support skills are highly preferred.
• CI/ CD knowledge is helpful
• Junit for unit testing
• Java certifications are a huge plus

Job Description:

• An ideal candidate is someone who works well with a cohesive team-oriented group of engineers, who have a passion for developing software, who enjoy solving problems in a challenging environment, and who have the desire to take their career to the next level.
• Participate in and lead day to day system development and maintenance activities of the team to meet service level agreements (SLAs) and create solutions with high level of innovation, cost effectiveness, high quality and faster time to market.
• Accountable for full systems development life cycle including creating high quality requirements documents, use-cases, design and other technical artifacts including but not limited to detailed test strategy/test design, performance benchmarking, release rollout and deployment plans, contingency/back-out plans, feasibility study, cost and time analysis and detailed estimates.
• Research and evaluate current and upcoming technologies and frameworks.
• Participate in PoCs (Proof of Concept) and help the Department with selection of Vendor Solutions, Technologies, Methodologies and Frameworks.
• Collaborate with Vendor Resources for Support of Products.
• Conduct brownbag sessions on new and upcoming technologies, methodologies and application appropriate frameworks. Ensure knowledge transfer of vendor technology to *** staff. Provide technical training to the other team members.
  
  

Qualifications:

• Bachelor's degree in Information Systems, Information Technology, Computer Science or Engineering or equivalent work experience.
• 3 to 5 years of experience in related field.
• Broad understanding of Software Engineering Concepts and Methodologies is required.
• Back end Java Development
• API- Restful Services
• Automated Unit Testing (J Unit)
• Spring MVC
• SQL skills- Ability to work with tables, views, and stored procedures
• GIT
• Must be high-energy, detail-oriented, proactive and have the ability to function under pressure in an independent environment.
• Must provide the necessary skills to have a high degree of initiative and self-motivation to drive results.
• Possesses strong communication skills -- both verbal and written and strong relationship, collaborative skills and organizational skills.
• Willingness and ability to learn and take on challenging opportunities and to work as a member of matrix based diverse and geographically distributed project team.

JOB DUTIES & RESPONSIBILITIES:

• Lead and mentor developers thru coaching and sharing of knowledge
• Architecture design and Develop new functionality and critical business logic of software products
• Enhance existing applications and software products and design new product

SKILLS:

• Strong knowledge on software implementation best practices
• Strong knowledge of SQL Server and/or Oracle database including store procedure, trigger etc.
• Knowledge of security and vulnerability best practices to design secure web application
• Knowledge of web application architecture with horizontal and vertical scalability
• Experience of working with application with large dataset of millions or billions of row in database table
• Ability to adapt quickly to an existing, complex environment
• Ability to complete all phases of software development life cycle including analysis, design, development, testing and support
• Ability to develop large scale web/database applications
• Ability to work on multiple projects with multiple deadlines
• Ability to communicate clearly with business users and project manager
• Ability to innovate and provide functional applications with intuitive interfaces

Company Profile

Prescinto is a VC funded SaaS company in the renewable energy space enabling digital transformation for customers across the globe.

Prescinto provides solutions to improve power generation for Renewable energy power plants by identifying areas of underperformance and lost generation opportunities through patent pending methodologies; systematically addressing these through an automated workflow system to improve power generation for our customers.

 This is achieved by leveraging the IoT and Analytics platform built to collect high frequency data from distributed renewable energy assets and the comprehensive data lake.

 Roles & Responsibilities

 You are responsible for understanding the product architecture and Design laid out by the Architect and Develop product features in alignment with the architecture.

Product is built on Microsoft stack with Angular 11, .NET and data residing in MS SQL Server and InfluxDB, mobile application built on Flutter and data lake deployed on Azure environment. It extensively uses multi-threading for parallel processing, stored procedures for data access and leverages time-series database for storing high frequency equipment data.

In this role, you should be able to work independently as well as work with vendor and junior members to collaboratively build the features and take them to production. You need to be both a big picture thinker and in-depth problem solver, your knowledge and skills are both broad and deep.

Do you take pride in building customer centric functionalities with an eye on performance? Are you remembered for the quality of your code? This position is for you.

Desired Skills & Experience

• 8+ years of Product development experience of which at least 2 years should comprise of working independently with minimal supervision and guidance
• Experience with at least one full cycle development of product features from requirements to Production deployment to Post production support is critical
• Excellent Programming Skills using C#, WPF, MVVM, Winforms, .NET Framework, Windows Communication Foundation (WCF), ASP.net web api, SQL Server, Store Procedure, Triggers
• Solid Understanding of Multi-Threading and Parallel Programming
• Excellent understanding of Windows Operating System Internals (Process, Threads, Memory Management).
• Clear understanding of OOP and OOAD
• Excellent application debugging skills using Visual Studio Debugger
• Strong knowledge in design patterns, data structures and algorithms
• Experienced in developing Windows desktop applications
• Ability to work independently and be self-driven
• Should have knowledge on code repositories like SVN, GitHub etc and Agile tools like JIRA
• Should have excellent communication skills, excellent analytical and problem-solving skills
• Have working experience in Test-driven Development and Test Automation experience in third party control like DevExpress, Telerik WPF controls
• Experience building a SaaS product preferable
• Startup experience preferable

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

Mandatory Requirement/ Preference:

- 4 years of experience for delivering enterprise solutions or products using full SDLC 

- 4 years of work experience with enterprise solutions for Microsoft platform (SQL Server, stored procedures, WCF, C#.net, Entity Framework) 

- Extensive knowledge and experience with creating and maintaining stored procedure in MS SQL Server.

- Working with WEB API added advantage