Data Warehouse Specialist
- Full-time
Company 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.
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