Redshift Consultant

VDart Inc is the leading global provider of digital solutions, products and talent management company providing digital technology solutions in Automotive, Manufacturing, Energy & Utilities and Healthcare Industries. Led by a strong global team located across 10 countries including USA, Canada, Mexico, Brazil, UK, Japan, Australia & India. We are currently accepting applications from staffing firms for our Preferred Partner Program, where we align niche staffing firms with specific verticals based on their strengths. To apply, please visit: ;nbsp; Job Title: Redshift Consultant Location: Hartford, CT Duration: Contract Job Description:

• 8+ Years of experience in Information Technology, with focus on Data Warehousing development and Administration.
• Candidate must work in several areas of Data Warehouse including Analysis, Requirement Gathering, Design, Development, Testing, Implementation and Administration.
• Expert DBA skills in Redshift, SQL Server, Oracle/Teradata & Matillion (Good to have).
• Expertise in database programming like writing Stored Procedures (SQL), Functions, Triggers, Views, Shell scripting.
• Expertise in performance tuning from design architecture to application development.
• Also, Worked in remediation (Performance Tuning) team for improving query performance of user queries and production SQL's.
• Should have good experience in working with big data technologies like Hadoop, Yarn, MapReduce, Pig, Hive, Spark and other associated technologies.
• Worked on Data Mining techniques for identifying claims on historical data.