Dice is the leading career destination for tech experts at every stage of their careers. Our client, InfiCare Technologies, is seeking the following. Apply via Dice today!<br><br><strong>Position: Lead Informatica Power Center Developer<br><br></strong><strong>Location- Branchville, NJ<br><br></strong><strong>Duration: Long term Contract<br><br></strong><strong>Work Mode: Five Days onsite <br><br></strong><strong>Primary skills:<br><br></strong><ul><li>Strong communicator who can coordinate on hybrid team directly with stakeholders</li><li>PowerCenter/CDIPC (legacy ETL – large codebase)</li><li>IDMC/IICS</li><li>SQL</li><li>Data modeling<br><br></li></ul><strong>Secondary skills:<br><br></strong><ul><li>Databricks/Pyspark (long term ETL vision)</li><li>Power BI (long term reporting vision)</li><li>Cognos (legacy reporting)</li><li>SSIS (legacy ETL small code base)<br><br></li></ul><strong>Required Qualifications<br><br></strong><ul><li>Must have a Lead hands‑on development and support</li><li>Min Ten+ years of experience leading and/or hands‑on developing Data Warehouse, data integration, or data engineering projects.</li><li>Responsible for unit, integration, regression, and user acceptance testing.</li><li>Proven leadership: history of owning deliverables and guiding teams to complete complex, time‑boxed projects.</li><li>Strong Informatica expertise: extensive experience building and maintaining mappings, workflows, parameterization, reusable components, and deployment packages.</li><li>Advanced SQL skills: ability to write, profile, and optimize complex SQL; experience with query tuning, indexing strategies, and analyzing execution plans.</li><li>Data modeling knowledge: dimensional and normalized modeling, star/snowflake schemas, and metadata management.</li><li>Experience with ELT and modern stacks: Databricks or INFROMATICA platforms preferred.</li><li>Solid troubleshooting skills for production support, performance issues, and data quality problems.</li><li>Excellent communication skills: able to explain technical tradeoffs to business stakeholders and produce clear documentation.</li></ul>