Offer summary

Qualifications:

Bachelor's degree or equivalent experience required., 10+ years of experience in ETL and Business Intelligence., Proficient in SQL and strong Snowflake development skills., Experience with cloud computing platforms like AWS or Azure..

Key responsabilities:

Develop and manage complex data warehouses using Snowflake.

Design and implement ETL/ELT processes to transform and load data.

Administer Snowflake computing platform and monitor performance.

Collaborate with clients to understand their data needs and provide solutions.

Job description

Job Description

Job Title: Senior Technical Specialist

Education: Any graduate

Experience: 10+Years

Location: Bangalore/Hyderabad/Mumbai/Anywhere in India

Job Description:

Required Skills:

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 Azzure
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 etc.

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.

Required profile