Should have experience with Reporting, Data Modelling, Business Intelligence and Reporting with Power BI Dashboards, SSRS, SSIS, Crystal Reports,
Strong Power BI experience - importing data from various sources such as SQL Server, SQL Server Analysis Services (Tabular Model), MS Excel etc. Experience with Power BI Report builder to create paginated reports pulling data from Oracle, SQL Server and Netezza Data Warehouse.
Should have Experience in gathering, analysing, developing and documenting requirements, coordinating with stakeholders, project documentation, developing - test plans, test cases, test scripts and executing them.
Should have Created Views, Materialized Views, Data Marts with scheduled refreshes where applicable. Pointed Reports, Power BI/Tableau Dashboards to the same on the data visualization projects.
Should have Hands-on experience with building - Workflow solutions, Data integration, Extract, Transform and Load (ETL) Solutions for Data Warehousing - using SSIS packages, Data Stage Jobs etc. Pulled data from multiple sources such as - MS Access, Flat files, SQL Server etc., and loaded them into target databases.