What are the responsibilities and job description for the Informatica Lead - ETL , PowerCenter, IICS position at ALIS Software?
JOB DESCRIPTION
POSITION: Informatica Developer - ETL , PowerCenter, IICS
DURATION: Long term
Location: Branchville, NJ - Onsite
Job Description
DURATION: Long term
Location: Branchville, NJ - Onsite
Job Description
Roles & Responsibilities
- 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.
- Author and tune complex SQL queries, analyze execution plans, optimize joins /index usage, and implement set‑based transformations for performance and scalability.
- Work with BAs to profile source data, define transformation logic, and validate outputs against business rules.
- Partner with Application and Enterprise Architects to review low‑level designs and ensure alignment with high‑level data flow and governance standards.
- Lead troubleshooting, root‑cause analysis, & remediation for production incidents; implement preventive fixes & runbooks.
- Coach developers on Informatica best practices, coding standards, unit testing, and performance tuning.
- Maintain detailed technical documentation for mappings, data models, interfaces, and downstream integrations.
- Assist product owners and project managers in prioritizing enhancements, new development, and maintenance; estimate effort and contribute to release planning.
- Assess ELT/modern data platforms (Databricks preferred), automation, and orchestration tools for fit and adoption.
- Surface technical risks, propose mitigation strategies, & communicate status to technical & business stakeholders.
- 7 years of experience leading developing Data Warehouse, data integration, or data engineering projects.
- Proven leadership: history of owning deliverables and guiding teams to complete complex, time‑boxed projects.
- Strong Informatica expertise: extensive 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.
- Dimensional and normalized modeling, star/snowflake schemas, and metadata management.
- Experience with ELT and modern stacks: Databricks or INFROMATICA platforms preferred.
- Solid troubleshooting skills for production support, performance issues, and data quality problems.
- Able to explain technical tradeoffs to business stakeholders and produce clear documentation.
- Customer‑focused with the ability to balance urgent fixes and long‑term architecture.