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 multitenants schemas data ingestion data transformation and data aggregation models.
- 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 Oracle.
- Should have strong Data Warehousing Reporting and Data Integration fundamentals.
- Advanced expertise with SQL
- Experience on AWS/Azure cloud data stores and its 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 .