MUFG Union Bank Data Warehouse Reconciliation (N-Tier) Developer 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 Reconciliation developer with a thorough understanding of the Data Warehouse and data reconciliation requirements and implementations. 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 data reconciliation 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 data reconciliation in Enterprise Data Warehouse and Data Marts, including source systems and downstream systems reconciliations.

•Develop and maintain reconciliation for complex ETL mappings and workflows in a normalized/denormalized data warehouse/data mart environment, based on technical specifications and other supporting documentation, using NTier, 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 data reconciliations solutions using NTier in complex large-scale data warehouse and data integration projects in the banking industry. (1 years)

•Hands-on experience in designing relational and dimensional databases in the banking industry. (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 Reconciliation (N-Tier) Developer

Location: NEW JERSEY-Jersey City

Requisition ID: 10009719-WD