Oracle Sql/pl Sql Developer Jobs

1 job found

1d ago

Informatica and Snowflake Data Engineer

SMART TECH SKILLS LLC Tallahassee, FL

Tallahassee, FL

1d ago

Full time Business Systems Cloud Cloud Data Engineering

Apply Now

Job Description

SMART TECH SKILLS LLC offers a Senior-level opportunity for an Informatica and Snowflake Data Engineer in a hybrid setup. If you value building reliable enterprise data pipelines and improving production stability, this role focuses on data integration design, ETL/ELT development, and ongoing support.

Based in Tallahassee, FL (hybrid) (Senior level, 8+ years), you will deliver scalable solutions using Informatica PowerCenter and Informatica Cloud, with Snowflake for data loading and performance-focused schema and query work. The role also emphasizes documentation, requirements gathering, and collaboration across business and technical stakeholders.

Responsibilities

Develop and maintain ETL workflows using Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations.
Ingest data from multiple heterogeneous sources such as flat files, APIs, relational databases, and mainframe extracts into Oracle databases.
Build and support cloud-based ETL/ELT solutions with 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 and help with 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 of experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment.
8+ years of hands-on ETL workflow development and maintenance using Informatica PowerCenter.
8+ years 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/or Informatica Cloud Data Integration for cloud-based ETL/ELT development.
8+ years gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications.
8+ years troubleshooting data quality issues, job failures, and performance bottlenecks in production ETL pipelines.
8+ years experience with job scheduling/orchestration tools such as 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

Preferred Qualifications

Experience with SAP Business Objects Universe design and/or maintenance.
Experience working in a state government or large enterprise IT environment with formal SDLC and change management processes.

Benefits

Competitive salary

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 Developer Jobs alerts

New Oracle Sql/pl Sql Developer Jobs, daily.