Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 1K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

For Employers

Add office photos

Employer? Claim Account for FREE

Datavail Infotech

Compare

3.2

based on 132 Reviews

23 Datavail Infotech Jobs

Senior Technical Specialist

Datavail Infotech Pvt. Ltd.

3.2

based on 132 Reviews

10-15 years

₹ 18.3 - 31.25L/yr (AmbitionBox estimate)

Kolkata, Mumbai, New Delhi + 4 more

1 vacancy

Senior Technical Specialist

Datavail Infotech

posted 9d ago

Job Role Insights

Flexible timing

Key skills for the job

Python SQL Oracle Django MySQL Postgresql

+ 3 more

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.