Data Warehouse Specialist
SATechnologiesInc4
Posted: April 14, 2017
Interested in this position?
Create a free account to apply with AI-powered matching
Quick Summary
Data Warehouse Specialist is responsible for translating business requirements into data warehouse solutions, working on business process flow and converting it into technical data flow, and engaging with business and IT stakeholders.
Required Skills
Job Description
Satincorp (www.satincorp.com) is a market leader and one of the fastest growing IT consulting firms with operations in US, Canada, Mexico & India. SAT is an Oracle Gold Partner, SAP Services Partner & IBM Certified enterprise.
We guarantee you the best rate for your skills and performance.
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