Virtusa
Redshift Snowflake Architect
Job Description
Design snowflake patterns and migration architecture
Provision Users, Setup Roles and policies.
Set up Data governance and data Lineage Processes
Monitor the system performance by performing regular tests, troubleshooting and integrating new features.
Experience in migration from legacy system to Snowflake ( At least one project Exp)
Excellent exp in SQL and advance analytical functions
Experience in building data pipelines using an ETL tool (e.g. Talend/Informatica or Snap logic based pipelines)
Excellent Data Modelling skills (RDBMS concepts, Normalization, dimensional modelling, star/snowflake schema etc)
Experience in using one or more data visualization tools (preferably PBI)
Experience with AWS technologies: Redshift, EMR, S3, MYSQL
Good Experience in to define Data Migration strategy
Must be analytic, creative and self-motivated.
Work Effectively within a global team environment.
Experience of working with a range of BI & analytics architectures. These may include: traditional warehousing, visualization
Excellent communication & documentation skills
Exp in data anonymization
Suggest innovative solutions based on new technologies and latest trends
Familiar with Agile delivery process
Familiar with CI/CD concepts and tools (Jenkins)
Complex problem-solving capability and ever improvement approach.
Experience and familiarity with data models and artefacts (entity relationship diagrams, conceptual models, logical models, star schemas, third normal form).
Experience of delivering data & analytics solutions using different delivery methodologies (e.g. Agile, Waterfall)
Desirable:
Some domain knowledge (processes & data): Pharma R&D, Finance, HR, Compliance etc
Stakeholders engagement, can work closely with Information architects and Enterprise architects
Good Story telling capability
Developing ETL pipelines in and out of data warehouse using combination of Snowflake capabilities, dbt,fivetran, Python Snowflake
Good understanding of Snowflake architecture
Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix, Python, etc. to do Extract, Load, and Transform data
Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, , Tasks, Streams, Time travel, Optimizer, Zero Copy Clone
Metadata Manager, data sharing, and stored procedures.
Data Sharing, RBAC, data security
Jobs at Chennai
Amazon
ML Content Writer, AWS Bedrock
Freshers/Experienced
Chennai, Tamil Nadu
Last Date: Oct. 1, 2024
Infosys
ATT_ECAS_SFDC_PCON_ Q2FY25
11 - 20 Years Exp.
Chennai, Tamil Nadu
Last Date: Sept. 30, 2024
Amazon
Support Engineer III, Global Store
Freshers/Experienced
Chennai, Tamil Nadu
Last Date: Oct. 1, 2024
Virtusa
Java Developer with Mongo DB
Full Time
Chennai, Tamil Nadu
Last Date: Dec. 31, 2024
More Jobs at Virtusa
Virtusa
Android Developer - Architect
Full Time
Hyderabad, Telangana
Last Date: July 30, 2025
Actively Recruiting Companies at Chennai, Tamil Nadu