Omega Hires
ETL DWH Sr. Principal Consultant
Omega Hires, Birmingham, Alabama, United States, 35275
Title/Role: ETL DWH Sr. Principal Consultant
Duration:
Long-term Contract PositionLocation:
Birmingham, Alabama (Hybrid)Responsibilities:
Experience in end-to-end data analytics strategy, design and architecture for Snowflake, Matillion Cloud and AWS Cloud Services.8+ years of experience in DWH, 4 years of experience in implementing DWH on Snowflake.Design and Develop/Review ETL programs primarily using Matillion Cloud.Experience in Design and implementation of Data Platform projects in a large-scale enterprise data warehouse environment and at least 2 successful implementations of Matillion with Snowflake is a must.Technical reviews, Data validation & end-to-end testing of ETL Objects, Source data analysis and data profiling.Handle multiple projects in parallel, participate and deliver Solution design, working closely with the architecture team.Understand business requirements and convert them into detailed technical specifications for Data models and ETL programs.Collaborate with business users to create architecture in alignment with business needs.Lead in developing project requirements for end-to-end Data integration processes using ETL for Structured, semi-structured and Unstructured Data.Experience with data security and data access controls and design in Snowflake.Design the data warehouse and provide guidance to the team in implementation using Snowflake SnowSQL.Experience in working on migrating data from on-premise databases and files to Snowflake.Strong understanding of ELT/ETL and integration concepts and design best practices.Experience in performance tuning of the Snow pipelines and should be able to troubleshoot issues quickly.Experience in Snowsql, Snowpipe, and Snowpark.
#J-18808-Ljbffr
Duration:
Long-term Contract PositionLocation:
Birmingham, Alabama (Hybrid)Responsibilities:
Experience in end-to-end data analytics strategy, design and architecture for Snowflake, Matillion Cloud and AWS Cloud Services.8+ years of experience in DWH, 4 years of experience in implementing DWH on Snowflake.Design and Develop/Review ETL programs primarily using Matillion Cloud.Experience in Design and implementation of Data Platform projects in a large-scale enterprise data warehouse environment and at least 2 successful implementations of Matillion with Snowflake is a must.Technical reviews, Data validation & end-to-end testing of ETL Objects, Source data analysis and data profiling.Handle multiple projects in parallel, participate and deliver Solution design, working closely with the architecture team.Understand business requirements and convert them into detailed technical specifications for Data models and ETL programs.Collaborate with business users to create architecture in alignment with business needs.Lead in developing project requirements for end-to-end Data integration processes using ETL for Structured, semi-structured and Unstructured Data.Experience with data security and data access controls and design in Snowflake.Design the data warehouse and provide guidance to the team in implementation using Snowflake SnowSQL.Experience in working on migrating data from on-premise databases and files to Snowflake.Strong understanding of ELT/ETL and integration concepts and design best practices.Experience in performance tuning of the Snow pipelines and should be able to troubleshoot issues quickly.Experience in Snowsql, Snowpipe, and Snowpark.
#J-18808-Ljbffr