Data Architect Job in Meredith Corp
Data Architect
- Bengaluru, Bangalore Urban, Karnataka
- Not Disclosed
- Full-time
Job Description
Position Summary: The ideal candidate will have 8+ years of experience developing and designing large-scale data warehouse databases. Additionally, the candidate should have experience with ETL tools, ETL architecture for columnar databases, working with columnar database technologies, data modeling and architecture as well as Business Intelligence tools.
Primary responsibilities:
1. Creating star schema data models, performing ETLs/ELT and validating results with business representatives
2. Supporting implemented BI solutions by: monitoring and tuning queries (MPP database) and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
3. Should have prior experience in systems development efforts (in python and MPP database), to understand the issues faced by the warehouse team.
4. Improvise the ELT process with sql tuning techniques to bring down processing time.
Technical Skills
Skill Sets
Mandatory
Preferred
Proficiency Level
Python
Yes
Proficient
Cloud environment such as Amazon Web Services.
Yes
Expert Business Intelligence tools such as Micro strategy or Tableau and schema design suited to these tools
Yes
Basic OLAP databases and reporting tools
Yes
Proficient columnar database technologies such as Redshift or Snowflake
Yes
Expert
SQL and query tuning skills
Yes
Expert ETL/ELT architecture and development using tools such as Talend and Pentaho
Yes
Expert Star/Snowflake schema data analysis, modeling and architecture
Yes
Expert
Role : Team Handling
Work Experience
1. 8+ years of experience developing and designing large-scale data warehouse databases. 2. 5+ experience with ETL tools, ETL architecture for columnar databases, 3. 5+ working with columnar database technologies, data modeling and architecture as well as Business Intelligence tools.
Candidate Qualification Bachelor s degree in Information Science / Information Technology, Computer Science, Engineering, or a related field.
Your 4 Step Guide to Career Success
