Senior Technical Specialist

Job Description

Job Description Job Title: Senior Technical Specialist Education: B.E\B.Tech\MCA\B.SC Experience: 10+ Years Location: Bangalore/Hyderabad/Mumbai Key Skills: SQL, PLSQL/TSQL, Data Warehouse, SQL, Snowflake, Matillion, Python, PySpark Qualifications: 10+ years of ETL and/or Business Intelligence experience Proficient with SQL writing skills Strong Snowflake Developer with Extensive Development experience and Data Analysis required to develop a new complex data warehouse At least 3 full years of recent Snowflake development experience Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Able to administer and monitor Snowflake computing platform Hands on experience with data load and manage cloud DB Evaluate Snowflake Design considerations for any change in the application Build the Logical and Physical data model for snowflake as per the changes required Define roles, privileges required to access different database objects Define virtual warehouse sizing for Snowflake for different type of workloads Design and code required Database structures and components Build the Logical and Physical data model for snowflake as per the changes required Deploy fully operational data warehouse solutions into production on Snowflake Experience in creation and modification of user accounts and security groups per request Handling large and complex sets of XML, JSON, and CSV from various sources and databases Solid grasp of database engineering and design Experience using Matillion, Understanding of Data integration tools. Good knowledge on Cloud Computing AWS and/or Azure Experience with any scripting languages, preferably Python Experience writing code that aggregates and transforms data from multiple data sources Experience designing, building, and optimizing analytics models in support of downstream BI platforms Experience with relational databases Knowledge of GIT Source Control, CI/CD Strong technical writing/documentation skills Effective written and oral communication skills Experience with processes that extract data from different sources, transform the data into a usable and trusted resource, and load that data into the systems end-users can access and use downstream to solve business problems (ETL/ELT processes) Nice to have: Scripting with Python SnowPro Certification Experience with an ETL tool, like Informatica, Datastage, Matillion About Us Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner. About The Team Datavail?s Data Management Services: Datavail?s Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments. Datavail?s team is comprised of not just excellent BI & analytics consultants, but great people as well. Datavail?s data intelligence consultants are experienced, knowledgeable and certified in the best in breed BI and analytics software applications and technologies. We ascertain your business objectives, goals and requirements, assess your environment, and recommend the tools which best fit your unique situation. Our proven methodology can help your project succeed, regardless of stage. With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the Data Management experts on demand you desire. Datavail?s flexible and client focused services always add value to your organization.