Informatica IICS Developer

Overview

On Site
$100,000 - $115,000
Full Time

Skills

Cloud Computing
Data Warehouse
Data-flow Diagrams
Data Governance
Data Integration
Continuous Integration
Data Extraction
Data Modeling
Auditing
Informatica
Continuous Delivery
Conflict Resolution
Data Quality
Problem Solving
Extract
Transform
Load
Git
Collaboration
PL/SQL
Data Profiling
Documentation
Quality Assurance

Job Details

Role - UI Developer

Location - Mclean VA

FULLTIME with Hexaware

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

8+ 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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.