Informatica

SmartRecruiters, Inc.; Cary (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

Sonsoft, Inc. is seeking a DW/BI ETL Developer with Informatica and Oracle expertise to design, develop and maintain ETL pipelines in a global delivery setup.

The role requires strong Unix/Linux knowledge, shell scripting, and collaboration with diverse stakeholders to deliver complex data warehousing solutions.

Qualifications

• Bachelor’s degree or foreign equivalent required from an accredited institution.
• At least 2 years of experience within the Information Technologies.
• 2+ years of experience in DW/BI, ETL with Informatica and Oracle tech.
• Hands-on design, development and build in ETL/Oracle projects.

Responsibilities

• Design, develop and maintain DW/BI ETL pipelines and warehouses.
• Troubleshoot ETL workflows and optimize performance.
• Collaborate with cross-functional teams and stakeholders in a global delivery environment.

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

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

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

• This is aFULL TIMEjob oppurtunity.
• OnlyUS Citizen,Green Card Holder,GC-EAD,H4-EAD,L2-EAD,TN VIsacan apply.
• NoOPT-EAD&H1-Bfor this position.
• Please mention your Visa Status in youremailorresume.