18 Sep
|
Quantiphi Analytics Solutions
|
Bengaluru
18 Sep
Quantiphi Analytics Solutions
Bengaluru
Role: Senior Senior Data Engineer
Experience Level: 4+ Years
Work location: Mumbai/Bangalore/Trivandrum
Role & responsibilities
- Strong proficiency in SQL, Python, DBT, AWS services, data modelling, Snowflake, building and maintaining data pipelines, and robust troubleshooting capabilities.
- In addition, exposure to asset management, alternative investments, or broader financial domain knowledge is highly valuable.
- Experience in establishing a golden source of
- truth using Snowflake as the data warehousing tool, with current data sources coming from external sources via SFTP and SEI via a Snowflake share; the data engineer's role involves pushing data to the golden layer using Snowflake tools like streams and stored procedures, requiring robust SQL stored procedure and Python skills, as well as a good understanding of data modeling concepts like star schema
- AWS resources on the Data side needed and not on the infra side & same for Snowflake.
- Exposure to orchestration tool on Data engineering side,
so that they can setup date pipeline etc
- Seeking a hands-on engineer with five to six years of experience and knowledge of basic AWS services like Redshift and S3.
- Data Ingestion, Frequency, and Orchestration The team is currently unsure of the exact frequency of files from JPMC but expects them to be on a daily or monthly basis, with transaction files potentially having a daily frequency
- Orchestrating third-party feeds, they plan to use Snowflake workflows and jobs.
- Tools: Snowflake Share, snowflake architecture (micro partition) , snowflake best practices, Snowflake SQLs, snowflake procedures, UDF, Task
- Other Tools: Python is definitely a required skill, and basic knowledge of Unix and Linux is good to have for using tools like Git. Data streams are used for change tracking purposes within Snowflake.
📌 Senior Data Engineer (Bengaluru)
🏢 Quantiphi Analytics Solutions
📍 Bengaluru