Data Architect

Job Description

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 .