Senior Consultant
Virtusa, Fremont, CA, United States
Senior Consultant (CREQ46763)
Responsibilities
The candidate will manage and enhance the data warehousing environment and to take it through the future iterations
Establish the longterm strategy and technical architecture for the data warehouse
Define and implement technical requirements, technical and data architectures for the data warehouse
Design and manage the ETL process, including data quality and testing
Design and manage the information access and delivery effort for the data warehouse
Define and implement production release requirements and sustainment architecture
Demonstrated ability to produce high quality technical documentation
Write maintain scripts to extract, clean, organize and load data across platforms
Manage the data architecture and infrastructure for processing large quantities of data sets
Manage documentation for their data models across multiple sets SQL and NoSQL databases
Qualifications
Proficiency in Data Warehouse/ETL industry leading tools (Snowflake, Redshift, Informatica, Talend, Matellica, Pentaho, Snaplogic etc.)
Experience w/ one or more of the following relational databases: MySQL, Postgres, Oracle, Sybase, SQL Server
Comprehensive knowledge of relational and dimensional data modeling practices and implementation techniques and where they are best utilized.
Exposure and experience working with AWS
Experience with Data Performance and Optimization techniques
Strong organization skills with excellent written and oral communication
#J-18808-Ljbffr
The candidate will manage and enhance the data warehousing environment and to take it through the future iterations
Establish the longterm strategy and technical architecture for the data warehouse
Define and implement technical requirements, technical and data architectures for the data warehouse
Design and manage the ETL process, including data quality and testing
Design and manage the information access and delivery effort for the data warehouse
Define and implement production release requirements and sustainment architecture
Demonstrated ability to produce high quality technical documentation
Write maintain scripts to extract, clean, organize and load data across platforms
Manage the data architecture and infrastructure for processing large quantities of data sets
Manage documentation for their data models across multiple sets SQL and NoSQL databases
Qualifications
Proficiency in Data Warehouse/ETL industry leading tools (Snowflake, Redshift, Informatica, Talend, Matellica, Pentaho, Snaplogic etc.)
Experience w/ one or more of the following relational databases: MySQL, Postgres, Oracle, Sybase, SQL Server
Comprehensive knowledge of relational and dimensional data modeling practices and implementation techniques and where they are best utilized.
Exposure and experience working with AWS
Experience with Data Performance and Optimization techniques
Strong organization skills with excellent written and oral communication
#J-18808-Ljbffr