Data Warehouse Specialist

Job Description
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,

Qualifications
Banking Compliance experience

Additional Information
Rushi Rathod
408-598-3037