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