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 : End-to-end ETL project (Involving any ETL tool). 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) Show more Show less