Informatica / PLSQL Data Developer

Agilus is recruiting for a Informatica/PLSQL Data Developer in the Oil and Gas in Calgary, Alberta.

In this exciting role, 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 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.

Accountabilities

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

Successful Candidates Will Have

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

Soft Skills

• Strong written and verbal communication skills
• Ability to self-direct and self-motivate
• Strong attention to detail
  
  

You'll Receive

• Competitive Salary
• A chance to work with one of Canadas most distinguished employers
• Potential to extend
  
  

Interested?

Please apply directly online

Agilus would like to thank all candidates for their interest in this opportunity. Due to the volume of resumes we receive; we may only be able to respond directly to those candidates being selected for an interview.

We encourage you to visit agilus.ca regularly or subscribe to our email alerts at agilus.ca/Account/Register as new exciting employment opportunities become available daily.