Attention prospective job seekers! Beware of fraudulent offers Read more

× Success! Job has been saved successfully.

Redshift Snowflake Architect

Chennai, Tamil Nadu, India
Posted on: 28-08-2024
Apply
Save job Click to Save job
Back to results Click to Back to results
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
Apply
Back to results Click to Back to results

 Key job details

Primary Location
Chennai, Tamil Nadu, India
Job Type
Experienced
Primary Skills
Snowflake, AWS Native Data Services
Years of Experience
10
Travel
No
Job Posting
28/08/2024

Join Virtusa

 
Ensure that you open the links to enable the Next button, assuming you have read all the documents.
Okay & NextClick to Next

Please enter a valid email address to begin your application.

Ensure that you open the links to enable the Next button, assuming you have read all the documents.
Okay & NextClick to Next
Submit Click to Submit

Thank you for verifying your email. Please proceed with the steps below to apply.

Ensure that you open the links to enable the Next button, assuming you have read all the documents.
Okay & NextClick to Next

We only accept the following file extensions: .pdf, .docx or .doc
Maximum file size: 1 MB
File name must not include special characters or spaces (e.g. “name_resume.pdf”)

Please attach your CV/Resume, ensure it is in the correct format and smaller than 1MB.
We only accept the following file extensions:

Thank you. You already have an active account with Virtusa's hiring system. Please login to our portal to proceed with your application or apply for more opportunities.

LoginClick to Login

Related jobs

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 36,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 is an Equal Opportunity Employer. All applicants will receive fair and impartial treatment without regard to race, color, religion, sex, national origin, ancestry, age, legally protected physical or mental disability, protected veteran status, status in the U.S. uniformed services, sexual orientation, gender identity or expression, marital status, genetic information or on any other basis which is protected under applicable federal, state or local law.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government-issued ID during each interview. All candidates must be authorized to work in the USA.

Learn more

Awards and recognition

Ensure that you open the links to enable the Next button, assuming you have read all the documents.
Okay & NextClick to Next

2023

UK’s Best Workplaces in Tech

2023

UK's Best Workplaces for Wellbeing 2023

2022

Virtusa Earns 2022 Great Place To Work Certification

2017-2022

Candidate Experience (CandE) Awards
View all awards and recognition Click to View all awards and recognition

Find us on Glassdoor.

Ensure that you open the links to enable the Next button, assuming you have read all the documents.
Okay & NextClick to Next

Have any questions?

What is the best way to find and apply for positions at Virtusa?

To join our bright team of professionals, you can apply directly to our website under the Careers tab and search all open jobs. https://www.virtusa.com/careers

Ensure that you open the links to enable the Next button, assuming you have read all the documents.
Okay & NextClick to Next

Can I apply for more than one position at the same time?

Yes, you can. Virtusa gives you the flexibility to apply for multiple open positions that excite you about your future and align to your experience and career goals.

Ensure that you open the links to enable the Next button, assuming you have read all the documents.
Okay & NextClick to Next

Can I apply for a position across multiple geographical locations?

Yes, you can. Virtusa is a global Company, and we serve our clients through our global delivery model.

Ensure that you open the links to enable the Next button, assuming you have read all the documents.
Okay & NextClick to Next

What happens after I’ve submitted my resume?

Our dedicated recruitment team will review your online application and match it to all our open jobs. We update our open jobs on a daily basis and encourage you to check back often.

Ensure that you open the links to enable the Next button, assuming you have read all the documents.
Okay & NextClick to Next

How will I be evaluated for a career opportunity with Virtusa?

Our team of recruiters will review your application, relevant job experience, and skills to appropriately align it to our open jobs. From there, the recruitment team will contact the qualified candidate to start the interview process.

Ensure that you open the links to enable the Next button, assuming you have read all the documents.
Okay & NextClick to Next

Career insights

Want to explore the ways you can engineer your career in technology? Our thought leaders share key career insights for candidates from entry-level job seekers to senior technologists.