[Hiring] Informatica ETL Developer @IBR

Role Description

As an Informatica ETL Developer at IBR, you will play a key role in designing and implementing secure, next-generation solutions that support critical missions. You will collaborate with technical leaders, business stakeholders, and a multi-disciplinary team to ensure solutions are scalable, secure, and forward-thinking, while remaining aligned with organizational and program goals.

• Assist in overseeing, developing, and maintaining policy for the HR system and data operations.
• Contribute to technical strategy within a dynamic, mission-driven, and customer-focused environment.

Qualifications

• 5+ years professional experience required.
• Must currently have an active Secret security clearance.
• Must currently hold an active CompTIA Security+ certification.
• In-depth technical experience specifically with Informatica, SQL, and Python.
• Experience in PowerCenter development.
• Experience with ETL development and the creation of technical documentation.
• Experience performing Informatica ETL operations and connectors for cloud-based and on-prem ERP systems such as SAP, Oracle, Fusion Cloud, and PeopleSoft.
• Oracle Database experience within large-scale database enterprise systems.
• Experienced in supporting ETL data migration.
• Experience performing code reviews, debugging, performance tuning, and data mapping.
• Prior software development experience beneficial.
• An understanding of data warehousing concepts.
• Knowledge of configuration, deployments, and troubleshooting.
• Knowledge of Oracle database provisioning, cloning, and patching techniques.
• Experience with Cognos BI preferred but not required.
• Data mapping and transformation experience preferred but not required.
• Experience working in Databricks preferred but not required.

Requirements

• Location: 100% remote. Candidates must reside in the continental United States.
• Years’ Experience: 5+ years professional experience.
• Education: Bachelor’s Degree required.
• Security Clearance: An active Secret security clearance is required.
• Employment Type: Full Time.
• Work Schedules: Flexible scheduling options aligned to Eastern Time Zone.

Responsibilities

• Conversion of the Extract, Transmit, Load (ETL) process from Data Manager to Informatica.
• Designing, developing, and maintaining ETL processes to facilitate data integration and transformation.
• Deploy, Upgrade, Operate, Manage, and Support of Informatica environments.
• Perform Tuning, Optimization, Troubleshooting, and Daily Monitoring of the database.
• Monitor daily extract generation from an Oracle database and address issues independently.
• Analyze, develop, test, and maintain data ETL extraction procedures utilizing Informatica.
• Perform and support Informatica ETL application installation, configuration, updates, and patches.
• Design, develop, and maintain Informatica ETL PowerCenter scripts.
• Analyze, design, develop, and maintain Informatica ETL power scripts.
• Build robust ETL pipelines.
• Optimize data workflows and SQL queries.
• Pull required data from the Oracle HCM Cloud using the Oracle BI tool.
• Involvement in code reviews, debugging, performance tuning, data mapping.
• Translate business requirements and database administration operational requirements into long-term architecture solutions.
• Ensure that data is accurately and securely extracted, transformed, and loaded into database system for analysis and reporting.
• Design, build, and maintain structure (e.g. relational) and unstructured databases within a multiple tier environment.
• Analyzing performance issues, diagnosing/resolving affecting database systems.
• Perform data access analysis design, and archive/recovery design and implementation.
• Maintaining database configurations in compliance with release management, change management, and office of information security requirements.
• Perform daily activities like production support and continuous database monitoring.
• Applies knowledge and experience with database technologies, development methodologies, and frontend (e.g. COGNOS) and back-end programming languages (e.g. SQL).
• Conducts quality control and auditing databases in a multiple-tier environment to ensure accurate and appropriate use of data.

Benefits

• Nationwide medical, dental, and vision insurance.
• 3 weeks of Paid Time Off and 11 Paid Federal Holidays.
• 401k matching.
• Life Insurance, Short-Term Disability, and Long-Term Disability at no cost to employees.
• Supplemental insurance options.
• Flexible spending accounts and Dependent Care spending accounts.
• Wellness incentives.
• Reimbursement for professional development and certifications.
• Access to training assistance opportunities to support career growth and progression.
• Hybrid and Remote work opportunities to support work-life balance.