Role | Sr Data Warehouse Developer |
Mandatory Technical Skills | · 10+ years of experience in Business Intelligence, Data Warehousing, SQL, and Data Modeling. |
· 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. |
Desirable Skills | · Good problem solving and debugging skills. |
· Excellent familiarity with project lifecycle approaches phases and tools. |
· Create and maintain documentation. |
· Strong verbal and written communication skills. |
Responsibility | 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. |
|
Conduct technical design and code reviews. |
· Establish, enhance, implement, enforce, and maintain ETL best practices. Own the change request process and coordinate with other teams as necessary. |
Total Experience Required | 10+ years |
Work Location | Sunnyvale, CA |