Vacancy expired!
- Design robust Logical Data Models and stewarding the data design of the asset and ensuring alignment with the larger roadmap goals.
- Work closely with business users to determine business requirements, lead requirements gathering meetings, propose future enhancements, resolve user queries or any issues.
- Develop and define application scope and objectives. Prepare specifications for development of data pipelines for migrating data in both OLTP and Data Warehouse environments.
- Design, develop, debug, and support complex data integration interfaces and processes (including stored procedure and complex queries) using various tools and technologies including Pentaho/SSIS/Informatica, PowerBI, SQL, and PostgreSQL/SQL Server.
- Create database tables, procedures, views, functions, indexes using SQL programming.
- Impact analysis on upstream data/process changes to Data Warehouse and Reporting systems.
- Design database objects as necessary to meet new business requirements for reporting.
- Strong understanding of ETL processes, OLAP concepts, SQL programming, and Reporting.
- Expertise in ETL (SSIS/Pentaho Data Integration/Informatica) and DBMS (SQL Server/PostgreSQL).
- Experience in SQL Server Reporting Services (SSRS), PowerBI or Tableau.
- Expert skills in performance tuning, monitoring, and troubleshooting data integration solutions; solid communication, interpersonal, leadership, and collaborative skills and a demonstrated ability for creative problem solving
- • Experience in Microsoft Azure (Azure Data Factory, Azure Data Lake), and Databricks. Experience in migrating on-premises data/process to Microsoft Azure using Azure Data Factory.
Vacancy expired!