Description

You will design, build, and administer enterprise-scale ETL/ELT solutions using Informatica IDMC/IICS and PowerCenter across cloud and on-premises environments.

You will own the migration strategy, performance tuning, and production support for critical data pipelines connecting SaaS platforms and data warehouses.

Responsibilities

• Design and architect data integration solutions using Informatica IDMC/IICS, PowerCenter, and Power Exchange for Snowflake, GCP, and Azure.
• Develop and optimize Mappings, task flows, and process flows using CDI, CDQ, and CAI services to ensure high-performance data processing.
• Manage Informatica infrastructure including installation, upgrades, secure agent deployment, repository backup, and server migrations.
• Implement complex data migrations from Oracle and SQL Server to cloud platforms like Snowflake and BigQuery with strict data integrity.
• Resolve critical production incidents through ServiceNow and apply optimization techniques such as pushdown optimization and CDC.

Required Skills

• 10+ years of experience with Informatica PowerCenter and IDMC/IICS.
• Deep expertise in Snowflake, GCP, Azure, Oracle, SQL Server, Teradata, and Postgres.
• Proficiency in SQL and PL/SQL, including stored procedures, DDL design, and indexing strategies.
• Hands-on experience with Toad, PuTTY, and WinSCP.
• Knowledge of Informatica Cloud Migration Factory and tools to accelerate migration efforts.
• Experience with automation and scheduling tools like Control-M, Autosys, or Cron.
• Strong understanding of data warehousing concepts including SCD, partition strategies, and data quality frameworks.

Preferred Skills

• Experience integrating SaaS platforms like Salesforce and Veeva CRM.
• Familiarity with infrastructure automation and shell scripting.

Key Skills

Education

Bachelor's degree