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 multi-tenants’ 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 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 .