Snowflake ETL Developer

Role:snowflake ETL Developer

Location:Chicago,IL(Hybrid)-Onsite 3 days/week in Downtown Chicago Duration:12 Months

Qualifications

• • Expertise in design/development in Snowflake (Azure or AWS would be preferred) • Experience in ETL tools like SnowSQL from design/development and implementing data ingestion and processing pipelines

• Preferred skills: 1) Snowflake - Expertise in design/development in Snowflake (Azure or AWS would be preferred) 2) SQL - Experience in ETL tools like SnowSQL from design/development and implementing data ingestion and processing pipelines 3) Python/Airflow 4) Data Analysis 5) Good problem Solving skills

Job Description: • Design and Develop ETL pipelines in and out of data warehouse using combination of Python and Snowflakes Snow SQL • Deep understanding of relational as well as NoSQL data stores methods and approaches star and snowflake dimensional modelling • Experience in designing and deploying virtual warehouse, schema, views, zero-copy clone in Snowflake cloud data warehouse • Work with data analyst in mapping documents and design/build IBM DataStage jobs to the requirements. • Participate in peer design reviews and provide recommendations. • Ensure runbooks are fully up-to date and consistently improving the efficiency derived from automation. • Hands-on experience to improve operational stability via automation, such as auto-healing where possible, and raise design changes SMEs and/or architects, as well as opportunities to application /service managers. • Work some off hours as demanded by projects, operations, and need of the on-shore team and stakeholders, such as release, testing and/or critical bug resolutions.