• Chubb
  • Whitehouse Station , NJ
  • Information Technology
  • Full-Time
  • 51 School Rd

Job Description - Sr. Data and ETL Developer (326495)Job Description Sr. Data and ETL Developer(Job Number: 326495)Description Job Title: Sr. Data and ETL Developer (Analytics) Job Category: IT Department: IT Relo Benefit: No HR Mgr.: Hiring Mgr.: Anthony Marino Posting City: Whitehouse Station, NJ Band: 25 Status: Full-Time Hiring Mgr Phone: (215) ###-#### Description: The Data and ETL Developer will join the Chubb Claims IT team which focuses on mission critical applications that support claim adjusters and other claim professionals in Chubb s Claims Department, world-renowned for outstanding customer service.The Sr. Developer role will guide and work closely with a team of development resources to analyze, design, construct and test software development projects focused on analytics and data integration. This position will require a high degree of collaboration and detailed communication within and across multiple teams working closely with business, IT architecture and outsourced technical teams.Included in the job are opportunities to: Assume a Sr. technical delivery position working on complex software development efforts and maintenance supportGain exposure to new technologies supporting digital and data strategiesCollaborate with other high-caliber IT professionals Responsibilities Include: Plan and coordinate data-focused development efforts with Business Partners, Project Managers, Architecture Teams and DevelopersProvide hands-on technical delivery and guide development teams consisting of both on and offshore developersFormulate, design and develop solutions based on business requirements and application roadmap aligning with architectural directionLead and implement assignments independently as a hands-on expert by providing technical and business expertise on key projects and enhancementsGather and analyze business and technicalrequirements and recommend solutions to meet functional requirements to support business needsWork with business partners and technical architects to develop strategic, cost-effective solutions to meet business needs and ensure programs meet standards and technical specificationsAccountable to size / estimate development work, establish plans for execution and conduct/facilitate design and code reviewsEffectively communicate project status and assist Project Managers in the timely and accurate measurement of overall project healthIdentify and quantify risks; make recommendations for risk mitigation and contingency plansAssist with issue identification, tracking and resolutionResponsible for ensuring adherence of all deliverables to appropriate standards and quality levelsTroubleshoot and support production processes to meet daily SLA'sCollaborate with DBA s to address data design and processing requirements / issues Technical Skills / Experience: Minimum 5 years of experience working with logical & physical normalized and denormalized data models & documentation (i.e. table & column definitions, relationships, keys (primary, foreign, surrogate), referential integrity). Ability to apply this information to effectively develop solutions, analyze data and research data issues.Understand high level data & process flow designs and reference data architectures Significant experience writing complex and effective SQL queries including the use of inner/outer joins, sub-selects, aggregates, basic/advanced functions, views, cursor processing and various other database programming techniquesRobust data analysis skills. Ability to gain an understanding of existing data, effectively communicate findings, and make recommendations that address business needsStrong database knowledge around table maintenance, run stats, reorg, indexing (various types), SQL performance tuning, etc.Experience working with large data volumes and complex systems. Good understanding of how to avoid database locks, contention and minimize database threads.Experience with ETL audit, balance, control and restart best practicesMinimum 5 years of experience developing with ETL and Data Virtualization toolsets, specifically Informatica PowerCenter on a UNIX Platform and/or ICS/IICSAdvance PowerCenter Transformation experience (effective usage of parameters, variables, SQ overrides, pushdown optimization, lookups and caching with performance considerations)Hands-on Mapplet and Worklet creation, usage and declared benefitExperienced in a Shared Development environment without versioned repositioriesReusability of developed code and shared objectsExtensive UNIX scripting experience, including PowerCenter Pre/Post Session commands (file list, etc )Minimum 5 years of SQL experience in Microsoft SQL Server, Oracle and/or DB2Proficient in learning new technologies with the ability to quickly understand capabilities and work with others to guide these into developmentBachelor's degree in Information Systems, Computer Science or similar technical degree, or equivalent Information Technology work experience Other Skills / Experience: Demonstrated Technical delivery with the ability to lead other developers by example through the complete SDLC of a projectExperience with Agile and / or like methodologiesProven ability to produce results in the analysis, design, construction, testing and deployment of applicationsStrong team emphasis and relationship building skills; partners well with business and non-Claim IT areasApplies technical knowledge to determine solutions and solves complex problemsAbility to be proactive, self-motivated, detail-oriented, creative, inquisitive and persistentExcellent communication and negotiation skillsAbility to organize, plan and implement work assignments, juggle competing demands and work under pressure of frequent and tight deadlinesImpact analysis, problem isolation, and performance tuningInsurance industry, Claims or Analytics experience a strong plusQualifications Job Title: Sr. Data and ETL Developer (Analytics) Job Category: IT Department: IT Relo Benefit: No HR Mgr.: Hiring Mgr.: Anthony Marino Posting City: Whitehouse Station, NJ Band: 25 Status: Full-Time Hiring Mgr Phone: (215) ###-#### Description: The Data and ETL Developer will join the Chubb Claims IT team which focuses on mission critical applications that support claim adjusters and other claim professionals in Chubb s Claims Department, world-renowned for outstanding customer service.The Sr. Developer role will guide and work closely with a team of development resources to analyze, design, construct and test software development projects focused on analytics and data integration. This position will require a high degree of collaboration and detailed communication within and across multiple teams working closely with business, IT architecture and outsourced technical teams.Included in the job are opportunities to: Assume a Sr. technical delivery position working on complex software development efforts and maintenance supportGain exposure to new technologies supporting digital and data strategiesCollaborate with other high-caliber IT professionals Responsibilities Include: Plan and coordinate data-focused development efforts with Business Partners, Project Managers, Architecture Teams and DevelopersProvide hands-on technical delivery and guide development teams consisting of both on and offshore developersFormulate, design and develop solutions based on business requirements and application roadmap aligning with architectural directionLead and implement assignments independently as a hands-on expert by providing technical and business expertise on key projects and enhancementsGather and analyze business and technicalrequirements and recommend solutions to meet functional requirements to support business needsWork with business partners and technical architects to develop strategic, cost-effective solutions to meet business needs and ensure programs meet standards and technical specificationsAccountable to size / estimate development work, establish plans for execution and conduct/facilitate design and code reviewsEffectively communicate project status and assist Project Managers in the timely and accurate measurement of overall project healthIdentify and quantify risks; make recommendations for risk mitigation and contingency plansAssist with issue identification, tracking and resolutionResponsible for ensuring adherence of all deliverables to appropriate standards and quality levelsTroubleshoot and support production processes to meet daily SLA'sCollaborate with DBA s to address data design and processing requirements / issues Technical Skills / Experience: Minimum 5 years of experience working with logical & physical normalized and denormalized data models & documentation (i.e. table & column definitions, relationships, keys (primary, foreign, surrogate), referential integrity). Ability to apply this information to effectively develop solutions, analyze data and research data issues.Understand high level data & process flow designs and reference data architectures Significant experience writing complex and effective SQL queries including the use of inner/outer joins, sub-selects, aggregates, basic/advanced functions, views, cursor processing and various other database programming techniquesRobust data analysis skills. Ability to gain an understanding of existing data, effectively communicate findings, and make recommendations that address business needsStrong database knowledge around table maintenance, run stats, reorg, indexing (various types), SQL performance tuning, etc.Experience working with large data volumes and complex systems. Good understanding of how to avoid database locks, contention and minimize database threads.Experience with ETL audit, balance, control and restart best practicesMinimum 5 years of experience developing with ETL and Data Virtualization toolsets, specifically Informatica PowerCenter on a UNIX Platform and/or ICS/IICSAdvance PowerCenter Transformation experience (effective usage of parameters, variables, SQ overrides, pushdown optimization, lookups and caching with performance considerations)Hands-on Mapplet and Worklet creation, usage and declared benefitExperienced in a Shared Development environment without versioned repositioriesReusability of developed code and shared objectsExtensive UNIX scripting experience, including PowerCenter Pre/Post Session commands (file list, etc )Minimum 5 years of SQL experience in Microsoft SQL Server, Oracle and/or DB2Proficient in learning new technologies with the ability to quickly understand capabilities and work with others to guide these into developmentBachelor's degree in Information Systems, Computer Science or similar technical degree, or equivalent Information Technology work experience Other Skills / Experience: Demonstrated Technical delivery with the ability to lead other developers by example through the complete SDLC of a projectExperience with Agile and / or like methodologiesProven ability to produce results in the analysis, design, construction, testing and deployment of applicationsStrong team emphasis and relationship building skills; partners well with business and non-Claim IT areasApplies technical knowledge to determine solutions and solves complex problemsAbility to be proactive, self-motivated, detail-oriented, creative, inquisitive and persistentExcellent communication and negotiation skillsAbility to organize, plan and implement work assignments, juggle competing demands and work under pressure of frequent and tight deadlinesImpact analysis, problem isolation, and performance tuningInsurance industry, Claims or Analytics experience a strong plusWhitehouse Station - A Whitehouse Station 08889-1600Information TechnologyTravel - NoJob Posting - Jun 3, 2019, 4:03:18 PM

by Jobble


Associated topics: .net, c, design pattern, devops, matlab, maven, programming, project architect, senior, senior software developer

* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...