Job Title: Pl-SQL Data Developer

Location: Calgary, AB

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

Data Engineering & Integration

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

Documentation & Collaboration

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

Work Environment

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