ETL Developer - TS/SCI Clearance Required

cFocus Software Incorporated; United States; Remote; USD 80,000 - 110,000; Full time

Job summary

An innovative firm is seeking an ETL Developer to support critical operations for Immigration and Customs Enforcement. This remote position requires a Bachelor’s degree in Computer Science or a related field, along with an active TS/SCI clearance. The ideal candidate will have 3-5 years of experience with Informatica PowerCenter and strong skills in SQL and PL/SQL. You will manage ETL processes, design mappings, and collaborate closely with database administrators to optimize data workflows. Join a team dedicated to enhancing data management and operational efficiency in a dynamic environment.

Qualifications

• 3-5 years experience with Informatica PowerCenter tools.
• Active TS/SCI clearance required.
• Strong problem-solving and communication skills.

Responsibilities

• Manage operations of Informatica PowerCenter software.
• Design and build ETL mappings and workflows.
• Collaborate with DBA to plan data partitioning strategies.

Skills

Informatica PowerCenter

SQL

PL/SQL

Oracle

SQL Server

Problem Solving

Communication Skills

Organizational Skills

Education

Bachelor’s degree in Computer Science

Bachelor’s degree in Information Technology

Related field

Tools

Informatica PowerCenter

Job description

cFocus Software ETL Developer Position

cFocus Software seeks an ETL Developer to join our program supporting Immigration and Customs Enforcement (ICE). This position is remote and 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 who thrives in resolving complex problems
• Excellent communication skills (written and oral) and interpersonal skills
• Superior organizational skills, attention to detail, and ability to prioritize and manage multiple tasks

Duties:

• Manage all operations of Informatica PowerCenter software
• Review data storage and access procedures; use Informatica tools to update, test, and resolve data issues
• Design new or modified mappings and workflows; prepare technical specifications
• Create ETL mappings, mapplets, workflows, and worklets using Informatica PowerCenter; document processes
• Design and build integrations supporting data warehousing objects within Fleet H.O.M.E.
• Conduct source system analysis as required
• Collaborate with DBA and ITPM to plan data partitioning strategies in the Enterprise Data Warehouse
• Implement version control for ETL repositories and supporting code
• Assist DBA in developing stored procedures, triggers, and SQL queries
• Optimize SQL code and implement best practices
• Load data into Fleet H.O.M.E. relational database using Informatica
• Design Informatica scripts, support services, ingest new data sources, deliver data to the application, transform data, and manage security and configuration issues