**126948BR** **Job Title:** Developer I (Informatica) - Must Be Local to Denver **Location:** Vistar Corporate (9002) **Job Description:** **Must have permanent work authorization** **We Deliver the Goods:** + Competitive pay and benefits, including Day 1 Health & Wellness Benefits, Employee Stock Purchase Plan, 401K Employer Matching, Education Assistance, Paid Time Off, and much more + Growth opportunities performing essential work to support America’s food distribution system + Safe and inclusive working environment, including culture of rewards, recognition, and respect **Position Summary** The primary role of the Developer I (Informatica) position is to collaborate within a small team of developers and business analysts to develop and modify custom business applications and reports. This role will work directly with business stakeholders and IT management to elicit requirements, provide ideas for improvements, and deliver well-documented solutions that accommodate stakeholder and business process needs while ensuring that pre-defined coding standard practices are followed. Position Responsibilities Include: + Create ETL/ELT mappings supporting the Data Warehouse environment using Informatica Intelligent Cloud Services (IICS) + Utilize SQL and Snowflake as data storage options and benefits of each platform. Create and debug queries supporting exhaustive unit testing and lead user acceptance testing + Work with other developers, project managers, architects, business analysts and other departments to develop new technology and expand into existing applications + Participate with Agile methods including define and log work using JIRA, standups, etc. + Develop design documents such as technical specifications, functional requirements, object modules, system test plans, technical and user documentation + Ensure successful completion of projects that meet requirements + Provide support to maintain existing applications + Participate in Team Code Reviews + Performs other related duties as assigned **Req Number:** 126948BR **Address Line 1:** 188 Inverness Drive West **Job Location:** Englewood, Colorado (CO) **Shift:** 1st Shift **Full Time / Part Time:** Full Time **EEO Statement:** Performance Food Group and/or its subsidiaries (individually or collectively, the "Company") provides equal employment opportunity (EEO) to all applicants and employees, regardless of race, color, national origin, sex, marital status, pregnancy, sexual orientation, gender identity, religion, age, disability, genetic information, veteran status, and any other characteristic protected by applicable local, state and federal laws and regulations. Please click on the following links to review: (1) our EEO Policy (http://pfgc.com/Policy) ; (2) the "EEO is the Law" poster (http://pfgc.com/Poster) and supplement (http://pfgc.com/Supplement) ; and (3) the Pay Transparency Policy Statement (http://pfgc.com/PayTransparency) . **Required Qualifications:** Must have permanent work authorization • High School Diploma/GED or Equivalent Experience • 2+ years integrating multiple data sources into holistic reporting structures using Informatica Power Center/IICS, Data Factory, Python, or other similar tool • 2+ years developing type 2 dimensions, facts, conformed dimensions, blending data from multiple systems into holistic data solutions • Ability to work with business partners to understand complex requirements. Listen to business jargon, convert to data design and ETL/ELT solutions driving engagement and satisfaction. • OLTP vs OLAP database designs and proper utilization of each. Strong knowledge of 3NF, star schema and proper data modeling techniques ensuring performance of design • Strong problem-solving skills enabling advanced troubleshooting techniques and resolutions to enhancement requests • Collaborative, self-starter, and someone who takes initiative driving resolutions and completion of projects. **Division:** VISTAR **Job Category:** Information Systems **Preferred Qualifications:** • Bachelors - Management Information Systems, Computer Science, Finance or related field • 2+ Years Informatica Development , including IICS concepts • Efficient design of mappings/mapplets, lookups, and overall performance of the data warehouse load ensuring SLAs are met • Experience utilizing informatica publish and scheduling processes • Experience managing real time data ingestion practices • Good communication, project management and interpersonal skills • Experience working in agile environment and JIRA • Experience with Power BI including modeling and telling the story with data **State:** Colorado **Company Description:** Vistar customers are everywhere people work, play, and shop. Vistar is America’s leading candy, snack, and beverage distributor with more than 25 distribution centers delivering everything from popcorn to healthy meal replacements anywhere in the U.S. The company has thrived by innovating, exceeding customer expectations, and fostering a collaborative culture built on teamwork, doing what’s right, and giving back to the communities they serve. **Benefits:** Click Here for Benefits Information (https://pfgc.com/Careers.aspx#benefits) **Compensation:** $75,000 - $110,000 base salary + 15% annual incentive potential