ETL Informatica Developer
Title:ETL Informatica Developer (Job ID: ICE-003-IDRS)Clearance Requirement:This position requires active DHS public trust suitability determination with 6C, or active DoD TS ClearanceDuties and responsibilities (include, but are not limited to the following):Developing, monitoring and execution of ETL processes involving multiple data sources and Oracle tables utilizing millions of rows, by using Informatica PowerCenter 9.5.Providing technical assistance in uploading data, scripting, report development and the movement of records between several database systems as required using extract, transform, and load (ETL) custom scripts on Informatica.Designing, implementing, and maintaining databases with respect to access methods; access time; batch processes; device allocation; validation checks; organization; protection and security; and documentation. This includes maintenance of database dictionaries and integration of systems through database design.Providing technical consulting in the definition, design, and creation of a database environment.Developing and applying procedures for periodic database backup. Assessing and performing research on designated automated intelligence databases for identifying information of interest to the customer; downloading the identified information to an appropriate medium and editing the information into format(s) to be specified by the customer.Creating and configuring databases to meet developer and user requirementsLocation:Washington, DC
Title: ETL Informatica Developer
Salary: None
Description: Title:ETL Informatica Developer (Job ID: ICE-003-IDRS)Clearance Requirement:This position requires active DHS public trust suitability determination with 6C, or active DoD TS ClearanceDuties and responsibilities (include, but are not limited to the following):Developing, monitoring and execution of ETL processes involving multiple data sources and Oracle tables utilizing millions of rows, by using Informatica PowerCenter 9.5.Providing technical assistance in uploading data, scripting, report development and the movement of records between several database systems as required using extract, transform, and load (ETL) custom scripts on Informatica.Designing, implementing, and maintaining databases with respect to access methods; access time; batch processes; device allocation; validation checks; organization; protection and security; and documentation. This includes maintenance of database dictionaries and integration of systems through database design.Providing technical consulting in the definition, design, and creation of a database environment.Developing and applying procedures for periodic database backup. Assessing and performing research on designated automated intelligence databases for identifying information of interest to the customer; downloading the identified information to an appropriate medium and editing the information into format(s) to be specified by the customer.Creating and configuring databases to meet developer and user requirementsLocation:Washington, DC
Requirements: Mid-Senior level experience, Bachelor's Degree education
Fraudulent: No