Job Description :
PowerBI Developer - BFSI - Eastdil // Ulis
Charlotte, NC
6 Months
Exp: 8-10 yrs4
Rate: $55
Role:
A results driven software professional with minimum 8+ years of experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Confidential SQL Server 2012/2008R2 /2008/2005, SSIS, SSRS and SSAS.
Skills:
Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation.Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, Physical, logical database design and Performance tuning.
Expertise in Power BI, Power BI Pro, Power BI Mobile.Expert in creating and developing Power BI Dashboards in to rich look.
Knowledge in all types of Database migrations with all the versions of SQL Server.Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.
Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report ManagerDeveloped OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart. Expertise in OLAP and OLAP Cubes in SSAS.Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.
Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.Developed U-SQL scripts for processing massive amounts of data in a very familiar environment which is mainly used for AZURE DATA LAKE ANALYTICS.Worked on creating Azure Data Factory for moving and transforming the data.Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations
Experience in Migrating databases from SQL 2008 R2 to SQL 2012.
Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies
Databases: Confidential SQL Server (2005/2008/2008 R2/2012), Oracle 8i/9i, Oracle 10g/9i DB2,Postgre MS Access, NoSql Databases(Hbase
Database Tools: MS SQL Server (2005/2008/2008 R2/2012), MS-Access, SQL Server Integration Services(SSIS), Data Transformation Services(DTS), SQL Server Reporting Services(SSRS)
Development skills: T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, Power BI
Languages: VB.net, Linux, UnixETL Tools: DTS, SSIS (SQL Server Integration Services), Informatica, COMOS, Kettle
Reporting Packages: SQL Server Reporting Services, MS Excel.
Tools/Methodologies: MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall.
Operating Systems: Windows XP, Windows 7,Windows 8, Win 2003/2008/2008 R2