What are the responsibilities and job description for the Informatica IDMC Admin position at Smart IT Frame LLC?
Role: Informatica IDMC Admin
Location: Raritan, NJ
We are looking for an experienced Informatica IDMC Developer (5 yrs) to design, develop, and support cloud-based data integration solutions.
Key Responsibilities:
- Build and maintain ETL/ELT pipelines using Informatica IDMC/IICS
- Develop mappings, task flows, and reusable components
- Integrate data from cloud and on-prem sources (databases, APIs, files)
- Optimize workflows for performance, scalability, and reliability
- Troubleshoot job failures, data quality, and connectivity issues
- Collaborate with stakeholders to translate requirements into technical solutions
- Prepare technical documentation and participate in code reviews and releases
Required Skills:
- Hands-on Informatica IDMC/IICS (CDI; CAI/CDQ is a plus)
- Strong SQL and relational database knowledge (Oracle, SQL Server, Snowflake)
- Data warehousing, data modelling, and cloud integration expertise
- Cloud platform experience (AWS, Azure, GCP)