ETL ,Informatica Consultant

Reposted 19 Days Ago
Be an Early Applicant
Minneapolis, MN, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop, and maintain ETL solutions using Informatica and Oracle. Produce technical designs (HLD/DLD), mappings, and code; perform performance tuning, CDC, UDFs, testing (SIT/UAT), production rollout and post-implementation support. Collaborate across on/offshore teams in financial-domain DW/BI projects.
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

Preferred
• At least 4 years of experience in Software development life cycle
• At least 4 years of experience in DW/BI related technologies and Informatica ETL tool – MUST
• At least 4 years of experience in Project life cycle activities on DW/BI development and maintenance projects
• At least 3 years of experience in Oracle Databases
• At least 3 years of hands on experience in Design, Development & Build activities in Informatica and Oracle Projects
• At least 3 years of experience in Design and Architecture review
• At least 2 years of experience with Unix Scripting
• Knowledge of Informatica Architecture, Projection Design, ETL flow, advanced SQLs
• Knowledge of data loading techniques using Informatica tool.
• Knowledge Best Practices in Informatica, Performance improvements, implementing CDC, UDFs
• Understand Requirements and Functional Design.
• Complete Technical Design – (DLD/HLD).
• Create mapping documents for data elements.
• Complete coding and ability to analyze and fix Technical Design and Coding Defects.
• Provide System Integration Testing and User Acceptance Testing Support
• Production Rollout, Implementation Validation and Post Implementation support.
• Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
• Ability to work in team in diverse/ multiple stakeholder environment
• Experience in Financial domain
• Strong analytical skills
• Experience and desire to work in a Global delivery environment; Comfortable working in an on/offshore model.

Qualifications

Qualifications Basic
• 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 as an Informatica Develper

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 Permanent job opportunity for you.
  2. Only US Citizen, Green Card Holder, TN Visa, GC-EADH4-EAD & L2-EAD can apply.
  3. No OPT-EAD & H1B Consultants please.
  4. Please mention your Visa Status in your email or resume.

Skills Required

  • At least 4 years of experience in Software Development Life Cycle (SDLC)
  • At least 4 years of experience in DW/BI technologies and Informatica ETL (MUST)
  • At least 4 years of experience in project lifecycle activities for DW/BI development and maintenance
  • At least 3 years of experience with Oracle Databases
  • At least 3 years hands-on experience in Informatica and Oracle project design, development, and build activities
  • At least 3 years of experience in design and architecture review
  • At least 2 years of experience with Unix scripting
  • Strong knowledge of Informatica architecture, ETL flow, projection design, and advanced SQL
  • Knowledge of data loading techniques using Informatica, best practices, performance improvements, CDC, and UDFs
  • Ability to understand requirements and produce technical design documents (DLD/HLD) and mapping documents
  • Experience coding, analyzing, and fixing technical design and coding defects
  • Provide system integration testing (SIT) and user acceptance testing (UAT) support
  • Production rollout, implementation validation, and post-implementation support experience
  • Hands-on development mentality with troubleshooting and problem-solving skills
  • Ability to work in a team with diverse and multiple stakeholders; experience in a global delivery/onshore-offshore model
  • Experience in the financial domain
  • Bachelor's degree or foreign equivalent required (or three years progressive experience in lieu of each year of education)
  • At least 4 years of experience as an Informatica Developer
  • Authorization to work in the U.S. (US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD, L2-EAD); employer cannot sponsor
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

Cox Enterprises Logo Cox Enterprises

Fixed Operations Performance Manager

Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Remote or Hybrid
MN, USA
50000 Employees
42K-124K Annually

Pluralsight Logo Pluralsight

Solutions Portfolio Lead, Cloud and Security

Edtech • Information Technology • Software
Remote or Hybrid
USA
1000 Employees
110K-145K Annually

MetLife Logo MetLife

Account Manager

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Hybrid
Minneapolis, MN, USA
43000 Employees
78K-104K Annually

Granted Logo Granted

Back-end Engineer

Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
In-Office or Remote
2 Locations
23 Employees
150K-225K 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