Business Intelligence consultant at Albany,New York-Onsite at Albany, Louisiana, USA |
Email: [email protected] |
From: Ashok Reddy, Sligo Software Solutions Inc. [email protected] Reply to: [email protected] Hi, Greetings from Sligo Software Solutions, Inc. !! SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government. We have a urgent requirement for Data warehouse and Business Intelligence consultant position with our client. Role: Data warehouse and Business Intelligence consultant Location: Albany, New York Duration: 24 Months Client: NY State Client Job ID#: HBITS-05-13175 Description This Senior IT Specialist position is required to support the continued development and maintenance of DW/BI solutions in response to critical agency requirements for the WCB. This position will also develop and maintain Pentaho ETL solutions, Pentaho BI schemas, executive dashboards and analytics. Additionally, this position will respond to all data warehouse and BI related ad hoc inquiry requests, development of dashboard features, and development of BI technical solutions for continued reporting requirements. Duties Gather and validate of BI and reporting requirements Document requirements & solutions Perform Data profiling on the source systems Design and review star schema dimensional model to support data warehouse and data marts Perform Source to Target Mapping between source system database and data warehouse target database Develop ETL transformations using one of the ETL tools like Pentaho Data Integration (PDI), or SQL Server Integration Services (SSIS) Develop reports and analytics using one of the tools like SQL Server Reporting Services (Pentaho or Tableau) Develop complex queries using Transact-SQL leveraging analytic functions Perform necessary Testing Complete Documentation Provide Web Development support to embade the anaytics reports on the Agency's internal portal (intranet). Mandatory Requirements Experience (8+ Years) Requirements This is an 100% Onsite In Person Interview 60 months experience in building extraction and transformation of transactional data to drive data warehouse loads and end user BI as well as reporting requirements using ETL tools like Pentaho Data Integration (PDI) or SQL Server Integration Services (SSIS) 60 months experience in reporting and analytics tools such as Pentaho or Tableau 60 months experience in complex SQL development leveraging analytics functions using in Sybase ASE or SQL Server 24 months experience in Pentaho Data Integration (PDI) development. 60 months experience in Star Schema / Dimensional Modeling to support data warehouse environments 60 months experience in doing data profiling and source to target mappings. 36 months experience in doing Web development using Java, HTML, and CSS Ashok Reddy Akkala Sligo Software Solutions, Inc. NYS and NYC MBE Certified Company. Email:[email protected] www.sligosoft.com Keywords: business intelligence active directory information technology Idaho New York |
[email protected] View all |
Wed Nov 29 02:26:00 UTC 2023 |