ETL Developer
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.
- 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.
- Should have experience of any reporting tool like Power BI, Quick Sight or SSRS.
- Should have experience of writing stored procs, functions, tables, views, triggers.
- Worked on various data formats like JSON, XML, CSV, EXCEL, TXT, Grafana and Tableau.
- Should have experience of OLTP, OLAP & DWH concepts and best design practices.
- Should have experience in design and development of Data warehouse, Snowflake, Big Query, Redshift, Duck DB.
- Should have experience in Postgres/MSSQL/MySQL.
- 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
Education: Bachelor’s degree in computer Sc., Information System, or related disciplines
Experience: 5+ Years
Job Type: Full Time
Job Location: REMOTE