Information Delivery & Visualization Engineer

Job Description:

We are seeking skilled and experienced Informatica IICS Developer with strong SQL expertise and hands-on experience in building and maintaining Reconciliation (Recon) Frameworks. The ideal candidate will be responsible for designing, developing, testing, and deploying scalable data integration solutions using Informatica IICS (Cloud Data Integration), while ensuring data quality, consistency, and reconciliation across systems.

Key Responsibilities:

• Design, develop, and implement end-to-end data integration workflows using Informatica IICS (Cloud Data Integration and Application Integration).
• Develop and maintain reconciliation frameworks to ensure data completeness, consistency, and traceability across source and target systems.
• Write and optimize complex SQL queries, stored procedures, and scripts for data extraction, transformation, and validation.
• Perform data profiling and quality analysis to identify data discrepancies and develop reconciliation logic.
• Design data flow diagrams and technical specifications based on business requirements.
• Implement error handling, logging, and exception management within IICS jobs.
• Schedule and monitor data integration jobs using IICS and external scheduling tools.
• Collaborate with data architects, business analysts, and stakeholders to understand integration requirements.
• Ensure compliance with enterprise data governance and security standards.
• Document technical design, workflows, and reconciliation logic for ongoing maintenance and audit purposes.

Required Skills & Experience: Informatica

• 10+ years of experience in ETL development with a minimum of 3 years in Informatica IICS –Informatica Sr
• Strong expertise in SQL (Oracle, SQL Server, or Snowflake), including performance tuning and query optimization.
• Proven experience in designing and implementing Reconciliation Frameworks using Informatica or equivalent tools.
• Good understanding of data warehousing concepts, data modeling, and data quality principles.
• Experience in handling large volumes of data and building scalable, performance-optimized pipelines.
• Familiarity with CI/CD tools, Git, and Agile/Scrum methodologies.
• Strong problem-solving skills, attention to detail, and the ability to work independently and guide a small team of informatica/SQL developers.
• 5+ years of experience in ETL development with a minimum of 1- 2 years in Informatica IICS –Informatica Jr
• Expertise in SQL queries including performance tuning and query optimization.
• Proven experience in working with Reconciliation Frameworks using Informatica or equivalent tools.
• Good understanding of data warehousing concepts, data modeling, and data quality principles.
• Experience in handling large volumes of data and building scalable, performance-optimized pipelines.
• Familiarity with CI/CD tools, Git, and Agile/Scrum methodologies.
• Strong problem-solving skills, attention to detail, and the ability to work independently.

Soft Skills:

• Strong communication and documentation skills.
• Ability to engage with both technical and non-technical stakeholders.
• Analytical mindset with a strong focus on data accuracy and quality.