Oracle Fusion HCM BI Reporting

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.

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

Requirements:

• Retrieve Data from Databases

SSRS developers optimize SQL server queries to retrieve data efficiently and quickly. As

teams submit requests for different ways of doing things, SSRS developers work with them to find solutions that meet their needs.

• Design Data Solutions

To create and design best-practice data warehouse solutions that support business reporting tasks. This is achieved using different programs and software, such as Microsoft Excel, MS SQL Server, and Tableau.

• Create and Maintain Reporting Processes

To maintain a record of the different reporting processes in place. Evolve ways & means for a more effective data management.

• Resolve IT and Data Issues
• Provide Delivery Plans and Estimates for Projects

About Sportz Interactive

Sportz Interactive (SI) works with its clients and partners to revolutionize the sports fan experience across consumption points by creating best-in-class, kickass products. SI was founded in 2002 as a B2B sports content business. Through the years, it gained immense reputation for its state-of-the-art hosted solutions, digital simulators, match centers and fantasy games. Sportz Interactive has a fantastic reputation in the online sports community, having worked with clients across the globe including the likes of The International Cricket Council, STAR Sports, Yahoo!, AOL, Eurosport, Castrol, Web 18, NDTV, Nimbus, Times of India, Rediff.com and Singtel amongst others. 

Sportz Interactive provides in-depth sports information and content and specializes in product development for the web, mobile and other interactive platforms. 
http://www.sportzinteractive.net/">www.sportzinteractive.net 

Designation: Senior Associate 

Office Location: Goregaon East, Mumbai

Position description:

3+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills.

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

Role: Software Engineer

Location: Hyderabad

Experience: 3-5 years of experience in software development using Core Java, multi-threading, DS and Algos.

Key Requirements:

• • Develop robust Core Java code for advanced financial banking and trading applications, primarily using core Java principles around multi-threading and caching technologies.
• • Strong in Core Java concepts, JVM, API’s along with SQL and Java Message Service (JMS) skills.
• • Experience in Java server-side / backend development experience
• • Experience in Java Spring (Spring MVC, Spring batch, Spring Boot), Hibernate and JPA is a plus.
• • Knowledge of microservices development, container stack and CI/CD;