Information Developer

Hi Folk,

, If you are interested with the below role than please reply back with updated resume and contact details.

Role: Informatica Developer

Location: Branchville, NJ – Onsite

Type: Contract

Duration: Long term

Must have : Local to NJ

Primary skills:

 Strong communicator who can coordinate on hybrid team directly with stakeholders

 PowerCenter/CDIPC (legacy ETL – large codebase)

 IDMC/IICS

 SQL

 Data modeling

Secondary skills:

 Databricks/Pyspark (long term ETL vision)

 PowerBI (long term reporting vision)

 Cognos (legacy reporting)

 SSIS (legacy ETL small code base)

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.