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:
o End-to-end ETL project (Involving any ETL tool)
o 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 Dev Ops
and CI/CD practices.
RequirementsShould 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 positive understanding of presentation and communications skills – written or verbal, specially
to express technical ideas / solutions.
Benefits • At Psiog, we believe people grow when opportunities do. You’ll be part of an ecosystem that encourages curiosity, innovation, and ownership.
• Work with global clients, and enterprise environments, enabling exposure beyond conventional delivery models.
• Accelerated career tracks with a faster roadmap to leadership for those who demonstrate capability and initiative.
• Opportunity to explore diverse technologies, projects, learning opportunities and domains, allowing you to shape your own growth path.
• An organization that celebrates passion alongside profession, encouraging creativity, art, and individuality.

📌 Technical Lead- Data (India)
🏢 Psiog
📍 India