Desired Competencies (Technical/Behavioral Competency)

Must-Have

1. 6+ years experience in building scalable enterprise data integration solutions; preferred on the Microsoft SQL Server, Azure Data Warehouse/Database platforms.
2. Proficiency with data integration tools such as SISS and Azure Data Factory, in-depth hands-on experience with SQL, TSQL, python and data formats such as XML and JSON.
3. In-depth understanding of data integration, data quality, and multi-dimensional design.
4. Proven experience with implementing data warehouse architecture standards, processes, and methodologies.

Good-to-Have

SN 

Responsibility of / Expectations from the Role

1.

1. Design and implement effective and scalable solutions to store and retrieve organization data.
2. Responsible for the architecture, modeling, design, development, testing, implementation and maintenance of the ETL, procedures and structures which populate and grow our databases, data marts and tables.
3. Provide direction to less experienced ETL developers on solution design and implementation. Ensuring standards are being followed.
4. Develop data flows that can leverage both on premise and cloud architectures.
5. Work with stakeholders including the business analytics teams and IS architecture teams to assist with data-related technical issues and support their data infrastructure needs.