Job Title: ETL / Informatica Developer (Ref Code:31615- NICHRI –IO37-M-ARI)
Location: Washington. DC
Duration: 6+ Months

 

Emp.Type: 1099/W2/H1B Transfer 

 

Must Have's:

5+ years of experience in full life cycle application/system development. 
5+ years of hands-on experience in design and development of large scale ETL and Enterprise Data Warehouse applications. 
At least 4 years of ETL design and development using Informatica PowerCenter (required); DQ, MDM and/or DT (a plus) 
Minimum 2 years working with or designing XML interfaces 
Minimum 1 years interfacing with messaging based systems and ESB's such as MQ/JMS or Tibco EMS is preferred. 
Strong programming experience with SQL and Oracle databases. 
Strong UNIX and shell scripting experience is required 
Autosys scheduling experience required. 
Must be experienced and hands-on in all facets of warehousing including Sourcing/Staging, ODS, DW, Marts, reporting and schema design. 
Strong experience in Performance Tuning and developing High Volume Data Loads required. 
Strong ability to understand, document and communicate technical architectures, best practices, toolsets and solutions. 
Strong understanding of SOA concepts, design patterns, tools, techniques and best practices. 
Must be detail oriented and possess strong problem-solving skills 
Experience with DOORS, Rational Clear Case, Remedy, Clear Quest, Quality Center and SharePoint are a plus

 

JOB INFORMATION 
Develop, modify, or update Informatica objects to support data mart application used by business units or infrastructure units. Participate in or review all of the steps in the software development life cycle to create and modify the software. 

KEY JOB FUNCTIONS 
Participate with team of technical staff and business managers or practitioners in the business unit to determine systems requirements and functionalities needed in large/complex development project. 
Assess and develop high level design requirements for project and communicate in writing or in meetings with development team. Assess detailed specifications against design requirements. 
Develop Informatica workflows and other objects to ensure the proper operation of Capital Market Data Mart 
Review coding done to advance application upgrade, extension, or other development. Analyze application for data integrity issues. 
May mentor less experienced technical staff; may use high end development tools to assist or facilitate development process. 
Qualifications 

EDUCATION 
Bachelor's Degree or equivalent required 
MINIMUM EXPERIENCE 
5+ years of related experience 

 

 

 

 

 

To Apply, Please click here: APPLY NOW