Design, build, and support enterprise data integration pipelines using Informatica and Snowflake in a hybrid role in Austin, TX.

Location: Tallahassee, FL (hybrid)
Experience: Senior level (8+ years)
Primary focus: Informatica ETL/Data Engineering and Snowflake data loading and optimization

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.
Design, develop, and support cloud-based ETL/ELT solutions using Informatica Cloud Data Integration.
Write, optimize, and maintain Oracle SQL/PL-SQL including stored procedures, packages, and performance tuning for ETL-related queries.
Load and support data in Snowflake, including 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 define input/output and reporting requirements.

8+ years of experience as a Data Engineer/Systems Analyst designing, developing, and supporting enterprise data integration solutions.
8+ years hands-on experience building and maintaining ETL workflows in Informatica PowerCenter.
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/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 supporting batch data loads (e.g., Control-M, Autosys, or Informatica scheduler).

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.

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.

Informatica and Snowflake Data Engineer

Job Description