Oracle Hiring for ETL Developer at PUNE, India Full Time

Job Description

Junior consulting position for those who are continuing to develop their expertise. Receives general instruction on routine work and detailed instruction on new projects or assignments.

Responsibilities

ETL Developer (SQL, PLSQL, Informatica & Oracle FLEXCUBE 14. x data model knowledge)

Our Team

We work for multiple clients with a presence across the globe. We work in the Banking and Financial Services domain and are one of the industry-leading solution providers for the Client. We handle the enhancements to the existing platform/Services to cater to the growing business needs based on industry trends, either functionally or technically and provide state-of-the-art solution offerings.

The solution involves offering core banking surround services and enhancements.

• We are looking for Sr. ETL Informatica- Technology Specialists who will work on the delivery of key initiatives including Finance Technology Projects and application enhancements that influence the bank’s management decision-making process, regulatory reporting (which can influence financial/non-financial penalties) and MIS reporting.

• Perform full SDLC life cycle work, including analysis, design, development, enhancement, testing, maintenance, and technical support for this project.

• Optimize the processes and automate the ETL Workflow monitoring and exception handling.

• The focus is also to evaluate the integration of various data sources like Oracle, SQL server and sequential files into the staging area and recommends and/or implements efficiencies also Perform data analysis, data mapping, data loading, and data validation, reusability, parameterization, workflow design, etc.

• Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions, also experience in Oracle Database using SQL and PL/SQL.

• Oracle FLEXCUBE backend data model knowledge

• Good to have experience with DWH/OFSAA Applications.

Key Result Areas

• Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members.

• Develop ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.

• Implement data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets.

• Enterprise-level ETL development and ETL architecture using Informatica and understanding/ using file structures.

• Work on Oracle Database using SQL and PL/SQL.

• PLSQL technical knowledge is essential

• Perform performance tuning and work end-to-end lifecycle using Enterprise-wide data warehouse.

• Exposure to Banking and Finance Domain is a must

• Knowledge of Oracle FLEXCUBE Core Banking data is a must

Your Opportunity

You will apply your extensive knowledge of developing and maintaining workflow codes using the Informatica tool to convert the business requirements into deployable code. You would be responsible for the entire development life cycle viz., the development until production implementation.

Your Qualifications

• Any Computer Science-based graduation [BE/B Tech/MCA]

• 3-5+ years in software development

• Hands-on development experience in Informatica tool

• Experience in Banking Domain, Oracle FLEXCUBE

• Good understanding of DWH concepts and implementation

• Good analytical skills and presentation skills

• Excellent Communication Skills

Our Ideal Candidate

• Must have skills

• Experience in SQL and PL/SQL programming

• Experience in Informatica ETL Tool

• Oracle FLEXCUBE backend data model knowledge

• Experience in a data warehousing environment, familiar with ETL concepts to apply standards, methods, techniques, and templates as defined by SDLC

• Good to have skills

• Knowledge of other ETL tools, such as–DataStage or ODI preferred

• Exposure to Unix Shell scripting

• Experience in Scheduling such as Control M, Tivoli or Autosys

Your Responsibilities

As an integral part of the development team, you will follow –

• Understanding the requirements of the Functional Team

• Understanding the Technical Design

• Developing the code that aligns to the technical design and coding standards

• Conduct Peer-Code Reviews for early detection of defects and code quality

• Support the testing phase (System Testing, SIT, UAT, Non-Regression Testing) and ensure quick turnaround of defect fixes

• Delivery of secure and clean code that is stable, well tested, operational, consistent and well-performing

• Take part in multiple project discussions

• Ability to handle day-to-day support activities and ETL Admin-related activities.

• Troubleshooting ETL jobs and following escalation procedures to resolve the issue

Filtration criteria:

• 3-5+ years of experience in Informatica ETL tool

• SQL and PL/SQL programming

• Knowledge of Oracle FLEXCUBE backend data model

• Good analytical skills and presentation skills

Screening Criteria Questionnaire

• How do you rate yourself in SQL or PL/SQL Programming?

• 7 & above/10 is good

• How do you rate yourself in the Informatica ETL tool?

• 7 & above/10 is good

• Have you worked on Oracle FLEXCUBE product/any core banking batch integration Projects?

• Yes

About Us

Diversity and Inclusion:

An Oracle career can span industries, roles, Countries and cultures, giving you the opportunity to flourish in new roles and innovate, while blending work life in. Oracle has thrived through 40+ years of change by innovating and operating with integrity while delivering for the top companies in almost every industry.

In order to nurture the talent that makes this happen, we are committed to an inclusive culture that celebrates and values diverse insights and perspectives, a workforce that inspires thought leadership and innovation.

Oracle offers a highly competitive suite of Employee Benefits designed on the principles of parity, consistency, and affordability. The overall package includes certain core elements such as Medical, Life Insurance, access to Retirement Planning, and much more. We also encourage our employees to engage in the culture of giving back to the communities where we live and do business.

At Oracle, we believe that innovation starts with diversity and inclusion and to create the future we need talent from various backgrounds, perspectives, and abilities. We ensure that individuals with disabilities are provided reasonable accommodation to successfully participate in the job application, interview process, and in potential roles. to perform crucial job functions.

That’s why we’re committed to creating a workforce where all individuals can do their best work. It’s when everyone’s voice is heard and valued that we’re inspired to go beyond what’s been done before.

Disclaimer:

Oracle is an Equal Employment Opportunity Employer * . All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

* Which includes being a United States Affirmative Action Employer