Informatica Developer

Concept Plus, LLC; Fairfax (VA); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Health, dental, vision insurance

Paid time off + 11 holidays

Performance bonuses

Tuition reimbursement

Unlimited training

Job summary

Concept Plus is seeking an Informatics Developer to support the USAF Financial platform. You will develop and deploy BI software across development, test, pre-production/integration and production environments.

Core duties include designing ETL pipelines feeding data warehouses, optimizing Oracle SQL/PLSQL, and ensuring security/compliance while working in an Agile setting. Proficiency with Informatica PowerCenter and Oracle APEX is required.

Qualifications

• Bachelor’s degree in computer science, information systems, or related field.
• 5+ years of 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 optimize robust ETL pipelines to feed BI data warehouses and semantic layers.
• Develop and deploy BI software across development, test, pre-production/integration and production environments.
• Oversee Agile development ceremonies and backlog management.
• Communicate and solve data-related problems as necessary.
• Integrate data from ERP and financial systems into budgeting tools where applicable.

Skills

ETL pipelines

Database development

Oracle SQL/PLSQL

Agile development

Security & compliance

Informatica PowerCenter

Oracle APEX / low-code

WebLogic/HTTP Server

BI / data warehousing

Education

Bachelor's degree in CS/IS

Tools

Jira

Confluence

Bitbucket

Job description

About Concept Plus

Concept Plus is a mission-focused technology solutions provider that transforms IT concepts into impactful solutions for federal agencies. Headquartered in Fairfax, VA, we bring the agility, responsiveness, and customer intimacy of a small business combined with the quality and infrastructure of a larger firm.

Recognized as an award-winning Oracle partner, we have delivered innovative solutions across Defense, Intelligence, Civilian, Health IT, and Tribal sectors. Our highly certified experts build systems that drive efficiency, accelerate modernization, and ensure mission outcomes with certainty.

We offer competitive pay, comprehensive health, dental, and vision insurance, paid life insurance, paid time off, 11 paid holidays, performance bonuses, tuition reimbursement, unlimited training, and the opportunity to thrive in a collaborative, flexible, and innovative environment.

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

• 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

• 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.