Data Warehouse Engineer II- In...

firstrepublic First Republic Bank

The Data Warehouse Engineer II is responsible for the development and maintenance of the FRB Data Warehouse and all the processes supporting the acquisition of data. Will also contribute in the design of new Data Warehouse Components/ Data Marts. Each team member is responsible for the quality of the all data integration processes

Responsibilities:

  • Design and develop ETL Data Loading packages.
  • Translate Business Requirements into a technical solution.
  • Provide Production Support of the Data Warehouse as well as the ETL jobs used to support the Data Warehouse and FRB. This includes being an active member of the Point rotation as well as providing support to other team members that are covering point. ETL jobs are in SSIS and Informatica.
  • Adhere to ETL/Data Warehouse development Best Practices.
  • Assist in the design and development of Data Warehouse/Data Mart.
  • Ability to identify and resolve any performance and/or data related issues.
  • Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) for all projects.
  • Mentorship of junior team members.
  • Knowledge and prior work experience in Banking, Private Wealth Management or related financial services is a plus.
  • Strong skills and experience using Informatica PowerCenter, Master Data Management and Metadata Strategy including implementation, architecture and developing Standards and Methodology required. Experience with Unix Shell and Perl scripting a plus.
  • Requires solid knowledge about ETL, data architecture,data modeling and Software Development Lifecycles.
  • Ability to explain complex data challenges to business users and work in cross-functional team environment.
  • Perform duties & responsibilities specific to department functions & activities.
  • Performs other duties & responsibilities as required or assigned by supervisor.
  • Responsibilities include the following:
    • Adhering to and complying with all applicable, federal and state laws, regulations and guidance, including those related to Anti-Money Laundering (i.e. Bank Secrecy Act, USA PATRIOT Act, etc.)
    • Adhering to Bank policies and procedures.
    • Completing required training.
    • Identifying and reporting potential suspicious activity to the BSA/AML Officer.
    • Knowing and verifying the identity of any customer(s) that enters into a relationship with the Bank.

Qualifications:

  • SQL Server database knowledge.
  • Oracle Database knowledge required.
  • Advanced Microsoft SQL Development (T-SQL).
  • Microsoft SSIS Development (2005, 2008, 2012) is a plus Advanced Informatica PowerCenter Development & Data Analysis skillset a must.
  • Informatica Test Data Management Development is a plus.
  • Implemented Enterprise Level Data Warehouses.
  • Understanding of Agile Data Warehouse Development.
  • Advance knowledge of performance tuning related to ETL Development.
  • Strong experience with Source Control (VSS, TFS, Subversion, etc.).
  • Strong experience with SQL Server Management Studio & BIDS.
  • Strong communication (verbal & written) and problem solving skills.
  • Proven self starter.
  • Results/Goal oriented.
  • Ability to handle multiple projects and manage time efficiently.
  • Have an understanding of Microsoft Analysis Services and the Microsoft Business Intelligence Stack.
  • Experience:
    • 5+ Years of Informatica PowerCenter Experience a must.
    • 2+ Years of MS SQL Server Database Design/Development.
    • 5+ Years of Data Warehousing Experience.
    • 3+ Years leading Data Warehouse projects.
    • 3+ Years writing PL/SQL procedures and functions.
    • Experience with Banking Data is a must.
    • Data Analysis skills is a must.
    • 5+ Years Unix/Linux scripting.

To apply for this job please visit tinyurl.com.