SI

Informatica IDQ + Python

Sightspectrum
Chennai5-10 LPA Posted 17 Jun 2025
FULL TIME
Data Modeling
Etl
Data Warehousing
Informatica
Python

Job Description

We are looking for a highly motivated Informatica Developer with strong hands-on experience in ETL development and Python scripting. The ideal candidate will be responsible for building and maintaining efficient, scalable data pipelines and integrating them with business logic using Python. This is an urgent requirement, and we're looking for professionals who can join immediately or within 15 days.

Key Responsibilities:

  1. Design, develop, and implement ETL workflows using Informatica IDQ.
  2. Integrate ETL pipelines with Python-based scripts to handle business logic and custom data processing.
  3. Extract, transform, and load data from various sources (databases, flat files, APIs) into target systems.
  4. Optimize and tune ETL jobs for performance and scalability.
  5. Collaborate with data analysts, engineers, and stakeholders to understand data requirements and translate them into technical solutions.
  6. Perform data validation, unit testing, and troubleshooting of ETL pipelines and Python scripts.
  7. Ensure data quality, consistency, and integrity across different stages of the ETL lifecycle.
  8. Deploy, monitor, and maintain ETL workflows across development, QA, and production environments.
  9. Document technical specifications, processes, and best practices.

Required Skills & Qualifications:

  • 5+ years of experience in Informatica development (IDQ).
  • Strong experience in ETL development and data pipeline design.
  • Proficient in Python scripting for data manipulation, automation, and API interaction.
  • Experience in SQL and working with relational databases like Oracle, SQL Server, or PostgreSQL.
  • Good understanding of data warehousing concepts and data modeling.