Job Details

ID #17349563
State Arizona
City Tempe
Job type Permanent
Salary USD TBD TBD
Source MUFG
Showed 2021-07-27
Date 2021-07-23
Deadline 2021-09-21
Category Architect/engineer/CAD
Create resume

Data Integration Engineer (Informatica), Assistant Vice President

Arizona, Tempe, 85285 Tempe USA

Vacancy expired!

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 (as ranked by S&P Global, April 2020). In the Americas, we're 13,000 colleagues, striving to make a difference for every client, organization, and community we serve. We stand for our values, developing positive relationships built on integrity and respect. It's part of our culture to put people first, listen to new and diverse ideas and collaborate toward greater innovation, speed and agility. We're a team that accepts responsibility for the future by asking the tough questions and owning the solutions. Join MUFG and be empowered to make your voice heard and your actions count.

Job Summary

In this role, you will develop ETL processes for Data Warehouse and Data Integration solutions. You will partner with Data Architect, BusinessObjects developers in all aspects of software development lifecycle. You will maintain and enhance existing ETL codes and trouble-shoot data issues when needed. Major 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.

  • 5+ years of related technical experience in developing ETL processes using Informatica ETL
  • Experience with developing Unix Shell script to automate ETL process, file management or file transmission
  • Experience with developing SQL scripts for data analysis and for ETL processes.
  • Familiar with Oracle database, dimensional data models and Star-Schemas concept.
  • Experience with scheduling tools such as Autosys, Control-M or Tivoli.
  • Bachelor's degree in Computer Science, Engineering, Information Technology or related

The above statements are intended to describe the general nature and level of the 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 in employment decisions on the basis of any protected category. A conviction is not an absolute bar to employment. Factors such as the age of the offense, evidence of rehabilitation, seriousness of violation, and job relatedness are considered in all employment decisions. Additionally, it's the bank's policy to only inquire into a candidate's criminal history after an offer has been made. Federal law prohibits banks from employing individuals who have been convicted of, or received a pretrial diversion for, certain offenses.

Vacancy expired!

Subscribe Report job