Informatica /Teradata Consultant
About this role
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 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 2 years of experience in Teradata - 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 Design and Architecture review
- At least 3 years of hands on experience in Design, Development & Build activities in Informatica and Oracle Projects
- 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
- Strong knowledge of Teradata Architecture: Nodes (AMP &PE), VProcs, BYNETS
- Efficient usage of Teradata DDL Statements – Derived Tables, Volatile Tables and Global Temporary Tables
- Hands on Knowledge on Teradata Concepts – Primary Index, Partitioned Primary Index, Secondary Index, Join Index and Compression Techniques.
- Understand the Concept of Locking Mechanisms in Teradata
- Experience on Query Tuning mechanisms using indexes & proper usage of Statistics in Teradata
- 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
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 4 years of experience with Informatica
- At least 2 years of experience with Teradata
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 Permanent job opportunity for you.
- Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
- No OPT-EAD & H1B Consultants please.
- Please mention your Visa Status in your email or resume.
Frequently Asked Questions
Is the salary disclosed for the Informatica /Teradata Consultant position at sonsoftinc?
The salary for this Informatica /Teradata Consultant role at sonsoftinc is not publicly listed. Click "Apply Now" to learn more about the compensation package on their official careers page.
Where is the Informatica /Teradata Consultant position at sonsoftinc located?
This Informatica /Teradata Consultant role at sonsoftinc is based in Charlotte, Charlotte, NC, United States, NC, us. The position is listed as on-site or hybrid. Check the full job description or apply directly to confirm the work arrangement.
Is the Informatica /Teradata Consultant role at sonsoftinc full-time or part-time?
This is listed as a Full time position. It is posted as a Informatica /Teradata Consultant role at sonsoftinc.
How do I apply for the Informatica /Teradata Consultant position at sonsoftinc?
Click the "Apply Now" button on this page. You will be redirected to sonsoftinc's official application portal hosted on smartrecruiters where you can submit your application directly.
When was the Informatica /Teradata Consultant job at sonsoftinc posted?
This Informatica /Teradata Consultant position at sonsoftinc was posted on Sep 27, 2016. Apply as soon as possible — early applications are often reviewed first.
Informatica /Teradata Consultant
sonsoftinc
You'll be redirected to sonsoftinc's official application page on SmartRecruiters.