Job Description
Informatica Developer- IICS at ALIS Software LLC Informatica Developer- IICS at ALIS Software LLC in Branchville, New Jersey Posted in 1 day ago.
Type:
full-time Job Description:
Role:
Informatica Developer Duration:
Long term Type:
Contract Location:
Branchville, NJ - Onsite Job Descripti onRoles & Responsibiliti esLead hands?on development and support of new and existing data integration applications using Informatica (PowerCenter, II CS, or equivalent), owning code quality, deployments, and operational stabilit y.
Informatica coding and implementation: design and build mappings, mapplets, reusable transformations, workflows, sessions, parameter files, and deployment artifacts; implement error handling, logging, and restartabilit y.
Author and tune complex SQL queries, analyze execution plans, optimize joins /index usage, and implement set?based transformations for performance and scalabilit y.
Work with BAs to profile source data, define transformation logic, and validate outputs against business rule s.
Partner with Application and Enterprise Architects to review low?level designs and ensure alignment with high?level data flow and governance standard s.
Lead troubleshooting, root?cause analysis, & remediation for production incidents; implement preventive fixes & runbook s.
Coach developers on Informatica best practices, coding standards, unit testing, and performance tunin g.
Maintain detailed technical documentation for mappings, data models, interfaces, and downstream integration s.
Assist product owners and project managers in prioritizing enhancements, new development, and maintenance; estimate effort and contribute to release plannin g.
Assess ELT/modern data platforms (Databricks preferred), automation, and orchestration tools for fit and adoptio n.
Surface technical risks, propose mitigation strategies, & communicate status to technical & business stakeholder s.7+ years of experience leading developing Data Warehouse, data integration, or data engineering project s.
Proven leadership: history of owning deliverables and guiding teams to complete complex, time?boxed project s.
Strong Informatica expertise: extensive experience building and maintaining mappings, workflows, parameterization, reusable components, and deployment package s.
Advanced SQL skills: ability to write, profile, and optimize complex SQL; experience with query tuning, indexing strategies, and analyzing execution plan s.
Dimensional and normalized modeling, star/snowflake schemas, and metadata managemen t.
Experience wit h E LT and modern stacks : Databricks or INFROMATIC A
platforms preferre d.
Solid troubleshooting skills for production support, performance issues, and data quality problem s.
Able to explain technical tradeoffs to business stakeholders and produce clear documentatio n.
Customer?focused with the ability to balance urgent fixes and long?term architectur e.