Hands on experience in Cognos. • Rich experience in creating FMs from star schema/data marts. • Hands on experience in creating rich interactive dashboards and tabular reports. • Sound Knowledge of Data warehouse and ETL Concepts with at least one full cycle project implementation. • Experience in Data Modelling of star schema – Logical/Physical design. • Excellent knowledge of complex SQL /PL-SQL, indexes, database schema, etc. • Hands-On experience on ETL tools- ODI, Informatica.
• Creating Load Plans for highperformance huge Volume data loads. • Scheduling of load jobs and inter-job dependency management. • Knowledge of Change Data Capture mechanisms/tools. • Design and Development of Incremental Load jobs. • Hands-On experience in development of complex Reports using any popular tools such as Tableau, OBIEE, Cognos, Jasper, etc • Design and Development of highly interactive and visually appealing dashboards.
•
