Oracle Fusion HCM BI Reporting

Requirements:

• 4-6 years of experience in developing Enterprise Web Applications using Java/J2EE technologies with a good professional track record.
• Excellent knowledge in Core Java (J2SE) and J2EE technologies.
• Proficient knowledge in Servlets, JDBC & JSP.
• Good knowledge of Spring framework (MVC, Cloud, Data and Security. Etc) and ORM framework like JPA/Hibernate.
• Strong knowledge of Exception Handling, Collections, File I/O Streams, Interfaces, and logging mechanisms is a must.
• Experience in developing REST APIs and integration of third-party APIs.
• Proficient knowledge in SQL/PLSQL.
• Expertise in application/web server deployment and connection pooling techniques.
• Cloud deployment (AWS & Azure) will be an added advantage.
• Experience in Version Control tools like Git, Bitbucket, etc.
• Experience in data security and protocols is a must.
• Maven and IDE tools experience is a must.
• Multi-threading and serialization techniques knowledge is a must.
• Good understanding of end-to-end software development lifecycle.
• Ability to read and understand requirements and design documents.
• Good Analytical skills and should be self-driven. Good communication with interpersonal skills.
• Open to learning new technologies and domains.
• A good team player and ready to take up new challenges
• Languages: Java(J2SE), J2EE (Servlets, JSPs, JDBC)
• Databases: MySQL, Oracle, SQL Server, PostgreSQL.
• DB Script: SQL and PL/SQL
• Frameworks: Spring, Spring Boot, Jersey, Hibernate and JPA
• OS: Windows, Linux/Unix.
• Cloud Services: AWS and Azure (Good to have)
• Version Control tools: Git, Bitbucket.
• Deployment Servers: Tomcat, JBoss, and Web sphere
• Build Tools: Gradle/Maven

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.

Job Description:  

As a L3 analyst, you will play a key role within the Application Management team, leading services for its customer(s). This service has responsibility for the smooth daily operational running of the Client platform both in the cloud and on-premises. The Client application is business critical and centrally manages data for trading, settlement, risk, client and regulatory reporting systems. As a L3 analyst, you will be responsible for supporting complex infrastructure and application issues raised by L1/L2 support teams, and business analysts. You would also be working on client requests for enhancements, fixes, maintaining custom code, and following the best practices such as Agile, DevOps, etc.

 

The role is a technical role requiring a good technical knowledge of SQL/PLSQ, Core Java along with good debugging skill while supporting client implementations. You should have basic understanding on Unix system and commands. The ability to troubleshoot issues, assist users and help write specifications is essential. This position also works with product management to improve the software engineering processes and practices associated with continuously building, deploying, and updating software and environments.

 

• Accountability and primary responsibility/duties:
• A typical day would look like as follows: -
  • 40% support issues.
  • 40% configuration/development work.
  • 20% continuous improvement, automation, CICD, so on.
• Activities would range across the lifecycle from discovery to post-implementation support.
• Understanding client’s requirement, replicate the problem and providing the solution
• Understanding and developing new requirements coming in from BAs (Business Analysts) and customers.
• Update the existing functionality based on client needs.
• Develop changes that cater to enhancing the product and/or fixing production issues
• Prepare product releases of software components. (Java/SQL-PLSQL)
• Contribute in all phases of the development cycle. (development/Deployment/Testing, peer review)
• Create technical document for all changes made.

 

Required Qualifications/Knowledge/Skills

• Bachelor’s degree in Computer Science or related field
• Strong basics and working experience in following technologies: -
  • Core Java.
  • SQL / PLSQL coding.
  • Object Oriented Programming concepts and data structures.
• Working knowledge on Unix platform
• Working knowledge on XSLT and XML handling
• Basic understanding App & web server working knowledge (JBOSS, WebLogic and WebSphere) and debugging skills.
• Advantageous to have:
  • Working understanding on CICD, Dev-ops technologies.
  • Queuing technologies including Kafka, MQ, Solace.
  • Scripting including Python, Unix, java.
