Informatica Developer (KDSS)

Concept Plus, LLC; United States; Remote; USD 110,000 - 150,000; Full time

Job summary

Concept Plus, LLC is seeking an Informatics Developer to support the USAF Financial platform, developing BI software across development, test, pre-production, and production environments.

The role requires 5+ years in Informatica PowerCenter and Oracle SQL/PL/SQL, with experience in UI/data maintenance via Oracle APEX and WebLogic.

Qualifications

• US Citizen
• Bachelor's degree in computer science, information systems, or related field
• 5+ years of experience with Informatica (PowerCenter)
• 5+ years with Oracle (SQL, PL/SQL, performance tuning)
• Experience with Oracle APEX or similar low-code platforms for UI/data maintenance
• Familiarity with Oracle WebLogic Server and HTTP Server (install, configure, patch)

Responsibilities

• Design and deploy ETL pipelines to feed data warehouses and BI semantic layers.
• Oversee Agile development processes (Scrum ceremonies, backlog management).
• Communicate and resolve data-related problems.
• Extract/load data into enterprise budgeting tools like IBM Planning Analytics or similar.
• Review ICDs and implement security/hardening measures.

Skills

ETL design

Data integration

Agile development

Data warehousing

Education

Bachelor's degree in Computer Science/Information Systems

Tools

Informatica PowerCenter

Oracle

SQL

PL/SQL

Oracle APEX

Oracle WebLogic Server

HTTP Server

Job description

About the role

Concept Plus is seeking an Informatics Developer to provide application system support for the USAF Financial platform. Responsible for developing and deploying all business intelligence system software application development across the development, test, pre-production/integration and production environments.

What you’ll do

Core Technical Skills

• Data Integration & Analytics Architecture:
• • Design and optimize robust ETL pipelines specifically built to feed business-facing data warehouses and universes. This includes downstream BI semantic layers, and aligning Informatica targets to SAP.
• Database Development & Data Warehousing:
• • 5+ years of advanced database development utilizing Oracle (SQL, PL/SQL). Must possess deep expertise in performance tuning, complex SQL optimization, and indexing strategies to ensure Informatica mapping process high volumes efficiently for rapid reporting execution.
• Delivery & Collaboration:
• • Oversee Agile development (Scrum ceremonies, backlog management).
  • Communicate and solve data related problems as necessary.
• Budgeting & Planning Integration:
• • Extract data from or load data into enterprise performance management stacks like IBM Planning Analytics (TM1) or similar enterprise budgeting tools.
• Security & Compliance:
• • Review Interface Control Documents (ICDs) and implement changes.
  • Resolve STIG findings and applying DoW security hardening.

Required Qualifications

• US Citizen
• Bachelor's degree in computer science, information systems, or related field
• 5+ years of experience with Informatica (PowerCenter)
• 5+ years with Oracle (SQL, PL/SQL, performance tuning)
• Experience with Oracle APEX or similar low-code platforms for UI/data maintenance.
• Familiarity with Oracle WebLogic Server and HTTP Server (install, configure, patch).

Preferred Qualifications

• Tuning ETL workflows, database queries, and reporting dashboards
• Implementing monitoring and alerting data pipelines and application services
• Jira, Confluence, Bitbucket (or similar tools)

Concept Plus is an Equal Opportunity Employer. As such, we will give your application full consideration without regard to your race, color, religion, sex, age, national origin, disability, veteran status, sexual orientation, gender identity, or any other classification protected by federal, state, or local law.