ETL Informatica Support Lead

Sonsoft Inc

Apply to this job
Madison, NJ, us on site Until 8/22/2026 H-1B sponsor history First posted February 26, 2026 Last posted February 26, 2026
Job description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

  • Extensive 8.6 or Higher Version- Informatica PowerCenter Technical Experience
  • Extensive Experience in Teradata - SQL Queries, Bteq,Jobs Development ,Export Utilities, Jobs Debugging
  • Exposure to MSTR/Tableau. Exposure to MDM
  • We need someone who is HANDS-ON
  • Architectural Design and Data Modelling Experience
  • Experience in Data Profiling
  • Experience in writing and executing Data Quality Rules against Datasets
  • Single point of contact for overall solution/program - technically.
  • Manage Global Delivery structure
  • Status Reporting Periodic to Clients/Stakeholders
  • Incident Management
  • Experience in Implementing Best Practices of ETL Projects
  • Resolve the issues when the Infomatica PowerCenter server is down.
  • Support DR activities for Informatica PowerCenter
  • Support Informatica PowerCenter code migration/deployment activities into Production.
  • Automation Experience in ETL Support Projects
  • Extensive Experience in Jobs Monitoring and debugging of failed Jobs
  • Work Experience in Third Party Schedulers like Autosys, TWS, etc
  • Experience in detailed investigation of long running jobs and provide suggestions

  • Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
  • At least 4 years of experience with Java technologies.

**U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Note:-

  1. This is a Fulltime job oppurtunity.
  2. Only US CitizenGreen Card HolderGC-EADH4-EADL2-EADTN VIsa can apply.
  3. No H1-B  & OPT is applicable for this position.
  4. Please mention your email id in your email or resume.
About this role

Summary

Lead ETL support, manage projects, troubleshoot Informatica PowerCenter, and collaborate with teams.

Job title

ETL Informatica Support Lead

Experience level

4+ years

Industry

software

Location requirements

Madison, NJ, USA; remote not allowed

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

Yes

Skills & keywords

Required skills

Informatica PowerCenterTeradataSQLJavaincident management

Preferred skills

Data profilingData modelingData quality rulesthird party schedulersautomation

Specializations

ETLInformatica PowerCenterTeradataData Quality
Locations

Structured locations inferred from the posting.

Madison, NJ, USA

On-site City