Desired Competencies (Technical / Behavioral Competency) :
Must-Have : ETL Knowledge, SQL Programming, Azure, : Python of / Expectations from the Role :
- Should have experience in database / ETL concepts & testing
- Should have experience in understanding business requirements and translating them (writing) and resolving
complex sql queries.
Should be able to write new code (SQL / java / python / excel macro) to compare two tables, create test scenario / test dataExperience working with Cloud (Azure,AWS)Experience in handling semi structure data like csv, json, textAbility to influence and negotiate with others to meet project deadlines without compromising qualityShould be very strong in writing SQL queries using complex data typesShould be able to create testcases, scenarios, test-plan, test scriptsShould have basic knowledge in Selenium using TestNG or BDD :Design, develop, and test ETL processes, data pipelines, and data solutions using Azure, Databricks, and SQL.Collaborate with cross-functional teams to understand business requirements and translate them into technical specifications.Develop and maintain complex SQL queries, data models, and data visualizations.Write new code (SQL, Java, Python, Excel macro) to compare two tables, create test scenarios, and test data.Work with semi-structured data (CSV, JSON, text) and cloud-based data platforms (Azure, AWS).Create test cases, scenarios, test plans, and test scripts.Participate in agile development methodologies and collaborate with team members to meet project :3+ years of experience in ETL development, with focus on Azure, Databricks, and SQL.Strong knowledge of ETL concepts, data warehousing, and data integration.Proficiency in SQL programming, including complex queries and data modeling.Experience with Azure, Databricks, and cloud-based data platforms.Ability to write clear and concise technical documents.(ref : hirist.tech)