Talend / ETL Developer ( AWS ) - Remote

The Travelers Companies Hartford , CT 06183

Posted 2 months ago

Company Information

Solid reputation, passionate people and endless opportunities. That's Travelers. Our superior financial strength and consistent record of strong operating returns mean security for our customers - and opportunities for our employees. You will find Travelers to be full of energy and a workplace in which you truly can make a difference.

Target Openings

1

Job Description Summary

Travelers is seeking a Software Engineer I to join our organization as we grow and transform our Technology landscape.

Individual will participate in the design, build and management of large-scale data structures and pipelines and efficient Extract/Load/Transform (ETL) workflows. Individual will complete intermediate end to end engineering tasks for specific system assignments including developing, analyzing, configuring, testing, debugging, troubleshooting, documenting, health monitoring/alerting, and implementing based on user or system design specifications, as well as participating in troubleshooting, conducting impact analysis and escalating appropriately.

Primary Job Duties & Responsibilities

  • Perform analysis, design, development, and configuration functions as well as define technical requirements for assignments of intermediate complexity.

  • Participate with team to perform analysis, assessment and resolution for defects and incidents of intermediate complexity and escalate appropriately.

  • Work within guidelines set by team to independently tackle well-scoped problems.

  • Seek opportunities to expand technical knowledge and capabilities.

  • Participates in the development of large-scale data structures and pipelines to organize, collect and standardize data that helps generate insights and addresses reporting needs

  • Writes ETL (Extract / Transform / Load) processes, designs database systems and develops tools for offline analytic processing

  • Uses advanced programming skills in Python, Scala or any of the major languages to build robust data pipelines and dynamic systems

  • Uses in-depth knowledge on Hadoop architecture, HDFS commands and experience designing & optimizing queries to build scalable, modular, and efficient data pipelines

  • Builds data marts and data models to support clients and other internal customers

  • Integrates data from a variety of sources, assuring that they adhere to data quality and accessibility standards

Minimum Qualifications

  • Bachelor's degree or its equivalent in work experience.

  • One year of programming/development experience.

Education, Work Experience, & Knowledge

  • Three years of programming/development experience preferred.

Job Specific Technical Skills & Competencies

  • Experience with one or more modern data ingestion/curation/wrangling tools/technologies (e.g.: Ab Initio, Informatica, Talend, AWS Glue, etc.)

  • Ability to leverage multiple tools and programming languages to analyze and manipulate data sets from disparate data sources

  • Experience with one or more data platforms (e.g.: Teradata, Hadoop, Oracle, SQL Server, DB2)

  • Proficiency in writing complex SQL scripts and procedures is a must

  • Experience building data transformation and processing solutions

  • Experience in building high volume data pipelines on distributed compute platforms like EMR & Databricks using Python, PySpark, Hive, etc.

  • Experience with bash shell scripts, UNIX utilities & UNIX Commands

  • Experience in Hadoop architecture, HDFS commands and experience designing & optimizing queries against data in the HDFS environment

  • Knowledge in NoSQL databases (e.g. MongoDB, Cassandra) is preferred

  • Experience in writing Shell/Perl scripts in LINUX, Power shell in Windows is nice to have

  • Exposure to Big Data / Hadoop applications using Sqoop, Pig, Hive, Python, Spark, Kafka and Storm

  • Experience in building software solutions on Public Cloud such as AWS or GCP is a plus

  • Delivery

  • Intermediate delivery skills including the ability to deliver work at a steady, predictable pace to achieve commitments, decompose work assignments into small batch releases and contribute to tradeoff and negotiation discussions.
  • Domain Expertise
  • Demonstrated track record of domain expertise including the ability to understand technical concepts necessary to do the job effectively, demonstrate willingness, cooperation, and concern for business issues and possess in-depth knowledge of immediate systems worked on.
  • Problem Solving
  • Proven problem solving skills including debugging skills, allowing you to determine source of issues in unfamiliar code or systems and the ability to recognize and solve repetitive problems rather than working around them, recognize mistakes using them as learning opportunities and break down large problems into smaller, more manageable ones.
  • Communication
  • Strong communication skills with the ability to clearly and concisely interact with team members, document work in a clear, easy to follow manner, collaborate well with team members, take in well- scoped requirements and ask the right questions to ensure clarification, seek out and receive constructive criticism well and listen when others are speaking.
  • Leadership
  • Intermediate leadership skills with a proven track record of self-motivation in identifying personal growth opportunities.

