+1 844 678 44 27


Company : Optghar
Req/job Title : Sr Data Warehouse Developer
Job Ref No : 6869
Post Date : 08/01/2022
Country : USA
Job State/Province : California
Job City : Sunnyvale
Experience : 10 - 0
OtherSkill :
Subject : Great Job Opportunity----Sr Data Warehouse Developer
Description :

RoleSr 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.
ResponsibilityDesign 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 Required10+ years 
Work LocationSunnyvale, CA