The Informatica ETL Developer must be able to meet the key criteria below:

Location: 100% remote

Years’ Experience: 5+ years professional experience

Education: Bachelor’s Degree required

Security Clearance: IBR is a federal contractor. Applicants must be able to obtain and maintain a Secret security clearance.

NOTE: United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance.

Employment Type: Full-Time, W2

Key Skills:

• Experience performing Informatica ETL operations and connectors for cloud-based and on-prem ERP systems
• Oracle DBMS experience within large-scale database enterprise systems
• Current CompTIA Network+, CompTIA Security+, CISSP, or higher-level certification as defined by DoD CIO Information Assurance requirements

Position Overview

As an Informatica ETL Developer, 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

• Conversion of the Extract, Transmit, Load (ETL) process from Data Manager to Informatica
• 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.
• 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

• Bachelor’s degree required
• Must be able to obtain a Secret security clearance
• Current CompTIA Network+, CompTIA Security+, CISSP or higher as defined by the DoD CO Information Assurance (IA) certification requirements
• 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.
• 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

Physical Demands and Work Environment

While this position primarily involves sedentary work in an office environment 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 thinking and rapid judgements.
• Additionally, flexible work arrangements may be available based on business needs.
• Employee will be exposed to a wide variety of clients in differing functions, personalities, and abilities.

About IBR
Imagine Believe Realize, LLC (IBR) is an emerging small business focused on delivering software and systems engineering solutions to government and commercial clients. Our talent acquisition strategy is tailored to career seeking candidates who embrace continuous learning and desire to grow as a professional in the software/systems engineering industry. 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
• Flexible spending accounts and Dependent Care spending accounts
• Wellness incentives
• Reimbursement for professional development and certifications
• Training assistance opportunities

Upon hire and in compliance with federal law, all persons hired are required to verify identity and eligibility to work in the United States, and to complete the required employment eligibility verification and background check. IBR is a Federal Contractor.

Imagine Believe Realize, LLC is proud to be an Equal Opportunity and Affirmative Action Employer. We do not discriminate based upon race, age, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.”
Learn more at http://www.teamibr.com

If alternative methods of assistance are needed with the application process, additional contact information has been provided below:

info@teamibr.com
407.459.1830