Overall 12+ years of experience working on Databases, Data Warehouse, Data Integration and BI/Reporting solutions with relevant experience in Lifesciences/Pharma domain.
Education: BE/B.Tech/Master of Computer Application
Technical:
- Design and implement effective database solutions and data models to store and retrieve data.
- Hands on experience in the design of reporting schemas, data marts and development of reporting solutions.
- Prepare scalable database design and architecture in terms of defining multi-tenants schemas, data ingestion, data transformation and data aggregation models.
- Should have expertise and working experience in at least 2ETL toolsamong Informatica, SSIS, Talend & Matillion
- Should have expertise and working experience in at least 2DBMS/appliances among Redshift, SQL Server, PostgreSQL, Oracle.
- Should have strong Data Warehousing, Reporting and Data Integration fundamentals.
- Advanced expertise with SQL
- Experience on AWS/Azure cloud data stores and it s DB/DW related service offerings.
- Should have knowledge and experience of Big Data Technologies (Hadoop ecosystem) and NO SQL databases.
- Should have technical expertise and working experience in at least 2 Reporting tools among Power BI, Tableau, ,Jaspersoft and QlikView/QlikSense.
- Advanced technical Competencies in SQL .