Назад
Company hidden
6 дней назад

Systems Analyst 1785 (Informatica ETL/Data Engineering)

Формат работы
hybrid
Тип работы
fulltime
Грейд
senior
Английский
b2
Страна
US
Релокация
US
Вакансия из списка Hirify.GlobalВакансия из Hirify Global, списка международных tech-компаний
Для мэтча и отклика нужен Plus

Мэтч & Сопровод

Для мэтча с этой вакансией нужен Plus

Описание вакансии

Текст:
/
TL;DR
Systems Analyst 1785 (Informatica ETL/Data Engineering): Designing, developing, and supporting enterprise data integration solutions with an accent on Informatica PowerCenter, Oracle SQL/PLSQL, Snowflake, and heterogeneous data ingestion. Focus on source-to-target mapping, data quality management, ETL performance optimization, production troubleshooting, and batch job orchestration.

Location: Hybrid in Austin, Texas; 2 days remote and 3 days onsite each week on Monday, Wednesday, and Friday. Candidates must be local to Austin or willing to relocate.

Company

hirify.global is a Texas-based IT staffing and IT delivery firm serving Texas state and local government agencies since 2002.

What you will do

  • Analyze business objectives, user requirements, operational procedures, and system problems to identify automation and improvement opportunities.
  • Evaluate alternative solutions, system capabilities, specifications, scheduling limitations, and cost-benefit considerations.
  • Design, develop, maintain, and support enterprise data integration solutions and ETL workflows.
  • Ingest data from heterogeneous sources into Oracle databases and support Snowflake data loading and schema design.
  • Troubleshoot data quality issues, job failures, and performance bottlenecks in production pipelines.
  • Collaborate with business and technical stakeholders in structured SDLC and change management environments.

Requirements

  • 8+ years of experience as a Data Engineer or Systems Analyst designing, developing, and supporting enterprise data integration solutions.
  • 8+ years of hands-on experience developing and maintaining Informatica PowerCenter ETL workflows, including mappings, sessions, workflows, and reusable transformations.
  • 8+ years of experience ingesting data from flat files, APIs, relational databases, mainframe extracts, and other heterogeneous sources into Oracle databases.
  • Strong working knowledge of Oracle SQL/PL/SQL, including stored procedures, packages, and performance tuning of ETL-related queries.
  • Experience with Snowflake data loading, schema design, and query performance optimization.
  • Experience with Informatica PowerCenter or Informatica Cloud Data Integration for cloud-based ETL/ELT development.
  • Experience gathering data requirements, creating source-to-target mappings, and documenting data flows and design specifications.
  • Experience resolving data quality issues, production job failures, and ETL performance bottlenecks.
  • Experience with batch job scheduling and orchestration tools such as Control-M, Autosys, or the Informatica scheduler.

Nice to have

  • 3+ years of experience designing or maintaining SAP Business Objects Universes.
  • 3+ years of experience in a state government or large enterprise IT environment using formal SDLC and change management processes.

Culture & Benefits

  • 1-year position supporting a government client in Austin, Texas.
  • Competitive compensation and benefits.
  • Professional growth, career support, and consultant well-being are emphasized.
  • Hybrid schedule with fixed onsite attendance three days per week.

Будьте осторожны

Если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →