MUFG Union Bank Lead Software Engineer in Jersey City, New Jersey
Lead Software Engineer - 35495
Duties : Leading the implementation of Oracle Financial Analytical Application Infrastructure (OFSAAI) and sourcing data into OFSAA data model to process various financial solutions on the OFSAA platform; Providing subject matter expertise on OFSAA architecture and guide the team on best practices in configuring and deploying OFSAA applications; Interacting with lines of business to understand the business requirements for Profitability and Funds Transfer Pricing (FTP) and interacting with business analyst to develop robust technical solutions using OFSAA; Providing expertise with OFSAA data model constructs and work closely with the data warehousing team to source data elements in the desired formats for OFSAA to consume. Must be able to configure and extend data model using Erwin data modeling tool; Configuring business rules in OFSAA using run rule framework and T2Ts transformations within OFSAA. Application development and database programming in PL/SQL, schedule batches using Autosys and deploying end-to-end solution in OFSAA on Red Hat Linux OS; Preparing functional and detailed design documents, test scripts and support user testing; Troubleshooting and debug complex issues in OFSAA and database queries. Optimize system performance; Helping setup application as per security standards set by Information security group. This would involve setting up AD / LDAP for user authentication, setup control around system monitoring etc. and documenting the process; Interacting and supporting the setup of analytics for business reporting using Oracle business intelligence tool (OBIEE); Writing and debugging SQL queries and Stored Procedures in Oracle database; Configuring GL Reconciliation module in OFSAA; Designing and developing applications based on dimensional modeling using data warehousing concepts.
Education : Bachelor's Degree in Computer Science, Information Technology, Engineering (any) or related field (or foreign equivalent degree).
Experience : 5 years of software development experience in application development and database programming in PL/SQL; configuring business rules in OFSAA using run rule framework and Table to Table transformations within OFSAA; implementing OFSAA data model to source and process financial data; writing and debugging SQL queries and Stored Procedures in Oracle database; and 3 years of experience must include configuring GL Reconciliation module in OFSAA; designing and developing applications based on dimensional modeling using data warehousing concepts.
Other : Required to work nights & weekends & be on-call during non-business hours for technical support & maintenance purposes.
Location : Jersey City, NJ 07311
We are committed to leveraging the diverse backgrounds, perspectives and experience of our workforce to create opportunities for our people and our business; Equal Opportunity Employer: Minority/Female/Disability/Veteran.
Job : Technology
Primary Location : NEW JERSEY-Jersey City
Job Posting : Jul 1, 2021, 12:11:37 AM
Shift: : Day
Schedule: : Full Time
Req ID: 35495