Previous Job
Data Warehouse Developer
Ref No.: 18-01387
Location: Philadelphia, Pennsylvania
Position Type:Contract
Experience Level: 5 Years
Start Date / End Date: 08/20/2018 to 06/30/2020

Data Warehouse/ETL Developer/Data Engineer

The Data Engineer is a data generalist on the Information Management team that translates business demand for information into ETL processes to move the data with a high level of quality to ensure its completeness and accuracy. This resource will be responsible for loading data from the new Guidewire Policy Center and Billing Center applications into the Enterprise Data Warehouse.

Specific Responsibilities
  • Ensure that data is loaded from the new Policy Center and Billing Center applications completely and accurately into the new Enterprise Data Warehouse according to the source-to-target mapping documentation.
  • Ensure the use of the company's development standards including naming conventions, reusable processes, development best practices, and unit testing.
  • Write efficient SQL code to move the data that moves the data in the shortest possible time.
  • Partner with business stakeholders to review specifications for data integration & movement that includes performing data analysis, identify data related issues, review source/target mappings and transformation, load and data cleansing rules.
  • Understand the overall project and proactively identify any issues as well as provide a recommended solution.
  • Support development troubleshooting of data defects with transactional systems, and data integration (ETL) platform. Prepare scripts for schema changes and data fixes.
  • Champion data quality. Ensure a high level of data quality by implementing data quality rules and developing improvement plans. Maintain metadata and support the firm's metadata platform.
  • Actively participate in projects and complete duties as assigned by manager and project leadership

5+ years of experience with data engineering, including experience with data migration
Expert with SQL and stored procedures.
Experience with modeling tools like ERWin and model management.
Experience with relational databases like Oracle or Microsoft SQL Server. Expert with SQL and stored procedures.
Experience with Guidewire Billing Center or Policy Center is preferred for the roles working with these specific Guidewire teams.

IND 123

For more information please contact Brian Otten at 203-433-7817 or

Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing  and Government sectors with local offices in Connecticut, Minnesota, Colorado,  Massachusetts, Tennessee, and New Jersey / Pennsylvania area. 

Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them.   So at iTech Solutions,  our personnel are all career IT professionals with a wide range of IT experience.  We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.  

Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.