Squircle IT Consulting Services is a leading IT solutions and services company established with a specific mission of providing comprehensive, top of the line solutions around ERP and BI. Since its inception in November, 2007, SQUIRCLE has emerged as a key player in ERP and BI space. SQUIRCLE brings together the best Technology and Domain expertise in PeopleSoft to offer a full spectrum of services ranging from Implementation, Business Consulting to Support.
Job Description
Need MSBI developers to assist with the Data Engineering team within the organization as well as third party vendors. Ideal candidates should have a successful track record of working in a team environment developing critical line-of-business applications using the Microsoft tools i.e SSIS, SSRS, SSAS and MDM (preferable).
Responsibilities:
• Analysis and gathering requirements for Development projects covering all parts of SDLC
• Creating tables and their relationships (Schemas) in the data warehouse.
• Creating SSIS packages to migrate large amounts of data.
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• Create Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Functions and views, Performance tuning of queries.
• Involve in using Master Data Management (MDM) tools for a Data Warehousing project (optional)
Job Requirements:
• Minimum 3 years direct experience in the Design and Development of Data Warehouse/Data Marts
• Extensive experience in using SQL server 2008, SSIS, SSRS. Exposure to SSAS and MDX queries would be an added advantage.
• Extensive experience of T-SQL, SSIS Package development and SSRS Report development on MS SQL 2008/R2/2012
• Should have positive Data Analytical skills
• Manage multiple priorities and ensure team deliveries in a dynamic environment
• Ability, if required, to design/develop/optimize stored procedures for reports
•