Data Architect

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 .