1. Azure Data Engineering, ADF, Data Bricks, Synapse
2. Should have good hands on experience on building ETL flow using any ETL tool such as ADF etc.
3. Should be able to understand the requirement and design the data flow diagram of ETL process end to end.
4. Should have good hands-on experience writing complex SQL queries and advance concepts of SQL such has indexes,partition,filegroup,transaction etc.
5. Should be able to understand the business requirement and develop end to end data pipelines using required tools/technologies.
6. Excellent troubleshooting and good communication skills with good attention to details.
7. Should have knowledge on designing optimized data processing based on volume of data.
8. Able to create documentation that clearly explains the purpose of the data flow and its intended use.
9.
Able to make regular modifications to existing production code for error correction and adding recent features.
10. Experience using Visual Studio,SQL server management studio.
11. Strong understanding of data warehousing concepts such as dimension,fact,schema ,data loading process, dimensional modeling and data mining.
12. Flexible to learn and adopt tools/technologies used in project.
13. Able to write DAX queries and create PowerBI dashboards from scratch
Responsibility of / Expectations from the Role
- Strong Knowledge on SQL to build complex business logic with optimized way
- Should know Azure /cloud services
- Flexible to learn and adopt tools/technologies used in project.
- Should be able to manage existing and new pipeline enhancement/development end to end.
- In depth knowledge on Data warehousing concepts and ETL concepts to propose the solution as per business requirement.