About the role
Position: MS Fabric Data and SQL Engineer
Experience: 3+ years
Location: Bangalore (5 days WFO)
Shift Timings: 6 PM to 2 AM
Mandatory Skill: MS Fabric (1 year experience min.)
Immediate Joiners Preferred
About the company:
Tibil Solutions is an IT consulting and data engineering company founded in 2010 that specializes in artificial intelligence, analytics, cloud data platforms, and business intelligence solutions. The company helps organizations across industries such as banking, retail, healthcare, manufacturing, and the social sector use data-driven technologies to improve decision-making and business performance.
Headquartered in Bengaluru with international presence in the USA and Australia, Tibil Solutions focuses on services like data engineering, machine learning, predictive analytics, and digital transformation for global clients.
Key Responsibilities
• Design and implement Lakehouse architecture using OneLake, Lakehouse, and Fabric Data Warehouse.
• Build Bronze / Silver / Gold data layers using Delta tables and medallion architecture.
• Migrate and modernize legacy SQL Server / SSIS workloads to Microsoft Fabric Pipelines and Notebooks.
• Analyze and study existing stored procedures, views, functions, triggers, and SQL jobs within on-prem SQL Server
• Reverse-engineer complex business and calculation logic embedded in database objects
• Document logic in a clear, structured manner suitable for Workday re-implementation
• Produce functional descriptions, data mappings, and dependency documentation
• Collaborate with functional & HRIS teams
• Support clarification of legacy logic during development and migration activities
• Identify redundant or obsolete logic and highlight simplification opportunities
Primary Skills:
• Develop and orchestrate data pipelines using:
• Fabric Data Pipelines (ADF Gen2 equivalent)
• PySpark / Spark SQL notebooks
• Dataflows Gen2
• API integration
• MS SQL Server 2016 (On-Premises, Legacy Systems)
• Advanced T-SQL (Stored Procedures, Functions, Views, Triggers)
• Strong understanding of complex joins, CTEs, and query optimization
• Excellent analytical and documentation skills
• Ability to translate technical SQL logic into functional documentation
Secondary / Good-to-Have Skills:
• .Net
• SSIS / PowerBI knowledge
• Agile delivery experience