MUFG Oracle Pl/SQL Developer (Identity & Access Management), Associate Vice President in Tempe, Arizona
Do you want your voice heard and your actions to count?
Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 7th largest financial group in the world. Across the globe, we’re 160,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.
This is a hybrid position. The selected colleague will work at an MUFG office or client sites up to four days per week and work remotely the remaining day(s). A member of our Talent Acquisition 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.
Perform hands on Oracle data model and tables design
Perform hands on Oracle PL/SQL and SQL queries development, tuning and optimization experiences, OLTP transaction processing and experience with manipulating large date sets
Participates in unit testing and team data quality efforts
System Integration Testing including integration with upstream and downstream systems
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
As an IAM Engineer and Developer you should demonstrate below experience and work on:
7+ years of hands on 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 with 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
Strong and solid understanding of testing and implementation lifecycles for identity access technologies including root cause analysis
Ability to effectively work with team members across multiple locations and time zones
Ability to adapt to new and changing environment and handle multiple priorities, including ability to learn quickly and achieve automation goals
Good understanding of system logical access and audit controls are desirable
Bachelor’s degree in computer science, Business Administration or equivalent educational or professional experience and/or qualifications. An advanced degree is also preferred
Professional certifications such as Certified Information System Security Professional (CISSP), Global Information Assurance Certification (GIAC) are a plus
The typical base pay range for this role is between $110K - $130K 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, and paid vacation, sick days, and holidays. For more information on our Total Rewards package, please click the link below.
MUFG Benefits Summary (https://careers.mufgamericas.com/sites/default/files/document/2023-01/mb-live-well-work-well.pdf)
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/Affirmative Action 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.
At MUFG, our colleagues are our greatest assets. Our Culture Principles provide a roadmap for how each of our colleagues must think and act to become more client-obsessed, inclusive and innovative. They reflect who we are, who we want to be and what we expect from one another. We are excited to see you take the next step in exploring a career with us and encourage you to spend more time reviewing them!
Our Culture Principles
Listen Up. Speak Up.
Innovate & Simplify
Own & Execute