Informatica and Snowflake Data Engineer

SMART TECH SKILLS LLC; Tallahassee (FL); Hybrid; USD 120,000 - 150,000; Full time

Benefits offered by this job

Competitive salary

Job summary

SMART TECH SKILLS LLC in Tallahassee, FL is seeking a Senior Data Engineer to design, build, and support enterprise data integration pipelines using Informatica and Snowflake in a hybrid role.

The role focuses on ETL/ELT development, data loading, performance tuning, and collaboration with business and IT teams to deliver scalable solutions.

Candidates should have 8+ years of experience with Informatica PowerCenter, Snowflake, and Oracle, and be adept at batch scheduling with Control-M or Autosys.

Qualifications

• 8+ years of experience designing, developing, and supporting enterprise data integration solutions.
• 8+ years building and maintaining ETL workflows in Informatica PowerCenter.
• 8+ years ingesting data into Oracle databases from multiple sources.
• 8+ years strong Oracle SQL/PL-SQL knowledge including procedures and tuning.
• 8+ years experience with Snowflake data loading and schema design.
• 8+ years experience with Informatica PowerCenter and Informatica Cloud Data Integration for cloud ETL/ELT.
• 8+ years experience gathering data requirements and mapping data flows.
• 8+ years troubleshooting data quality, job failures, and production bottlenecks.
• 8+ years experience with job scheduling tools like Control-M, Autosys, or Informatica scheduler.

Responsibilities

• Develop and maintain ETL workflows in Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations.
• Ingest data from multiple sources 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 and packages.
• Load and support data in Snowflake, including schema design and query performance optimization.
• Troubleshoot 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 procedures to identify automation or system improvement opportunities.
• Support batch data loads using scheduling/orchestration tools such as Control-M, Autosys, or 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.

Skills

Analytical thinking

Problem solving

Communication skills

SDLC

Change management

Troubleshooting

Collaborative

Tools

Informatica PowerCenter

Informatica Cloud Data Integration

Oracle SQL/PL-SQL

Snowflake

Control-M

Autosys

Informatica scheduler

Oracle databases

SAP Business Objects Universe

Job description

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

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

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).

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

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.