Offer summary

Qualifications:

Bachelor's degree in Engineering, Technology, MCA, B.Sc, or any relevant degree., Over 10 years of experience in ETL and Data Warehouse tools., Strong expertise in AWS, Snowflake, and Fivetran, with at least 3 years of recent Snowflake development experience., Proficient in Python and SQL, with knowledge of database management and cloud services..

Key responsabilities:

Serve as a subject matter expert for AWS, Snowflake, and Fivetran.

Design and build BI delivery components, including Data Marts and Data Warehouses.

Develop solutions to meet customer requirements and define data models for analytics.

Implement and manage ETL pipelines using AWS Glue and DMS, ensuring data integrity and performance.

Job description

Job Description

Job Title: Senior Technical Specialist

Education: B.E\B.Tech\MCA\B.SC\Any Degree

Experience: 10+ years

Location: Anywhere in India.

Job Description:

10+ Years of Proven experience in working with Various ETL / Datawarehouse tools.
Extensive back-end development experience, ideally for customer-facing products.
Serves as one of the subject matter experts for AWS, Snowflake and Fivetran.
Proficient in end-to-end system profiling, performance tuning, and optimization. Strong database knowledge Oracle PL/SQL, tuning
Good knowledge of UNIX scripting.
Strong knowledge of SCD1 and SCD2 logic implementation using ETL Tools, SQL (T-SQL, PLSQL) and Spark SQL.
Design & Build BI Delivery components like Data Marts, and Datawarehouse.
Design and Develop solutions to meet customer functional and non-functional requirements.
Define conceptual High-Level and Low-Level Data Models to address customer analytical needs.
Skilled in writing well-structured, efficient python code and adept in designing, building, maintaining, testing, and deploying software.
Expert in Python, with knowledge of at least one Python web framework such as Django, Flask, etc.
Having Knowledge on pg8000, boto3, scikit learn, matplotlib, seaborn is an added advantage.
Should have good experience in using Pandas DF, Spark DF, Numpy, Matplotlib.
Proficient understanding of code versioning tools such as Git, Mercurial or SVN.
At least 3 full years of recent Snowflake development experience
Hands-on experience with Snowflake utilities, Snow SQL, Snowpipe, DBT.
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 and privileges required to access different database objects.
Define virtual warehouse sizing for Snowflake for different types of workloads.
Strong Experience in Designing and Implementing the ETL Pipelines using AWS Glue and DMS to load / read data from/to Dynamo DB, Postgres and Snowflake.
Good Knowledge of AWS Services like S3, IAM.
Experienced in cloud environment architectures, utilizing technologies such as,
AWS Lambda, Glue, S3, DMS, DynamoDB.
PostgreSQL.
Snowflake DBT
Python.
Fivetran.
Hands-on experience with Fivetran data pipelines and relational databases, including Oracle, PostgreSQL, SQL Server, or MySQL.
Good to have AWS Certified Solutions Architect – Professional or SnowPro Advanced Certification.

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