Job Description Overview
  • Skill: Informatica Developer, Informatica PowerCenter, Informatica Cloud, Informatica Data Quality, ETL Development, Data Integration, Data Modeling, Performance Optimization, Troubleshooting, Data Quality, Data Transformation, SQL, Data Warehousing, Informatica Mappings, Sessions, Workflows, Session Recovery, Data Validation, Data Cleansing, Production Support, Data Accuracy, Cloud Platforms (AWS, Azure, Google Cloud), Unix/Linux, Job Scheduling, Scripting, Automation, Database Technologies (SQL Server, Oracle, Teradata)
  • Location: Remote
  • Experience: 7

 

 

We are seeking an experienced Informatica Developer with 6 to 8 years of hands-on experience in designing, developing, and implementing data integration solutions using Informatica PowerCenter, Informatica Cloud, or Informatica Data Quality tools. The ideal candidate will have a strong background in ETL processes, data modeling, and performance optimization. The position requires immediate joining to contribute to key ongoing projects and help the team deliver high-quality data solutions.

 

 

Responsibilities:

  • Informatica ETL Development: Design, develop, test, and deploy complex ETL processes using Informatica PowerCenter or Informatica Cloud to load data from multiple sources (e.g., databases, flat files, APIs) into data warehouses or data lakes.
  • Data Integration: Work on data integration projects, involving extraction, transformation, and loading (ETL) of data from source to target systems, ensuring data accuracy and integrity.
  • Performance Tuning: Optimize ETL workflows and improve the performance of existing mappings, sessions, and workflows.
  • Troubleshooting & Support: Identify and resolve performance bottlenecks, data quality issues, and production issues in ETL processes.
  • Data Quality & Transformation: Implement data validation, cleansing, and transformation logic to ensure high-quality, accurate data output.
  • Collaboration: Work closely with business analysts, data architects, and other development teams to understand requirements and deliver effective solutions.
  • Documentation: Create technical documentation for processes, mappings, and workflows, and ensure knowledge sharing within the team.
  • Continuous Improvement: Recommend and implement improvements to existing ETL solutions, automation processes, and development practices.

 

 

Required Skills & Experience:

  • 6 to 8 years of hands-on experience in Informatica PowerCenter or Informatica Cloud.
  • Strong expertise in ETL development, data integration, and data transformation.
  • Experience with SQL for querying, optimizing, and troubleshooting data issues.
  • Proficiency in creating Informatica mappings, sessions, workflows, and sessions recovery.
  • Knowledge of Data Warehousing concepts and architecture.
  • Experience with data quality tools (e.g., Informatica Data Quality) is a plus.
  • Strong understanding of database technologies (e.g., SQL Server, Oracle, Teradata, etc.).
  • Hands-on experience with Unix/Linux for job scheduling, scripting, and automation.
  • Familiarity with cloud platforms (AWS, Azure, Google Cloud) is a plus.
  • Excellent communication skills to collaborate with cross-functional teams and present technical solutions effectively.
  • Ability to work independently and manage multiple tasks simultaneously.