Job Description :
Responsible to write SQL queries to validate data quality and integrity in SQL Server, Oracle, APS, PDW , MDM etc.
Responsible to write Scala and SQL code on Spark to ensure data quality and integrity in Hadoop based data stores like Azure Cosmos DB , Azure Blob, Hive etc. using HDI cluster in cloud.
Responsible to ensure data quality and integrity is maintained in ETL processes that built using traditional tools like SSIS, Informatica and Cloud based tools like Azure Data Factory and Spark jobs.
Responsible to review and assess analytical data models built on traditional Inman or Kimball methodology (Star schema, snow flake and denormalized data base models