Data Integration Officer

Talent One is seeking a Data Integration Officer to develop monitor and support reliable data interfaces across enterprise systems. The role covers ETL workflows databases APIs file-based integrations data quality and production issue resolution.

Develop test deploy and support ETL and ELT workflows using Informatics PowerCenter and SQL.

Integrate data from Oracle databases enterprise applications APIs SFTP and flat files.

Prepare source-to-target mappings transformation rules interface specifications and support documentation.

Monitor scheduled jobs investigate failures perform root-cause analysis and restore services promptly.

Apply data validation reconciliation logging error-handling and audit controls.

Support production releases data corrections change requests and user acceptance testing.

Maintain interface inventories data lineage operational procedures and incident records.

Coordinate with data engineers application teams vendors analysts and business users.

• Bachelors degree in Computer Science Information Systems Software Engineering or a related discipline.
  
• Minimum 4 years of relevant experience in data integration ETL development or application integration.
  
• Hands-on experience with Informatics PowerCenter workflows mappings sessions and production support.
  
• Strong Oracle SQL and PL SQL skills including query optimisation and troubleshooting.
  
• Experience with APIs JSON or XML SFTP flat files batch processing and incremental data loads.
  
• Knowledge of data quality reconciliation job scheduling version control and incident management.
  
• Strong documentation problem-solving communication and stakeholder coordination skills.
  

REST or SOAP services middleware Apache Airflow dbt Python shell scripting or Power BI.

Cloud data platforms CI CD practices data governance and agile delivery methods.