Job Description :
Hi
Hope you are doing great.


Title: Informatica Developer
Location: 720 S. Colorado Blvd. Glendale, CO 80246
Contract Duration: permanent/6 months (could extend)
Type: Contract (H1B), Permanent (only for GC and US citizens)

Need Locals

We can use H1 transfers/Pass Throughs/Sub-vending

Description:
They need to know Informatica, strong SQL skills, and the will need to know how to link relational databases to non-relational databases. They will be using a Azure Data Link to connect the relational db to non-relational db (MS Polybase is the tool that is added onto SQL Server Ideally that experience but if we can''t find that someone who has linked relational to non-relational db like Mongo or AWS

Data Warehouse Developer
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.

ESSENTIAL FUNCTIONS:
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

MINIMUM EXPERIENCE:

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

PREFERRED EXPERIENCE

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

WORKING ENVIRONMENT/PHYSICAL ACTIVITIES:

PC usage up to 100% of the time
Office equipment such as telephone, fax and copier
Cellular phone may be required
May be required to work in excess of 40 hours per week and may include weekend/evening/holiday hours including on call rotations

Please see me with questions or candidates!