Analysis of the source system data
and design and mapping to the Integrated Data Warehouse model
Develop Business Intelligence
Application using Extract Transform Load to enable business users to perform
business driven analysis.
Analyze and Test pipeline that
ingest data from different sources, and cleansing, transformations and
performance tuned on Hadoop and Teradata platforms to fulfill high volume data
business intelligence reporting requirements.
Code and develop the strategies
that improves the current existing process of Business Intelligence application
development or testing that saves manual efforts and time. This includes
developing python, shell scripts and web interface development.
the Hadoop and Teradata application that built using MapReduce, Pig
programming and BTEQ scripts using HiveQL and SQL. Extracting data from AWS
Cloud S3 buckets and loading them on to the Teradata server.
Prepare Test plan, Test
Cases, perform End-To-End testing, Test review meeting, on data flow and
validation of its transformation and finally preparing exit reports for
the IT/business team approvals.
Manage day-to-day production
support issues ensuring effective and timely resolution.
project status to Contrive Solutions management Attending
training in new technologies for career advancement.
Provide KT and train new hires at client teams and
contrive solutions as needed.
Provide peer review for
complicated projects and suggest solutions for other client projects at
Bachelor’s Degree in Computer science or relevant field. or the equivalent combination of education, technical certifications or training, or work experience.
6-7 years of IT experience, MySQL , Microsoft SQL, Teradata, Spark, Hive, Core JAva
Excellent problem solving and analytical skills
Excellent written and oral communication skills
Strong organizational, analytical, and collaborative skills
• Benefits included - Health/Dental, trainings, travel expenses.
• Employer location Northborough MA. Duties for current role to be performed at Atlanta, GA
Referral bonus is available for this position