Informatica Consultant with IICS & IDMC
Posted 2 days ago by ECLAT Integrated Software Solutions, Inc.
Negotiable
Undetermined
Remote
Remote or Texas
Summary: The Informatica Consultant role focuses on leading the design, development, and deployment of enterprise-scale data integration solutions using Informatica tools. The consultant will be responsible for end-to-end ETL solution delivery and will collaborate with various teams to ensure effective data management. Strong hands-on expertise in Informatica PowerCenter, IICS, IDMC, and related technologies is essential. The position is remote, allowing for flexibility in work arrangements.
Key Responsibilities:
- Lead end-to-end ETL solution delivery, including requirement analysis, design, development, deployment, and support.
- Serve as the technical lead for Informatica initiatives and mentor ETL developers.
- Coordinate with business analysts, architects, DBAs, and cross-functional teams.
- Perform design and code reviews to ensure best practices and standards are followed.
- Collaborate with business and analytics teams to understand data requirements and source-to-target mappings.
- Design scalable, high-performance ETL architectures and workflows.
- Define error handling, logging, reconciliation, and audit mechanisms.
- Prepare and review technical design documents and mapping specifications.
- Develop and optimize ETL mappings, workflows, and sessions using Informatica PowerCenter, IICS and IDMC.
- Implement complex transformations, lookups, aggregations, and incremental loads.
- Tune ETL processes for performance and scalability.
- Develop Unix shell scripts for automation, monitoring, and file handling.
Key Skills:
- Strong hands-on expertise with Informatica PowerCenter, IICS, and IDMC.
- Experience with Unix, Autosys, and Oracle.
- Proficient in ETL design, development, and deployment.
- Ability to perform requirements analysis and technical design.
- Strong mentoring and leadership skills.
- Excellent collaboration and communication skills.
- Experience in developing Unix shell scripts.
- Knowledge of performance tuning and optimization techniques.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Role: Informatica Consultant with IICS & IDMC
Duration: 6+ Months
Location: Remote
Description:
ETL Informatica Consultant to lead the design, development, and deployment of enterprise-scale data integration solutions. The ideal candidate will have strong hands-on expertise with Informatica PowerCenter, Informatica Intelligent Cloud Services, Informatica Intelligent Data Management Cloud (IDMC), Unix, Autosys, and Oracle, and will play a key role in requirements analysis, technical design, development, testing, deployment, and production support.
Key Responsibilities
- Lead end-to-end ETL solution delivery, including requirement analysis, design, development, deployment, and support.
- Serve as the technical lead for Informatica initiatives and mentor ETL developers.
- Coordinate with business analysts, architects, DBAs, and cross-functional teams.
- Perform design and code reviews to ensure best practices and standards are followed.
Requirements & Design
- Collaborate with business and analytics teams to understand data requirements and source-to-target mappings.
- Design scalable, high-performance ETL architectures and workflows.
- Define error handling, logging, reconciliation, and audit mechanisms.
- Prepare and review technical design documents and mapping specifications.
Development
- Develop and optimize ETL mappings, workflows, and sessions using Informatica PowerCenter, IICS and IDMC.
- Implement complex transformations, lookups, aggregations, and incremental loads.
- Tune ETL processes for performance and scalability.
- Develop Unix shell scripts for automation, monitoring, and file handling.