Informatica Developer contract C2C jobs Branchville, NJ – Onsite

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.