Sr. ETL Developer
Chubb
- Whitehouse Station, NJ
- Permanent
- Full-time
- Take ownership of your projects and deliver high-quality data-driven solutions
- Work across data sources and types to build, optimize, integrate, and/or troubleshoot the ETL jobs that bring data from across the personal lines business into a centralized repository
- Collaborate with peers and stakeholders across business and technical teams to define requirements, identify source data, assist with high level data designs, analyze, and troubleshooting data issues
- Conduct senior level analysis utilizing SQL to facilitate the data integration process through profiling data, understanding relationships in the data, and validating the integrity of the data
- Synthesize data, uncover inherent trends in data, assess impacts of data on business usage, and make recommendations for improvement
- Create UNIX shell scripts to perform file level validation and analysis
- Create Jll files and utilize AutoSys for job orchestration, monitoring, and reporting
- At least 5+ years of experience in an ETL Development role showing a strong understanding of ETL development concepts and tools such as AWS Glue, Google Dataflow, Azure Data Factory, Snowflake, etc.
- Strong experience working with Informatica PowerCenter / IICS and other Informatica offerings like Informatica Intelligent Data Management Cloud (IDMC)
- Experience working with enterprise class RDBMS platforms like Oracle, SQL Server, and DB2; must have worked on ETL efforts in one of these environments
- Must be able to read, understand, and interpret data models
- Bachelor's degree required in Computer Science, Computer Information Systems, Information Systems, Information Technology or Computer Engineering or equivalent work experience
- Demonstrated experience coordinating ETL work with an onshore/offshore vendor team
- Experience mentoring and leading junior developers, especially in an onshore/offshore model including the flexibility to manage work schedule as needed to support onshore/offshore model
- Proven ability to create and maintain documentation (ETL designs, technical specs, test cases, test results, project status, deployment plans, etc.)
- Experience working on projects using Agile, Scrum, or Scaled Agile Framework (SAFe)
- Prior experience working in a data warehouse environment or on data integration projects a strong plus
- Property and Casualty Insurance domain experience and/or knowledge is a plus
- Exposure to and/or experience with MS Azure or other Cloud Platforms a plus
- Dynamic Hybrid - flexible work arrangements
- Competitive offer packages which include a competitive base salary bonus and equity (for applicable roles)
- Employee stock purchase plan (15% discount)
- Comprehensive benefits that start day 1
- Retirement savings plan (Chubb contributes up to 9% on your behalf)
- Investment in education program- Tuition reimbursement program
- Charitable gift matching programs
- Mentorship programs to help you grow your career