Redshift Snowflake Architect

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

**About Virtusa**

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 30,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.

Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.

Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.