Sr Data Engineer with exp in Python, Snowflake, Automation, Databricks at Alpharetta GA

Job ID : 2362 L4

Location : Alpharetta GA

Duration : 12+ months

Location : Alpharetta GA

Title: Snowflake Data Engineer with exp in Shell scripting/Python/Java, Api, AWS, Databricks, Data warehousing - OLTP, OLAP at Alpharetta GA 12+ months cont

Description:

Hybrid 2-3 days a week

Fully Remote option available

Database Platforms Services - Analytics team is looking for a proactive, enthusiastic, and knowledgeable individual who is a self-starter and is passionate about Engineering Database solutions.

This position will be focused on building automation pipelines around database platforms (on-prem and cloud) which will require programming skills (Shell scripting/Python/Java) and API development experience.

Primary Responsibilities:

• Automate standard Database processes using Shell scripting/Python/Java scripting.
• Design and Architect database solution on Snowflake cloud platform, AWS and Databricks.
• Develop new automation scripts in Python and write unit cases.
• Enhance/troubleshoot existing Unix shell scripts.

Skills Required:

• • Expert in programming and has automation mind set.
  • Experience with DB2, AWS, Snowflake and Azure data ecosystem.
  • Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Snowpark, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
  • Snowflake SQL Writing SQL queries against Snowflake Developing scripts Java, Python, Scala, etc. to do Extract, Load, and Transform data.
  • In-depth understanding of Data Warehouse/ODS, ETL concept and modeling structure principles
  • Experience with Database design and architecture patterns.
  • Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
  • Experience gathering and analyzing system requirements.
  • 5+ years of hands on experience designing and implementing production grade data warehousing solutions on large scale data technologies such as Snowflake, DB2, Hadoop or SAP IQ.

Nice To Have:

• • General Database knowledge.
  • Team player.