ETL Developer with Informatica

Sonsoft Inc; Springfield (MA); On-site; USD 80,000 - 120,000; Full time

Job summary

A technology consultancy firm in Massachusetts is seeking an experienced professional for a full-time role focusing on ETL/ELT framework design and development. Candidates must hold a Bachelor’s degree or equivalent and have extensive experience in Data Warehousing and Informatica projects. Strong analytical skills and teamwork capabilities are essential. U.S. citizens and authorized workers are encouraged to apply, but sponsorship is not available.

Qualifications

• Strong Knowledge of ETL Frameworks, Design, and Development using Informatica.
• Working knowledge of Unix/Linux systems and shell scripting.
• 4+ years experience in Information Technology and 3+ years in DW/BI.

Responsibilities

• Design and implement ETL/ELT framework for complex data warehouses.
• Collaborate with diverse teams in a global delivery environment.
• Troubleshoot and solve complex problems in data development.

Skills

Dimensional Modelling

ETL Frameworks

Informatica

Unix/Linux

Shell scripting

Analytical skills

Teamwork

Education

Bachelor’s degree or foreign equivalent

Three years of progressive experience in IT

Tools

Informatica Data Transformation Studio

ETL/ELT tools

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.

Job Description

• Strong Knowledge of Dimensional Modelling, DW architecture, ETL Frameworks, Design and Development using Informatica, Informatica B2B, Best Practices and Troubleshooting
• Working knowledge of Informatica Data Transformation and Data Transformation studio
• 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
• Strong analytical skills
• Experience and desire to work in a Global delivery environment.

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 4 years of experience with Information Technology.
• At least 3 years of experience with DW/BI and ETL tools
• At least 2 years of hands on experience in Design, Development & Build activities in Informatica Projects - MUST
• At least 3 years of experience in Project life cycle activities on DW/BI development and maintenance projects.

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:-

• This is a FULL TIME job opportunity.
• Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, TN VIsa can apply.
• No H1-B & OPT is applicable for this position.
• Please mention your email id in your email or resume.