Job Title: Informatica Developer

Location: CA

Employment Type: Full-time / Contract

Experience Level: Mid to Senior Level

Job Summary

We are looking for a skilled Informatica Developer to design, develop, and maintain ETL processes and data integration workflows using Informatica PowerCenter / IICS. The ideal candidate will have strong experience in data warehousing, SQL optimization, and performance tuning, ensuring reliable and efficient data movement across systems.

Key Responsibilities

• Design, develop, and implement ETL workflows and mappings using Informatica PowerCenter or Informatica Cloud (IICS).
• Collaborate with data architects and business analysts to understand data requirements and translate them into efficient ETL solutions.
• Perform data extraction, transformation, and loading (ETL) from various sources such as databases, flat files, and APIs.
• Optimize ETL processes for performance and scalability.
• Conduct unit testing, system integration testing, and assist in user acceptance testing.
• Monitor and troubleshoot ETL jobs and data loads in production environments.
• Work with SQL/PLSQL for data validation, transformation, and troubleshooting.
• Maintain detailed documentation of ETL designs, data mappings, and workflows.
• Ensure data quality, integrity, and security across data movement processes.
  
  

Required Skills And Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 37 years of hands-on experience in Informatica PowerCenter / IICS development.
• Strong proficiency in SQL, PL/SQL, and database concepts (Oracle, SQL Server, or similar).
• Experience in data warehousing concepts, dimensional modeling, and ETL best practices.
• Good understanding of data integration, data quality, and metadata management.
• Experience with Unix/Linux scripting and job scheduling tools (Control-M, Autosys, etc.).
• Strong problem-solving and debugging skills.
• Excellent communication and teamwork abilities.
  
  

Preferred Skills

• Experience with cloud data platforms (AWS, Azure, GCP).
• Knowledge of Informatica Cloud Data Integration (IICS), Informatica MDM, or Data Quality (IDQ).
• Familiarity with Agile/Scrum methodologies.
• Exposure to Python or shell scripting for automation.
  
  

Key Attributes

• Analytical and detail-oriented mindset.
• Ability to work independently and in a team environment.
• Commitment to meeting deadlines and delivering high-quality solutions.