- Utilize Power Center, IICS Data Integration, and IICS Application Integration to perform data integration tasks
- Develop and maintain ETL workflows, adhering to team standards for naming, promotion, data flow, documentation, and code repository
- Design, build, and optimize data pipelines and workflows for efficient data processing and analysis
- Collaborate closely with project teams, including Business Analysts, Solution Architects, Project Managers, Application Developers, and BI Developers
- Collaborate with operational teams such as DBAs, Service Operations Center, BI developers, and SAP developers
- Participate in peer reviews of Informatica workflows and production deployments
- Perform data modeling, logic development, performance tuning, scheduling, and validation of data flows
- Provide immediate incident resolution for data, performance, and integration problems.
- Conduct incident follow-up with root cause analysis and manage incident change release and dev/acceptance reconciliation
- Maintain and provide support for Informatica and Linux middleware, including patching, installations, shell scripting, updates, and configuration
- Stay updated with emerging trends in data management, ETL, and data engineering
- Availability to provide 24/7 on-call support (on rotation basis)
- Bachelor's degree in Computer Science, Information Systems, or equivalent education or work experience
- 5+ years' experience in ETL development
- 5+ years' experience with SQL and scripting skills for data manipulation and transformation
- 3+ years' experience with big data patterns, data modeling (Star, Snowflake, Relational), NoSQL, and data engineering concepts
- 3+ years' experience with database systems, including Oracle or SQL Server
- 3+ years' experience in data pipeline design, implementation, and optimization.
- Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and their data services
- 3 + years' experience with data warehousing, data lakes, and data integration techniques
- Recent experience with database systems, including Azure Synapse, Snowflake, and SAP eHana is nice to have
- Knowledge of system integration using APIs, MQ, FTP, and other integration software is nice to have
- Working knowledge of Linux and shell scripting, Python and R is nice to have
- Flexible and competitive benefits package
- Employer Funded Retirement Plan
- Employee Share Purchase Plan
- Performance Incentive Program
- Annual Fitness Subsidy
- Part-time Studies Program
- Criminal history check
- Reference check
- Req ID:
- Department: Information Services
- Job Type: Full-Time
- Position Type: Non-Union
- Location: Calgary, Alberta
- Country: Canada
- % of Travel: 0-10%
- # of Positions: 1
- Job Grade: 4
- Job Available to: Internal & External
-
Territory Manager
2 days ago
John Brooks Company Alberta, CanadaJohn Brooks Company Limited is a well-respected leading supplier of Fluid Handling Solutions to the Canadian Manufacturing and Processing Industry with branches across Canada. We have been in business for over 80 years and are committed to providing our customers with a diverse s ...
-
Data Modeler
14 hours ago
Myticas Consulting Calgary, CanadaMyticas Consulting's Calgary based client is looking for a Senior Data Modeler for a long-term hybrid contract opportunity. · Experience: · Bachelor's degree in Computer Science, Information Systems, or a related field · 8+ years of experience in Data Modeling, data integration ...
-
Data Engineer Data Analytics
22 hours ago
Edjuster Calgary, AB, CanadaArbor provides sustainability as a service, and is a data platform that enables brands to increase their profits, and save the planet. Utilizing a proprietary sustainability data engine, Arbor provides companies with the power to measure, improve, and showcase the sustainability ...
-
Power BI Data Engineer
3 days ago
AMTRA Solutions Calgary, AB, CanadaWe are seeking a talented Power BI/Data Engineer to join our team. The ideal candidate will have a strong background in data engineering, database management, and data visualization using Microsoft Power BI. The Power BI/Data Engineer will be responsible for designing, developing ...
-
Engineer - Data Engineer
4 days ago
stellaralgo corp. Calgary, AB, CanadaWe are brought together by the belief that accessible and actionable data inspires the personalized and authentic experiences that create lifelong fans. Through a combination of embracing challenges, a belief that alignment enables autonomy and a committed team, we believe in emp ...
-
Data Developer
4 days ago
Trafigura Calgary, AB, CanadaData Integration Developer page is loaded Data Integration Developer · Apply locations Calgary, Canada time type Full time posted on Posted 30+ Days Ago job requisition id R Main Purpose: · We are recruiting a Data Integration Developer; who is knowledgeable in the full data in ...
-
Manager, Software Development
4 days ago
SMART Technologies Inc Calgary, AB, CanadaWe are seeking a dynamic and experienced Manager to lead our DevOps and Data Platform teams. The successful candidate will be responsible for overseeing the day-to-day operations, strategic direction, and continuous improvement initiatives for both teams across multiple time zone ...
-
Software Implementation Lead
6 days ago
SMART Technologies Inc Calgary, AB, CanadaWe are seeking a dynamic and experienced Manager to lead our DevOps and Data Platform teams. Provide leadership, guidance, and mentorship to the DevOps and Data Platform teams. · Foster a collaborative and high-performance culture that encourages innovation, accountability, and ...
-
Remote Salesforce Developer
2 days ago
ATB Financial Calgary, AB, CanadaMaybe it's our exceptional culture where your total wellness is supported through market-leading benefits and you're free to bring your whole self to work. We foster a culture of purpose, performance and possibilities. System Title: Full Stack Software Developer 7 or 8 · # Leader ...
-
Lead Data Analyst, Vice President
2 days ago
MUFG Bank, Ltd. Alberta, CanadaLead Data Analyst, Vice President page is loaded · Lead Data Analyst, Vice President · Apply locations Tempe, AZ time type Full time posted on Posted Yesterday job requisition id WD Do you want your voice heard and your actions to count? · Discover your opportunity with Mitsub ...
-
Senior Software Engineer
17 hours ago
RBC - Royal Bank Calgary, Canada Full timeJob Summary · Job Description · What is the opportunity? · Working within Wealth Management Global IT Data Services Canada - you will be our Senior Software Engineer, leveraging Java and Database technologies such as Spring Boot, Spring Batch Kafka, InMemory distributed databases ...
-
Senior Software Engineer
1 day ago
0000050007 Royal Bank of Canada Calgary, Canada Full timeJob Description · What is the opportunity? · Working within Wealth Management Global IT Data Services Canada - you will be our Senior Software Engineer, leveraging Java and Database technologies such as Spring Boot, Spring Batch Kafka, InMemory distributed databases (MemSQL), I ...
-
Cybersecurity Architect
17 hours ago
FYidoctors Calgary, Canada Full timeJoin our team as a Cybersecurity Architect & Engineer In this role, you will take the lead in developing and executing the next generation of our Cybersecurity strategy. It's an exciting and collaborative role that transcends the organization. · What Will You Be Doing? · Leading ...
-
Specialist QA
12 hours ago
CB Canada Calgary, CanadaSpecialist, QA & Automation Testing Job Details · The Specialist, QA & Automation Testing will be working with multiple integrations projects including UI, API and ETL Automation. · Specialist, QA & Automation Testing Responsibilities · The Specialist QA & Automation Testing wil ...
-
Senior Technical Specialist
13 hours ago
ATCO Calgary, Canada Full timeAt ATCO we are challenging the status quo and aspiring to make a positive impact on the world. With our commitment to accelerating the energy transition, we've become a meaningful player in the future of sustainable energy. While the rest of the industry is thinking, we are execu ...
-
Data Analyst
17 hours ago
Worley Calgary, Canada Full timeWorley is a global professional services company of energy, chemicals and resources experts. We partner with customers to deliver projects and create value over the life of their assets. We're bridging two worlds, moving towards more sustainable energy sources, while helping to p ...
-
Software Developer
12 hours ago
CB Canada Calgary, CanadaSoftware Developer · On behalf of our client, Procom is seeking a Software Developer for a 6 month contract, in Calgary, AB. · Software Developer Job Details · The Software Developer will work with other Developers, Tech leads, Project and Product Managers throughout the software ...
-
Manager, Software Development
1 day ago
Smart technologies Calgary, Canada Full timeWe are seeking a dynamic and experienced Manager to lead our DevOps and Data Platform teams. The successful candidate will be responsible for overseeing the day-to-day operations, strategic direction, and continuous improvement initiatives for both teams across multiple time zone ...
-
Full Stack Developer
1 day ago
Hexagons Autonomy & Positioning division Calgary, Canada Permanent Full timeOverview · Hexagon Autonomy & Positioning is on the lookout for a proficient Full Stack Developer , who possesses over 5 years of hands-on experience in full stack development with a focus on AngularJS, .NET, and MS SQL technologies. Join our dynamic Manufacturing Execution Sys ...
-
Analyst - Data & Analytics
17 hours ago
WestJet Calgary, Canada Full time RegularOverview of role: · The Revenue Analytics team provides business intelligence analytics and reporting solutions for the Revenue Management & Pricing department within WestJet. Transforming data into meaningful information is an art form that requires the combination of technical ...
ETL Engineer - Calgary, Canada - CPKC
Description
Canadian Pacific (CP) and Kansas City Southern (KCS) are now CPKC. As the only truly North American railway, we are making big moves Drawing on our strong foundations and heritage, CPKC moves essential goods across our 20,000-mile network to support economic growth throughout Canada, the U.S. and Mexico. Be a part of history as we connect a continent and create exciting career opportunities across our new transnational network. Visit to learn about the CPKC advantage, our purpose and culture.
PURPOSE OF THE POSITION:
As an ETL Engineer, you will be responsible for data integration using Power Center, IICS Data Integration, and IICS Application Integration. In addition to developing ETL workflows, you will also apply your data engineering skills to design, build, and optimize data pipelines and workflows for efficient data processing and analysis. Collaborating with cross-functional teams, you will ensure seamless data integration and drive data-driven insights for business decision-making.
POSITION ACCOUNTABILITIES:
POSITION REQUIREMENTS:
WHAT CPKC HAS TO OFFER:
ADDITIONAL INFORMATION:
As an employer with North American presence, the possibility does exist that the location of your position may be changed based on organizational requirements.
Background Investigation:
The successful candidate will need to successfully complete the following clearances:
Management Conductor Program:
Becoming a qualified conductor or locomotive engineer is the single best way for a management employee to learn the business at CPKC. You may be required to obtain a certification or to maintain your current certification/qualification as a conductor or locomotive engineer.
CPKC is an employment equity employer committed to the principles of employment equity and inclusion. We encourage all qualified candidates to apply including women, Black, Indigenous, People of Colour (BIPOC), members of the LGBTQ+ community, and people with disabilities. Accommodations for the job application process can be provided, as appropriate, upon request. All applicant information will be managed in accordance with the federal Personal Information Protection and Electronic Documents Act (PIPEDA).
#LI-ONSITE
#LI-GK1