Oracle Sql/pl Sql Engineer Jobs

1 job found

Today

Informatica and Snowflake Data Engineer

SMART TECH SKILLS LLC Tallahassee, FL

Tallahassee, FL

Today

Full time Business Systems Cloud Cloud Data Engineering

Apply Now

Job Description

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.

View full job page →

Get Oracle Sql/pl Sql Engineer Jobs alerts

New Oracle Sql/pl Sql Engineer Jobs, daily.