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. Lets 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: Bachelors Degree required

Security Clearance: A current and 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 support the Manpower Analytics and Human Resources Systems (MAHRS) program that is in support of the United States Navy. As part of the program you will assist in overseeing developing and maintaining policy for the HR system and data operations. MAHRS develops delivers and sustains Human Capital business analytics and tools to improve and support data-driven decision making.

Responsibilities

• Deploy Upgrade Operate Manage and Support of Informatica environments
• 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
• 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 backend 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

• Bachelors degree required
• Must be able to obtain a Secret security clearance
• Must currently holdan active CompTIA Security certification
• Must possess in depth technical experience specifically with Informatica SQL and Python.
  • Experience in PowerCenter development
• Involvement in code reviews debugging performance tuning data mapping
• Experience with ETL development and the creation of technical documentation.
• Prior software development experience desired
• 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.
• 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 $95000 $125000 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 who require alternative assistance with the application or interview process may request reasonable accommodations by contacting us using the contact information provided below:


407.459.1830

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 .

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 contractors 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).