Systems Analyst 3

HCL Global Systems Inc.

  • Austin, TX
  • 4 days ago

    Highlights

    Experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment Hands-on experience developing and maintaining ETL workflows using Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations Experience ingesting data from multiple heterogeneous source systems (flat files, APIs, relational databases, mainframe extracts, etc.) 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, including data loading, schema design, and query performance optimization Experience with Informatica Power center / Informatica Cloud Data Integration for cloud-based ETL/ELT development Experience gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications Experience troubleshooting and resolving data quality issues, job failures, and performance bottlenecks in production ETL pipelines Experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Informatica scheduler) supporting batch data loads Experience with SAP Business Objects Universe design and/or maintenance 11

    Numbers & Facts

    LocationAustin, TX

    Description

    Experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment
    Hands-on experience developing and maintaining ETL workflows using Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations
    Experience ingesting data from multiple heterogeneous source systems (flat files, APIs, relational databases, mainframe extracts, etc.) 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, including data loading, schema design, and query performance optimization
    Experience with Informatica Power center / Informatica Cloud Data Integration for cloud-based ETL/ELT development
    Experience gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications
    Experience troubleshooting and resolving data quality issues, job failures, and performance bottlenecks in production ETL pipelines
    Experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Informatica scheduler) supporting batch data loads
    Experience with SAP Business Objects Universe design and/or maintenance 11

    Similar Jobs