Informatica and Snowflake Data Engineer

SMART TECH SKILLS LLC is hiring a Senior Informatica and Snowflake Data Engineer to design, build, and support enterprise data integration solutions. This hybrid role in Tallahassee, FL focuses on Informatica-based ETL/ELT development, Oracle SQL/PL-SQL performance tuning, Snowflake data loading and optimization, and hands-on production support for critical pipelines.

Role Overview

You will own ETL workflow development and maintenance using Informatica PowerCenter and Informatica Cloud Data Integration, while also delivering Oracle-based ingestion and query optimization. The work includes coordinating source-to-target mappings, documenting data flow and design specifications, and improving reliability and performance in production environments.

Responsibilities

• Develop and maintain ETL workflows in Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations.
• Ingest data from multiple heterogeneous sources (flat files, APIs, relational databases, and mainframe extracts) into Oracle databases.
• Develop and support cloud-based ETL/ELT solutions using Informatica Cloud Data Integration.
• Write and optimize Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning for ETL-related queries.
• Load data into Snowflake, including support for schema design and query performance optimization.
• Troubleshoot and resolve data quality issues, job failures, and performance bottlenecks in production ETL pipelines.
• Gather data requirements, perform source-to-target mapping, and document data flow and design specifications.
• Analyze user requirements and operational procedures to identify opportunities for automation or system improvement.
• Support batch data loads using 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.

Requirements

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

Technologies

• Informatica PowerCenter
• Oracle SQL/PL-SQL
• Oracle databases
• Snowflake
• Informatica Cloud Data Integration
• Control-M
• Autosys
• Informatica scheduler
• SAP Business Objects Universe

Benefits

• Competitive salary

Location

Hybrid in Austin, TX

Location is also listed as Tallahassee, FL (hybrid).

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.
• Comfort 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.