Qureos Mentor

IFI Techsolutions

Data Engineer (Azure &amp; Power BI Specialist)Location: NoidaExperience Level: 4+ years in data engineeringAbout Us: IFI Techsolutions (www.ifi.tech)&#8239; is a leading cloud solutions and managed services provider that was recognized as a 2020 Microsoft Partner of the Year Finalist. Founded by former Microsoft executives, IFI Techsolutions has delivered over 370 projects, 45,000 consulting hours, migrated 4,100-plus servers for more than 260 global customers and has presence in India, US, UK, Australia, and UAE. Also, IFI Techsolutions has earned Microsoft Azure Advanced Specializations on Windows Server and SQL Server Migration, Modernization of Web Applications and Windows Virtual Desktop.Key Responsibilities:<ul><li>Design, build, and optimize scalable data pipelines using Azure Data Factory (ADF), including parameterized pipelines, deadlock detection/resolution, and debugging data duplication in ingestion processes.</li><li>Implement and tune Spark jobs in Azure Databricks, handling data skewness, Catalyst Optimizer, GroupByKey, and ReduceByKey for efficient large-scale data processing.</li><li>Develop advanced analytics solutions in Power BI, creating new measures/columns with DAX functions like CEILING, FLOOR, ABS, VAR.P, VAR.S, STDEV, IF, Nested IF, and IIF.</li><li>Manage MySQL databases with strong command of constraints (Primary Key, Foreign Key, Candidate Key, Alternate Key), Clustered/Non-Clustered Indexes, and query optimization.</li><li>Collaborate with cross-functional teams to deliver SCD Type 1/2/3 implementations, Parquet/Delta Tables, and Medallion Architecture for data lakes.</li><li>Communicate technical concepts clearly in meetings, documentation, and presentations&mdash;strong verbal/written skills and pronunciation clarity are essential.</li></ul>Must-Have Qualifications:<ul><li>Bachelor's/Master's in Computer Science, Data Engineering, or related field.</li><li>Proven expertise in Azure Data Factory (ADF): Parameterized pipelines, deadlock resolution, data duplication debugging.</li><li>Deep knowledge of Azure Databricks/Spark: Catalyst Optimizer, data skewness handling, GroupByKey vs. ReduceByKey.</li><li>Advanced Power BI/DAX: New Measures/Columns, functions including CEILING, FLOOR, ABS, VAR.P, VAR.S, STDEV.</li><li>Strong MySQL fundamentals: All constraints (Primary/Candidate/Alternate Keys), Clustered/Non-Clustered Indexes.</li><li>Experience with data modeling: SCD Types 1/2/3, Parquet, Delta Tables, Medallion Architecture.</li><li>Excellent communication skills: Ability to explain complex ideas clearly and articulately (mandatory for client/stakeholder interactions).</li></ul>Nice-to-Haves:<ul><li>Certifications: Azure Data Engineer Associate (DP-203), Power BI Data Analyst (PL-300).</li><li>Familiarity with additional tools like Azure Synapse, SQL Server.</li></ul>Job Types: Full-time, PermanentPay: &#8377;1,200,000.00 - &#8377;1,800,000.00 per yearBenefits:<ul><li>Flexible schedule</li><li>Health insurance</li><li>Leave encashment</li><li>Provident Fund</li></ul>Work Location: In person

Consultant (Azure & Power BI)

Responsibilities:<ul><li>Develop and maintain AI systems and solutions using various frameworks and tools.</li><li>Lead a team of AI developers and engineers in the creation and implementation of generative AI applications.</li><li>Collaborate with data scientists and domain experts to understand business requirements and translate them into AI solutions.</li><li>Perform data analysis, preprocessing, and feature engineering to prepare data for AI models.</li><li>Train, test, and evaluate AI models using appropriate metrics and methods.</li><li>Deploy and monitor AI solutions in production environments to ensure their reliability and performance.</li><li>Research and stay updated on the latest trends and technologies in AI, particularly in the field of generative AI.</li><li>Ensure compliance with company policies and industry regulations regarding AI ethics and data privacy.</li><li>Provide technical guidance and mentorship to team members.</li><li>Communicate project progress, results, and challenges to stakeholders and senior management.</li></ul>Required Skills and Qualifications:<ul><li>Gradation or Post Graduation in Computer Science, Engineering, or related field.</li><li>Strong knowledge of machine learning, deep learning, natural language processing, computer vision, and other AI-related domains and practices.</li><li>Hands on experience with Open AI, Llama and other LLM models.</li><li>Proven experience in developing and deploying generative AI applications.</li><li>Familiarity with Microsoft AI capabilities, such as Azure Cognitive Services, Azure Machine Learning, Microsoft Bot Framework, Azure Open AI, and MS Copilots.</li><li>Excellent programming skills in languages such as Python, R, or Java.</li><li>Strong problem-solving abilities and attention to detail.</li><li>Experience leading and managing a team of AI professionals.</li><li>Excellent communication and interpersonal skills.</li><li>Ability to work in a fast-paced, dynamic environment and manage multiple projects simultaneously.</li></ul>Preferred Skills:<ul><li>Experience with cloud platforms such as Microsoft Azure.</li><li>Experience with agile development methodologies.</li><li>Developing enterprise applications as a developer or team lead.</li><li>Experience of working with international customers</li></ul>Job Types: Full-time, PermanentPay: ₹1,500,000.00 - ₹2,500,000.00 per yearBenefits:<ul><li>Flexible schedule</li><li>Health insurance</li><li>Leave encashment</li><li>Provident Fund</li></ul>Work Location: In person

AI - Team Manager

Join IFI Techsolutions and explore 2   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

IFI Techsolutions

ABOUT_COMPANY

Consultant (Azure & Power BI)

AI - Team Manager