Informatica IICS - 10+ Years of experience

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 12 Month(s)
No Travel Required
Able to Provide Sponsorship

Skills

Informatica IICS

Job Details

Informatica IICS: - 10+ Years of experience Required. - W2 ONLY NO C2C

Design and Development:

Architect, develop, and implement ETL processes and mappings using Informatica PowerCenter.
Collaborate with business analysts and data architects to understand requirements and translate them into technical designs.

Data Integration:

Integrate data from multiple on-premises and cloud sources (e.g., databases, flat files, APIs) while ensuring data quality, integrity, and consistency.
Create reusable components and frameworks to streamline ETL development and support scaling.

Testing & Optimization:

Develop and execute unit, integration, and system test cases for ETL processes.
Optimize performance of ETL jobs, troubleshoot failures, and resolve data-related issues efficiently.

Documentation & Maintenance:

Produce thorough technical documentation for code, data flows, and process architecture.
Maintain existing ETL jobs, support data migration and ongoing enhancement activities.

Collaboration:

Work closely with database administrators, QA testers, and business partners for successful project delivery.
Participate in code reviews and provide feedback to improve code quality and consistency.

Required Skills & Qualifications

Technical Skills:

3+ years of hands-on experience with Informatica PowerCenter (or Informatica Intelligent Cloud Services).
Strong expertise in SQL and relational databases (e.g., Oracle, SQL Server, MySQL).
Experience with performance tuning of ETL processes and jobs.
Familiarity with data warehousing concepts, dimensional modeling, and data governance best practices.
Understanding of scheduling/orchestration tools (e.g., Control-M, Autosys) and basic knowledge of Unix/Linux scripting.

Soft Skills:

Excellent problem-solving and analytical abilities.
Comfortable working independently and in team environments.
Strong written and verbal communication skills.

Preferred Qualifications

Experience with cloud migration or integration (e.g., AWS, Azure, Google Cloud Platform).
Exposure to big data technologies (Hadoop, Spark) or other ETL tools.
Informatica certification(s) or relevant training.
Experience in Agile/Scrum environments.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.