Data Pipeline Specialist

Remote: 
Full Remote
Contract: 
Work from: 

Offer summary

Qualifications:

Strong hands-on experience with Informatica PowerCenter and Microsoft SQL Server is mandatory., 3+ years of experience in roles supporting data pipelines or ETL environments is required., Familiarity with BMC Control-M, ServiceNow, Azure DevOps, and Azure File Storage is preferred., English proficiency for effective communication within the team..

Key responsibilities:

  • Monitor data pipelines and identify failures using BMC Control-M.
  • Troubleshoot and resolve issues in data ingestion from various sources including IBM DB2 and SQL Server.
  • Manage outbound data feeds to Azure File Shares and external services.
  • Document incidents and solutions using ServiceNow and collaborate with internal teams to ensure data flow.

Rivka Development logo
Rivka Development SME http://www.rivkadevelopment.com/
51 - 200 Employees
See all jobs

Job description

Remote Candidates located in Spain or Mexico only
Full-time | Remote

About the Role:

We are looking for a Data Pipeline Support Engineer to join our team and play a key role in supporting and maintaining critical data pipelines for a large-scale data environment. The ideal candidate is highly skilled in Informatica PowerCenter, SQL Server, and has a strong troubleshooting mindset. You will monitor, identify, and resolve failures across ETL processes, data ingestion, and transformation pipelines.

This is a 100% remote position, open exclusively to candidates located in Spain or Mexico.

Key Responsibilities:

  • Monitor data pipelines and identify failures using BMC Control-M.

  • Troubleshoot and resolve issues in data ingestion from IBM DB2, SQL Server, and Azure File Shares.
  • Resolve errors in transformation pipelines managed via Informatica PowerCenter and SQL Server.
  • Manage outbound data feeds to Azure File Shares (CSV/XLSX) and external services like CLEO Harmony, IVANS Connect, and SMTP.
  • Profile and query data using SQL to address data quality issues.

  • Deploy changes to Informatica and SQL components using Git and Azure DevOps pipelines.
  • Document incidents and solutions using ServiceNow.

  • Collaborate with internal teams to ensure consistent data flow and performance.

Required Skills:
  • Strong hands-on experience with Informatica PowerCenter (mandatory).
  • Proficient in Microsoft SQL Server (mandatory).

  • Experience monitoring jobs with BMC Control-M (preferred).

  • Familiarity with ServiceNow, Azure DevOps, and Azure File Storage (preferred).
  • Understanding of FTP, SMTP, and data exchange protocols.

  • Knowledge of IBM DB2 is a plus.

  • Strong analytical skills and experience in data troubleshooting.

  • Ability to work independently and manage tasks in a remote environment.


Requirements:
  • Reside in Spain or Mexico.

  • English proficiency (written and spoken) for team communication.

  • 3+ years of experience in similar roles supporting data pipelines or ETL environments.
  • Availability to work within European or North American time zone

Required profile

Experience

Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Troubleshooting (Problem Solving)
  • Analytical Skills

Related jobs