Informatica ETL Developer

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.

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.

Qualifications

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

Application Deadline:

Applications will be reviewed as received and accepted on a continuous basis until the position is filled. Early application is strongly encouraged.

Physical Demands and Work Environment

This role primarily involves sedentary work, in a workplace and/or home office environment. There are some physical demands associated with the role, including:

• Extended periods of sitting and working at a computer workstation.
• Occasional lifting and carrying of equipment or materials weighing up to 20 pounds.
• Occasional travel to client sites or meetings may be required.
• Work may need to be performed in a fast-paced environment requiring quick decision making.
• Flexible work arrangements may be available based on business needs.
• Will be exposed to a wide variety of clients in differing functions, personalities, and abilities.

Benefits and Compensation Information
Imagine Believe Realize, LLC (IBR) is focused on delivering software and systems engineering solutions to government and commercial clients. Our talent acquisition strategy is designed for career-minded professionals that value continuous learning and growth. We strive to enhance our team members’ ability to thrive in the workplace by creating a proper work/life balance and first-class benefits package that includes:

• 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

The expected salary range for this position is $95,000 – $130,000 USD annually. This is a good-faith estimate and not a salary guarantee as compensation may vary based on factors such as experience, education, skills, associated role responsibilities, applicable contractual requirements, and geographic location.

Apply Today

If you are ready to grow your career and make an impact, then we encourage you to apply today by submitting an application. We welcome you to explore additional job opportunities listed on our careers page

Applicants who require alternative assistance with the application or interview process may request reasonable accommodations by contacting us using the contact information provided below:

Compliance and Regulatory Statements

Equal Employment Opportunity (EEO) Statement

Imagine Believe Realize, LLC is proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to legally protected characteristics such as race, ethnicity, color, religion, sex, sexual orientation, gender identity, gender expression, creed, age, national origin, disability (including pregnancy, childbirth, or related medical conditions), marital status, veteran status, or any other applicable legally protected class in accordance with federal, state, and local laws.

Affirmative Action

As a federal contractor, Imagine Believe Realize, LLC takes affirmative action to employ and advance in employment qualified minorities, women, protected veterans, and individuals with disabilities.

Individuals with Disabilities

Imagine Believe Realize, LLC is committed to providing equal opportunity to qualified individuals with disabilities and to making reasonable accommodations to enable them to apply for positions and perform their jobs. If you require an accommodation during the application or interview process, please contact Human Resources at View email address on click.appcast.io.

Protected Veterans (VEVRAA)

Imagine Believe Realize, LLC actively seeks to employ and advance qualified protected veterans in compliance with the Vietnam Era Veterans’ Readjustment Assistance Act (VEVRAA).

Pay Transparency Nondiscrimination Provision

Imagine Believe Realize, LLC will not discharge or otherwise discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action (including an investigation conducted by the employer), or (c) consistent with the contractor’s legal duty to furnish information.

Right to Work / Employment Eligibility

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form (Form I-9).