ARAMARK Senior Technical Analyst ETL - Corporate in Philadelphia, Pennsylvania
Aramark (NYSE: ARMK) is in the customer service business across food, facilities and uniforms, wherever people work, learn, recover, and play. United by a passion to serve, our more than 270,000 employees deliver experiences that enrich and nourish the lives of millions of people in 22 countries around the world every day. Aramark is recognized among the Most Admired Companies by FORTUNE and the World’s Most Ethical Companies by the Ethisphere Institute. Learn more at www.aramark.com at http://www.aramark.com/ or connect with us on Facebook at http://www.facebook.com/aramark and Twitter at http://www.twitter.com/aramark .
The Data Warehouse Developer, as part of the Aramark Enterprise IT team, will provide support to Supply Chain Management and Finance groups by designing, developing, and supporting new database objects and ETL routines that interface with transactional systems and external partners.
The Data Warehouse Developer will perform daily software development and operational support activities at the direction of IT Management, Project Managers, and Architects. These activities will deliver on enterprise data management and reporting strategies and will ensure high quality and resilient data exchange between back office systems, trade vendors, partner organizations, customers, and IT service providers.
Perform software design, development, and testing activities within the Enterprise Data Warehouse and various Supply Chain and Finance systems using Aramark enterprise tools (Oracle Database 10g-12c, Informatica PowerCenter, Oracle Warehouse Builder) and in accordance with SDLC policies and guidelines.
Deliver and maintain functional and technical documentation to support new development, change management, maintenance, and operational support activities.
Support IT and business teams with requirements definition and opportunity analysis by providing guidance on data availability, quality, and performance. Provide proof of concept and prototype SQL queries and data extracts.
Provide day-to-day support and troubleshooting of established data integrations:
Extract and analyze error information
Coordinate reprocessing and/or resubmission of failed data integration routines
Escalate critical job failures to internal staff and/or consultant teams as necessary
Provide ongoing status updates to project management and leadership teams.
Provide technical guidance and support to junior and peer team members.
The ideal candidate will have:
4-7 years of experience in a data warehousing and/or software development role within a mature, large-scale enterprise environment
Expert SQL and PL/SQL experience in an Oracle Data Warehouse environment
Significant hands-on development experience with best-in-class ETL and Data Integration tools from Informatica and Oracle
Strong Linux shell scripting experience
Strong written and verbal communication skills
Demonstrated ability to work proactively with diverse teams of employees, contractors, and external partners
Demonstrated ability to author and maintain technical documentation
Demonstrated ability to turn requirements and design documentation into database / ETL deliverables
Demonstrated ability to develop and execute test strategies and plans against deliverables
Experience working within the constraints of a multi-domain (Dev / QA / Prod), controlled, large-scale Data Warehouse environment
Experience in a supply chain, procurement, or finance setting is a plus
Experience with the Salesforce.com platform and/or concepts in a plus
Aramark is an EQUAL EMPLOYMENT OPPORTUNITY/AFFIRMATIVE ACTION employer – Minority/Female/Disability/Veteran