Established in 2004, 3Core System is a certified small minority owned business providing ERP Systems Integration, AMS, IT Consulting and Staff Augmentation Services to Fortune 1000, SMB, and State, Local and Education (SLED) customers. While our System Integration services help organizations achieve digital and cloud transformation objectives, AMS Services help increase the availability of critical services of end user applications. On the other hand, our IT Consulting Services would provide subject matter experts to help you assist with specific project needs and the Staff Augmentation services help you balance workload and achieve budget parameters. >ERP System Integration Services: 3Core Systems is an SAP Silver Partner and authorized service provider offering technical architecture, application design and configuration, integration, testing, data migration and solution adoption services for solutions including SAP SuccessFactors, SAP HCM On-Premises and SAP Business Intelligence>Application Management Services (AMS): We offer post go-live, System Health Check and Optimization, Function Enhancements, Integration Monitoring, Release, and patch services. Our AMS services span across SAP Solutions including ERP (S/4 HANA), Financial Management, Human Capital Management, Data and Analytics, Supply Chain, CRM, and Customer Experince. >IT Consulting and Staffing Augmentation Services: Ever since its inception, 3Core Systems has been offering IT Consulting and Staff Augmentation solutions including temporary, long-term, project based and contract staffing services that could be personalized based on your needs. Our staffing services span across emerging technologies and legacy solutions including but not limited to Artificial Intelligence, Machine Learning, Data Science, Cloud, ERP, CRM, BI/BW/ETL, Database, Web & E-Commerce, UI/UX, Network & Security and Mobile.

Job description

Role: INFORMATICA LEAD
Location: Remote - Travel On-Site to MIAMI, FL When Needed
Duration: 12 + Month Contract

Informatica Intelligent Data Consultant Lead (IDMC)

As the Informatica Intelligent Data Consultant Lead, you will spearhead the migration from the legacy Informatica PowerCenter to Informatica IDMC, a modern cloud-based data management platform. Your role will involve managing the transition of ETL workflows, data mappings, transformations, and operational processes to the cloud, enhancing scalability, performance, and agility, while reducing infrastructure overhead.

Responsibilities:

Utilize Informatica Cloud Data Integration (CDI) Migration Utility for automated conversion.
Recreate or refactor complex mappings and transformations in IDMC.
Establish cloud connectivity and data pipelines
Take Inventory existing PowerCenter assets (workflows, mappings, transformations).
Identify dependencies and evaluate cloud compatibility.
Define migration strategy (Lift & Shift vs. Optimization).
Perform unit testing on migrated workflows.
Optimize performance for cloud execution.
Ensure security & compliance in the new environment.
Transition workloads to production in IDMC.
Monitor and fine-tune jobs using IDMC Operational Insights.
Train users on the new cloud-based interface.