Teradata with ETL Informatica Architect

Location: Charlotte, NC, us

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

• Strong Requirement Elicitation & Analysis skills
• Should have the capability to understand requirements and convert to design
• Should have capability to architect and design ETL frameworks using Unix and Teradata
• Should have capability to automate the ETL development using ETL framework
• Ability to coordinate with SMEs, stakeholders, manage timelines, escalation & provide on time status – strong project management skills as well.
• Good knowledge in Teradata concepts and Logical/physical database design
• At least 5 years of Experience in using Teradata utilities TPT, TPump,BTEQ,fastload, fastexport and multiload.
• In-depth knowledge of Performance tuning and optimization to handle and process large volume of data in Teradata.
• Experience in SQL programming (views/store procedures/macros/functions) based on User requirements and architectural guidelines and standards.
• Strong experience(atleast 6 years) in Unix Shell Scripting.
• Experience in Informatica ETL tool.
• Good knowledge of BI/DW concepts
• In-depth knowledge of Performance tuning and optimization to handle and process large volume of data in Teradata
• Experience in SQL programming (views/store procedures/macros/functions) based on User requirements and architectural guidelines and standards.
• Experience in writing Unix Shell scripting is a must
• Excellent Communication Skills

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 7 years of experience with Information Technology.

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-EAD, H4-EAD & L2-EAD can apply.
3. No OPT-EAD & H1B Consultants please.
   
4. Please mention your Visa Status in your email or resume.