Data Warehouse Engineer

Hi,

Job title:- Data Warehouse Engineer

Location:- San Jose, CA - onsite

Duration:- 12 months+

Key Responsibilities

• Data Modelling - Designing and developing data models to efficiently store and retrieve information.
• ETL Development - Creating and optimizing ETL processes to extract, transform, and load data from various sources ensuring data consistency and quality
• Design, implement and maintain Data Pipelines using ADF
• Database Design and Implementation: Designing and implementing relational and multidimensional database structures within the data warehouse.
• SQL Query Development: Writing efficient SQL queries, stored procedures, and functions to extract, manipulate, and analyze data.
• Database/ Performance Optimization: Optimizing database performance through indexing, query tuning, and other optimization techniques.
• Data Management: Ensuring data integrity, security, and consistency across multiple environments.
• Troubleshooting and Problem Solving: Troubleshooting and resolving Datawarehouse-related issues and errors.
• Reporting and Analysis: Developing and providing reports and dashboards based on data warehouse data.

Skills and Qualifications:

• 10+ years of experience in DW/BI space in both designing the model and building analytics. At least executed two end-to-end implementations. At least worked for min. 2 year in Azure SQL and ADF
• SQL / Relational Database Proficiency: Strong knowledge of SQL syntax, database design principles, and SQL Server, Oracle or other database systems.
• Data Management: Experience with data modeling, data warehousing, and ETL (Extract, Transform, Load) processes
• Strong understanding of Azure Data Factory: Expert-level knowledge of Azure Data Factory's features, capabilities, and best practices.
• Master in Azure SQL stack architecture (SQL Server, SQL Warehouse and Azure Data factory)
• Understanding of data analysis principles and reporting techniques.
• Preferred knowledge of python, Pentaho, or shell scripting
• Problem-solving and Analytical Skills: Ability to identify and resolve data warehouse issues and analyze complex data sets.
• Communication Skills: Ability to communicate technical concepts to both technical and non-technical audiences.
• Functional knowledge of common business processes like quote to cash, clickstream analysis, revenue, booking, billing, etc. is desirable.

Education: Bachelor s degree in computer science, a related field or equivalent experience.

Zafar Khan

Technical Recruiter