Sr. Informatica Developer

Sonoma Consulting Inc.

Apply to this job
New Brunswick, NJ, us on site Until 8/21/2026 First posted February 23, 2026 Last posted February 23, 2026
Job description

Halo Group is a premier provider of IT talent. We place technology experts within
the teams of the world’s leading companies to help them build innovative
businesses that keep them one step closer to their customers and one step
ahead of the competition. We offer a meaningful work environment for
employees, attractive and interesting engagements for consultants, and cutting-edge
digital innovation for our customers.

We delight in helping our customers execute their digital vision. Big projects or
small, Halo Group knows that by combining the highest quality talent with our
unwavering support, we will become an invaluable extension of the team. Halo
Group's experienced consultants in Detroit, Atlanta and Dallas specialize in all
areas of product/project governance, UX/UI, multi-platform applications, quality
assurance/testing, cloud computing, and data analytics.

Since its inception, Halo Group has been recognized for numerous awards, including: 

- INC 5000
- Future 50
- 101 Best and Brightest
- Michigan 50 Companies to Watch
- Goldline Research - “Most Dependable Companies”
- Ernst & Young - “Entrepreneur of the Year” Finalist

-Designs, develops, modifies, configures, debugs Informatica workflows using Informatica PowerCenter and PowerExchange CDC tools
-Design technical and Business solutions in our change data capture technologies.
-Build infrastructure to extract and format captured change data and provide that data to other Informatica components and products.
-Expertise in handling data recovery, solution designing, Production implementation, Testing and support of interfaces PWC and PWX.
-Responsible for the development/customization of interfaces, conversions, and enhancements
-Analyses existing applications and systems and formulates logic for new systems, devises logic procedures, logical database design, performs coding and tests/debugs programs
-Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members
-Implements data clean-up procedures, data import/export utilities, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets
-Performs Data analysis, data mapping, data loading
-Responsible for the development and documentation of deliverables, and specifications on a project-by-project basis as defined in the IT Methodology, in collaboration with business analyst and other project team members
-Performs migration of workflows from development/Test to production environment and provide post-deployment support
-Documents all technical specifications and associate project deliverables
-Should have worked in multi-location delivery environment
-Preferred worked with multiple databases like Netezza,Oracle etc.

-Bachelor's Degree in computer science/related field or equivalent experience
-Professional Informatica certification a PLUS
-4+ years development, maintenance and enhancement experience in Informatica PowerCenter,
-3+ years of experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes
-4+ yrs. experience in Power Exchange CDC tools and should have worked extracting data from different source system like SAP, Oracle, and AS400 etc.

-Good Knowledge on DWH concepts
-Experience in developing and deploying Informatica in Unix and Oracle 11g database environment
-Experience in performance trouble shooting and remediation

** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.
This is a Full-Time / Permanent job opportunity.
Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
** All your information will be kept confidential according to EEO guidelines.

About this role

Summary

Designs, develops, modifies, and supports Informatica workflows and data integration solutions.

Job title

Sr. Informatica Developer

Experience level

4+ years

Industry

it

Location requirements

New Brunswick, NJ; remote work not specified

Salary

Not specified

Management role

No

Skills & keywords

Required skills

informaticapowercenterPowerExchange CDCdatabasesUnixOracle 11g

Preferred skills

netezzasapas400dwh

Specializations

informaticapowercenterPowerExchange CDCdatabasesetl
Locations

Structured locations inferred from the posting.

New Brunswick, NJ, USA

On-site City