BI – Developer Responsibilities: –Should Involve in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
– Experienced in database design process and data modeling process.
– Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
– Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
– Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
– Created a report model on SSAS cubes.
– Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
– Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
– Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012/2008 R2 Business Intelligence Development Studio.
– Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
– Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
– Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
– Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
– Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
– Deployed and Tested (UAT) Reports in Multiuser Environment. Created RSConfig Files and Ensure Report Security with Keys.
– Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
– Worked closely with QA team and helped them come up with test scenarios.
– Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.
– Nice to have – hands on experience on Power BI reporting tool.