Job Description :
BI Developer,

Hartford, CT

6+ Months Contract

Phone + In-Person/Skype


Description:


Work closely with business, application developers, and production teams across functional units.
Develop Sub Reports, Matrix Reports, Charts, Drill through Reports and Drill down reports, using SQL Server Reporting Services (SSRS
Develop complex queries on DB2 database for extracting data for reporting purposes.
Create ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc and then load the data into destination tables by performing transformations using SSIS packages.
Developing and deploying SSIS packages for ETL from OLTP and various sources to staging and to production Data warehouse.
Design SSIS packages to import data from multiple sources to control upstream and downstream of data into SQL Azure database.
Create tabular reports using Power BI features.
Rigorously test and debug Stored Procedures and Triggers to ensure the validity of the data after the insert, update or delete.
Design, develop, test, and maintain Tableau functional reports.
Develop OLAP cubes using SSAS.
Monitor Full/Incremental/Daily Loads as well as other scheduled ETL jobs.


Tools: MS SQL Server 2016/2014/2012/2008R2, IBM DB2, MS Azure, T-SQL, PL/SQL, Visual Studio 2013/2012, SQL Server Reporting Services (SSRS 2014/2012), SQL Server Integration Services (SSIS 2014/2012/2008), SQL Server Analysis Services (2014/2012/2008), SSAS, Amazon web services, Informatica, Tableau.
             

Similar Jobs you may be interested in ..