Agile Techlabs
Snowflake ETL Engineer
Agile Techlabs, Chicago, Illinois, United States, 60290
Job Title:
Snowflake ETL EngineerJob Location:
Chicago, IL (Remote)Job Type:
Full TimeJob Description:2 years of hands-on experience in Snowflake cloud data warehouse.Experience in designing warehouse and pipelines with Snowflake architecture and data model.Complete understanding of Snowflake concepts like Snowpipe, SnowSQL, cloud services, data sharing, reader accounts, designing optimal virtual warehouses as per the business SLAs, optimized data distribution, clustering keys, and usage of materialized views.Minimum of 6 years of IT experience, including experience as a technical lead in data warehousing technologies, including modern cloud data warehousing.Hands-on experience in ELT tools like Informatica, AWS Glue, or any other parallel ELT tools.Experience in handling semi-structured (XML, JSON) and unstructured data.Knowledge of implementing security features like SSO, column masking, and role-based administration.Strong knowledge of ELT/ETL concepts, design, and coding.Experience in designing and developing stored procedures, queries, ETL processes, views, and data models necessary to support BI visualizations.Ability to effectively handle report performance and administration.Knowledge of complex source system data structures, preferably in the financial services industry, and reporting-related developments will be an advantage.Interested candidates can send their updated resumes to:
anupam.pal@agile-techlabs.com
#J-18808-Ljbffr
Snowflake ETL EngineerJob Location:
Chicago, IL (Remote)Job Type:
Full TimeJob Description:2 years of hands-on experience in Snowflake cloud data warehouse.Experience in designing warehouse and pipelines with Snowflake architecture and data model.Complete understanding of Snowflake concepts like Snowpipe, SnowSQL, cloud services, data sharing, reader accounts, designing optimal virtual warehouses as per the business SLAs, optimized data distribution, clustering keys, and usage of materialized views.Minimum of 6 years of IT experience, including experience as a technical lead in data warehousing technologies, including modern cloud data warehousing.Hands-on experience in ELT tools like Informatica, AWS Glue, or any other parallel ELT tools.Experience in handling semi-structured (XML, JSON) and unstructured data.Knowledge of implementing security features like SSO, column masking, and role-based administration.Strong knowledge of ELT/ETL concepts, design, and coding.Experience in designing and developing stored procedures, queries, ETL processes, views, and data models necessary to support BI visualizations.Ability to effectively handle report performance and administration.Knowledge of complex source system data structures, preferably in the financial services industry, and reporting-related developments will be an advantage.Interested candidates can send their updated resumes to:
anupam.pal@agile-techlabs.com
#J-18808-Ljbffr