Data Warehouse Specialist
SA Technologies Inc - San Ramon, California, United States, 94583
Work at SA Technologies Inc
Overview
- View job
Overview
Skills/Requirements Responsibilities: Able to translate requirements into DWH/BI/Analytics solutions. Work on business process flow and convert it into technical data flow. Develop DW, ODS, Data Marts, and Reporting Solutions. Engage with business and IT stakeholders to understand processes and constraints. Perform data profiling, ensure scalability of integration processes, and execute multi-dimensional SQL queries. Provide technical, strategic advice to senior management and technical teams. Banking industry experience required. Minimum 4+ years of experience in Data Management solutions implementation. At least 3+ years of experience as a Data Architect (DWH/BI/Analytics). Hands-on experience in developing conceptual, logical, and physical data models using tools like ERWin or similar. Expertise in data quality, profiling, analysis, integration, archival, and migration processes. Strong database knowledge in Oracle, MS-SQL Server, or similar databases. Exposure to ETL tools like Informatica, Hyperion, SSIS is desirable. Hands-on experience with Denodo (data virtualization technology). Informatica MDM implementation experience is a plus. Banking industry experience in Compliance work streams such as KYC, Onboarding, AML Operations.
#J-18808-Ljbffr