BI Hadoop - Teradata - L3 Support Engineer

Company DescriptionSonsoft , 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 DescriptionNote: Green Card and USC Checklist for hiring:Should have worked in production support projects for 1-2 years/ProjectShould have good knowledge on teradata performance optimization & tuningShould have knowledge on ticketing toolHadoop, Hive working knowledge will be goodManage complex data loading operations Should have knowledge on ITIL process QualificationsJob Description :Should have 5-7 yrs of experience in Teradata & Hadoop technology & having ETL experience would be goodShould have good data modelling knowledgeExpertise and hand-on experience with the Hive and/or SparkSQL is a must.Hands-on experience with the Hadoop Ecosystem with large scale data processing requirements. Proficient with Hive/Pig and workflow automation on Hadoop.Experience in developing distributed computing systems applications using Hadoop, MapR, Hbase, Hive, Java/MapReduce, Data synapse, Pig, Storm,Kafka,Flume,Sqoop, Cloudera & HortonworksStrong experience into Map Reduce and HDFSShould have strong Pl/SQL experience in teradata & able to handle complex queriesShould be able to handle complex data loading process using teradata utilitiesShould be good in Teradata performance tuningAdditional InformationNote:-This is a Full-Time & Permanent job opportunity for you.Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.No OPT-EAD, H1B & TN candidates please.Please mention your Visa Status in your email or resume.SummaryType: Full-timeFunction: Information TechnologyExperience level: Mid-Senior LevelIndustry: Information Technology And Services