Informatica ETL Administrator

Location: 100% Remote

Years Experience: 5+ years professional experience

Education: Bachelor s Degree required

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

Clearance: Applicants must be able to obtain and maintain a Secret security clearance.

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

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

• Bachelor s 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