Company: PetSmart Location: Phoenix, AZ Employment Type: Full Time Date Posted: 07/24/2021 Expire Date: 10/27/2021 Job Categories:
Architectural Services, Computers, Software, Construction, Mining and Trades, Engineering, Healthcare, Other, Information Technology, Law Enforcement, and Security, Research & Development, Medical, Nonprofit and Volunteer Services, Energy / Utilities
Sr. ETL Engineer - Informatica About the Team
It’s an exciting time in technology, and that buzz is felt throughout PetSmart! We are continuing to grow at a faster pace and we want to continue to provide best-in-class experiences for pets and pet parents. Our IT team has 4 different departments: Information Security, IT Service Delivery, Business Enabling Systems, and IT Commerce & Customer Engagement.
Whether it’s online or in our stores, the work that the IT team does is instrumental in PetSmart’s success. We have a strategic and actionable plan underway and are looking for associates who are just as excited about it as we are.
About the Job
Senior ETL Engineer - Informatica
How this role will make an impact:
As the Senior ETL Engineer on the team, you will be responsible for collaborating with the various PetSmart business areas to design and build sustainable solutions to meet business needs and add significant business value. The individual will execute the detailed design, build, test and deployment of the solution to ensure it meets specifications and ultimately the business requirements. This is an exciting time to join PetSmart and work with all the latest and great technologies!
Your goals and responsibilities will include:
Works 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.
Executes the build, test and deployment of full lifecycle solutions – for Application Integration & Data Analytics (data integration) solutions.
Builds implementation plan and coordinates deployment with platform teams
Champion efforts to ensure appropriate development best practices
Work on multiple concurrent projects, meet business expectations, influence outcomes and maintain stated timelines
What you’ll bring to the table:
Informatica Power Center -5 years min
BA/BS Degree in IT, MIS or business related functional discipline
Minimum 5-8 years hands on software development, Informatica, Power Center 10.x
SQL scripting skills for multiple backends such as Netezza, SQL Server and Oracle
Experience on Application and Data Integration architectures, integration patterns and best practices
Strong domain on multiple data formats such JSON and XML
Strong Software Development Life Cycle (SDLC) skills
Strong analytical skills with the ability to understand key business processes and related issues
Experience building automated unit and functional test scripts for ETL processes
Excellent oral and written communication skills
Strong self-leadership and ability to manage conflict
Ability to develop successful relationships with external and internal partners
Experience using other tools in the PetSmart Platform: /.Net(C#)/DtaBricks-BigData/ Tibco BW/Mulesoft/ Denodo (desired)
About the Culture
Our home office offers outstanding amenities in a fun and rewarding workplace including:
Pet friendly environment, bring your pets to work!
A work-life balance and family events such as movie nights, art events and holiday festivals
“Top Dog” gym with equipment, fitness classes, massage therapists and personal trainers
“Sit & Stay” Café serving fresh breakfast and lunch options
Starbucks cart—productivity at its finest!
“Lil’ Paws” learning center and onsite daycare facility