Informatica Consultant (GC-EAD,GC,USC)

Reposted 23 Days Ago
Be an Early Applicant
Jersey City, NJ, USA
In-Office
Junior
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop, and maintain DW/BI ETL solutions using Informatica and Oracle. Build ETL/ELT frameworks, write and tune Oracle SQL/PLSQL, perform query tuning and explain plan analysis, work with Unix/Linux shell scripting, and support project lifecycle and client interactions in a global delivery environment.
Summary Generated by Built In
Company 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.

Job Description

Job Description:-

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

Qualifications

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.

Additional Information

** 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.

Skills Required

  • At least 2 years of experience with DW/BI and 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
  • At least 2 years of project lifecycle experience on DW/BI development and maintenance projects
  • Hands-on experience in design, development and build activities in ETL/Oracle projects
  • 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 systems, file systems, and shell scripting
  • Experience with design and implementation of ETL/ELT frameworks for complex warehouses/marts
  • Extensive experience in Oracle SQL and PL/SQL
  • Experience with database development tools (Oracle, Toad)
  • Understanding of partitioning, indexes, bitmap indexes, triggers, and materialized views
  • Experience in query tuning and reading explain plans
  • Experience in the Financial domain
  • Ability to work in team environment and client interfacing skills
  • Strong analytical skills
  • Desire to work in a global delivery environment
  • Bachelor's degree or foreign equivalent (or 3 years progressive experience per year of education waived)
  • At least 2 years of experience within Information Technologies
  • Authorized to work in the U.S.; employer unable to sponsor visas
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

SonSoft Inc. Logo SonSoft Inc.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
Jersey City, NJ, USA
87 Employees

Toast Logo Toast

Account Executive

Cloud • Fintech • Food • Information Technology • Software • Hospitality
In-Office
Toms River, NJ, USA
5000 Employees
128K-205K Annually
Hybrid
2 Locations
289097 Employees
Hybrid
4 Locations
289097 Employees

Similar Companies Hiring

Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees
Revel.io Thumbnail
Aerospace • Hardware • Robotics • Software
US
50 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account