PLSQL data developer

Airswift; Calgary; On-site; CAD 130,000 - 165,000; Full time

Job summary

A leading company in the oil and gas sector is seeking a skilled Data Engineer for a contract role aimed at supporting new projects and operational data needs. The ideal candidate will have expertise in Informatica and PL/SQL, working in a fully on-site environment. Responsibilities include developing data pipelines and troubleshooting production issues, within a collaborative, fast-paced team.

Qualifications

• 3+ years in Informatica PowerCenter development.
• 3+ years of Oracle SQL and PL/SQL experience.
• Strong manual data operation skills including scripting.

Responsibilities

• Design and maintain ETL/ELT pipelines using Informatica.
• Troubleshoot production incidents and conduct root cause analysis.
• Support data replication and real-time integration using HVR.

Skills

Informatica PowerCenter

Oracle SQL

manual data operations

problem-solving

clear communication

Job description

Direct message the job poster from Airswift

Type: Contract - T4 & INC (6 months, possibility of extension)

Schedule: Monday to Friday, 8-hour shifts

Work Setup: Fully On-site (no remote or hybrid options)

Job Summary

Airswift is currently seeking a highly skilled Data Engineer to support a major client in the energy sector. This contract opportunity is ideal for professionals with strong Informatica PowerCenter and Oracle PL/SQL expertise, who thrive in a fully on-premise, non-cloud environment.

The role will involve supporting new project development, ongoing operational data support, and production troubleshooting within a highly data-driven team.

Key Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Informatica PowerCenter.
• Write and optimize Oracle PL/SQL queries and stored procedures.
• Support data replication and real-time integration using tools like HVR (training available if needed).
• Perform manual data import/export, scripting, and operational support across staging environments.

Operational & Production Support

• Troubleshoot production incidents and conduct root cause analysis.
• Monitor and maintain performance of data pipelines and ETL processes.
• Ensure smooth transitions between development and production following structured release processes.
• Document data workflows, maintenance tasks, and solution architecture.
• Work closely with analysts, developers, and business stakeholders to meet data needs.
• Participate in an after-hours support rotation as required by the team.

Must-Have Qualifications

• 3+ years of Informatica PowerCenter development experience.
• 3+ years of experience with Oracle SQL and PL/SQL (advanced query writing and performance tuning).
• Strong experience with manual data operations, including scripting and job orchestration.
• Familiarity with managing data in non-cloud, on-premise environments.

Nice-to-Have Skills

• Experience with Change Data Capture (CDC) tools such as HVR or PowerExchange.
• Exposure to SQL Server and common data file formats (CSV, XML, JSON, Excel).
• Understanding of manual deployment/versioning workflows instead of automated CI/CD tools.
• Previous experience in a DBA-style support role is a plus.

Soft Skills & Attributes

• Able to independently ramp up and contribute with minimal supervision.
• Strong problem-solving and troubleshooting skills.
• Clear communication skills for working with technical and business teams.
• Comfortable working in fast-paced, operational support environments.
• 100% on-site in Calgary (no remote or hybrid).
• Work is fully within an on-prem infrastructure—cloud experience is not required.
• Candidate must be open to rotational after-hours support responsibilities.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  Oil and Gas

Referrals increase your chances of interviewing at Airswift by 2x

Sign in to set job alerts for “Data Engineer” roles.

Calgary, Alberta, Canada CA$130,000.00-CA$165,000.00 4 days ago

Data Science Developer (12-month contract)

Python and Kubernetes Software Engineer - Data, AI/ML & Analytics

Python and Kubernetes Software Engineer - Data, Workflows, AI/ML & Analytics

Software Engineer (Python/Linux/Packaging)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.