BI Backend Developer

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.

Job brief 

We are looking for a qualified Database developer to design stable and reliable databases, according to our company’s needs. You will be responsible for developing, testing, improving and maintaining new and existing databases to help users retrieve data effectively.

As part of our IT team, you will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude.

Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis.

Responsibilities

• Design stable, reliable and effective databases
• Optimize and maintain legacy systems
• Modify databases according to requests and perform tests
• Solve database usage issues and malfunctions
• Liaise with developers to improve applications and establish best practices
• Gather user requirements and identify new features
• Develop technical and training manuals
• Provide data management support to users
• Ensure all database programs meet company and performance requirements
• Research and suggest new database products, services and protocols

Requirements

• Proven work experience as a Database developer (5+ Years)
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
• Knowledge of software development and user interface web applications
• Advanced proficiency and hands on experience with T-SQL, Stored Procedures, Cursors, Triggers, Schedulers etc.
• Familiarity working with MS SQL Server, MySQL, .Net Framework, java
• Excellent analytical and organization skills
• An ability to understand front-end users’ requirements and a problem-solving attitude
• Ability to craft detailed technical manuals.
• Excellent verbal and written communication skills
• BE/MCA/MSc Degree in Computer Science or relevant field.

Oracle Apex Developer:

• No. of Position: 3
• Budget: 12 - 16 LPA all inclusive depending on experience bracket
• Work Location – For Mumbai candidate it will be Mahape - Navi Mumbai; candidates from Pan India who are not ready to relocate can permanently WFH.
• Joining Time – Immediate to 45 Days
• US Client – Long term logistics domain project
• Opportunity to work with a team of 20+ Apex experts on the latest Apex technologies in the market
• Onsite opportunity for tenured employees

Experience:

• 5-8 years’ experience in Oracle PL SQL & Oracle Apex; (Majority of Oracle Apex experienced required)
• Preferred Education: B. Tech / B. E - Any Specialization, Computers (OR) BCA (AND/OR) MCA                                 

Core Competencies:

• Experience working on Oracle PL/SQL Programming and DB features
• Proficient in Oracle Apex components is a must
• Experience in Javascript, Jquery and CSS
• Knowledge of Page zero concept, shared components, Page rendering & processing, Interactive reports
• Exposure to DBA activities like Table space management, Export/Import etc.
• Experience in Unix Shell scripting
• Exposure to any reporting tool
• Good communication skills
• Ability to take responsibility and handle pressure 
• Ability to think creatively and solve complex problems 
• Self-motivated, fast learner with the ability to operate independently 
• Team player with strong interpersonal skills and a willingness to help others 
• Ability to thrive in a cross-functional team on business-critical projects 
• Intrinsically cares about the quality of work 
• Organized and focused on delivering tasks within defined deadlines

Specific Responsibilities:

• Would work in design, develop, enhance, test and maintain software applications
• Design and develop SQL scripts, stored procedures, packages, parameterized queries and objects using tools like Toad, SQL Developer, Pl/SQL developer
• Build and maintain Application database schema/objects and account for data migration/upgrades across versions
• Identify and automate routine maintenance tasks
• Optimizing DB queries, stored procedures, Data structures, Indexes and DB Normalization.
• Certify all queries written by software developers to ensure optimal execution of the queries
• Research, investigate and evaluate potential database solutions to business problems/requirements
• Write Test cases for developed queries/functions using PLSQL and Quest code tester.

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:

• To resolve the tickets raised as per the defined standards of time, cost, and quality for increased customer satisfaction.

Skills and Experience

• Good SQL & PLSQL knowledge.
• Good Unix basic commands knowledge.
• Good Unix scripting knowledge will be an advantage.
• ANSI SQL
• Unix - Others/
• Experience - Fresher

You will get while working with us

• Opportunity to work on highly distributed systems with micro-services architecture and big-data volumes
• Solve challenging real-world problems by leveraging OOP & functional programming concepts
• Opportunity to incubate an open source project
• Get to work with cutting edge technologies to name a few Kafka, Elasticsearch, Postgres, Scala
• Developing scalable, sustainable and reliable enterprise systems
• Hands-on experience of working with TDD and BDD
• Develop environment using practices such as Continuous Integration, Continuous Delivery
• Learning opportunity on how to turn complex business requirements into a working product

Roles & Responsibilities

• Requirement understanding & analysis by interacting with client
• Carry out architectural and design discussions with fellow team members and come up with right approach
• Understand system domain, user’s perspective of system and use-cases
• Understand patterns in existing code and effectively leverage and improvise it 
• Develop backend involving Java8 based functional programming and REST services
• Ensure best practices of code reviews, automated testing and CI
• Research new tools & technologies required for the projects
• Mentor fellow team members and bring their level up

Must have

• Strong hold on written/verbal communication
• Strong core Java fundamentals
• Strong Analytical & problem solving skills
• Proactive and inherent nature of working with ownership
• Passion of writing clean code
• Experience in designing relational data model from business requirements

Good to have

• Knowledge of functional programming (Scala or Java 8 lambda)
• Knowledge of NOSQL
• Working knowledge of linux & networking
• Performance optimisation - Optimise/refactor queries, code, stored procedures to take performance next level

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

Mandatory Skills:

1. Good Coding Skills
2. Hands on Experience on C#
3. Indexer
4. Object Oriented concepts using C#
5. Linq
6. Generics
7. Delegates
8. File IO
9. GAC concepts
10. MVC
11. Entity framework
12. .Net Core Concepts
13. Web-API
14. Sql Queries

Secondary Skills:

• Knowledge of Angular/React/Vue/Java Script/ Type Script
• Knowledge of HTML and CSS
• SQL Server and PL/SQL
• Understanding of Design Patterns

Interpersonal Skills:

1. Good in communications (Verbal and Written)
2. Should have worked individually or in team

Job Description:

- 2+ years experience in application support on Asp.Net and SQL

- Should be able to debug production issues and bug fixes

- Should be able to write queries for extracting data using joins

- Interact with stakeholders and provide regular status updates on call logs to on-site and offshore project co-coordinator

- Provide daily status updates and time-sheets to on-site and offshore project

- Ready to work in shifts

- Knowledge Transfer / Training to stakeholders

- Good communication skills

- Highly committed and able to work independently and as a team

- Positive attitude towards learning

- Deadline orientated and escalate in advance in case of delays 

- Contribute towards improving quality, standardization and documentation for all 

changes & Support activity

- Ability to remain calm in a fast-paced and highly pressure environment