PetSmart, Inc. Sr. ETL Engineer - Informatica in Phoenix, Arizona
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
Volunteer events with PetSmart Charities
Learn more about #Life A tPetSmart here: https://www.lifeatpetsmart.com/life-at-petsmart/
Check out Associate stories and share in some celebrations at PetSmart: https://www.blog.lifeatpetsmart.com/
Explore PetSmart Benefits here: https://benefits.petsmart.com/
Learn more about #LifeAtPetSmart in the IT space from our team members: https://www.blog.lifeatpetsmart.com/it
This job summary is intended to describe the general nature and level of work associates/leaders assigned to this job perform. It is not intended to include all duties and responsibilities. You will be provided a copy of a job description for the actual position you are hired in to. PetSmart is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national or ethnic origin, disabilty, as well as any other characteristic protected by federal, provincal or local law. Applicants must be over the age of 18. The employer will consider for employment qualified Applicants with Criminal Histories in a manner consistent with the Los Angeles Fair Chance Initiative for Hiring.