Position Details

Salary $90K – $130K USD / year

Type Full-Time

Experience senior

Exp. Years 5+ years

Education Bachelor’s Degree required

Category Data & Analytics

About this role

Informatica ETL Developer for the MAHRS program, responsible for designing, developing, and maintaining secure ETL processes and Informatica environments for HR analytics.

Key Responsibilities

Convert ETL from Data Manager to Informatica
Design, develop, and maintain ETL processes
Deploy, Upgrade, Operate, Manage, and Support Informatica environments
Monitor, tune, and optimize Oracle database
Pull data from Oracle HCM Cloud using Oracle BI tool

Technical Overview

Focus on Informatica ETL development, PowerCenter, Oracle DB, SQL, Python; migrating ETL from Data Manager; integration with Oracle HCM Cloud and BI tools; security-compliant data operations.

Ideal Candidate

The ideal candidate is a senior Informatica ETL Developer with 5+ years of experience, holding an active Secret clearance and CompTIA Security+ certification, proficient in Informatica, SQL, Python, and Oracle databases, with experience integrating cloud-based and on-prem ERP systems.

Must-Have Skills

5+ years professional experienceActive Secret security clearanceActive CompTIA Security+ certificationInformatica ETL developmentOracle Database experienceSQLPythonETL developmentExperience with ETL Operations and connectors for cloud-based and on-prem ERP systemsData migration experience

Nice-to-Have Skills

Cognos BI experienceDatabricks experienceCognos BI preferredDatabricks preferred

Tools & Platforms

InformaticaPowerCenterOracle DatabaseOracle BICognos BIDatabricksOracle HCM CloudSAPFusion CloudPeopleSoft

Required Skills

Informatica ETLInformatica PowerCenterOracle DatabaseOracle DBMSSQLPythonETL developmentData migrationData integrationCognos BIOracle BIDatabricks

Hard Skills

Informatica ETLInformatica PowerCenterOracle DatabaseOracle DBMSSQLPythonCognos BIOracle BIETLData warehousingData migrationData integrationCloud-based ERP connectorsSAPFusion CloudPeopleSoftDatabricks

Soft Skills

collaborationcommunicationanalytical thinkingproblem solvingteamworkadaptabilitystakeholder communicationdocumentation

Certifications

Required

CompTIA Security+

Industry & Role

Industry Government/Public Sector

Job Function Design, develop, and maintain secure Informatica ETL pipelines for HR analytics

Role Subtype ETL Developer

Keywords for Your Resume

Informatica ETLInformatica PowerCenterETLOracle DatabaseOracle DBMSSQLPythonCompTIA Security+Active Secret security clearanceERP connectorsSAPFusion CloudPeopleSoftCognos BIOracle BIDatabricksData warehousingData migrationData integrationETL operations

Deal Breakers

No active Secret clearance, No CompTIA Security+ certification, Less than 5 years of experience, No Bachelor's degree, Not authorized to work in the United States

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile

Informatica Developer

Get matched to jobs like this