Snowflake Data engineer[Onsite]

SmartIPlace•Columbus, OH

1d•Onsite

About The Position

This role is for a Technical Specialist 4 (TS4) position focused on Snowflake Data Engineering, located onsite in Columbus, OH. The work hours are Monday to Friday, 8:00 AM to 5:00 PM EST. Interviews will be conducted via Teams and the mode of work is onsite at 50 W. Town Street, Columbus, Ohio 43215.

Requirements

Proficiency in Data Warehousing, Data migration, and Snowflake is essential.
Strong Experience in the implementation, execution, and maintenance of Data Integration technology solutions.
Minimum (4-6) years of hands-on experience with Cloud databases.
Minimum (2-3) years of hands-on data migration experience from the Big data environment to Snowflake environment.
Minimum (2-3) years of hands-on experience with the Snowflake platform along with Snowpipe and Snowpark.
Strong experience with Snow SQL, PL/SQL, and expertise in writing snowflake procedures using SQL/python/Java.
Experience with optimizing Snowflake database performance and real-time monitoring.
Strong database architecture, critical thinking, and problem-solving abilities.
Experience with the AWS platform Services.
8+ years of experience with Big Data, Hadoop on Data Warehousing or Data Integration projects.
Analysis, Design, development, support and Enhancements of ETL/ELT in data warehouse environment with Cloudera Bigdata Technologies (with a minimum of 8-9 years' experience in Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, StreamSets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Flume, Zookeeper, Sentry, Cloudera Navigator) along with Oracle SQL/PL-SQL, Unix commands and shell scripting.
Strong development experience (minimum of 8-9 years) in creating Sqoop scripts, PySpark programs, HDFS commands, HDFS file formats (Parquet, Avro, ORC etc.), StreamSets pipeline creation, jobs scheduling, hive/impala queries, Unix commands, scripting and shell scripting etc.
Writing Hadoop/Hive/Impala scripts (minimum of 8-9 years' experience) for gathering stats on table post data loads.
Strong SQL experience (Oracle and Hadoop (Hive/Impala etc.)).
Writing complex SQL queries and performed tuning based on the Hadoop/Hive/Impala explain plan results.
Experience building data sets and familiarity with PHI and PII data.
Expertise implementing complex ETL/ELT logic.
Accountable for ETL/ELT design documentation.
Basic knowledge of UNIX/LINUX shell scripting.
Utilize ETL/ELT standards and practices towards establishing and following centralized metadata repository.
Good experience in working with Visio, Excel, PowerPoint, Word, etc.
Effective communication, presentation and organizational skills.
Familiar with Project Management methodologies like Waterfall and Agile.
Ability to establish priorities and follow through on projects, paying close attention to detail with minimal supervision.
BS/BA degree or combination of education & experience.

Nice To Haves

Snowflake Certification is Highly desirable.
Snowpark with Python programming languages is preferred to be used to build data pipelines.

Responsibilities

Proficiency in Data Warehousing, Data migration, and Snowflake.
Implementation, execution, and maintenance of Data Integration technology solutions.
Hands-on experience with Cloud databases.
Hands-on data migration experience from Big data environment to Snowflake environment.
Hands-on experience with the Snowflake platform along with Snowpipe and Snowpark.
Writing snowflake procedures using SQL/python/Java.
Optimizing Snowflake database performance and real-time monitoring.
Database architecture, critical thinking, and problem-solving.
Experience with the AWS platform Services.
Analysis, Design, development, support and Enhancements of ETL/ELT in data warehouse environment with Cloudera Bigdata Technologies.
Development experience in creating Sqoop scripts, PySpark programs, HDFS commands, HDFS file formats (Parquet, Avro, ORC etc.), StreamSets pipeline creation, jobs scheduling, hive/impala queries, Unix commands, scripting and shell scripting etc.
Writing Hadoop/Hive/Impala scripts for gathering stats on table post data loads.
Writing complex SQL queries and performed tuning based on the Hadoop/Hive/Impala explain plan results.
Building data sets and familiarity with PHI and PII data.
Implementing complex ETL/ELT logic.
Accountable for ETL/ELT design documentation.
Utilize ETL/ELT standards and practices towards establishing and following centralized metadata repository.
Effective communication, presentation and organizational skills.
Establish priorities and follow through on projects, paying close attention to detail with minimal supervision.