ETL Developer - TS/SCI Clearance Required

cFocus Software Incorporated; Mississippi; Remote; USD 80,000 - 100,000; Full time

Job summary

A leading company is seeking an ETL Developer to support Immigration and Customs Enforcement. This remote position requires an active TS/SCI clearance and involves managing Informatica PowerCenter operations, creating ETL mappings, and collaborating on data strategies. Ideal candidates will have a Bachelor’s degree in Computer Science or IT, along with 3-5 years of relevant experience.

Qualifications

• 3-5 years experience with Informatica PowerCenter tools.
• 3-5 years experience with SQL and PL/SQL programming languages.

Responsibilities

• Manage operations of Informatica PowerCenter software.
• Create ETL mappings and workflows using Informatica PowerCenter.
• Collaborate with DBA to implement data partitioning strategies.

Skills

Problem Solving

Communication

Education

Bachelor’s degree in Computer Science

Bachelor’s degree in Information Technology

Tools

Informatica PowerCenter

SQL

PL/SQL

Oracle

SQL Server

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 that 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 modify existing 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 needed
• Collaborate with DBA and ITPM to plan and implement 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, transform data, and manage security for Informatica PowerCenter