Previous Job
Data Warehouse Developer - Denver, CO
Ref No.: 17-02886
Location: Denver, Colorado
Job Title: Data Warehouse Developer
Job Location: Denver, CO
Position Type: Contract (12+ months with possible extension)
Rate: DOE
Interview Process: Phone/webex hire

US Citizen and Green Card preferred- No Third Party C2C Candidates

Job Description

About the Job
Develop integrations between Janus internal systems and to external data vendors. Develop job schedules using Autosys to meet daily SLAs for the enterprise data warehouse and centralized security master applications. The ideal candidate has strong software development skills and can pick up new technologies and assist in all aspects of the team's work such as development using data warehouse and master data vendor platform tools. The candidate must have a willingness to work across multiple teams in an open and collaborate way to solve business problems.

• Develop Informatica interfaces
• Develop Autosys schedules
• Develop SQL and PL/SQL for Informatica jobs
• Perform unit and integration tests, as well as support UAT testing
• Provide estimates, work independently and meet deadlines
• Update ERDs and other documentation as needed
• Manage the releases and the related builds in each environment

• 8 years+ in information technology and/or application development
• 5 years+ Informatica development, experience with version 10 preferred
• Must have experience with Oracle 11g, SQL Developer/Toad, and SVN (or other version control)
• Experience with architecture principles and design best practices
• Must have experience with data modeling in an Enterprise Data warehouse and data marts
• Autosys or comparable job scheduler (control-M or Tivoli)
• Comfortable working directly with business partners at all levels of the organization
• Experience designing and implementing information solutions
• Extensive knowledge of star schema data warehousing concepts and methodologies
• Experience translating complex functional requirements into technical solutions

• Experience in asset management data
• Experience developing Perl and unix shell scripts to supplement Informatica as needed
• Experience with JIRA, Confluence, Bamboo, Putty preferred

• Bachelor's degree or equivalent experience is required.