ETL Developer - Python Programming

Summary : This position is for an experienced ETL Developer with a focus on integration of data from various sources. ETL developer will be part of scrum team to help the engineering team in agile fashion. Responsibilities : - Develop data integration framework from various sources. - Build DWH and data sync pipeline from Transactional Database and external data sources. - Application Database design and development. - Performance Tuning and Query Optimization. - Writing and optimizing complex queries. Skills and Experience : Primary : - Experience of working on ETL/ELT. Able to write data flow pipeline from scratch. - Worked on various data formats like JSON, XML, CSV, EXCEL, TXT, Grafana and Tableau. - Hands on experience of writing stored procs, functions, tables, views, triggers. - Should have experience of OLTP, OLAP & DWH concepts and best design practices. - Should have experience in design and development of Data warehouse, Snowflake, BigQuery,Redshift, DuckDB. - Should have experience in Postgres/MSSQL/MySQL. - Should have experience of any reporting tool like Power BI, Quick Sight or SSRS. - Working as a contributor in current role. Secondary : - In-depth knowledge of database architecture, experience of working with any RDBMS. - Experience in Performance Tuning and Query Optimization. - Strong knowledge of indexes and index management. - Hands on database development, ability to write and troubleshoot SQL Code - Should have good exposure on data integration from multiple sources. - Playing a key role in designing, developing, and implementing the database for various products - Experience of any NOSQL database. Desirable : - Working in Cloud Environment. - Experience of working with Python. - Knowledge of jobs, job scheduling alternatives. - Finance Domain knowledge. - Strong written/oral communication, presentation, and interpersonal skills (ref:hirist.tech)

Location: Delhi, IN

Posted Date: 4/24/2024