Senior Informatica & Snowflake Data Engineer — ETL/ELT

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

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.