ETL- Informatica PowerCenter Admin with Development Experience (Multiple Locations)
Apply NowLocation:
New York, NY, US
Company:
TMS LLC specializes in IT and software solutions, offering expertise in data management and software development.
Summary:
The Informatica PowerCenter Admin will design and develop ETL processes with a focus on Informatica and SQL. Applicants should have extensive experience in ETL development, specifically with Informatica PowerCenter and SQL.
Requirements:
Technology: Informatica PowerCenter, SQL Server, Oracle, PostgreSQL
Hard Skills: Informatica PowerCenter, MS SQL, ETL workflows, Source-to-Target (S2T) mapping, SQL, database management
Credentials: bachelors-degree
Experience: 5+ years of experience in Informatica PowerCenter development, Experience working on Informatica power center application upgrade or new installation of the application servers, Min 7 years experience loading data to target DWH/source to target mappings
Job Description:
Role: ETL- Informatica PowerCenter Admin with Development Experience
Location- Chicago, IL/ Dallas, TX, Charlotte, NC/ Morristown, NJ, NYC, Conshohocken, PA. (Hybrid)
Duration- Long Term Contract (C2C)
Note:
Need to have current 4 years in Informatica PowerCenter working on loading into DWH. Not on IICS (informatica cloud)
Need to be strong in MS SQL working on complex SQL.
Experience working on Informatica power center application upgrade or new installation of the application servers.
80% developer and 20% admin
Min 7-year experience loading data to target DWH/ source to target mappings.
Strong in MS SQL.
Experience working as an Informatica Admin.
Job Description:
We are seeking a highly skilled Informatica Developer with admin skills who will be responsible for designing, developing, and optimizing ETL processes while also handling minimal administrative tasks. The ideal candidate should have a strong background in Informatica PowerCenter, source-to-target mapping, and SQL.
Key Responsibilities:
ETL Development (80%)
Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter.
Perform source-to-target data mapping and ensure data transformation meets business requirements.
Develop and optimize complex SQL queries for data extraction, transformation, and loading.
Work with relational databases such as Oracle, SQL Server, and PostgreSQL for efficient data processing.
Conduct data profiling, performance tuning, and troubleshooting of ETL processes.
Collaborate with business analysts, data architects, and stakeholders to understand data requirements.
Ensure data integrity, accuracy, and consistency across multiple data sources.
Informatica Administration (20%)
Perform basic Informatica administrative tasks such as user management, security settings, and performance monitoring.
Assist in installation, configuration, and upgrades of Informatica components.
Monitor ETL job schedules, troubleshoot failures, and ensure system availability.
Maintain documentation for ETL processes and administrative configurations.
Required Skills & Qualifications:
5+ years of experience in Informatica PowerCenter development.
Strong experience in Source-to-Target (S2T) mapping and ETL workflows.
Expertise in SQL and database management (Oracle, SQL Server, PostgreSQL, or similar).
Hands-on experience in ETL performance tuning and optimization.
Basic understanding of Informatica Administration tasks (user management, configurations, monitoring).
Knowledge of Unix/Linux scripting is a plus.
Strong analytical and problem-solving skills.
Excellent communication and documentation skills.
