Data Analysis, Analyst

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

Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 7th largest financial group in the world. 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 :

This position requires experienced Informatica ETL developer along with UNIX shell scripting and scheduling tool knowledge with 2+ years of experience to work in the Financial Crimes Data Governance domain.

Responsible for end-to-end project lifecycle from requirement analysis, design, development, testing and support of Data warehousing / Data quality applications.

Work with business users to understand their data requirements and help them make data related decisions. This job might also require the candidate to learn other tools and technologies like AWS, Python etc.

to support the ongoing transition in the technical architecture end.

Major responsibilities :

• Develop ETL process using Informatica to implement the business requirements.
• Create Unix shell scripts to build control validation, fine tune the ETL flows etc.
• Develop data quality business rules using Informatica IDQ.
• Work with business to prepare the data sourcing requirement and mapping documents.
• Prepare functional design, detailed design, and unit testing documents.
• Optimize the ETL code to achieve performance improvement.
• Perform data analysis and validation.
• Perform unit testing along with providing support to QE and business users testing.
• Troubleshooting and fixing the issues identified in testing phase.
• Perform Peer review and migrate the code to higher environment.
• Involve in change management process to deploy the code in production environment.
• Perform post-production deployment validation and support batch run.
• Provide production support as necessary.

Qualifications :

• Bachelor’s degree or master’s degree (Preferably in Computer applications / Information technology related or a closely related field)
• Minimum 2+ years of experience who has extensively worked on SDLC phases (Data profiling and analysis, Design analysis, requirement gathering, code development, Testing, Migration etc..).
• Should be proficient in various Informatica PowerCenter ETL transformations like Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy, Java transformation etc, along with source to target data mapping, ability to define, capture Meta data and Business rules.
• Good knowledge is expected on Data ware housing / Data Modelling concepts.
• Proficiency in IDQ development around data quality, data profiling will be an added advantage.
• Knowledge of understanding / compiling mapping lineages, FDD, DDD, etc.
• Work experience on any of the data sources such as Relational (Oracle, SQL Server, DB2 etc.), Files (XML Files, Fixed Width Flat Files, Delimited Flat Files etc.).
• Experience in both Waterfall and Agile methodologies is expected.
• Expertise is needed in troubleshooting the issues from end to end with quick work around solutions.
• Hands on experience is expected under Unix shell scripts along with basics of HTML code.
• Basic knowledge of IDQ tool is a plus.
• Should have been worked on Schedulers like Autosys at the development level along with supporting activities.
• Experience in performance tuning is expected.
• SQL and PL SQL scripting should be known with both debugging and development aspects.
• Exposure to the various Database like Relational (Oracle / SQL Server / DB2 / Greenplum etc..), Flat Files (Delimited, XML files, csv files), Encryption / Decryption techniques like PGP / ENC etc. is required.
• Basic / Advanced Level of Python scripting is an added advantage.
• Banking domain knowledge is good to have.
• Should be self driven and expected to have good analytical and problem-solving skills with enthusiastic nature to work as both team player and as independent player.
• Good communication skills are key.

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

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.