Overview: Required. "Client facing experience with Informatica PowerCenter Administration Experience with Informatica PowerCenter Development Experience with Informatica Deployments using the deployment wizard High level of proficiency with Unix (AIX and Linux preferred) command line High level of comfort with Oracle SQL"

About the Role

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.

Qualifications

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 robust 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.

Pay range and compensation package

Travel: This position is primarily remote. No travel may be required.

Degree

Bachelor's Degree in Computer Science, Information Systems, Engineering, or equivalent work experience.

Preferred Skills

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).

Equal Opportunity Statement

We are committed to diversity and inclusivity.

📌 Informatica PowerCenter Admin (Toronto)
🏢 ThoughtStorm
📍 Toronto