Data Warehouse Specialist

Satincorp () 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 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.