Job Title: Informatica/PLSQL Data Developer
Location: Calgary, AB – Onsite
Contract: 6-month contract with possibility of extension
Schedule: Monday to Friday, 8-hour shifts (5x2). After-hours support will be required on a rotational basis
within the team

Airswift is seeking an Informatica/PLSQL Data Developer to join our client’s Data Provisioning Services team. This is an onsite role based in Calgary, supporting a high-impact team that plays a key role in the company’s transformation into a data-driven organization.

In this exciting position, you’ll collaborate with a talented group of Data Analysts, Business Systems Analysts, and industry experts to design and build cutting-edge data pipelines and products for analytics and application integration. You’ll harness powerful tools like Informatica PowerCenter and Oracle PL/SQL to manage the entire data lifecycle—extracting, transforming, validating, and loading data from diverse sources into operational data stores, data warehouses, and applications, ensuring seamless integration and insightful reporting.

The Data Provisioning Services team works across the organization to develop innovative, data-driven solutions that enhance customer service and internal operations. This is a hands-on role with a strong focus on performance, reliability, and scalability.

Responsibilities:
  Deliver hands-on support for seamless data integration in daily operations, including proactive monitoring, configuration, troubleshooting, user administration, and optimizing data objects to ensure smooth end-user experiences. Ensure smooth transitions from project to production environments by strictly following ITIL processes. Lead root cause analysis efforts to quickly resolve incidents flagged by monitoring systems or reported by end[1]users, minimizing downtime and disruptions. Configure and manage robust data replication and integration using industry-leading tools such as HVR, Informatica Developer & PowerCenter, Orchestrator, and DevOps. Fine-tune performance for queries and data pipelines, ensuring the rapid delivery of critical data. Drive consistency and excellence by developing and maintaining best practices, templates, and standards for data engineering across tools and functions.
Skills & Qualifications: Post-secondary degree in Computer Science, Software Engineering, or a related field, or equivalent experience in data integration or data engineering. 3+ years of experience in developing high-performance, scalable, and efficient ETL/ELT data pipelines and integration solutions. 3+ years of experience as an Informatica Developer, working with PowerCenter, DevOps/CI/CD pipelines, optimized data storage, and REST APIs. 3+ years of experience in Oracle SQL, PL/SQL, and SQL Server development. Bonus: Experience with Change Data Capture (CDC) and data replication using tools like HVR, Power Exchange, and MS Orchestrator for scheduling. Proficient in handling various file types, including XML, JSON, CSV, Text, Excel, etc)