Sr. Data Engineer (Snowflake, Python & SQL) in NJ

Role: Sr. Data Engineer (Snowflake, Python & SQL)

Job location – New Providence, NJ (Hybrid Onsite).

Note – Look for local and genuine candidates with strong technical experience in Python and SQL with Data Warehousing background (Snowflake)

Interview process – We will have initial 1 tech screening round from Mastek side before client submission. If client shortlist the profile, then they will be having 3 rounds which includes initial 2 would be virtual and last final round would be face to face.

Job Description

• Experienced Data management specialist responsible for developing, overseeing, organizing, storing, and analyzing data and data systems
• Participate in all aspects of the software development lifecycle for Snowflake solutions, including planning, requirements, development, testing, and quality assurance
• Work in tandem with our engineering team to identify and implement the most optimal solutions
• Ensure platform performance, uptime, and scale, maintaining high standards for code quality and thoughtful design
• Troubleshoot incidents, identify root causes, fix and document problems, and implement preventive measures
• Able to manage deliverables in fast paced environments
• Demonstrate both technical and team leadership.

Areas of Expertise

• At least 10 years of experience designing and development of data solutions in enterprise environment
• At least 6+ years’ experience on Snowflake Platform
• Strong hands-on SQL and Python development 
• Experience with designing and development data warehouses in Snowflake
• A minimum of 5 years’ experience in developing production-ready data ingestion and processing pipelines using Spark, Scala
• Strong hands-on experience with Orchestration Tools e.g. Airflow, Informatica, Automic
• Good understanding on Metadata and data lineage
• Hands on knowledge on SQL Analytical functions
• Strong knowledge and hands-on experience in Shell scripting, Java Scripting
• Able to demonstrate experience with software engineering practices including CI/CD, Automated testing and Performance Engineering.
• Good understanding and exposure to Git, Confluence and Jira
• Good problem solving and troubleshooting skills.