Req ID: 386828
We are currently seeking a Informatica Power Center Admin to join our team in Toronto, Ontario (CA-ON), Canada (CA).
Day to Day job Duties: (what this person will do on a daily/weekly basis)
• Administer, monitor, maintain, and support Informatica PowerCenter environments across development, test, and production platforms.
• Perform installation, configuration, upgrades, patching, and troubleshooting of Informatica PowerCenter components.
• Manage Informatica repository services, integration services, domains, and application services to ensure platform stability and performance.
• Support and execute Informatica code migrations and deployments using Informatica Deployment Groups and Deployment Manager/Wizard.
• Collaborate with ETL developers, database administrators, infrastructure teams, and business stakeholders to resolve production and application issues.
• Monitor daily ETL processing, identify failures, perform root cause analysis, and implement corrective actions.
• Provide operational support for Oracle databases and assist with SQL performance troubleshooting related to Informatica workflows and mappings.
• Utilize Unix/Linux command-line tools to manage batch processes, scripts, file transfers, scheduling activities, and platform administration.
• Participate in release management activities, including deployment planning, validation, and post-deployment support.
• Create and maintain operational documentation, support procedures, and knowledge articles.
• Support incident management, problem management, and change management activities in accordance with established processes.
• Participate in scheduled after-hours and weekend on-call support rotations to ensure critical production systems remain operational.
• Work directly with client teams and business users to provide technical support and communicate issue status and resolution.
Basic Qualifications: (what are the skills required to this job with minimum years of experience on each)
• Minimum 5+ years of experience administering and supporting Informatica PowerCenter environments.
• Minimum 3+ years of experience performing Informatica PowerCenter installations, upgrades, migrations, and platform administration.
• Minimum 3+ years of experience with Informatica PowerCenter development, including workflows, sessions, mappings, and troubleshooting.
• Minimum 2+ years of experience using Informatica Deployment Groups, Deployment Manager, or Deployment Wizard for migrations and releases.
• Minimum 5+ years of experience working with Unix/Linux operating systems, preferably AIX and Linux.
• Minimum 3+ years of experience writing and troubleshooting Oracle SQL queries.
• Experience supporting production ETL environments and resolving critical incidents.
• Experience working in a client-facing role with strong verbal and written communication skills.
• Experience with change management, deployment processes, and release support activities.
• Ability to participate in an on-call support rotation, including occasional weekend support.
Travel: This position is primarily remote. Preferred candidates are based in Mexico (Nearshore). Candidates located in Canada will also be considered. No travel may be required.
Degree: Bachelor's Degree in Computer Science, Information Systems, Engineering, or equivalent work experience.
Nice to Have; (But not a must)
• Experience with Informatica PowerCenter architecture design and capacity planning.
• Experience supporting Informatica domains in high-availability environments.
• Experience with Control-M, Autosys, or other enterprise job scheduling tools.
• Knowledge of shell scripting (Bash, KornShell, or Python).
• Experience working in cloud or hybrid data integration environments.
• Informatica certification(s).
• Experience supporting financial services, gaming, hospitality, or other highly regulated industries.
• Project leadership or technical lead experience.
• Experience working with ServiceNow, Jira, or similar ITSM platforms.