Informatica BI Analyst

iSpace, Inc.

United States

On-site

USD 70,000 - 90,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL Production Support Engineer
ETL Production Support Engineer

Jobsbridge • San Ramon (CA)

On-site
USD 100,000 - 130,000
Production ETL & Workflow Analysis Specialist
Production ETL & Workflow Analysis Specialist

iSpace, Inc. • United States

On-site
USD 70,000 - 90,000
ETL Production Support
ETL Production Support

Tata Consultancy Services Limited • Charlotte (NC)

On-site
USD 100,000 - 120,000
ETL Developer
ETL Developer

Laurus Technologies LLC • Tracy (CA)

On-site
USD 90,000 - 130,000
Informatica Production Support Engineer
Informatica Production Support Engineer

Eitacies Inc • Phoenix (AZ)

On-site
USD 85,000 - 110,000
ETL Informatica Developer
ETL Informatica Developer

Envision Technology Solutions • Plano (TX)

On-site
USD 85,000 - 120,000
Informatica Production Support Engineer
Informatica Production Support Engineer

EITACIES Inc. • Phoenix (AZ)

On-site
USD 90,000 - 120,000
401(k)
ETL Informatica/Hadoop Developer
ETL Informatica/Hadoop Developer

Envision Technology Solutions • Plano (TX)

On-site
USD 90,000 - 150,000
ETL Production Support Engineer
ETL Production Support Engineer

TechDigital Group • Holmdel Township (NJ)

On-site
USD 90,000 - 130,000
ETL Production Support Engineer
ETL Production Support Engineer

Compunnel Inc. • Smithfield (RI)

On-site
USD 80,000 - 100,000