Role : BI Developer
Location : Chicago,IL
Duration : 6+ Months
Need Locals as face to face is mandatory.
Job Description :
QUALIFICATIONS: 7+ years of SQL database experience Strong SQL Skills including experience writing views, stored procedures and SQL Server Agent jobs Strong, practical experience with the Microsoft BI experience including SSRS, SSIS and SSAS Working knowledge of Microsoft SQL Server Solutions for BI DW Environments, including SQL Server 2008, DTS Integration Services (SSIS), Analysis Services (SSAS), Reporting Services, and Multidimensional OLAP Reporting tools, SQL Profiler, BIDS 2008, E/R Studio Experience with Master Data Management architecture, tools and principles a plus Thorough understanding of and Data Warehouse and ETL Working knowledge of relational and dimensional data modeling techniques Solid knowledge of data warehousing concepts Have working understanding of data and its exchange with other systems Create SSIS and SSAS packages Proven strength in Highly SSRS Report generation and familiar with different workarounds Must be aware of SSRS Subscription and Auto generation of Reports SharePoint Integration points among these technology will be plus RESPONSIBILITIES: Responsible for standards and design of physical data storage, maintenance, access and security administration, this person will performs backup and recovery on DBMS and configure database parameters, along with related activities Provide general software development services for SharePoint, specifically, the person will develop using Microsoft BI SSAS, SSIS, and SSRS technologies Manages and maintains all production and non-production databases provides support to network administration, provides mainframe support, performs data modeling, develops tables for databases, develops applications for web-based applications, and provides design, programming, and testing services Delivery of business intelligence solutions and ongoing development and maintenance of existing application developed on SSIS, SSRS, SSAS Provide input into the logical design and development of data models Identify ways of improving information delivery, data capture and design and business process through the provision of technical solutions Present a professional, competent, and confident image in dealing with users as well as the BI team and other Teams within IT