This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
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
Requirements:
5+ years professional experience
Bachelor’s Degree Required
Must be able to obtain and maintain a secret security clearance
United States Citizenship required
Must currently hold an active CompTIA Security+ certification
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
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
An understanding of data warehousing concepts
Knowledge of configuration, deployments and troubleshooting
Knowledge of Oracle database provisioning, cloning and patching techniques
Nice to have:
Prior software development experience is beneficial
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