MUFG Union Bank Sr. Software Engineer - Data Integration in Charlotte, North Carolina
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.
Reporting to Credit Risk Data Integration Manager, this role will be responsible for working on the Data Integration initiatives within the Corporate Functions Technology(CFT) Organization. This person is expected to work closely with the Business Users, Architects, System Integrators, Quality Engineers and Developers that are building and supporting the Credit Risk Applications.
Develop and maintain complex ETL mappings, workflows, and UNIX shell scripts in a Data Warehouse environment, based on technical specifications and other supporting documentation, using Informatica PowerCenter, Unix Shell Scripts, advanced SQL, and Autosys/Tidal Enterprise Scheduler.
Provide input for the creation of technology related project documents including functional and detailed design documents ensuring that the design meets requirements and is detailed enough to provide to development teams.
Participate in the rollout of any changes to the production environment and the setting of new standards using change control, documentation, and full communication with the operations and support.
Ensure compliance with technical best practices, standards and policies.
Gather/document business requirements, analyzing current technology, data, and processes versus potential to create recommended solutions.
Analyze complex cross functional problems, quickly grasp concepts related to industry specific design/development and articulate them concisely to foster project team collaboration.
Work with the IT lead and coordinate development, testing, and implementation phases ensuring that all deliverables meet expectations.
Work well under pressure and work independently or as part of a team.
Support the Data Quality Program, including the creation and execution of DQ queries using Informatica IDQ and JIRA
Education: Bachelor’s degree(Preferably Computer Science, Information Systems) with 7 years or Master’s degree(Preferably Computer Science, Information Systems) with 5 years of experience in design, development, and implementation with distributed applications involving Data Warehouses and Data Marts.
5-7 years of hands-on experience using Informatica, DB2, SQL Server and Unix.
2 years of data integration experience in a lead role, preferably in financial services industry.
5 years of Informatica ETL experience in both batch and real-time or near real-time data integration.
1 years of experience in any of the object oriented programming language such as Python, Java preferred.
Experience in Data Modeling using ER Studio– Dimensional Modeling, Canonical Modeling
Strong experience with one or more RDBMS platforms (DB2, Oracle, etc.) and UNIX Scripting is required.
Knowledge or experience in Informatica Data Quality, data modeling and data design of data warehouse, data marts, data lakes is preferable.
Understanding of AWS Data Services like RDS, Redshift, S3, Athena, Glue, Kinesis, EMR.
Experience with Big Data approaches and technologies including: Hadoop, AWS, Spark, Kafka, Hive is preferable.
Excellent meeting facilitation and presentation skills, with best in class customer service orientation and multi-tasking ability.
Experience working in Waterfall/Agile development methodologies.
A team player (https://resources.workable.com/team-player-interview-questions) with excellent communication skills, logical thinking and analytical skills.
Ability to be flexible, decision oriented, and motivated.
Ability to manage multiple work streams with conflicting deadlines proactively.
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.
Primary Location: NORTH CAROLINA-Charlotte
Schedule Full Time
Req ID: 10040036-WD