Informatica BI Analyst

iSpace, Inc.; United States; On-site; USD 70,000 - 90,000; Full time

Job summary

A data solutions company in the United States is looking for an experienced ETL Operations Specialist. You will analyze, troubleshoot, and resolve failures in ETL data movement using Informatica or comparable applications. Responsibilities include utilizing workflow monitors to determine failure points, interpreting SQL syntax from various databases, and managing a ticket queue for issue resolution. Experience with cloud data warehouses is a plus.

Qualifications

• Experience with Informatica or similar ETL applications.
• Proficient in SQL syntax across various databases.
• Ability to analyze and troubleshoot data movement failures.

Responsibilities

• Analyze, troubleshoot, and resolve failures in ETL data movement.
• Use workflow monitor to identify failure points and backtrack for analysis.
• Manage ticket queue and resolve or escalate issues.

Skills

ETL Data Movement

SQL interpretation

Troubleshooting

Workflow analysis

Tools

Informatica

ActiveBatch

Cloud data warehouses

Job description

• Informatica or equivalent ETL Application.
• ActiveBatch or Comparable Enterprise Scheduling Application.
• ETL Data Movement in a Production Operation Role - Analyze, troubleshoot and resolve failures.
• Utilize Workflow monitor to determine failure point.
• Backtrack to Workflow Manager to further analyze components of a failed workflow viewed in monitor.
• Interpret workflow/session logs to determine root cause of failure.
• Ability to interpret SQL syntax from various database sources – SQL, Oracle, Netezza, DB2, etc.
• Manage ticket queue and resolve or escalate issues.
• Cloud data warehouse experience is a plus.