Sr. Informatica Developer

Sonoma Consulting Inc.

New Brunswick (NJ)

On-site

USD 85,000 - 110,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

A leading consulting firm is seeking a skilled Informatica Developer to design and develop workflows using Informatica PowerCenter. Ideal candidates should have 4+ years of experience in Informatica development and a strong background in data analysis and mapping. This is a full-time position based in New Jersey, and only U.S. citizens and authorized workers can apply. Strong proficiency in various databases and troubleshooting performance issues is required.

Qualifications

  • 4+ years development and enhancement experience in Informatica PowerCenter.
  • 3+ years of experience in developing Informatica Mappings and Work-flows.
  • Experience in performance trouble shooting and remediation.

Responsibilities

  • Design and develop Informatica workflows using Informatica PowerCenter.
  • Implement data clean-up procedures, transformations and execute test plans.
  • Responsible for documentation of project specifications and deliverables.

Skills

Informatica PowerCenter
Data analysis
SQL proficiency
Data mapping
Data loading

Education

Bachelor's Degree in computer science or related field
Professional Informatica certification

Tools

PowerExchange CDC
Unix
Oracle 11g

Job description

Overview
Job Description
  • 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.
Qualifications
  • 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
Additional Information

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Informatica Developer
Informatica Developer

Ethereum Technologies LLC • Atlanta (GA)

On-site
USD 110,000 - 150,000
Informatica Developer
Informatica Developer

Quantum Technologies LLC • Atlanta (GA)

On-site
USD 90,000 - 130,000
Informatica Developer
Informatica Developer

Valiant Technologies LLC • Atlanta (GA)

On-site
USD 120,000 - 160,000
Remote Informatica PowerCenter ETL Developer
Remote Informatica PowerCenter ETL Developer

AHU Technologies Inc. • United States

Remote
USD 80,000 - 120,000
ETL Engineer
ETL Engineer

Quantum Technologies LLC • Columbia (SC)

On-site
USD 110,000 - 140,000
informatica
informatica

Eros Technologies Inc. • King of Prussia (PA)

On-site
USD 95,000 - 135,000
Informatica Developer
Informatica Developer

TechDigital Group • Purchase (NY)

On-site
USD 120,000 - 150,000
Informatica Developer - Bloomington, IL
Informatica Developer - Bloomington, IL

AHU Technologies Inc. • United States

Remote
USD 120,000 - 170,000
Informatica( Lead)
Informatica( Lead)

Sonsoft Inc • Moline (IL)

On-site
USD 80,000 - 100,000
ETL Developer - Informatica PowerCenter & Automation
ETL Developer - Informatica PowerCenter & Automation

Compunnel Inc. • Charlotte (NC)

Hybrid
USD 90,000 - 120,000