ETL Developer

Posted Mar 17

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