Clairvoyant is a global technology consulting, services, and product company. We help organizations build innovative products and solutions using enterprise stack, big data, analytics, and the cloud. Our global team consists of experienced professionals, with backgrounds in design, software engineering, analytics, and data science. Each member of our team is highly energetic and committed to helping our clients achieve their goals.
Must Have:
Min. 2 years of Experience on SQL
Experience on working with very large datasets
Skilled with writing, tuning, and troubleshooting SQL queries (Must Have)
Experience with BI tools like Power BI,Tableau etc.
Strong organizational skills and planning prowess, with excellent attention to detail
Good analytical and problem-solving skills, ability to triage technical issues and drive resolution with cross-functional teams
Hands on experience in analytics driven projects involving data exploratory analyses
Good to have:
Data modeling, data warehousing, and building ETL pipelines
Detailed knowledge of cloud-based data warehouses (primarily AWS), architecture, infrastructure components, ETL and reporting/analytic tools and environments.
Must have experience with Big Data technologies such as Hive/Spark, AWS Glue, AWS Lambda , Redshift
Strong Python, Spark skills
Role & Responsibilities:
Provide the database architect detailed information of the datasets to create a unified warehouse schema that cuts across use cases
Write ETL (Extract, Transform, Load) scripts to load facts and dimensions data using SQL (Structured Query Language) queries, document catalog data
Seniority level
Associate
Employment type
Full-time
Job function
Information Technology
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at EXL by 2x