• Hands on knowledge of Dev ops processes and tools Good interpersonal and communication skills.
  
  

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.

 

• 4-8 years of experience in BI/DW
• 3+ years of experience with Microstrategy schema, design and development
• Experience in Microstrategy Cloud for Azure and connecting with Azure Synapse as Data Source
• Extensive experience in developing reports, dashboards and cubes in Microstrategy
• Advanced SQL coding skills
• Hands on development in BI reporting and performance tuning
• Should be able to prepare unit test cases and execute unit testing

 

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)

Needle Innovision isn't your average run of the mill company. We are focused on a long term goal of making research based development a norm to develop innovative solutions and services. As an intensely vision oriented company, we work hard to make business sense without insane burning of investor's money, and hence are entirely self funded via high value turnkey projects we undertake with companies in B2B Enterprise Technologies, Healthcare, e-commerce to name a few. We are now looking to expand our crazy, small team of doers. We are looking for someone to join our exciting journey, as part of our solutions delivery team. What we are looking for: 1. Firstly we are looking for someone who has the lead your own way spirit. 2. Someone who is excited to work on new projects, has a delivery acumen but is looking to explore the in and outs of new technologies would be an ideal fit. 3. We are looking for people who are honest, transparent and place the team before their personal agenda. 4. We are not looking for the best developer out there but as long as you have done something with your skills till date, and are willing to learn, we should be good. 5. A definite track record of end to end backend development of a product/platform. 6. A full stack proficiency using angular.js, node.js on server side and backend using Java, MyBatis will be a definite plus. Technology stack: Java, Spring, Oracle DB/PostgreSQL, PL/SQL, MyBatis. What's on offer working with us: 1. An insanely talented team to work with. 2. Lot of responsibility and on the go learning. 3. Decent salary of 5-7 LPA and stock options after 6 months. 4. An amazing workspace. If this hits the right chords, please do give me a buzz. I am Rupam, the Co-Founder of the company and I am listening out for you.

Critical Tasks and Expected Contributions/Results : The role will be primarily focused on the design, development and testing of ETL workflows (using Talend) as well as the batch management and error handling processes. Build Business Intelligence Applications using tools like Power BI. Additional responsibilities include the documentation of technical specifications and related project artefacts. - Gather requirement and propose possible ETL solutions for in-house designed Data Warehouse - Analyze & translate functional specifications & change requests into technical specifications. - Design and Creating star schema data models - Design, Build and Implement Business Intelligence Solutions using Power BI - Develop, implement & test ETL program logic. - Deployment and support any related issues Key Competency : - A good understanding of the concepts and best practices of data warehouse ETL design and be able to apply these suitably to solve specific business needs. - Expert knowledge of ETL tool like Talend - Have more than 8 years experience in designing and developing ETL work packages, and be able to demonstrate expertise in ETL tool- Talend - Knowledge of BI tools like Power BI is required - Ability to follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively. - Exposure to Performance tuning is essential - Good organisational skills. - Methodical and structured approach to design and development. - Good interpersonal skills.

Skills: 1. C#, .NET, MVC, EF, MS SQL, WCF, PL SQL, WEB API 2. AJAX, Java Script, JSON, XML etc. 3. Good Experience in using standard SCM and bug-trackers (like git, svn, redmine, bugzilla etc.) 4. Agile Scrum, TDD, PowerShell 5. Knack for writing clean, readable, and easily maintainable code 6. Experience in implementing BDD and CI CD will be preferred Responsibilities: 1. Design, code, test, debug and document software according to the functional requirements 2. Develop, maintain and support programs/tools for internal and external clients 3. Analyse, diagnose and resolve errors related to their applications 4. Help define project plans requiring software development 5. Translate application storyboards and use cases into functional applications 6. Design, build, and maintain efficient, reusable, and reliable code 7. Ensure the best possible performance, quality, and responsiveness of applications 8. Identify bottlenecks and bugs, and devise solutions to mitigate and address these issues