Relevant Experience 

(in Yrs) Must have total 10+ yrs of experience in IT and 5+ years' experience working as a Data Architect 

Must Have Technical/Functional Skills

• Must have experience at least two end to end implementation of Snowflake cloud data warehouse. 

• Expertise in Data modelling, ELT using snowflake, implementing complex stored Procedures and standard DWH and ETL concepts. 

• Experience in Data Migration from RDBMS to cloud data warehouse 

• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel, and understanding how to use these features. 

• Experience in Data Masking & Security features of snowflake  

• Experience in handling Structured & semi-structured data (JSON, XML) 

• Experience with AWS or Azure data storage and management technologies such as S3 and ADLS 

• Must have experience of Agile development methodologies. 

• Strong written communication skills. Is effective and persuasive in both written and oral communication. 

• Exposure or expertise working in health care domain will be added advantage.

Experience Required 10 + Years

Roles & Responsibilities

• Study as and TO planning along with TCS and customer stake holders 

• Build solution architecture, design , reviews

• Build processes supporting data transformation, data structures, metadata, dependency, and workload management. 

• Implementation of this architecture

• Provide resolution to an extensive range of data pipeline related problems, proactively and as issues surface. 

• Working with development team, customer teams during entire execution. 

• Representations as architect to customer on various forums during lifecycle of project.

• Co-ordination with offshore team during project execution.

Generic Managerial Skills Co-ordination with stake holders

Representations to customer – meetings, steering committee, architecture board, technical reviews

Salary Range: $120,000-$150,000 a year

TCS Employee Benefits Summary:

Discretionary Annual Incentive.

Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

#LI-SP1