Data Warehouse Specialist

Skills/Requirements

Responsibilities

• Able to translate the requirements into DWH/BI/Analytic solutions

• Work on business process flow and able to convert the business process flow into technical data flow

• Work on DW, ODS, Data Marts, and Reporting Solutions

• Engage with business and IT stakeholders to understand the business process flow and current constraints

• Perform Data profiling, scalability of end-to-end Integration processes, multi-dimensional SQL queries

• Provide technical, strategic advice and guidance to Senior Managers and technical resources Required experience

• Banking industry experience

• 4+ years of experience in implementing Data Management solutions

• 3+ years of experience primarily as Data Architect (DWH/BI/Analytics)

• 3+ year of hands-on experience in developing conceptual, logical and physical data model using tools like ERWin or similar tools

• Expertise in data quality, data profiling, data analysis, data Integration, data archival and its migration processes.

• Strong database knowledge is required in any of the databases like Oracle, MS-SQL Server

• Exposure to any of the ETL tools like Informatica, Hyperion, SSIS etc. Nice to have’s

• Hands-on experience working in Denodo (data virtualization technology)

• Nice to have: Informatica MDM implementation experience (Must be Informatica)

• Banking industry experience in Compliance work stream (KYC, Onboarding Applications, AML Operations) Project overview Create a Master Data Management platform supporting the Party,

Banking Compliance experience

Rushi Rathod 

408-598-3037