Business Intelligence | ADF | Informatica 4 - 7 years Exp | chennai Location

Company Description Qzensys Solutions is a trusted professional services partner providing IT staffing, consulting, software development, and technology solutions across modern platforms and tools. The company supports organizations in building agile, future-ready teams through access to specialized talent and expertise in cutting-edge technologies. With a strong focus on quality, reliability, and client success, Qzensys Solutions helps businesses drive digital transformation and remain competitive in a fast-changing technology landscape. In addition to staffing and consulting, the company delivers end-to-end software development services across diverse technology stacks and platforms.

Immediate joiner; start date August 12th 2026 work from office ( Chennai location)

Interested folks reach me directly 9703589293. We are seeking a skilled BI Engineer with strong expertise in Business Intelligence, ETL development, data modelling, and reporting solutions. The ideal candidate will be responsible for designing and developing scalable reporting data models, building interactive dashboards, and ensuring high-quality, accurate reporting solutions. The role requires close collaboration with business stakeholders and cross-functional teams to translate business requirements into insightful analytics and reporting.

Key Responsibilities: • Design, develop, and maintain reporting data models, semantic layers, and curated datasets for enterprise reporting. • Develop, optimize, and maintain ETL/ELT pipelines to extract, transform, and load data from multiple source systems. • Build interactive dashboards and reports using BI tools such as Power BI, Qlik Sense/QlikView, IBM Cognos, Tableau, or similar platforms. • Develop complex SQL queries, views, stored procedures, and aggregation logic for reporting and analytics. • Design and implement dimensional data models, including star and snowflake schemas. • Validate and reconcile reporting data against source systems to ensure data accuracy and consistency. • Collaborate with business users to gather reporting requirements and deliver actionable insights. • Optimize report performance and improve data processing efficiency. • Support User Acceptance Testing (UAT) and resolve reporting or data discrepancies. • Participate in code reviews, version control, and CI/CD deployment processes for BI solutions. • Enhance existing dashboards and reports based on evolving business needs. • Utilize AI-assisted tools to improve SQL development, ETL processes, and data modeling efficiency.

Required Skills & Experience: • 4–7 years of experience in Business Intelligence, Data Engineering, or Analytics. • Strong hands-on experience in ETL development using tools such as SSIS, Azure Data Factory (ADF), Informatica, Talend, or similar ETL platforms. • Strong SQL expertise, including complex query development, performance tuning, stored procedures, views, and data optimization. • Experience designing reporting semantic layers and enterprise reporting data models. • Hands-on experience with Power BI, Qlik Sense/QlikView, IBM Cognos Analytics, Tableau, or other enterprise BI tools. • Strong understanding of dimensional modelling concepts, including fact tables, dimension tables, star schemas, and snowflake schemas. • Experience working with Azure SQL Database, Azure Synapse Analytics, SQL Server, or other relational databases. • Experience validating and reconciling reporting data with source systems. • Familiarity with version control systems and CI/CD pipelines. • Experience using AI tools to support SQL development, ETL design, and reporting optimization. • Excellent analytical, problem-solving, and communication skills. Preferred Skills • Experience with Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, or other cloud- based data platforms. • Knowledge of data warehousing concepts, Lakehouse architecture, and Medallion Architecture (Bronze, Silver, Gold). • Experience with Azure DevOps, Git, or similar source control tools. • Understanding of data governance, data quality, and metadata management. • Experience working with ERP or enterprise business applications. • Exposure to financial, operational, or enterprise reporting environments