MUFG Union Bank Data Warehouse ETL Developer - Assistant Vice President in Jersey City, New Jersey

About Mitsubishi UFJ Financial Group (MUFG)

Join a financial group that’s as committed to your future as you are. At MUFG, we share a vision for our future, we share our successes, and we strive to bring out the best in each other in everything we do.

Our 14,000 diverse colleagues are connected by a common ambition to create change for the better—from forging more dynamic career paths, to driving progress in our communities, to continuously reshaping the standards of global financial services. Positive impact starts here; see the change you can make as we strive to become the world’s most trusted financial group.


Data Warehouse ETL developer with a thorough understanding of the Data Warehouse and AML (Anti-Money Laundering). Work in conjunction with Data Warehouse Technical Business Analysts and other stakeholders to assess the intended outcomes of business, technical, quality, and security requirements to achieve the intended outcomes while following the banks processes, standards, and procedures.

Major Responsibilities

•Function as ETL SME and supply technical knowledge on required subject-areas and systems.

•Domain experience in required MUFG products and services.

•Plan, design, document, develop, test, implement, monitor, maintain, and support Enterprise Data Warehouse and Enterprise Data Mart solutions, including subject area marts and interfaces to downstream applications.

•Develop and maintain complex ETL mappings, workflows, and Unix shell scripts in a normalized/denormalized data warehouse/data mart environment, based on technical specifications and other supporting documentation, using Informatica PowerCenter, Unix Shell Scripts, advanced SQL, and Tidal Enterprise Scheduler.

•Perform DUT/SIT/UAT/DR/regression testing activities.

•Handle user inquires and production support.

•Conduct trainings and knowledge sharing sessions.

•Ensure best practices, standards, processes, and procedures are followed.

•Support Information Management and other ITD initiatives as required.


•Hands-on expertise in developing Informatica ETL mappings and workflows in complex large-scale data warehouse and data integration projects in the banking industry. (5 years)

•Hands-on experience in designing relational and dimensional databases in the banking industry. (3 years)

•Hands-on experience in Unix shell scripts. (3 years)

•Hands-on experience in advanced SQL and advanced Excel functions. (3 years)

•Hands-on experience in Tidal Enterprise Scheduler. (3 years)

•Experienced in waterfall and agile SDLC methodologies. (3 years)

•Subject-matter expertise in required business domain in the banking industry.

•Detail-oriented with excellent interpersonal, verbal and written communication, coordination, documentation, analytical, problem solving, leadership, and time management skills.

•UML experience and knowledge a plus.

•Bachelor's Degree in Computer Science, Information Systems, or directly related field.

Why Work for MUFG?

• We are a financially strong and stable bank.

• We value workplace diversity.

• We are committed to the training and development of our employees.

• We offer a matching 401k, a Retirement Plan, a variety of Flexible Health Benefits.

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 in employment decisions on the basis of any protected category.

Job: *Systems / Technology

Title: Data Warehouse ETL Developer - Assistant Vice President

Location: NEW JERSEY-Jersey City

Requisition ID: 10009642-WD