Informatica and Snowflake Data Engineer

The ideal candidate brings strong Informatica PowerCenter and Oracle SQL/PL-SQL expertise, along with hands-on Snowflake experience, and is comfortable collaborating with business and technical stakeholders in structured SDLC environments. This role involves building and maintaining ETL workflows, ingesting data from diverse source systems, and optimizing performance across large-scale data pipelines.

Benefits:

• Competitive salary

Location
Hybrid in Austin, TX

Experience Level
Senior Level (8+ years of experience).

Role Overview
We are seeking an experienced Informatica ETL/Data Engineer to design, develop, and support enterprise data integration solutions. This role involves building and maintaining ETL workflows, ingesting data from diverse source systems, and optimizing performance across large-scale data pipelines. The ideal candidate brings strong Informatica PowerCenter and Oracle SQL/PL-SQL expertise, along with hands-on Snowflake experience, and is comfortable collaborating with business and technical stakeholders in structured SDLC environments.

Key Responsibilities

ETL Development & Data Integration

• Develop and maintain ETL workflows using Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations.
• Ingest data from multiple heterogeneous source systems, including flat files, APIs, relational databases, and mainframe extracts, into Oracle databases.
• Develop and support cloud-based ETL/ELT solutions using Informatica Cloud Data Integration.

 Database & Performance Optimization

• Write and optimize Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning of ETL-related queries.
• Load data into Snowflake and support schema design and query performance optimization.
• Troubleshoot and resolve data quality issues, job failures, and performance bottlenecks in production ETL pipelines.

 Requirements & Design Documentation

• Gather data requirements and perform source-to-target mapping.
• Document data flow and design specifications.
• Analyze user requirements and operational procedures to identify opportunities for automation or system improvement.

 Operations & Collaboration

• Support batch data loads using job scheduling/orchestration tools such as Control-M, Autosys, or the Informatica scheduler.
• Collaborate with business and technical stakeholders to deliver scalable data engineering solutions.
• Confer with organizational units to analyze current procedures and define input/output and reporting requirements.

 Required Qualifications

• 8+ years of experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment.
• 8+ years of hands-on experience developing and maintaining ETL workflows using Informatica PowerCenter.
• 8+ years of experience ingesting data from multiple heterogeneous source systems into Oracle databases.
• 8+ years of strong working knowledge of Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning.
• 8+ years of experience with Snowflake, including data loading, schema design, and query performance optimization.
• 8+ years of experience with Informatica PowerCenter/Informatica Cloud Data Integration for cloud-based ETL/ELT development.
• 8+ years of experience gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications.
• 8+ years of experience troubleshooting data quality issues, job failures, and performance bottlenecks in production ETL pipelines.
• 8+ years of experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Informatica scheduler) supporting batch data loads.

 Preferred Qualifications

• Experience with SAP Business Objects Universe design and/or maintenance.
• Experience working in a state government or large enterprise IT environment, following formal SDLC and change management processes.

 Core Skills & Attributes

• Strong analytical and problem-solving skills with a detail-oriented approach to data engineering.
• Excellent written and verbal communication skills for engaging business and technical stakeholders.
• Comfortable working within structured SDLC environments and formal change management processes.
• Strong troubleshooting mindset for production support and performance optimization.
• Collaborative and adaptable, able to work effectively across business and technical teams.