Informatica ETL Developer

IBR•Rockledge, FL

5h•$95,000 - $130,000•Remote

About The Position

At Imagine Believe Realize, LLC we are driven by innovation, transformation and a relentless pursuit of excellence. As an industry leader delivering impactful results, we thrive on solving complex technical challenges and developing cutting-edge solutions that empower our customers and advance critical missions. IBR is a fast-growing company fueled by passion, curiosity, and innovative thinking – where every team member has the opportunity to continuously learn, unlock their full potential, and redefine what is possible in engineering and technology. If you are inspired by innovation, eager to make a difference, and ready to bring your creativity and expertise to a mission-focused team, we invite you to join us and together, we will shape the future. Let’s Make It Real! The Informatica ETL Developer must be able to meet the key criteria below: Location: 100% remote. This is a United States based position, and candidates must reside in the continental United States to be eligible for employment. 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: IBR promotes work-life balance by offering flexible scheduling options. Standard business hours are aligned to the Eastern Time Zone. Key Skills: Experience performing Informatica ETL operations and connectors for cloud-based and on-prem ERP systems Informatica Development experience required Oracle DBMS experience within large-scale database enterprise systems Must currently hold an active CompTIA Security+ certification Position Overview 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. As a member of our Manpower, Analytics, and Human Resources Systems (MAHRS) program, 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. As an Informatica ETL Developer, you will assist in overseeing, developing, and maintaining policy for the HR system and data operations. The MAHRS program develops, delivers, and sustains Human Capital business analytics and tools to improve and support data-driven decision making. This position offers the opportunity to contribute to technical strategy within a dynamic, mission-driven, and customer focused environment.

Requirements

5+ years professional experience required
Must currently have an active Secret security clearance
Must currently hold an active CompTIA Security+ certification
Must possess in depth technical experience specifically with Informatica, SQL, and Python, and experience in PowerCenter development.
Must have 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 monitoring the database daily and addressing issues independently.
Experienced in supporting ETL data migration.
Experience performing code reviews, debugging, performance tuning, and data mapping.

Nice To Haves

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.

Responsibilities

Conversion of the Extract, Transmit, Load (ETL) process from Data Manager to Informatica
Responsible for 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 and feeding the ETL process the files to be converted into data for existing reports.
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.
Designs, builds, and maintains structure (e.g. relational) and unstructured databases within a multiple tier environment.
Analyzing performance issues, diagnosing/resolving affecting database systems.
Performs 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).
Performs database programming and supports systems design.
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 our 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