What are the responsibilities and job description for the Informatica Developer position at InfiCare Staffing?
This position requires five days per week onsite in Branchville, NJ. We are seeking a consultant who is local to New Jersey or nearby.
Key Responsibilities
- Databricks
- Lead hands‑on development and support of new and existing data integration applications using Informatica (PowerCenter, IICS, or equivalent), owning 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: partner with Application and Enterprise Architects to review low‑level designs and ensure alignment with high‑level data flow and governance standards.
- Production support and incident management: lead troubleshooting, root‑cause analysis, and remediation for production incidents; implement preventive fixes and runbooks.
- Mentorship and technical guidance: coach developers on Informatica best practices, coding standards, unit testing, and performance tuning.
- Documentation and knowledge transfer: maintain detailed technical documentation for mappings, data models, interfaces, and downstream integrations.
- Prioritization and planning: assist product owners and project managers in prioritizing enhancements, new development, and maintenance; estimate effort and contribute to release planning.
- Evaluate new technologies: assess ELT/modern data platforms (Databricks preferred), automation, and orchestration tools for fit and adoption.
- Risk escalation and stakeholder communication: surface technical risks, propose mitigation strategies, and communicate status to technical and business stakeholders.
Must Have:
- PowerCenter
- IICS
- IDMC,
- SQL
- SCD2 logic
- Agile
- Power BI reporting
- Data Warehouse /Data Mart