Informatica Developer

Location: Bengaluru

Job Description
We are looking for a skilled  Informatica Developer  to design, develop, and maintain  ETL workflows  for enterprise data integration projects. The ideal candidate will have experience in  Informatica Power Center / Cloud ,  ETL development ,  SQL , and working with  data warehouses  or cloud platforms.

Key Responsibilities
ETL Development :
Design, develop, and maintain  ETL mappings, workflows, and sessions  in  Informatica Power Center or Informatica Cloud .
Implement  data extraction, transformation, and loading  from multiple sources to target systems (Data Warehouse, Data Lake, or cloud platforms).
Data Validation & Quality :
Perform  source-to-target data validation  to ensure data integrity and accuracy.
Implement  error handling and exception management  in ETL workflows.
Generate and review  data quality reports  and reconcile data discrepancies.
Database Interaction :
Write and optimize  SQL queries, views, and stored procedures  for data extraction and validation.
Perform  database performance tuning  as required for large-scale ETL operations.
Collaboration & Documentation :
Collaborate with  Data Architects, Business Analysts, and QA teams  to understand requirements and design ETL solutions.
Maintain proper  documentation for ETL mappings, transformations, workflows, and processes .
Deployment & Support :
Support deployment of ETL workflows across  Dev, QA, and Production environments .
Assist in  production support and issue resolution  for ETL jobs.
Cloud Integration (Optional) :
Work with cloud platforms like  Azure ,  AWS , or  Snowflake  if ETL workflows are deployed in cloud environments.