Oracle Fusion HCM BI Reporting

As a Senior Database Developer, you will design stable and reliable databases,
according to our company’s needs. You will be responsible for planning, 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.
You get to work with some of the best minds in the industry at a place where
opportunity lurks everywhere and in everything.
Responsibilities
Your responsibilities are as follows.
• Working cross functional teams to develop robust solutions aligned with the
business needs
• Maintaining communication, providing regular updates to the development
team ensuring solutions provided are fit for purpose
• Training other developers in the team on best practices and technologies
• Troubleshooting issues in the production environment understanding the root
cause and developing robust solutions
• Developing, implement, maintain and solutions that are both reliable and
scalable
• Capture data analysis requirements effectively and represent them formerly
and visually through our data models.
• Maintaining effective database performance by identifying and resolving
production and application development problems
• Optimise the integration and installation of new releases
• Monitoring system performance, test, troubleshoot and integrating new
features
• Proactively recommending solutions to improve new and existing database
systems
• Providing database support by coding utilities, resolving user questions and
problems
• Ensuring compliance to database implementation procedures
• Performing code and design reviews as per the code review process
• Installing and organising information systems to guarantee company
functionality
• Preparing accurate documentation and reports
• Migration of data from legacy systems to new solutions
• Stakeholders’ analysis of our current clients, company operations and
applications, and programming requirements
• Collaborate with functional teams across the business to deliver end-to-end
products, features enabling enhanced performance
Required Qualifications
We are looking for individuals who are curious, excited about learning, and navigating
through the uncertainties and complexities that are associated with a growing
company. Some qualifications that we think would help you thrive in this role are:
• Minimum 8 Years of experience as a Database Administrator
• Strong knowledge of data structures and database systems
• In depth expertise and hands on experience with MySQL/MariaDB Database
Management System
• In depth expertise and hands on experience in database design, data
maintenance, database security, data analysis and mining
• Hands-on experience with at least one web-hosting platform such as Microsoft
Azure, AWS (Amazon Web Services) etc.
• Strong understanding of security principles and how they apply to web
applications
• Basic knowledge of networking, Desirable knowledge of business intelligence
• Desirable knowledge of data architectures related to data warehouse
implementations
• Strong interpersonal skills and a desire to work collaboratively to achieve
objectives
• Understanding of Agile methodologies
• Bachelor/Masters of CS/IT Engineering, BCA/MCA, B Sc/M Sc in CS/IT
Preferred Qualifications
• Sense of ownership and pride in your performance and its impact on company’s
success
• Critical thinker, Team player
• Excellent trouble-shooting and problem-solving skills
• Excellent analytical and Strong organisational skills
• Good time-management skills
• Great interpersonal and communication skills

EDUCATION AND QUALIFICATIONS/ SKILLS AND COMPETENCIES
•Degree/Master Degree in Engineering/computer or equivalent subject
•Good Knowledge of Java (Core Java, XML, Java Script, UI5 etc).
•Experience of working in Java on cloud products would be an advantage.
•Excellent analytical skills
•Effectiveness in problem-solving, results-orientation
•Very good powers of comprehension, high quality commitment and self-motivating working style
•Ability to quickly acquire understanding in new areas
•Good communication skills
•Team spirit and ability to work with virtual and local teams
•Ability to present complex information in a clear and appealing manner

EXPECTATIONS AND TASKS
•Analysis, modeling, design, implementation of business requirements for the SuccessFactors
Onboarding Localization & Legal Compliance
•Responsible for development focusing on coding. Additional responsibility will entail testing and
quality assurance as per team backlog.
•Demonstrate full responsibility for accepted tasks and deliver with a high level of quality, speed,
reliability and efficiency.
•Maintenance and corrections to keep solution up-to-date in accordance with customer feedback

WORK EXPERIENCE
•2-3 years’ of coding experience in Java (Core Java, XML, Java Script, UI5)
•Experience in HCM products is preferred
•Experience in working on cloud products would be an advantage.

