Requirement gathering, creating, and designing documents based on the given requirements, development and implementation of cloud projects using snowflake, AWS S3, Python, SQL, and Data Build tools. Working with the Business users on functional requirements, define data structure and application integration solutions appropriate to the user requirements. Analyzing existing functions and creating data models using data warehouse techniques which involve creating databases, schemas, tables, and views. Developing the Python programs and scripts to connect SAAS application using APIs to extract the data from the API reports and ingest data into AWS S3 data store. Build Data pipelines to load source data from AWS S3 to snowflake DB using Five Tran/HVR injection frameworks and transform the data by writing DBT models and macros. Create pipelines for real time streaming data ingestion into snowflake using Snow Pipe and Snow tasks. Create custom procedures using SQL to process data from various source system applications to the destination database tables. Work under supervision. Travel and/or relocation to unanticipated client sites in USA is required.

Experience of Twelve (12) months working on AWS or Python is required. Travel and/or relocation is required to unanticipated client sites within USA. International travel is not required. The frequency of travel is currently not known as it depends on the client and project requirement that cannot be currently anticipated. Employer provides Information technology services to various clients in USA and hence implementing projects will require such travel.

No. of Positions

Location