Informatica Developer

Role: Informatica Developer

Duration: Long Term

Location: Charlotte, NC- 3 days Hybrid

Note:

1. Pls submit local candidate only.

2. Need to have current 4 years in Informatica PowerCenter working on loading into DWH. Not on IICS (informatica cloud)

3. Need to be strong in MS SQL working on complex SQL.

4. Hybrid 3 days in office

5. experience working on Informatica power center application upgrade or new installation of the application servers.

6. No Domain exp. is required.

7. 80% developer and 20% 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.