Informatica Developer

Location: 100% Remote

Years’ Experience: 5+ years Professional Experience

Education: Bachelor’s Degree Required

Clearance: Applicants must be able to obtain and maintain a secret security clearance. United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance.

Required Certifications:

• Must currently hold an active CompTIA Security+ certification

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.

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

• 5+ years professional experience required.
• Must currently have an active Secret security clearance.
• Must currently hold an active CompTIA Security+ certification.
• Must possess in depth technical experience specifically with Informatica, SQL, and Python, and experience in PowerCenter development.
• Must have experience with ETL development and the creation of technical documentation.
• 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.
• Experience performing code reviews, debugging, performance tuning, and data mapping.
• Prior software development experience is beneficial.
• An 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 is preferred but not required.
• Experience working in Databricks is preferred but not required.