Data Integration Engineer, AVP - Hybrid

Your potential. Your opportunity.

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

Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 5th largest financial group in the world. Across the globe, we're 180,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.

Job Summary:

In this role, you will develop ETL processes for Data Warehouse and Data Integration solutions. You will partner with Data Architect, Business Objects developers in all aspects of software development lifecycle. You will maintain and enhance existing ETL codes and trouble-shoot data issues when needed.

Responsibilities:

• Designing, developing implementing and maintaining ETL codes for Data Warehouses and Data Integration Solutions.
• Developing maps, sessions and workflows using Informatica according to specifications and business requirements.
• Developing Unix Shell script to automate ETL process, file management and file transmission.
• Developing SQL scripts for data analysis and ETL processes.
• Developing batch job, job schedule and dependency using Autosys Contributing to and following ETL standards and best practices.
• Conducting intensive data analysis and preparing test results.
• Troubleshooting and resolving product issues.
• Participating in all phases of testing. Conducting peer code reviews.

Required Skill and experience:

• Bachelors degree in computer science or related field
• 5 years of related technical experience in developing ETL processes using Informatica ETL
• developing Unix Shell script to automate ETL process, file management or file transmission
• developing SQL scripts for data analysis and for ETL processes.
• Familiar with Oracle database, dimensional data models and Star-Schemas concept.
• Worked with scheduling tools such as Autosys, Control-M or Tivoli.

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.

#LI-Onsite