Informatica ETL Administrator
Informatica ETL Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
The Informatica ETL Administrator must be able to meet the key criteria below:
Location: 100% remote
Years Experience: 5 years professional experience
Education: Bachelors 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 or ability to obtain either CompTIA Network CompTIA Security or higher-level certification as defined by DoD CIO Information Assurance requirements
Position Overview
As an Informatica ETL Administrator 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
- 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 power center scripts
- Analyze design develop and maintain Informatica ETL power scripts
- 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.
- Apply patches like Critical Patch Updates (CPU) Patch Set Updates (PSU) and One-Off Patches Interim patches DST and Patch sets.
- 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.
- Implement database environments refresh using data pump
- Translate business requirements and database administration operational requirements into long-term architecture solutions.
- Performs all activities related to the administration of computerized databases.
- 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
- Current Network Security or higher as defined by the DoD CO Information Assurance (IA) certification requirements
- 5 years of experience performing Informatica ETL Operations and connectors for cloud-based and on-prem ERP systems such as SAP Oracle Fusion Cloud and PeopleSoft
- 5 years of Oracle Database experience within large-scale database enterprise systems monitoring the database daily and addressing issues independently
- Must possess in depth technical experience specifically with Informatica SQL and Python.
- 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
If alternative methods of assistance are needed with the application process additional contact information has been provided below:
407.459.1830
Required Experience:
Unclear Seniority
Employment Type
Full-Time
