Consultant (Azure & Power BI)

Data Engineer (Azure & Power BI Specialist)

Location: Noida

Experience Level: 4+ years in data engineering

About Us: IFI Techsolutions (www.ifi.tech)  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:

• 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.
• Implement and tune Spark jobs in Azure Databricks, handling data skewness, Catalyst Optimizer, GroupByKey, and ReduceByKey for efficient large-scale data processing.
• 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.
• Manage MySQL databases with strong command of constraints (Primary Key, Foreign Key, Candidate Key, Alternate Key), Clustered/Non-Clustered Indexes, and query optimization.
• Collaborate with cross-functional teams to deliver SCD Type 1/2/3 implementations, Parquet/Delta Tables, and Medallion Architecture for data lakes.
• Communicate technical concepts clearly in meetings, documentation, and presentations—strong verbal/written skills and pronunciation clarity are essential.

Must-Have Qualifications:

• Bachelor's/Master's in Computer Science, Data Engineering, or related field.
• Proven expertise in Azure Data Factory (ADF): Parameterized pipelines, deadlock resolution, data duplication debugging.
• Deep knowledge of Azure Databricks/Spark: Catalyst Optimizer, data skewness handling, GroupByKey vs. ReduceByKey.
• Advanced Power BI/DAX: New Measures/Columns, functions including CEILING, FLOOR, ABS, VAR.P, VAR.S, STDEV.
• Strong MySQL fundamentals: All constraints (Primary/Candidate/Alternate Keys), Clustered/Non-Clustered Indexes.
• Experience with data modeling: SCD Types 1/2/3, Parquet, Delta Tables, Medallion Architecture.
• Excellent communication skills: Ability to explain complex ideas clearly and articulately (mandatory for client/stakeholder interactions).

Nice-to-Haves:

• Certifications: Azure Data Engineer Associate (DP-203), Power BI Data Analyst (PL-300).
• Familiarity with additional tools like Azure Synapse, SQL Server.

Job Types: Full-time, Permanent

Pay: ₹1,200,000.00 - ₹1,800,000.00 per year

Benefits:

• Flexible schedule
• Health insurance
• Leave encashment
• Provident Fund

Work Location: In person