Informatica Developer

Team: IT

Location: US

Commitment: Full-time

Workplace Type: remote

Accountabilities

• Design, develop, and optimize robust ETL pipelines using Informatica PowerCenter to support business-facing data warehouses, BI semantic layers, and reporting environments.

• Develop and maintain complex Oracle database solutions using SQL and PL/SQL, including performance tuning, query optimization, and indexing strategies for high-volume data processing.

• Align Informatica data integration targets with SAP and other enterprise data platforms to support reliable analytics and reporting.

• Develop and deploy business intelligence application software across development, testing, pre-production/integration, and production environments.

• Support Agile development practices, including Scrum ceremonies, backlog management, technical planning, and delivery coordination.

• Extract data from and load data into enterprise performance management and budgeting platforms such as IBM Planning Analytics (TM1) or comparable solutions.

• Review Interface Control Documents (ICDs), implement required changes, and address data integration requirements.

• Resolve security findings and implement required security hardening, including STIG-related remediation.

• Monitor and troubleshoot data pipelines and application services, contributing to reliable and efficient production operations.

• Collaborate with technical and business stakeholders to investigate data-related issues, communicate solutions, and support continuous improvement.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, or a related technical discipline.

• U.S. citizenship is required.

• 5+ years of hands-on experience with Informatica PowerCenter and enterprise data integration.

• 5+ years of advanced Oracle database development experience, including SQL, PL/SQL, performance tuning, complex query optimization, and indexing.

• Experience with Oracle APEX or a comparable low-code platform for user interface and data maintenance.

• Familiarity with Oracle WebLogic Server and Oracle HTTP Server, including installation, configuration, and patching.

• Experience tuning ETL workflows, database queries, and reporting or analytics solutions.

• Knowledge of monitoring and alerting practices for data pipelines and application services.

• Familiarity with Agile development environments and tools such as Jira, Confluence, and Bitbucket or similar platforms.

• Strong analytical and troubleshooting abilities, with the capacity to identify and resolve complex data and integration issues.

• Clear communication skills and the ability to collaborate effectively with technical teams and stakeholders.

• Experience working with security, compliance, and enterprise technology standards is valuable, particularly in regulated or mission-critical environments.

Benefits

• Competitive compensation.

• Comprehensive health, dental, and vision insurance.

• Employer-paid life insurance.

• Paid time off.

• 11 paid holidays.

• Performance bonus opportunities.

• Tuition reimbursement.

• Unlimited training and professional development opportunities.

• Collaborative, flexible, and innovative work environment.

• Remote work opportunity within the United States.

• Opportunity to contribute to technology solutions supporting federal mission environments.