Data Warehousing Developer

  • ISO,
  • Jersey City, NJ
ETL OLTP SSIS SQL
Full Time
competitive salary
Telecommuting not available Travel not required

Job Description

Position Summary:

Are you passionate about transforming and engineering data in most effective way and does creating innovative data management and reporting solutions excite you? Are you looking for an opportunity where you can both practice your technical trade while adding to your leadership, consulting and delivery experience to turn a career corner? If you've got technical chops, consulting skills and are a passionate data engineer, please read on...

 Responsibilities:

  • Responsible for maintenance, improvement, cleaning, and loading data into data warehouses, analytics data stores for reporting and BI solutions, advanced analytics platforms
  • Responsible for integration of data from data warehouse and big data platform into Data Lake or Modern Data Platform
  • Maintenance of meta data, data policies and business data definition and publish them for internal and external stakeholders
  • Work closely with BI technology vendors for performing proof of concept (POC)of new data ingestion and transformation tools for recommending new tools and technologies for internal and external stakeholders
  • Implement data transformation and integration rules based on industrial best practice and help developing corporate strategy in those practice
  • Work closely with Data Modeler and DBA team for implementing data validations and data quality standards in to the data warehouse
  • Document data sources on client projects and perform gap analysis to identify inflow of bad data into data warehouse and develop data quality recommendations and solutions
  • Responsible for assessing data quality gaps for P&C Insurance clients and develop industry best practices and solutions for business problems for internal and external stakeholders

 

Requirements:

  • 5+ years of experience in data transformation and data integration practice in SSIS data integration tool
  • Hands on experience in developing ETL scripts for loading data into star and snowflake schema
  • Hands on experience developing ETL scripts for loading data in OLTP databases in 3N form
  • 2+ years of hands on experience in Insurance Data model and/or BDW and able to create/maintain/coordinate with metadata and data validation rules with project stakeholders
  • Data Mapping hands on expertise, able to understand business requirement and derive data conversion rules for implementing into ETL scripts
  • Expertise in any of the tools preferable any two of SSIS, IBM InfoSphere DataStage, Informatica PowerCenter (SSIS most preferred)
  • Understanding of Business Intelligence tools such as Tableau, Tibco Spotfire and able to summarize and consolidate the dimensions and measures for reporting
  • Strong SQL is a must and previous experience in any of the database preferably SQL Server
  • Able to learn new data integration tools such as Pentaho Data Integration, Hive, Spark-SQL for ingesting data into Data Lake
  • Knowledge and/or experience in the P&C industry is highly desired – along with at least one functional area relevant to these clients – new business, agency, policy system, actuarial, claims and loss, Stat plan reporting
  • Thorough understanding of data warehouse architectures and data models for P&C insurance company
  • Good team player
  • Strong project management skills and attention to detail
  • Excellent communication skills, both written and verbal

 

We are offering an excellent compensation package. Our competitive benefits package includes full health care options, a 401(k) plan, and generous Paid-Time-Off.

Dice Id : 10123386
Position Id : 139652
Have a Job? Post it