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