Informatica Consultant (GC--USC)

Posted 14 Days Ago
Be an Early Applicant
Minneapolis, MN, USA
In-Office
Junior
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop, and maintain ETL processes using Informatica and Oracle for DW/BI projects. Perform SQL/PLSQL development, query tuning, and implement ETL/ELT frameworks. Troubleshoot, optimize, and collaborate with stakeholders in a global delivery environment, with emphasis on financial domain experience.
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 related tools, including Informatica and Oracle
  • At least 2 years of experience in Software Development Life Cycle (SDLC)
  • At least 2 years hands-on experience in Design, Development & Build activities in ETL/Oracle projects
  • Knowledge of Informatica software architecture, design, best practices and troubleshooting
  • Experience creating cached resources and Data Sources in Informatica ETL domain
  • Understanding of Unix/Linux systems, file systems and shell scripting
  • Experience designing and implementing ETL/ELT frameworks for complex warehouses/marts
  • Extensive experience with Oracle SQL and PL/SQL
  • Experience with database development tools (Oracle, Toad)
  • Good 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, client interfacing skills, and strong analytical skills
  • Bachelor's degree or foreign equivalent required (or equivalent progressive experience)
  • Must be 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

CrowdStrike Logo CrowdStrike

Cryptography Engineer - Product Security, Cybersecurity (Remote)

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
10000 Employees
120K-180K Annually

MetLife Logo MetLife

Group Insurance Administrator

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
46K-46K Annually

MetLife Logo MetLife

Product Owner

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
93K-120K Annually

MetLife Logo MetLife

Senior Total AMS - Virtual - 8/17/26

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
50K-50K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account