ETL Developer - TS/SCI Clearance Required

cFocus Software Incorporated; United States; Remote; USD 90,000 - 120,000; Full time

Job summary

A leading company is seeking an ETL Developer with TS/SCI clearance to support Immigration and Customs Enforcement. This remote position requires expertise in Informatica PowerCenter and programming languages like SQL. The ideal candidate will manage ETL operations, design workflows, and collaborate with teams to optimize data processes.

Qualifications

• 3-5 years of experience with Informatica PowerCenter tools.
• 3-5 years of experience with SQL and PL/SQL.
• Active TS/SCI clearance required.

Responsibilities

• Manage all aspects of Informatica PowerCenter software operations.
• Design new or modified mappings and workflows.
• Collaborate with DBA to implement data partitioning strategies.

Skills

Problem Solving

Communication

Organizational Skills

Education

Bachelor’s degree in Computer Science

Bachelor’s degree in Information Technology

Tools

Informatica PowerCenter

SQL

PL/SQL

Oracle

SQL Server

Job description

ETL Developer - TS/SCI Clearance Required

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 of experience with Informatica PowerCenter tools (workflow manager, workflow monitor, designer)
• 3-5 years of experience with programming languages (SQL, PL/SQL)
• 3-5 years of experience with data platforms (Oracle, SQL Server)
• Problem solver and troubleshooter who thrives in resolving complex problems
• Excellent written and oral communication skills and interpersonal skills
• Superior organizational skills, attention to detail, and ability to prioritize and manage multiple tasks

Duties:

• Manage all aspects of Informatica PowerCenter software operations
• Review data storage and access procedures; update, test, and resolve data issues using Informatica tools
• 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.
• Perform source system analysis as needed
• Collaborate with DBA and ITPM to implement data partitioning strategies in the Enterprise Data Warehouse
• Implement version control for ETL repositories and code
• Develop stored procedures, database triggers, and SQL queries in collaboration with DBA
• Optimize SQL code for performance
• Load data into Fleet H.O.M.E. relational database using Informatica
• Design Informatica scripts, support IT infrastructure and geospatial services, ingest new data sources, deliver data to applications, transform data, manage security for PowerCenter, and troubleshoot configuration issues

Additional Information:

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Business Development and Sales