Equal Employment Opportunity Statement

Travelers is an equal opportunity employer.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Lead ETL Developer Data Engineering

The Travelers Companies

Posted 2 weeks ago

VIEW JOBS 7/30/2020 12:00:00 AM 2020-10-28T00:00 Company Information Solid reputation, passionate people and endless opportunities. That's Travelers. Our superior financial strength and consistent record of strong operating returns mean security for our customers - and opportunities for our employees. You will find Travelers to be full of energy and a workplace in which you truly can make a difference. Target Openings 1 Job Description Summary Under limited supervision, performs expert programing, configuring, and/or analysis for impactful and visible projects. Manages the effective use of line of business resources for implementation of ongoing projects, enhancements, initiatives and/or problem resolution. Acts as subject matter expert across multiple applications, systems and technologies, leveraging technical and business knowledge to drive the planning and execution of complex initiatives. Participates in the design/ development process. Provides technical leadership on complex projects. Leads investigation and resolution efforts for critical, high impact problems and incidents. This job is a technical lead. This job does not lead others. Primary Job Duties & Responsibilities * Manages the strategic plans and tactical activities for assigned information systems and business unit systems projects. * Acts as subject matter expert across multiple applications, systems and technologies leveraging technical and business knowledge to drive the planning and execution of complex initiatives. * Responsibilities include performing complex analysis, expert level design, configuration and programming functions for impactful and visible projects. * Leads investigation and resolution efforts for critical, high impact problems, defects, and incidents. * Contributes to staffing and project plan estimations in collaboration with the project manager and other key stakeholders. * Assesses the technical viability of projects and objectives. * Acts as a technology advocate and independently seeks opportunities where technology can be utilized to improve the business. * Builds, maintains, and utilizes partnerships across the enterprise ensuring the best use of resources. * Provides technical leadership, fosters a team environment, and provides mentorship and feedback to technical resources. * Manages the effective use of line of business resources to implement ongoing projects, enhancements, initiatives, and/or problem resolution. * Applies knowledge of current industry trends and techniques to formulate solutions within the context of assigned projects. * Ensures project team's work complies with Travelers standards, processes, and protocols. * Other duties as assigned. Minimum Qualifications * A bachelor's degree in Computer Science or a related field, or its equivalent in work experience, and five years of programming/development experience. Education, Work Experience, & Knowledge * 7 years of programming/development experience preferred. * Experience as a technical lead preferred. Job Specific Technical Skills & Competencies * Data concepts - Data Warehouse, Data Lake, Data Model, DB Design, Data Mapping * Data platforms - RDBMS, Big Data and Cloud * Data integration tools - Talend, Ab Initio * Scheduling tools - Autosys, Control-M * Programming languages - Spark, Python, Java * Dev Ops - Continuous Integration, Continuous Deployment, Version Control * Data serialization formats - Parquet, Orc * Cloud services - Ex: AWS - EC2, EMR, RDS, Redshift, S3, Lambda * Containerization technologies - Docker, Kubernetes Environmental / Work Schedules / Other * Operates standard office equipment. * Requires extended periods of computer use. * Requires extended periods of sitting. Equal Employment Opportunity Statement Travelers is an equal opportunity employer. The Travelers Companies Hartford CT

Talend / ETL Developer ( AWS ) - Remote

The Travelers Companies