| 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 |