Explore 1M+ Live Opportunities.
Direct applications, high-package MNC listings, and exclusive insider referrals updated daily across 50+ niches worldwide.
Live Jobs|Remote & Onsite|Apply in 1 Click
Join Our WhatsApp Job ChannelDirect applications, high-package MNC listings, and exclusive insider referrals updated daily across 50+ niches worldwide.
Hallmark Global Solutions Ltd · Princeton, New Jersey
Please strictly adhere to the following resume naming convention:ALL CAPS, NO SPACES B/T UNDERSCORESPTN_US_GBAMSREQID_CandidateBeelineIDi.e. PTN_US_9999999_SKIPJOHNSON0413Bill Rate: MAX CONFIRMED-*****/HR- *****/HR.###: Shilpa Bajpai
Princeton, NJ - Hybrid- 3 days/Week from officeDuration: 6 monthsGBaMS ReqID: 11003895Role: Informatica IICS / PowerCenter Developer - Oracle SQL & Production SupportSkills: Digital : Amazon Web Service(AWS) Cloud Computing~Master Data Management_Informatica (MDM)~Digital : Snowflake~Informatica CDI (Cloud Data Integration)~PL/SQLExperience Required: 10 & AboveDesirable Skills: Salesforce CPQ DeveloperRole Descriptions: Good communication skills hands-on experience in Oracle SQLexperience in database design and advance SQLAble to manage hands on experience in PowerCenterExpertise in to Informatica Cloud (IICS)Mostly supporting and with fixing minor isAwareness of Agile FrameworkKey Responsibilities -1. Design| develop| test| deploy| and maintain scalable ETL and data integration pipelines using Informatica IICS / IDMC and Cloud Data Integration.2. Develop and optimize mappings| mapping tasks| taskflows| reusable components| schedules| parameters| and integration workflows.3. Analyze existing Informatica PowerCenter workloads and support migration| redesign| and modernization to IICS / IDMC.4. Implement cloud data integration solutions connecting enterprise databases| applications| cloud platforms| data warehouses| and analytical platforms.5. Develop and optimize SQL and PL/SQL components required for data extraction| transformation| loading| validation| and reconciliation.6. Implement data-quality checks| validation rules| reconciliation controls| exception handling| and appropriate MDM-related integration patterns.7. Perform performance tuning of mappings| taskflows| SQL queries| database operations| and end-to-end data pipelines.8. Troubleshoot integration failures| data issues| and production incidents| perform root cause analysis| and implement permanent corrective actions.9. Collaborate with data architects| business analysts| application teams| database teams| cloud teams| QA teams| and business stakeholders to understand and deliver integration requirements.10. Support unit testing| system integration testing| regression testing| data validation| deployment| and production readiness activities.11. Follow enterprise development standards| security requirements| data governance policies| release processes| and change-management controls.12. Prepare and maintain technical specifications| source-to-target mappings| implementation documents| operational runbooks| deployment instructions| and knowledge transfer materials.Essential Skills: Additional Information for Competencies -1. Strong hands-on experience with Informatica Intelligent Cloud Services (IICS) / Informatica Data Management Cloud (IDMC) and Cloud Data Integration (CDI).2. Deep expertise in ETL and ELT development| enterprise data integration patterns| and cloud data integration solutions.3. Strong experience with Informatica PowerCenter and migration or modernization of PowerCenter workloads to IICS / IDMC.4. Strong hands-on experience developing mappings| mapping tasks| taskflows| reusable components| parameterization| and integration workflows.5. Advanced SQL and PL/SQL skills with experience developing| debugging| and optimizing complex queries| stored procedures| functions| and database objects.6. Good understanding of Data Quality| data profiling| validation| reconciliation| governance| and Master Data Management concepts.7. Experience integrating data across cloud platforms and data platforms including AWS| Azure| Snowflake| and Amazon Redshift.8. Strong understanding of source-to-target mapping| data transformation| error handling| restartability| monitoring| logging| and operational support requirements.9. Experience with performance tuning| production troubleshooting| root cause analysis| and optimization of high-volume data integration pipelines.10. Strong analytical| technical documentation| communication| mentoring| and stakeholder collaboration skills.
Details
| Company | Hallmark Global Solutions Ltd |
| Location | Princeton, New Jersey |
| Type | FULL TIME |
| Niche | Architecture and Engineering Occupations |