Developer I (Informatica) - Must Be Local to Denver

Overview

USD 75,000.00 - 110,000.00 per year
Full Time

Skills

SAFE
IT Management
Business Process
Cloud Computing
SQL
Snow Flake Schema
Data Storage
Debugging
Unit Testing
Acceptance Testing
Specification Gathering
Functional Requirements
System Testing
User Guides
Law
Problem Solving
Conflict Resolution
Extract
Transform
Load
ELT
Management Information Systems
Computer Science
Finance
Data Warehouse
Informatica
Scheduling
Management
Real-time
OLTP
OLAP
Database
RDBMS
Star Schema
Data Modeling
Communication
Project Management
Agile
JIRA
Microsoft Power BI
Modeling
Distribution
Collaboration
Teamwork

Job Details

Job Description

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 medium to large scale applications with medium complexity
  • Design, develop and implement business applications using current technologies
  • 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

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; (2) the "EEO is the Law" poster and supplement; and (3) the Pay Transparency Policy Statement.

Required Qualifications

High School Diploma/GED or Equivalent Experience
2+ Years Informatica Development, including IICS concepts ensuring efficient running of mappings/mapplets, lookups, and overall performance of the data warehouse load ensuring SLAs are met
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.
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.

Preferred Qualifications

Bachelors - Management Information Systems, Computer Science, Finance or related field
4+ Years Informatica Development , including IICS concepts ensuring efficient running 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
OLTP vs OLAP database designs and proper utilization of each. Strong knowledge of 3NF relational database concepts, star schema and proper data modeling techniques ensuring performance of design
Good communication, project management and interpersonal skills required.
Experience working in agile environment and JIRA
Experience with Power BI tool including modeling and telling the story with data

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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.