Informatica Consultant (GC-EAD,Gc,USC)

Sonsoft Inc

Apply to this job
Jersey City, NJ, us on site Until 8/21/2026 H-1B sponsor history First posted February 23, 2026 Last posted February 23, 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.

• At least 2 years of experience with DW/BI and related tools, understanding of Informatica as ETL and Oracle technology
• At least 2 years of experience in Software development life cycle
• At least 2 years of experience in DW/BI related technologies and Informatica as ETL - MUST
• At least 2 years of experience in Project life cycle activities on DW/BI development and maintenance projects
• At least 2 years of hands on experience in Design, Development & Build activities in ETL/Oracle Project
• Knowledge of Informatica Software Architecture, Design, Best Practices and troubleshooting
• Knowledge in creating cached resources and Data Sources in Informatica ETL Domain
• Understanding of Unix/Linux system, file systems, shell scripting
• Experience with design and implementation of ETL/ELT framework for complex warehouses/marts
• Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
• Ability to work in team in diverse/ multiple stakeholder environment
• Extensive Experience in Oracle SQL, PL/SQL.
• Good experience with database development tools (Oracle, Toad)
• Good understanding partitioning, indexes, Bitmap indexes, triggers, materialized views.
• Good experience in Query tuning, reading explain plans.
• Experience in Financial domain
• Ability to work in team environment and client interfacing skills.
• Strong analytical skills
• Experience and desire to work in a Global delivery environment

Basic Qualifications :-
• 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 2 years of experience within the Information 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 FULL TIME job oppurtunity.
  2. Only US CitizenGreen Card HolderGC-EADH4-EADL2-EADTN VIsa can apply.
  3. No OPT-EAD & H1-B for this position.
  4. Please mention your Visa Status in your email or resume.
About this role

Summary

Develop and maintain ETL processes using Informatica and Oracle in a DW/BI environment

Job title

Informatica Consultant (GC-EAD,Gc,USC)

Experience level

2+ years

Industry

software

Location requirements

Jersey City, NJ, US; remote not specified

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

No

Skills & keywords

Required skills

DW/BIInformaticaETLOracleUnix/Linuxshell scriptingSQLPL/SQLdatabase development

Preferred skills

Data warehousingquery tuningpartitioningindexestriggersmaterialized viewsfinancial domain

Specializations

ETLInformaticaOracleDW/BISQL
Locations

Structured locations inferred from the posting.

Jersey City, NJ, USA

On-site City