Senior Technical Specialist

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