Informatica Developer - IICS


ALIS Software
Dice Job Match Score™
✨ Finding the perfect fit...
Job Details
Skills
- (PowerCenter
- IICS
- or equivalent)
- owning code quality
- deployments
- and operational stability.
- ELT/modern data platforms (Databricks preferred)
- automation
- and orchestration
Summary
DURATION: Long term
Location: Branchville, NJ - Onsite
Job Description
- 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.
- Dice Id: 90709585
- Position Id: 8908439
- Posted 2 days ago
Company Info
ALIS specializes in Data Management and Data Analytics solutions to enable business transformation. We leverage our expertise and deep technical background to create comprehensive IT strategies, for a digital and technological transformation.
We offer services like Strategy Development, Solution Implementation and Operation & Support in three different engagement models – Consulting, Managed Services, and IT Staffing. We are headquartered in Austin, TX and having an offshore delivery center in India.
ALIS was established in 2014. Our leadership team is empowered with decades of experience in delivering enterprise solutions. Our team of experts has experience across multiple industries including banking, healthcare, insurance, manufacturing industries, and more.
Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs