Job Seekers, Please send resumes to resumes@hireitpeople.comDescription:
Client is seeking and a Senior Bi Data Solution Architect with 5+ years of experience to assist their team in building an overall strategic Bi Data Solution. The perfect candidate will possess prior experience in the following:
- Business workflow, Data Knowledge
- Datawarehouse Concepts (Star Schema)
- Database Knowledge (SQLServer,Oracle) + ETL Tools (SSIS, ODI, Talend)
- Reporting Tools (SSRS, SSAS, PowerBI, Tableau, OBIEE)
- ETL Tools (SSIS, ODI, Talend), Database Knowledge
- Knowledge of the System End to End
- Key Components and Tasks
Know User Requirements:
- Identify the Source System
- Available Data points
- Check the Data quality
- Adapter to extract data
- Categorize Fact Tables
- Categorize Dimension Tables
- Create Measures
- Create KPIS
- Provisioning for Historical Data
- Evaluate Logical vs Physical Keys
- Identify how to link the data from various systems
- Metadata management
- Refresh Cycle
- Handling Failovers
- Datamarts
- Reporting\Dashboarding
- Multi Dimensional Cubes
- Flat Files
- Direct DB
- Handle New Requests
- Security
- Audit Trails
- Feedback Managements
- Should be a team player with good communications.
