Job ID: JOB_ID_2894
Job Overview
HMG America LLC is seeking an experienced Informatica IICS Consultant for a hybrid role based in Orlando, FL. This is a contract position with a duration of 6-12 months, requiring local candidates only. The consultant will play a pivotal role in shaping our data integration strategy, focusing on leveraging Informatica PowerCenter and CDI to design and develop robust data integration solutions within a cloud environment.
Key Responsibilities
- Develop, enhance, and maintain ETL processes using Informatica PowerCenter and Informatica Cloud Data Integration (CDI).
- Lead or contribute to migration efforts from PowerCenter to IDMC/CDI.
- Integrate data across various platforms including Oracle, SQL Server, and Snowflake.
- Leverage REST APIs within IDMC CDI to connect with internal and external applications and systems.
- Collaborate with business and technical teams to understand data requirements and translate them into effective integration solutions.
- Analyze complex source-to-target mappings and resolve data integration challenges independently.
- Troubleshoot and optimize data workflows for issue resolution, performance, and scalability in a cloud environment.
- Develop and maintain SQL queries and Unix scripts as part of data workflows and automation.
- Document ETL processes, data flows, and system integrations effectively.
Required Qualifications
- 5+ years of hands-on experience with Informatica PowerCenter.
- 3+ years of experience with Informatica Cloud Data Integration (CDI).
- Experience with IDMC migration projects is a strong plus.
- Strong understanding of ETL architecture, data modeling concepts, and data warehousing best practices.
- Proficiency in SQL (complex queries, optimization) and scripting.
- Ability to work independently with minimal supervision in a fast-paced environment.
- Excellent problem-solving skills and a proactive attitude toward learning and development.
Preferred Qualifications
- Experience with Informatica Data Management Cloud Services (IDMC), Data Quality (IDQ), or other IDMC components.
- Exposure to cloud platforms such as AWS, Azure, or GCP.
- Familiarity with job scheduling tools (e.g., Control-M, Autosys).
- Good communication and interpersonal skills to interact with cross-functional teams.
Job Details
- Location: Orlando, FL (3 days a week onsite)
- Duration: 6-12 months
- Experience: 10+ years
- Employment Type: Contract
Client Requirement
NEED LOCAL ONLY
Special Requirements
Local candidates only
Compensation & Location
Salary: $65 – $95 per year (Estimated)
Location: Orlando, FL
Recruiter / Company – Contact Information
Recruiter / Employer: HMG America LLC
Email: harman@hmgamerica.co
Recruiter Notice:
To remove this job posting, please send an email from
harman@hmgamerica.co with the subject:
DELETE_JOB_ID_2894