Oracle PL/SQL Developer

Developer Requirements/Expectations:

• Experience: 5+ Years
• Tech Stack: Core PHP, MySQL, Basic JavaScript, Oracle
• 3rd Party Integration: Payment Gateways (Apple Pay Wallet, Google Pay, Stripe)
• Tools: Trello, Slack, Github
• Soft Skills: Team Work, Excellent Client Communication. 

Engagement Type: Full Time, Dedicated

• Work Hours: 8 Hours per day, 160 hours per month
• Shift: 10 AM-7 AM IST (Including Lunch hour)
• Work shifts need to be flexible to accommodate client calls in EST.

Screening Process: 

Round 1: Technical 

Round 2: Managerial 

Location: Ahmedabad (Hybrid)

Job responsibility The Lead Developer contributes, to create a customer’s solution, in the building phase of the software development lifecycle. The Software Engineer is responsible for performing the detailed design of application and technical architecture components and classes in accordance to the specification provided by the Solution Architect, for coding of SW components, and for the early testing phases (component testing), and system testing support

Hands on experience in Java, Python, scripting
- Design, implement, deploy and support web-based applications and web services using server technologies stacks that include Java, MySQL
- Experience in Java/J2EE using web frameworks Play or Spring boot, REST API Development and ORM (JPA, Hibernate eBean etc.)
- In depth knowledge of Design patterns and Data structures
- Databases - MySQL, Oracle, SQL
- Solid understanding of concepts like Web Services, SOA, REST APIs, Message Queue, Caching, Distributed/Scalable Architecture
- Secure application development best practices, such as OWASP
- Document and maintain all design documents and involve in review process.
- Experienced problem solving and debugging skills.
- Good verbal and written communication and interpersonal skills
- Experience in Agile methodology is added advantage
- Knowledge of Cloud Knowledge /Azure
- Must know about Unix knowledge
- experience in Elastic search

Job Description

1. 5- 8 yrs IT industry experience preferably Banking domain
2. Strong Python Skills and good understanding of Java and Microservices
3. Should have handled banking customers and exposure to Production support processes
4. Good in database and Pl/SQL – Ability to write SQL as and when needed  
5. Good attitude and communication
6. WFH not allowed – Working from Bank premises as per bank calendar in Saifabad or Hitech City – Saifabad Flexibility must

Job Profile

Purpose of Role: To support and maintain the existing and future applications managed by ABD (Agile Business Development) Team.

Main Responsibilities:

• To work on existing and future applications as required
• Work with ABD India Application Support and Business Support team to address production issues and/or to do development work
• Work with US ABD team to coordinate the on-going support and monthly release of C-Hub (Customer-Hub) application and other ABD Applications
• Report status to management on project progress
• Identify and escalate related issues and risks
• Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies 
• Assess current modules and offer performance improvements techniques  
• Make sure Database Design Standards/coding standards established by ABD are followed
• Constant communication with ABD leadership team in US.
• Problem Solving ability with “Can-do” attitude
• IT experience in Banking industry is preferred

Candidate Profile:

• Minimum 10 years of experience at least 3-5 years of experience in Corporate & Investment Banking area and Bachelor's degree in Engineering, Accounting, Finance, or equivalent
• Expertise with MS SQL Server development including SSIS and SSRS, Proficient in development of Stored procedure, Views, Functions etc in MS SQL Server
• Experienced with DBA kind tasks such as replication, linked server, query analyzer, DBCC commands, data transfer from one DB server to other DB Server etc
• Experienced in MS Excel VBA and macro scripting
• Knowledge of data Encryption in database

Job Description for Drools developer -

• Hands on experience in design and development in Drools rule engine (minimum 1.5 years) and Core Java
• Exceptional ability to communicate with both technical and non-technical people
• Expertise in object oriented programming
• Experience in Deploying and supporting core and advanced features
• Good exposure to SQL and/or Oracle/ MySQL,
• Candidate should be well verse with Agile processes
• Strong ability to work collaboratively across diverse groups of business and technical stakeholders is required.

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

Job Role – SDE2

Duration – 12 months

Location – HYD

Key Skills:

• 3- 5 years
• Understanding databases and building reports
• Ideal candidate should have experience in Cosmos, Kusto and powerbi
• Mandatory experience in some Database query language(such as SQL)