39 applicants
Compunnel Inc. ยท 2 days ago
ETL Developer
Chicago, IL
Full-time
Hybrid
Mid Level
3+ years exp
Wonder how qualified you are to the job?
Maximize your interview chancesIT Services and IT Consulting
Insider Connection @Compunnel Inc.
Responsibilities
Design and Develop ETL pipelines in and out of data warehouse using a 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
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
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
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
Bachelors Degree
Preferred
Snowflake - Expertise in design/development in Snowflake (Azure or AWS would be preferred)
SQL - Experience in ETL tools like SnowSQL from design/development and implementing data ingestion and processing pipelines
Python/Airflow
Data Analysis
Azure and Azure Databricks would be nice to have
Company
Compunnel Inc.
Founded in 1994, Compunnel Inc.
1,001-5,000 employees
H1B Sponsorship
Compunnel Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Trends of Total Sponsorships
2023 (1572)
2022 (2192)
2021 (2385)
2020 (2157)
Funding
Current Stage
Late StageLeadership Team
Andy Gaur
Founder, Chairman & CEO
Karthik Natarajan
Executive VP & CTO
Company data provided by crunchbase
