Description:

The Associate Staff Engineer will be responsible for database development tasks including writing SQL queries, stored procedures, views, and indexes.
They will need to build data pipelines using Azure Synapse, Azure Data Factory, and Azure Data Bricks.
The role involves creating Notebooks in Azure Synapse for data ingestion, analysis, and pipeline building.
The candidate must have expertise in data integration (ETL) best practices and techniques.
Knowledge of Data Warehousing concepts such as Star/Snowflake schema and solution designing is required.
Understanding of relational structures and dimensional data modeling is essential.
Familiarity with ETL tools, especially SSIS, is preferred for designing ETL unit test cases and debugging ETL mappings.
Exposure to Data Governance concepts and tools like Data Quality tools and Master Data Management Tools is beneficial.
The candidate should be able to create documentation for various purposes and have experience working with Agile (Scrum) development practices.
Analytical ability and strong written and verbal communication skills are necessary for this role.

Requirements:

Expertise in SQL Server Integration Services and Azure Synapse.
Proficiency in database development tasks like writing SQL queries, stored procedures, views, and indexes.
Experience in building data pipelines using Azure Synapse, Azure Data Factory, and Azure Data Bricks.
Knowledge of data integration (ETL) best practices and techniques.
Understanding of Data Warehousing concepts such as Star/Snowflake schema and solution designing.
Familiarity with relational structures and dimensional data modeling.
Ability to design ETL unit test cases and debug ETL mappings.
Exposure to Agile (Scrum) development practices.
Strong analytical ability.
Excellent written and verbal communication skills.

Opportunity to work for a Digital Product Engineering company that is scaling rapidly.
Ability to work remotely from Sri Lanka.
Full-time position with a service region in South Asia.
Dynamic and non-hierarchical work culture.
Opportunity to work with a global team of over 15,000 experts across 26 countries.
Chance to be part of a team that builds products, services, and experiences that inspire, excite, and delight.

Skills