Informatica Developer

Department: Software
Project Location(s): Bengaluru, Karnataka,India
Education: Bachelor of Engineering

Responsibilities

 

  • Designing, developing, and maintaining ETL processes using Informatica PowerCenter or Informatica Cloud.
  • Collaborating with business analysts and data architects to understand data requirements and translate them into technical specifications.
  • Creating and maintaining documentation related to ETL processes, data mappings, and data lineage.
  • Performing data profiling and data quality analysis to ensure data accuracy and completeness.
  • Troubleshooting ETL job failures and performance issues.
  • Implementing best practices for data integration, data quality, and data governance.
  • Working with cross-functional teams to integrate data from multiple sources into a data warehouse or data lake.
  • Participating in code reviews and ensuring adherence to coding standards.
  • Keeping up-to-date with Informatica product updates and industry trends.
  • Providing technical support and training to end-users and other team members.
  •  

Skills/Experience

 

  • Proficiency in Informatica PowerCenter or Informatica Cloud.
  • Strong understanding of data warehousing concepts and ETL (Extract, Transform, Load) processes.
  • Experience with relational databases such as Oracle, SQL Server, or MySQL.
  • Knowledge of SQL and database querying tools.
  • Familiarity with data modeling and data integration techniques.
  • Understanding of data quality and data governance principles.
  • Experience with performance tuning and optimization of ETL processes.
  • Knowledge of scripting languages such as Shell scripting or Python.
  • Familiarity with version control systems and deployment processes.
  • Strong analytical and problem-solving skills.
  • Excellent communication and teamwork skills.