You will design and implement ETL/ELT architecture using Snowflake as the enterprise data warehouse.
Responsibilities
Design and implement ETL/ELT architecture integrating data from RDBMS, APIs, SaaS apps, flat files, streaming platforms, and cloud services into Snowflake.
Define data integration best practices covering reusability, scalability, and cost optimization.
Optimize Snowflake performance, including managing virtual warehouses, clustering, and query tuning.
Establish data quality, governance, and lineage frameworks for data pipelines.
Lead and mentor ETL/ELT developers in building robust data integration pipelines.
Required Skills
10+ years in ETL/ELT architecture and development.
Strong expertise in Snowflake (warehouses, streams, tasks, snowpipe, data sharing).
Proficiency with ETL/ELT tools including Informatica, Talend, Matillion, SSIS, AWS Glue, DBT, and FiveTran.
Expert SQL and data performance optimization skills.
Experience integrating data from diverse sources (RDBMS, APIs, SaaS apps, streaming).
Ability to evaluate and implement ETL/ELT tools and automation frameworks.
Experience defining data integration best practices.