Offer summary

Qualifications:

Bachelor’s degree in Computer Science, Information Technology, or a related field, Active TS/SCI clearance, 3-5 years of experience with Informatica PowerCenter tools and programming languages like SQL, PL/SQL, Strong problem-solving skills and excellent communication abilities..

Key responsibilities:

Manage Informatica PowerCenter software operations and update data storage procedures.

Design and create ETL mappings, workflows, and technical specifications with the team.

Collaborate with DBA and ITPM to implement data partitioning strategies in the Enterprise Data Warehouse.

Load and transform data for the Fleet H.O.M.E. application while ensuring security management for Informatica PowerCenter.

Job description

cFocus Software seeks an ETL Developer to join our program supporting Immigrations and Customs Enforcement (ICE). This position is remote. This position requires an active TS/SCI clearance.

Qualifications:

Bachelor’s degree in Computer Science, Information Technology, or a related field
Active TS/SCI clearance
3-5 Years Experience with Informatica PowerCenter tools (workflow manager, workflow monitor, designer)
3-5 Years Experience with programming languages (SQL, PL/SQL)
3-5 Years Experience with Data platforms (Oracle, SQL Server)
Problem solver and troubleshooter that thrives in resolving complex problems.
Excellent communications skill (written and oral) and interpersonal skills.
Superior organizational skills, attention to detail, and ability to prioritize and manage multiple tasks.

Duties:

Responsible for all management of Informatica Powercenter Software operations.
Review data storage and access procedures and use Informatica tools to update, test, and provide solutions for data issues.
Responsible for the ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter and prepare corresponding documentation.
Designs and builds integrations supporting standard data warehousing objects within Fleet H.O.M.E.
Performs source system analysis as required.
Works with DBA and ITPM to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.
Implements versioning of the ETL repository and supporting code as necessary.
Participates with DBA in developing stored procedures, database triggers and SQL queries where needed.
Implements best practices and tunes SQL code for optimization with DBA.
Loads data to Fleet H.O.M.E. Relational database using Informatica.
Responsible for Informatica Script Design, 14 Fleet H.O.M.E. IT Infrastructure and Geospatial Support Services, Ingestion of new data sources, Delivery of data to the Fleet H.O.M.E. application, Transformation of data to support data use by the Fleet H.O.M.E. application, Security Management for Informatica PowerCenter, Application configuration issues