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