Job title: Informatica Administrator
Company: Canadian Institute for Health Information
Job description: Who we are
We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, not-for-profit organization and together with our partners we provide essential information on Canada’s health systems, enabling decisions that lead to healthier Canadians. As a valued member of the CIHI team, you and your work will have a pivotal role in the evolution of Canada’s health care systems.
CIHI is recognized as an exceptional place to work that embraces diversity, respect, integrity, collaboration and innovation. Learn about our and the work being done to create a more inclusive and welcoming organization by focusing on how we learn, govern and practise.
At CIHI, we recognize what matters to our employees. Some of the benefits of working at CIHI include
- HOOPP Pension Plan (Defined Benefits Pension)
- Retirement Planning Program
- Generous vacation days for permanent and long-term contracts
- Work-life balance
- Career Planning Program
- Learning and Professional Development Program
- Flexible benefits program from your first day on the job for permanent and long-term contracts
Why is this role important?
Reporting to the Manager, Enterprise Technology Services, the Informatica Administrator provides daily administrative and development support for the ETL toolset and Informatica Administrator provides technical expertise & recommendations to management relating to the ETL usage strategy. Provides consulting support to ITS development and operations staff as well as business areas and formulate 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.
What you’ll do
1. Supports the Information Security Management System (ISMS) through the implementation, management and/or monitoring of required Information Security controls and participates in key ISMS processes as required, including but not limited to Risk Management, Audit and Assessment, Monitoring and Reporting and Record Management.
2. Ensures Informatica platform availability, including:
- Product installation and hardening, version upgrades, patch management, daily system monitoring, usage reporting
- Security/user authentication and management
- ETL project/object promotion through development, UAT and production environments
- ETL Project setup
- Creates data connectors
- Server performance tuning
- Establishes LDAP authentication
- Troubleshoots Informatica, EMR cluster integration
3. Provides recommendations to management on environment design and architecture strategies for a sustainable and scale environment.
4. Provides cross-training, support and knowledge transfer to ITS development/ maintenance teams and business areas.
5. Leads and coordinates the resolution of Informatica-related technical issues in a time-sensitive/priority-sensitive manner.
6. Designs, implements and administers Informatica security.
7. Develops relationships with vendor (Informatica) and maintains vendor relationships (including acquiring new patches, software upgrades, license maintenance and promoting industry best practices).
8. Works closely with Linux/DBB Administrators relating to performance tuning, upgrades and archive strategy.
9. Develops and documents policies and procedures for Informatica system processes and maintains and documents Informatica related data profiles/engineering and architecture.
10. Maintains current knowledge of advancements in the latest Informatica technologies.
What you’ll bring to the table
- Bachelor’s degree in computer science or equivalent.
- Minimum of 5 years Data Warehousing knowledge and experience in an Oracle and AWS EMR, data lake environment; and a minimum of 3 years’ experience as an Informatica Administrator.
- Solid knowledge of various Informatica products such as DEI, EDC, Axon, MDM, IDQ.
- Experience with installing, configuring, tuning, upgrading, patching hotfixes, EBF on Informatica server and cluster.
- Informatica security administration experience.
- Solid knowledge of SQL (both programming and tuning).
- Strong application development background.
- Excellent interpersonal and communication skills – both written and oral. With the ability to communicate effectively with users, management, and technical staff.
- Excellent analytical, problem solving and troubleshooting skills.
- Works well under pressure and can prioritize competing issues appropriately.
- Ability to work with minimal supervision and direction.
- Ability to work in fast-paced multi-disciplinary teams.
- Ability to work as a team player and leader.
- Must be able to work after hours/weekends and on call.
- MicroStrategy certification is an asset.
- Knowledge of the Canadian healthcare system, the CIHI environment and program areas is an asset.
- Fluency in both official languages is an asset.
To find out more about this role and other exciting opportunities visit our website at www.cihi.ca and check out our ‘Careers’ section.
We thank all those who apply, however, only candidates selected for an interview will be contacted.
At CIHI we are committed to fostering an inclusive, barrier-free and accessible environment. Part of this commitment includes arranging accommodations to ensure an equitable opportunity to participate in the recruitment and selection process. If you require an accommodation, we will work with you to meet your needs.
Please note the CIHI Recruiting Team uses email to communicate with applicants. Please make sure your profile has an updated email address that is checked regularly, including the junk/spam mail folder, as we send time sensitive emails (i.e. testing and interview bookings).
Expected salary:
Location: Toronto, ON – Ottawa, ON
Job date: Tue, 24 Oct 2023 02:34:28 GMT
