Junior Data Engineer Consultant - DataLake/Data Factory

Here is a list of mandatory skills based 1. Azure Data Services : - Azure Data Factory - Azure SQL Database - Azure Data Lake (4-5 years' hands-on project experience) 2. Power BI (PBI) : (4-5 years' hands-on project experience) 3. Data Pipelines Development : - Building data pipelines using Azure Data Factory (4 years' hands-on project experience) 4. SQL Expertise : - Writing and analyzing SQL queries - Creating and optimizing Stored Procedures and Views (Should rate themselves at least 8/10) 5. Data Profiling, Sourcing, and Cleansing : - Strong experience in data profiling, sourcing, and cleansing routines We are seeking an experienced Azure Data Solutions Developer to join a dynamic team delivering large-scale digital and data solutions. This is an exciting opportunity to work on a transformative cloud-hosted application for a major Version 1 customer. The ideal candidate will have a strong background in implementing data ingestion and transformation pipelines for enterprise-level organizations, with deep technical expertise across various Microsoft Azure services. Key Responsibilities : - Design and deliver scalable data solutions using Azure Data services. - Develop and implement data ingestion and transformation pipelines for large-scale environments. - Build data solutions using a wide range of tools and Azure services. - Collaborate on proof-of-concept development and production implementation. - Meet tight project deadlines while delivering high-quality solutions. - Translate business requirements into technical solutions with a focus on data quality and performance. Qualifications : Essential : - 4-5 years of hands-on experience designing and delivering data solutions using : - Azure Data Factory - Azure SQL Database - Azure Synapse Analytics - Azure Data Lake - Expertise in writing and optimizing SQL, stored procedures, and views. Strong ability to analyze query performance, use partitioning, and apply clustering techniques. - Hands-on experience with Power BI or other BI platforms such as Tableau or Qlik Sense. Proven experience building data solutions using ETL/ELT tools like : - SQL Server Integration Services (SSIS) - Oracle Data Integrator (ODI) - Talend - Direct experience in building data pipelines using Azure Data Factory. - Strong knowledge of data management best practices, including data profiling, sourcing, and cleansing routines. - Advanced experience with RDBMS, including complex stored procedures, functions, query optimization, and indexing strategies. - Proven ability to coach and mentor novice developers. - Excellent problem-solving and data analysis skills. - Strong communication skills, both written and oral, to articulate complex concepts effectively. - Full project lifecycle experience, from concept to deployment and support. Desirable : - Programming experience, particularly in Python. - Experience working with offshore teams. - Consultancy experience. - Familiarity with Agile/Scrum methodologies. (ref:hirist.tech)

Location: bangalore, IN

Posted Date: 11/24/2024