SA TECHNOLOGIES
Data Warehouse Specialist
SA TECHNOLOGIES, San Ramon, California, United States, 94583
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/RequirementsResponsibilities
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+ years 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
Hands-on experience working in Denodo (data virtualization technology).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.
#J-18808-Ljbffr
Skills/RequirementsResponsibilities
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+ years 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
Hands-on experience working in Denodo (data virtualization technology).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.
#J-18808-Ljbffr