Psiog Digital - Lead Data Engineer

About Psiog : Psiog Digital is a pure play software services specialist focusing on delivering technology services & solutions in the areas of operational efficiency & customer experience. Headquartered in Chennai, India, Psiog services global customers in North America, EMEA, ANZ & APAC across a variety of industries such as Manufacturing, Energy & Utilities, Hi-Tech, Financial Services, Retail and Automobile. Psiog's core expertise is in building, implementing, testing, integrating & maintaining applications leveraging a variety of cutting-edge tools & technologies. Key service offerings for the Mid-market segment are : - Application Development & Maintenance. - Outsourced Product Development. - Testing & description : Key Skills : - SQL - ETL Tools - Reporting Requirements : - Expert-level knowledge in RDBMS (SQL Server) with clear understanding of SQL query writing, object creation and management and performance and optimisation of DB/DWH operations. - Good understanding of Transactional and Dimensional Data Modelling, Star Schema, Facts/Dimensions, Relationship. - Good understanding of ETL concepts and exposure to at least one ETL service providing tool. - (SSIS/ADF/Similar) Expert-level knowledge in at least one MS reporting/visualisation tool (Power BI/Azure Analysis Services). - Should have worked on at least 1 development lifecycle of one of the below : 1. End-to-end ETL project (Involving any ETL tool). 2. End-to-end reporting project (Involving a reporting too, Power BI & Analysis Services preferred). - Ability to write and review test cases, test code and validate code. - Ability to perform data analysis on different reports to come up with troubleshooting of missing data, suggest value added metrics and consult on best practices to the customer. - Good understanding of SDLC practices like source control, version management, usage of Azure DevOps and CI/CD practices. - Should have the skill to fully understand the context and use-case of a project and have a personal vision for it - Play the role of interfacing with customer directly on a daily basis. - Should be able to converse with functional users and convert requirements into tangible processes/models and documentation in available templates. - Should be able to provide consultative options to customer on best way to execute projects. - Should have a good understanding of project dynamics - scoping, setting estimates, setting timelines, working around timelines in case of exceptions, etc. - Should be able to demonstrate the ability to technically lead a team of developers and testers and perform design reviews, code reviews, etc. - Should have a good understanding of presentation and communications skills - written or verbal, specially to express technical ideas / opportunities : - Opportunity to work as part of the Enterprise Data Management Centre of Excellence and contribute to strategic growth of a fast-growing practice. - Opportunity to mentor, young fresh minds from across premiere institutions. - Exposure to multiple clients and projects simultaneously through CoE model of Skills : - Knowledge of Python. - Knowledge of Azure DevOps, Source Control/Repos. (ref:hirist.tech)

Location: chennai, IN

Posted Date: 4/6/2025