Oracle pl sql developer Jobs in Scottsdale, AZ

Do you want your voice heard and your actions to count?

Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), one of the world’s leading financial groups. Across the globe, we’re 120,000 colleagues, striving to make a difference for every client, organization, and community we serve. We stand for our values, building long-term relationships, serving society, and fostering shared and sustainable growth for a better world.

With a vision to be the world’s most trusted financial group, it’s part of our culture to put people first, listen to new and diverse ideas and collaborate toward greater innovation, speed and agility. This means investing in talent, technologies, and tools that empower you to own your career.

Join MUFG, where being inspired is expected and making a meaningful impact is rewarded.

The selected colleague will work at an MUFG office or client sites four days per week and work remotely one day. A member of our recruitment team will provide more details.

As Identity & Access Management (I&AM) Engineer and Developer you will be

responsible for design, analysis, evaluation, testing, debugging and implementation of access controls enhancements, reduce risk of access controls failures, business and operational efficiencies. The candidate will be expected to have Hands on experience implementing technology solutions to automate and make I&AM sustainable access controls issues monitoring, recording, resolution and evidence collection repositories and UIs.

As an IAM Engineer and Developer you should demonstrate below experience and work

on :

Helps engineer team to write and document design specs and solutions according to defined processes, policies and standard with information security requirements

Support in troubleshooting and resolving complex problems

Must have perfect communication skills, including writing and presentation skills in documentation and presentation

Passionate, positive and driven attitude

Good communication (written and oral) and interpersonal skills

Reliable time management and organization

Proactive mindset and behaviors

Ability to lead complex efforts with minimal supervision

Ability to adapt to new and changing environment and handle multiple priorities, including ability to learn quickly and achieve automation goals

Participates in unit testing and team data quality efforts

System Integration Testing including integration with upstream and downstream Systems

Strong and solid understanding of testing and implementation of lifecycles for identity access technologies including root cause analysis

Required Skills :

5+ years of hands-on PLSQL, Oracle engineering and development experience :

Oracle data model and tables design, complex queries development and tuning

Oracle PL / SQL and SQL queries development, tuning and optimization experiences, OLTP transaction processing and experience manipulating large date sets

Develop triggers to log audit logs and data change history

Strong experience and ability to work in the team environment as well as deliver tasks with little supervision, analyze issues and proposed solutions are must

Strong knowledge and hands on experience with scripting and ETL data manipulation abilities.

Experience within Pentaho Data Integration (PDI) is highly desired

Solid understanding of IAM Certification, Access Controls, Accounts Inventories with Ownership and LCM, Regional Regulatory & Approval requirements (Access Controls implementation experience is preferred)

API and Integration development leveraging above technology

Experience with IAM vendor-based solutions implementations is a plus

Strong SQL Server and tSQL experience a plus

Experience with Excel pivot tables and graphic chart for data analysis and reporting OS UNIX, Windows and SQL database experience and knowledge are a plus

Preferred but not required Application Development Experience with Java and / or

• Net technologies with use of Web Services APIs, JavaScript, XML, JSON, AJAX and others is highly desired

Desirable Skills :

Professional certifications such as Certified Information System Security Professional (CISSP), and Global Information Assurance Certification (GIAC) are a plus.

Education :

Bachelor’s degree in computer science, Business Administration or equivalent educational or professional experience and / or qualifications. An advanced degree is also preferred.

Work Location(s) :

As per MUFG’s Return to Office policy , must work onsite for 4 days per week & 1 day remote out of either Tampa, FL or Tempe, AZ (Preference) or Jersey City, NJ.

The typical base pay range for this role is between $121K - $142K depending on job-related knowledge, skills, experience, and location. This role may also be eligible for certain discretionary performance-based bonus and / or incentive compensation. Additionally, our Total Rewards program provides colleagues with a competitive benefits package (in accordance with the eligibility requirements and respective terms of each) that includes comprehensive health and wellness benefits, retirement plans, educational assistance and training programs, income replacement for qualified employees with disabilities, paid maternity and parental bonding leave, paid vacation, sick days, and holidays. For more information on our Total Rewards package, please click the link below.

We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws (including (i) the San Francisco Fair Chance Ordinance, (ii) the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, (iii) the Los Angeles County Fair Chance Ordinance, and (iv) the California Fair Chance Act) to the extent that (a) an applicant is not subject to a statutory disqualification pursuant to Section 3(a)(39) of the Securities and Exchange Act of 1934 or Section 8a(2) or 8a(3) of the Commodity Exchange Act, and (b) they do not conflict with the background screening requirements of the Financial Industry Regulatory Authority (FINRA) and the National Futures Association (NFA). The major responsibilities listed above are the material job duties of this role for which the Company reasonably believes that criminal history may have a direct, adverse and negative relationship potentially resulting in the withdrawal of conditional offer of employment, if any.The above statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities duties and skills required of personnel so classified.We are proud to be an Equal Opportunity Employer and committed to leveraging the diverse backgrounds, perspectives and experience of our workforce to create opportunities for our colleagues and our business. We do not discriminate on the basis of race, color, national origin, religion, gender expression, gender identity, sex, age, ancestry, marital status, protected veteran and military status, disability, medical condition, sexual orientation, genetic information, or any other status of an individual or that individual’s associates or relatives that is protected under applicable federal, state, or local law.