Senior Technical Specialist

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 

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.