This job has expired, please see additional jobs below
Senior Analyst
Mitsubishi UFJ Financial Group
Jersey City, NJ, United States
Job Details - this job has expired, please see similar jobs below
Description
Senior Systems Analyst, Assistant Vice President
Job Summary
Senior ETL developer with a thorough understanding of the Data Warehouse. 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. Implement Data Quality and GL Reconciliation solutions across portfolio of Financial Instruments and transactions. Lead data warehouse integration efforts.
Major Responsibilities
• Lead, manage, 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.
• Function as ETL SME and supply business and technical knowledge on required subject-areas and systems.
• 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.
• Create and maintain project, design, and other required documentation.
• Conduct trainings and knowledge sharing sessions.
• Support ISA/BIT initiatives as required.
Qualifications
• College degree, preferably a B.S. in Computer Science, Engineering, Management Information Systems or a related field or the equivalent
• 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 using Enterprise Scheduler (Tidal or Autosys). (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.