Senior Data Engineer

PetSmart LLC Position : Senior Data Engineer Responsible for working with Solution Architects and business area teams to build detailed technical design and specification documents to meet business needs, considering capabilities, risks, and system dependencies regarding ETL integrations.

Experience, qualification, and soft skills, have you got everything required to succeed in this opportunity Find out below.

Executes the build, test, and deployment of full lifecycle solutions – for Application Integration & Data Analytics (data integration) for ETL solutions.

Builds implementation plans and coordinating deployment with platform teams.

Ensures appropriate development best practices.

Works on multiple concurrent projects, meeting business expectations, influencing outcomes, and maintaining stated timelines.

Supports existing ETL integrations, triaging, and troubleshooting alongside Level 1 support teams and coding and deploying fixes as needed.

Mentors / coaches less experienced engineers.

This position requires a Bachelor’s degree or equivalent in Computer Science, Data Science, or a related field and 5 years related (progressive, post-baccalaureate) experience.

Must also have 24 months of demonstrated experience with each of the following : 1) Developing ETL flows per design specifications using Informatica Power Center Designer 10.4, Workflow Manager, and Netezza and Snowflake Databases to extract and load data; 2) Gathering requirements to perform requirement analysis, design, development, and system testing, and creating detailed design Confluence Pages; 3) Creating reusable components and PL / SQL Stored Procedures to improve reusability and reduce turnaround time, and scheduling and monitoring ETL flows using Tidal jobs; 4) Creating unit test cases, testing developed code, and ensuring that output is as per given requirements by scheduling workflows and validating data using SQL scripts in Snowflake / Microsoft SQL Server Management Studio; and 5) Resolving bugs in JIRA during SIT and User testing cycles to find root cause.

Employer will accept experience gained concurrently.

Full-time, position located in Phoenix, AZ.

Please apply online at https : / / careers.petsmart.com.