Search Jobs
Informatica IICS Powercenter / Data integration Branchville, NJ
|
NJ-23, Branchville, NJ, USA ESR Healthcare Informatica IICS Powercenter / Data integration Branchville, NJ (Short Hills, NJ by Oct/Nov) - Need locals Here is the JD: Key Responsibilities - Hands-on development and support of new and existing data integration applications using Informatica (PowerCenter, IICS, or equivalent), with a strong focus on code quality, deployments, and operational stability. - Informatica coding and implementation: design and build mappings, mapplets, reusable transformations, workflows, sessions, parameter files, and deployment artifacts; implement error handling, logging, and restartability. - SQL analysis and optimization: author and tune complex SQL queries, analyze execution plans, optimize joins/index usage, and implement set-based transformations for performance and scalability. - Translate business requirements into data solutions: work with business analysts to profile source data, define transformation logic, and validate outputs against business rules. - Architectural collaboration: work closely with Application and Enterprise Architects to implement low-level designs aligned with established data flow and governance standards. - Production support and incident management: troubleshoot production issues, perform root-cause analysis, and implement fixes to ensure data pipeline reliability and performance. - Code quality and standards: follow established coding standards, participate in code reviews, and ensure maintainable and reusable development practices. - Documentation and knowledge transfer: maintain clear and detailed technical documentation for mappings, data models, interfaces, and downstream integrations. - Prioritization and execution: work with product owners and project managers to deliver enhancements, new development, and maintenance tasks within defined timelines. - Exposure to modern platforms: contribute to initiatives involving ELT/modern data platforms (Databricks preferred), automation, and orchestration tools. - Stakeholder communication: provide regular updates on development progress, risks, and blockers to technical and business stakeholders. Required Qualifications - 5–8+ years of hands-on experience developing Data Warehouse, data integration, or data engineering solutions. - Strong Informatica expertise: experience building and maintaining mappings, workflows, parameterization, reusable components, and deployment packages. - Advanced SQL skills: ability to write, profile, and optimize complex SQL; experience with query tuning, indexing strategies, and analyzing execution plans. - Data modeling knowledge: understanding of dimensional and normalized modeling, including star/snowflake schemas. - Experience with ELT and modern stacks: exposure to Databricks or INFORMATICA platforms preferred. - Strong troubleshooting skills for production support, performance issues, and data quality problems. - Good communication skills: able to work effectively with technical teams and business stakeholders and contribute to clear documentation. .. |
Report / Flag this Job Ad
Tags :
Informatica
IICS
Powercenter
/
Data
integration
Branchville,
NJ
Informatica United States Of America
IICS United States Of America
Powercenter United States Of America
/ United States Of America
Data United States Of America
integration United States Of America
Branchville, United States Of America
NJ United States Of America
More Jobs
Informatica IICS Powercenter / Data integration Branchville, NJ
NJ-23, Branchville, NJ, USA ESR Healthcare Informatica IICS Powerce
MySQL DBA (Database Administrator) framingham, MA (Onsite)
Framingham, MA, USA ESR Healthcare MySQL DBA (Database Administrato
EV Battery Pack Lead Engineer Foster City, CA ( Need locals)
Foster City, CA ESR Healthcare EV Battery Pack Lead Engineer Foster
Cyber Security Analyst (Alps Alpine) Detroit, MI
Detroit, MI, USA ESR Healthcare Cyber Security Analyst (Alps Alpine