Data Warehouse Consultant
Location
Hartford, CT | United States
Job description
- 8+ Years of experience in Information Technology, with focus on Data Warehousing development and Administration .
- 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 SQLs.
- 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.
Job tags
Salary