What are the responsibilities and job description for the Data Warehouse Cincinnati - OH - Ohio position at Sierra Business Solution LLC?
Job Details
Role name: Lead Data Warehouse Engineer
Role Description: Experience in Data warehousing, AWS Cloud Business, Intelligence, Informatica and Databricks(data flow design, development, enhancement and maintenance).Real time data ingestion using StreamsetsExperience UDM ModelExperience in Dimensional Modelling, Data Migration, Data Cleansing, Data conversion and bridging, and ETL techniques on multiple databases and operating systems.Experience in Python, Databricks, perl, spark , Kubernetes, dockers and other cloud native tools and technologies.Informatica Power Center, PLSQL, Cobol , C, JCL, Teradata BTEQ, Unix Shell scriptingContextual knowledge on Nationwide claims applications and data processing into warehouse. DataLakehouse development on Ingestion , Harmonization and Curation layersExperience in developing application framework to ingest third party data
Experience (Years): 10 & Above
Essential Skills: Data warehousing, AWS Cloud Business, Intelligence, Informatica and Databricks(data flow design, development, enhancement and maintenance).Real time data ingestion using StreamsetsExperience UDM ModelExperience in Dimensional Modelling, Data Migration, Data Cleansing, Data conversion and bridging, and ETL techniques on multiple databases and operating systems.Python, Databricks, perl, spark , Kubernetes, dockers and other cloud native tools and technologies.
Desirable Skills: P&C insurance domain knowledge