10+ year of experience in delivering BI/Data Warehouse design, architecture and implementation projects in Pharma and Life Sciences domain.
Strong experience in data modeling, data science, data analytics, design and development of applications using various BI, reporting and data warehouse technologies.
Experience on AWS cloud and services like Athena, RDS, PostgreSQL, S3, python, Lambda.
Hands-on experience on Erwin data modeling to design source specific model, functional model, LDM/PDM technical design model is preferred.
Solid experience in complete life cycle of Data Warehouse Development starting from Source – Target Data mapping, loading landing and staging tables through complete aggregation and reporting of the Enterprise Data Warehouse including process documentation.
Experience on requirement gathering, communicating with business SME or BA, providing architecture solution based on requirement, providing technical architect solution to deciding technologies and flow to achieve project requirement.
Hand on experience on OLTP system like Oracle, SQL Server and MySQL to extract data, SQL/PLSQL programming, writing complex SQL and query optimization on various databases.
Experience working on Agile methodology for software development using JIRA application.
Knowledge on Python, C programming, UNIX Shell Scripting is a huge plus
Must possess excellent communication and management skills.