Data Integration Engineer

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.

Job Summary

Reporting to Credit Risk Data Integration Manager, this role will be responsible for working on the Data Integration initiatives within the Enterprise Functions Technology Organization. This person is expected to work closely with the Business Users, Architects, System Integrators, Quality Engineers and Developers that are building and supporting the Credit Risk Applications.

Major Responsibilities

• Develop and maintain complex ETL mappings, workflows, and UNIX/Python shell scripts in a Data Warehouse environment, based on technical specifications and other supporting documentation
• Provide input for the creation of technology related project documents including functional and detailed design documents ensuring that the design meets requirements and is detailed enough to provide to development teams.
• Participate in the rollout of any changes to the production environment and the setting of new standards using change control, documentation, and full communication with the operations and support.
• Ensure compliance with technical best practices, standards and policies.     
• Gather/document business requirements, analyzing current technology, data, and processes versus potential to create recommended solutions.
• Analyze complex cross functional problems, quickly grasp concepts related to industry specific design/development and articulate them concisely to foster project team collaboration.
• Work with the IT lead and coordinate development, testing, and implementation phases ensuring that all deliverables meet expectations.
• Work well under pressure and work independently or as part of a team.
• Support the Data Quality Program, including the creation and execution of DQ queries using Informatica IDQ and JIRA

Qualifications

• Bachelor’s degree in Computer Science, Information Systems or related
• 7+  years of experience in design, development, and implementation with distributed applications involving Data Warehouses and Data Marts.
• 6+ years of hands-on experience using Informatica, DB2, SQL Server and Unix.
• 4+ years of data integration experience in a lead role in financial services industry/banking.
• 5+ years of Informatica ETL experience in both batch and real-time or near real-time data integration.
• 2+ years of experience in data integration using Databricks/Snowflake
• 1+ years of experience in any of the object oriented programming language such as Python, Java preferred.
• Experience in Data Modeling using ER Studio– Dimensional Modeling, Canonical Modeling
• Strong experience with one or more RDBMS platforms (DB2, Oracle, Aurora Postgres etc.) and UNIX Scripting is required.
• Knowledge or experience in Informatica Data Quality, data modeling and data design of data warehouse, data marts, data lakes is preferable.
• Experience with AWS Data Services like RDS, Redshift, S3, Athena, Glue, Kinesis, EMR.
• Understanding of Big Data approaches and technologies including: Hadoop, AWS, Spark, Kafka, Hive, is preferable.
• Excellent meeting facilitation and presentation skills, with best in class customer service orientation and multi-tasking ability.
• Experience working in Waterfall/Agile development methodologies.
• A team player with excellent communication skills, logical thinking and analytical skills.
• Ability to be flexible, decision oriented, and motivated.
• Ability to manage multiple work streams with conflicting deadlines proactively.

The typical base pay range for this role is between $114K - $150K 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

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.