Data Warehouse & Integrations Consultant

We need BI and Data Warehouse & Integrations consultant. PRINCIPLE DUTIES & RESPONSIBILITIES: Responsible for the architecture, report design, and functional testing. Create and maintain OLTP, OLAP and warehousing databases in MS SQL Server and/or Oracle. Create both T-SQL to support application and/or reporting requirements. Analyze and tune development and production databases (including Index Creation/Modification and/or Query rewrites to optimize SQL plan selection) to create performing systems using SQL Profiler and other means. Create and maintain ETL packages in SSIS. Create, maintain and tune cubes in SSAS. Create and maintain reports in SSRS, PowerBI. Create and maintain dashboards and interactive reports in Power BI and/or Tableau. Create practical data models. Manage structured & unstructured data sets & hierarchies. Integrate with diverse source systems, e.g. internet-of-things. Evaluate master data issues & ensure data integrity. Create deployment scripts for databases when moving from development to staging and production. Communicate effectively with business users when direction is necessary for project completion. Maintain and manage existing Oracle environment including Backups, Restores, Tuning, Indexes, Upgrades, etc. Innovate and continuously improve product delivery predictability, reduce response times, and streamline development processes. Provide knowledge transfer to business end users Provide strong analytic support to various teams. Collaborate with IT and business unit resources to understand business requirements and ensure the successful creation of reports. Please share your resumes on career@futuresofts.net