Data Warehouse Specialist

Job Description

Role Summary & Role Description

Candidate will play a crucial role in ensuring the quality and reliability of our software products with a focus on developing Azurebased applications data warehouse and ETL bacicend systems. Proficiency in Data Warehousing and Snowflake is essential for this role. Candidate must have minimum of 8 years of relevant experience in Data Warehousing and Database application development. Candidate must have hands on experience in Snowflake and Azure. Analyze Design and Code snowflake objects and views. Create Database Views/materialized views Indexes Partitions. Experience in Shell scripting and Autosys/ConvoyM/Cron scheduling Ability to communicate with Business users understand and Analyze requirements and Use Cases. Experience working in Agile Teams. Proven problem solving communication interpersonal and analytical skills. Ability to work both independently as well as within a team.

Core/Must have skills

Good knowledge in Data Warehouse concepts and different schema types like Star and Snowflake Strong experience in writing complex queries performance tuning query optimization and debugging. Minimum 4 years working experience in Snowflake and good knowledge on Snowpipe DBT Experience in working with Snowflake. Handson experience in bulk loading and unloading data Snowflake tables using COPY command Handling large and complex data sets like JSON ORC PARQUET CSV files from various sources like AWS S3. TASK. Snowpipe creation for scheduling/Automate Snowflake jobs good exposure in Snowflake Cloud Architecture Snow SQL and SNOWPIPE for continuous data loading. Good communication skills problem solving skills and ability to analyses quickly and comeup with an efficient industry standard solution for a given problem

Good to have skills

Good knowledge on Oracle database and Proficient in SQL Performance tuning. Good knowledge on Bigdata and Sped (Good knowledge on Databricks)