Informatica Lead - Admin & Development for Data Integration

Compunnel, Inc.; Los Angeles (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading data solutions provider is seeking an experienced Informatica Support Admin and Developer Lead to manage and optimize Informatica environments. The role requires strong expertise in SQL and Python scripting, with a background in data integration. You'll lead development efforts, ensuring high-quality data workflows and solutions while collaborating across teams. Ideal candidates possess 9–12 years of experience in Informatica Administration and skills in data modeling, MFT, and APIs.

Qualifications

• 9–12 years of experience in Informatica Administration and PowerCenter.
• Strong knowledge of data modeling and data access patterns.
• Advanced SQL skills for writing complex queries.
• Experience with Python scripting for data manipulation.
• Hands-on experience with Managed File Transfer (MFT).
• Familiarity with APIs and AWS S3 integration.
• Good understanding of unit testing and release management.
• Knowledge of star schema and data warehouse concepts.
• Excellent analytical and problem-solving skills.
• 3–4 years of experience in a lead role.

Responsibilities

• Administer and manage Informatica environments for reliability.
• Design and maintain ETL processes using Informatica PowerCenter.
• Implement and support data modeling and access patterns.
• Write and optimize advanced SQL queries for data operations.
• Develop Python scripts for data manipulation from large datasets.
• Manage and support Managed File Transfer (MFT) processes.
• Integrate APIs and work with AWS S3 for data storage.
• Ensure adherence to testing and release management best practices.
• Provide leadership to development teams for timely delivery.

Skills

Informatica Administration

Data integration

SQL

Python scripting

Managed File Transfer (MFT)

API integration

Data modeling

Analytical skills

Tools

Informatica PowerCenter

Tableau

Job description

A leading data solutions provider is seeking an experienced Informatica Support Admin and Developer Lead to manage and optimize Informatica environments. The role requires strong expertise in SQL and Python scripting, with a background in data integration. You'll lead development efforts, ensuring high-quality data workflows and solutions while collaborating across teams. Ideal candidates possess 9–12 years of experience in Informatica Administration and skills in data modeling, MFT, and APIs.