Key Responsibilities:
- Design and develop scalable and reliable ETL workflows using Informatica IICS.
- Work with structured and semi-structured data from different sources and formats.
- Develop complex SQL queries for data extraction, transformation, and reporting.
- Automate data pipelines and data validation processes using Python scripting.
- Perform data quality checks, error handling, and logging.
- Collaborate with data analysts, architects, and business stakeholders to gather requirements and ensure data accuracy and consistency.
- Monitor and optimize ETL jobs and troubleshoot performance issues.
Educational Qualifications:
- bachelors or masters degree in Computer Science, Information Systems, or a related field.
Must-Have Skills:
- 5 8 years of experience in ETL/Data Integration development.
- Proficient in Informatica IICS (Application Integration, Data Integration).
- Strong command of SQL (Oracle, SQL Server, or PostgreSQL).
- Solid hands-on experience with Python scripting for automation tasks.
- Experience in data modeling, performance tuning, and troubleshooting ETL pipelines.
Good-to-Have Skills:
- Experience with REST/SOAP APIs integration using IICS or Python.
- Experience with cloud platforms (AWS) is a plus.
- Familiarity with CI/CD tools and version control (Git, Jenkins) is an advantage.
- Informatica IICS certification is a plus.
- Experience in working with data warehousing concepts and tools.
