ETL/Iinformatica Expert./ Excellent opportunity for Security cleared candidates.

Position: ETL/Iinformatica Expert.
Due Date: ASAP
Location: Springfield, VA

Duration: FULL TIME
Description/Job Duties:
Must Have

§ 7+ years of ETL developer experience and a minimum of 5+ years of Informatica experience
§ Design, develop, implement, and assist in validating ETL processes
§ Bachelor's degree in Computer Science or equivalent experience
§ Strong database development skills like complex SQL queries, and be able to understand complex Oracle store procedures
§ Experience in Data Analysis and Data Modeling
§ Strong experience with ETL development life cycle
§ Unix/Linux scripting experience
§ Experience with identifying and resolving source data issues and
§ Strong organization skills; self-directed with minimal supervision
§ Excellent communication skills
§ Excellent Interpersonal skills
§ Excellent problem-solving skills

Preferred

§ Experience with PowerExchange CDC Real-Time (Oracle and/or Datacom and/or WebServices)
§ Experience with Informatica 8 and above
§ Experience with Informatica Server Administration
§ Experience with integration projects and OLTP (not data warehouse) as the target database

Main responsibilities:

§ source data Analysis and profiling
§ Target database design
§ Source-to-Target mappings
§ Mapping specifications
§ ETL design
§ Develop common objects
§ Develop mappings, mapplets, session, workflows, etc.
§ Document all ETL related code
§ Create and execute unit test plans based on written specifications
§ Troubleshoot, optimize, and tune ETL processes

ELEGIBILITY REQUIREMENTS

Work Status: Must be a US Citizen as required by the Government contracts.
Candidates with CBP Clearance STRONGLY PREFERED and will get the first look.
Candidate must meet security clearance requirements for Customs and Border Protection.
- U.S. Citizenship is required.
- CBP requires that for the three (3) years prior to the filing of an application for employment, individuals must meet the one or more of the following primary residence criteria:
(a) the applicant resided in the United States (short trips abroad, such as vacations, will not necessarily disqualify an applicant); or
(b) the applicant worked for the U.S. Government as an employee overseas in a Federal or military capacity; or
(c) the applicant was a dependent of a U.S. Federal or military employee serving overseas.