Job Description
Description Competitive Benefits. Meaningful Extras. Unmatched Value. - A place where you can take your career in the direction you want to grow and go
- Flexible work options and summer hours for eligible employees
- Save on gas at stations across Canada, including Chevron, Fas Gas, Ultramar, and Pioneer
The Opportunity: Informatica Administrator will play a pivotal role in the overall usage of IICS within Parkland, providing daily administrative and development support for the ETL toolset, the role provides technical expertise & recommendations to the team Lead relating to ETL development and usage strategy. Provides consulting support to NextGen Data Team (both onshore and offshore), Consultant, as well as business user while also formulating policies and procedures relating to Informatica application development and management. Maintains the optimal performance of ETL business intelligence applications, performance monitoring, capacity planning and tuning.
Responsibilities: - Ensures Informatica platform availability through product installation and hardening, version upgrades, patch management, daily system monitoring, usage reporting, Security/user authentication and management, ETL project/object promotion and development, UAT and production environments, creating data connectors, Server performance tuning, troubleshooting and work with IT to ensure optimum system performance
- Implement procedures in GitHub to maintain, monitor, backup, and recovery operations for ETL environment/project.
- Informatica Domain setup/config on multi environment (Dev / QA / UAT / Prod), also establishing projects, roles, users, privileges in the ETL environments.
- Designs, implements, and administers Informatica security, managing logs, domain objects, and domain reports
- Foster relationships with the Informatica vendor, ensuring software updates, and industry best practices.
- Develop and document policies and procedures for Informatica system processes, maintain and document Informatica related data profiles/engineering and architecture.
- Maintains current knowledge of advancements in the latest Informatica technologies.
- Support developers on Informatica issues and guide them to follow the best practices and standards
- Work with various technical teams to develop and manage the execution and implementation of plans for high to critical complex new applications.
- Works closely with DBA for the purpose of performance tuning, upgrades, and archive strategy.
- Support Parkland data initiative (Data Quality, MDM, Data Conversion etc.) by staying current on industries best practice for data integration and management.
- Provides cross-training, support and knowledge transfer to developers and business users/ community
Requirements: - 5-7 years of experience in Informatica admin activities and/or Bachelor’s degree in IT, business or related field required.
- Proficiency in a range of Informatica products, including IICS, Power Centre, DEI, EDC, Axon, MDM, and IDQ, demonstrating a comprehensive understanding of their functionalities.
- Hands-on experience in managing Informatica server and cluster, covering tasks such as installation, configuration, performance optimization, upgrades, and the application of patches and hotfixes.
- Hands-on experience in managing GitHub, Set up, code maintenance, version control, backup etc.
- Proven expertise in Informatica security administration, ensuring the protection of sensitive data and managing access.
- Ability to read, analyze, and interpret user manuals, technical procedures, or business communication.
- Strong data modeling, data architecture, Data Integration, and Data Modeling and data warehouse skills
- Expert level experience in SQL, MS SQL server, programming, and query optimization.
- Experience with SaaS environments
- Outstanding analytical, problem-solving, and troubleshooting skills, capable of addressing complex issues efficiently.
- Top Notch sense of innovation, initiative, creativity, organization, autonomy, adaptability to various technologies and problem-solving abilities
Humble. Hungry. Smart. Does this sound like you? Do others describe you as being a down-to-earth achiever? Someone who thinks outside the box and always strives to do more than what is required. Someone who sees the bigger picture? You sound brilliant to work with!
We Want You To Shine: We are committed to providing equal opportunities to all applicants. If you require accommodation due to a disability, you will have an opportunity to notify us when scheduling your interview.
Belonging Matters. Because You Do: We are an equal opportunity employer and encourage applications from all qualified individuals.
Our ability to work as one team across Canada, the United States and the Caribbean is foundational to our success. We show up as our authentic selves each day and create space for one another’s unique contributions.
Our Employee Resource Groups (ERGs) and Affinity Networks help us activate enterprise-wide strategies that power a proactive culture of diversity, equity, inclusions, and ultimately – belonging.
We respect the diverse cultures, traditions and perspectives of Indigenous Peoples and seek to achieve equitable partnerships and opportunities with Indigenous communities.
The Fine Print: Candidates must be legally eligible to work in the country in which they applied. Regrettably, we are unable to sponsor employment visas at this time.
Please note that final candidates for this position will be required to undergo a confidential pre-employment background check, including but not limited to educational, criminal, credit, drug and alcohol, and/or fitness for duty testing.
Job Tags
Work visa, Offshore, Flexible hours,