Data Architect @ Prov HR Solutions

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 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

Employement Category:

Employement Type: Full time
Industry: Software Product
Role Category: DBA / Datawarehousing
Functional Area: Not Applicable
Role/Responsibilies: Data Architect

+ View Contact

Keyskills:   Databases Data Integration ETL Informatica SSIS Talend DBMS SQL Server PostgreSQL Oracle Data Warehousing SQL AWS Azure Big Data Hadoop NO SQL Power BI Tableau Jaspersoft QlikView QlikSense Data Warehouse BIReporting LifesciencesPharma Matillion Redshift