Informatica ETL Developer

Overview

Remote
Depends on Experience
Full Time

Skills

Auditing
CPU
Change Management
Cloud Computing
CompTIA
Database
Database Administration
Databricks
DoD
Enterprise Resource Planning
Extract
Transform
Load
Extraction
IBM Cognos Analytics
Impact Analysis
Informatica
Information Architecture
Information Assurance
Information Security
Management
Mapping
Network+
Optimization
Oracle
Oracle Fusion
PeopleSoft
Production Support
Programming Languages
Provisioning
Python
Quality Control
Recovery
Regulatory Compliance
Release Management
SAP
SQL
Security Clearance
Security+
Software Installation
System Monitoring
Systems Analysis/design
Systems Design
ETL

Job Details

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

 

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

 

  • 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.
  • 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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.