- Senior development position focused on integrations with a high volume OLTP system deployed globally to over 12,000 users.

- Actively participate in the exchanging of ideas and information within the department

- Participate in rollout of new business system integrations.

- Serve as escalation point for system and troubleshooting issues, assist in resolving production issues.

- Participate in or lead solution design sessions.

- Ability to work effectively under pressure with changing priorities and tight deadlines

- Provide technical advice, code reviews and assistance to other programmers.

- Write complex integration solutions, optimized data extracts, updates and interfaces.

- Interface with functional specialists to ensure solution design and integrity.

- Devise sample input data to test accuracy of program.

- Observe or runs test of program using sample or actual data, assist in user acceptance training.

- Understand and embrace the global IT strategic direction

- Adhere to all safety and health rules and regulations associated with this position and as directed by superior.

- Proactively organize verbal and written ideas clearly and use an appropriate business style

- Be effective and consistent in providing regular updates to appropriate managers

Communication :

- Ask questions; encourage input from team members

- Able to work with and participate within a small multicultural professional team.

- Provide regular updates to appropriate managers

- Confer with reporting manager on complex or unusual situations

- Maintain a thorough knowledge and in-depth field experience regarding emerging or job technologies required to fulfill the job, this could include formal or self paced professional development. Participate in the exchange of ideas and information within the department

- Offer new ideas and suggestions for improvement. Identify and implement new practices and processes that are - best in field- 

Requirements:

KNOWLEDGE REQUIREMENTS :

- Experience in analysis, design, coding, and implementation of enterprise integration solutions.

- Experience with webMethods components: Integration Server, Broker, Trading Networks, and SAP Adapter. webMethods 9.x version preferred.

- Experience with RosettaNet PIP's and standards.

- Experience with XML and webservices (SOAP/REST).

- Experience with PL/SQL.

- Experience with FlatFile processing

- General understanding of scalability and high-availability systems.

- Excellent communication/documentation skills

- Experience in system administration a plus.

EDUCATION & EXPERIENCE REQUIREMENTS :

- B.E./B.Tech/M.Tech/MCA

- 3 to 5 years experience in a relevant IT position OR equivalent external work experience

WORKING CONDITIONS :

- Location: 

- Travel requirements: Domestic and/or International, up to 10%.

- Climate controlled office environment during normal business hours

● Strong hands-on experience in writing SQL/PL SQL and Stored procedure
● Good knowledge of Dimensional data warehouse systems
● Reporting data models with SSIS and MS SQL Server
● Knowledge on all aspects of BI preferably data modeling, data
● integration, data analysis and reporting
● Good working knowledge of MS Azure environment
● Knowledge of BI tools like Tableau or PowerBI
● Good communication skills

Comes with the opportunity to upskill on Big Data cluster

. Good in PL/SQL database Developer . Looking for a candidate who have good strong development experience in PLSQL technology.  . Proficient in programming using PL/SQL and SQL Concepts.  •  Basic Knowledge in Linux Command.  •  Good exposure with PL/SQL in constructing Packages, Stored Procedures, Functions & Triggers.  •  Good understanding of key concepts such as Collections, Exception Handling and Cursors.  •  Hands on experience in Bulk Collect, Bulk Binds, Bulk Exception Handling, Views, Materialized View, Ref Cursors, Joins, Sub Queries.

The main roles and responsibilities of a Power BI developer are discussed below:

• Power BI development and administration.
• Building Analysis Services reporting models.
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Excellent in analytical thinking for translating data into informative visuals and reports.
• Able to implement row level security on data and have an understanding of application security layer models in https://powerbi.microsoft.com/en-us/">Power BI.

Professional Attributes 

- 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

coordinator.

- Ready to work in shifts

- Knowledge Transfer / Training to stakeholders

Personal Attributes 

- 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

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