We use essential cookies

Please Accept our Privacy Policy

Senior Informatica ETL/Data Engineer

Siritech Solutions Corp

Austin, TX • 10/28/2026

Job Description

Job Description
\n\n
\n

Senior Informatica ETL/Data Engineer (PowerCenter, Snowflake & Oracle)

Total Required Experience in Years:12+ Years\n

Mode of Work:Hybrid 3 Days Onsite / 2 Days Remote | Must Currently Reside Within 50 Miles of Austin, TX

\n
\n

The Senior Informatica ETL/Data Engineer will design, develop, implement, and support enterprise data-integration solutions using Informatica PowerCenter, Informatica Cloud Data Integration, Oracle SQL/PL-SQL, and Snowflake.

\n

The role requires extensive hands-on experience developing ETL/ELT workflows, mappings, sessions, transformations, data-ingestion pipelines, and batch-processing solutions. The engineer will also troubleshoot production pipelines, resolve data-quality and performance issues, and work with business and technical stakeholders throughout the SDLC.

Key Responsibilities:\n
    \n
  • \n

    Design, develop, and support enterprise ETL/ELT solutions.

  • \n
  • \n

    Develop Informatica PowerCenter mappings, sessions, workflows, and reusable transformations.

  • \n
  • \n

    Develop cloud-based integrations using Informatica Cloud Data Integration.

  • \n
  • \n

    Ingest data from heterogeneous source systems.

  • \n
  • \n

    Integrate flat files, APIs, relational databases, and mainframe extracts.

  • \n
  • \n

    Load and transform enterprise data into Oracle and Snowflake environments.

  • \n
  • \n

    Develop complex Oracle SQL and PL/SQL.

  • \n
  • \n

    Develop and maintain Oracle stored procedures and packages.

  • \n
  • \n

    Perform ETL-related SQL and database performance tuning.

  • \n
  • \n

    Develop Snowflake data-loading processes.

  • \n
  • \n

    Support Snowflake schema design and query optimization.

  • \n
  • \n

    Gather and analyze business and data requirements.

  • \n
  • \n

    Develop source-to-target mappings and data-flow specifications.

  • \n
  • \n

    Troubleshoot production ETL pipelines and job failures.

  • \n
Additional Responsibilities:\n
    \n
  • \n

    Identify and resolve data-quality issues.

  • \n
  • \n

    Diagnose and resolve ETL performance bottlenecks.

  • \n
  • \n

    Optimize mappings, workflows, SQL queries, and batch processes.

  • \n
  • \n

    Support job scheduling and orchestration.

  • \n
  • \n

    Monitor scheduled enterprise batch loads.

  • \n
  • \n

    Analyze existing systems and identify data-processing improvements.

  • \n
  • \n

    Develop technical and data-flow documentation.

  • \n
  • \n

    Support production deployments and change-management activities.

  • \n
  • \n

    Work within formal SDLC processes.

  • \n
  • \n

    Collaborate with business analysts, database teams, application teams, and technical stakeholders.

  • \n
  • \n

    Support SAP BusinessObjects Universe design or maintenance where applicable.

  • \n
Required Skills:\n
    \n
  • \n

    Minimum 8+ years as a Data Engineer/Systems Analyst designing, developing, and supporting enterprise data-integration solutions.

  • \n
  • \n

    Minimum 8+ years of hands-on Informatica PowerCenter experience.

  • \n
  • \n

    Strong experience developing:

    \n
      \n
    • \n

      Mappings

    • \n
    • \n

      Sessions

    • \n
    • \n

      Workflows

    • \n
    • \n

      Reusable Transformations

    • \n
  • \n
  • \n

    Minimum 8+ years ingesting data from heterogeneous sources, including:

    \n
      \n
    • \n

      Flat Files

    • \n
    • \n

      APIs

    • \n
    • \n

      Relational Databases

    • \n
    • \n

      Mainframe Extracts

    • \n
  • \n
  • \n

    Minimum 8+ years of strong Oracle SQL/PL-SQL experience.

  • \n
  • \n

    Experience developing Oracle stored procedures and packages.

  • \n
  • \n

    Experience tuning ETL-related Oracle queries.

  • \n
  • \n

    Minimum 8+ years of Snowflake experience, including data loading, schema design, and query-performance optimization.

  • \n
  • \n

    Minimum 8+ years with Informatica PowerCenter and/or Informatica Cloud Data Integration for cloud ETL/ELT.

  • \n
  • \n

    Minimum 8+ years gathering data requirements and performing source-to-target mapping.

  • \n
  • \n

    Experience documenting data-flow and design specifications.

  • \n
  • \n

    Minimum 8+ years troubleshooting data-quality issues, ETL job failures, and performance bottlenecks.

  • \n
  • \n

    Minimum 8+ years using batch scheduling/orchestration tools such as:

    \n
      \n
    • \n

      Control-M

    • \n
    • \n

      AutoSys

    • \n
    • \n

      Informatica Scheduler

    • \n
  • \n
Preferred Skills:\n
    \n
  • \n

    Minimum 3+ years of SAP BusinessObjects Universe design and/or maintenance experience.

  • \n
  • \n

    Minimum 3+ years working within a state-government or large enterprise IT environment.

  • \n
  • \n

    Experience following formal SDLC processes.

  • \n
  • \n

    Experience with enterprise change-management processes.

  • \n
  • \n

    Large-scale data migration and integration experience.

  • \n
  • \n

    Cloud-based ETL/ELT implementation experience.

  • \n
  • \n

    Enterprise data-quality and production-support experience.

  • \n
Qualifications:\n
    \n
  • \n

    Strong hands-on Informatica development expertise.

  • \n
  • \n

    Strong Oracle SQL/PL-SQL and Snowflake capabilities.

  • \n
  • \n

    Strong understanding of ETL/ELT architecture and data-integration patterns.

  • \n
  • \n

    Strong troubleshooting and root-cause-analysis skills.

  • \n
  • \n

    Ability to optimize complex data-processing pipelines.

  • \n
  • \n

    Strong analytical and problem-solving capabilities.

  • \n
  • \n

    Strong technical documentation skills.

  • \n
  • \n

    Ability to translate business requirements into technical data solutions.

  • \n
  • \n

    Strong written and verbal communication skills.

  • \n
  • \n

    Ability to work effectively with business and technical stakeholders.

  • \n
  • \n

    Must currently reside within a 50-mile radius of Austin, TX.

  • \n
  • \n

    Must be willing to work 3 days onsite and 2 days remotely.

  • \n
  • \n

    Work arrangement is subject to change.

  • \n
Education:\n
    \n
  • \n

    Education requirements were not specified in the provided requirement.

  • \n
Certifications:\n
    \n
  • \n

    Informatica PowerCenter Certification Preferred

  • \n
  • \n

    Informatica Cloud Data Integration Certification Preferred

  • \n
  • \n

    Snowflake SnowPro Certification Preferred

  • \n
  • \n

    Oracle Database / PL-SQL Certification Preferred

  • \n
\n