ETL Developer

Honeywell Overland Park , KS 66204

Posted 3 months ago

ETL Developer

Join the industry leader to design the next generation of breakthroughs

The selected candidate will join our ETL and BI Developers within the IT division at the Kansas City National Security Campus. The team is responsible for working with internal business customers to identify business requirements, developing and administering big data ingestion processes on our Hortonworks Hadoop platform, and supporting/interfacing with our ETL (Talend), Data Virtualization (Denodo), and Enterprise Analytics (MicroStrategy) platforms. This position will focus on our growing ETL and Big Data ingestion needs with opportunities to work on Microstrategy.

This position can work remotely but must live in the Kansas City Metro area.

Summary of Duties:

  • Design, translate business requirements, develop, document, test, monitor, troubleshoot and administrate our data environment using our ETL / Data Virtualization / BI Reporting/ Big Data ingestion tool sets

  • Participate in maintenance and upgrades for our platforms and tool sets

  • Contribute to the support and resolution of incidents which involve all data platforms which includes a weekly on-call rotation

  • Maintain knowledge of new technologies and methods for area of expertise and have knowledge sharing sessions with the team

  • Communicate and accurately document all architectural decisions, plans, goals, functional requirements, and open items and issues to key stakeholders, including management, development teams, and business areas

  • Build and maintain strong peer relationships within the team and across the organization

  • Participates in short- and long-term planning sessions with customers to improve business processes and works closely with Technical Review Board and architects to assure all systems are in line with IT long-term strategy.

  • Proactively analyzes existing information systems and applications to identify weaknesses and develop opportunities for improvements and may lead the evaluation and selection process for new application packages.

  • Manages customer's priorities of projects and requests with the help of the Data Team Lead.

  • Assesses customer needs utilizing a structured requirements process (gathering, analyzing, documenting, and managing changes) to prioritize immediate business needs and advising on options, risks and cost vs. benefits.

  • Participate in data governance initiatives, maintain metadata (data definitions, relationships, sources, and consumers), and contribute to the company's Data strategies and roadmaps

  • Adheres to quality standards and procedures. Reviews code for quality assurance and checks compliance with data architecture standards and conducts unit testing to ensure code meets specifications.
    40 ETL Development 40 ETL Support 20 Collaborate with stakeholders

You Must Have:

  • U.S. Citizen in order to obtain and maintain US Dept. of Energy "Q" level security clearance

  • Bachelor's degree in the field of Information Systems, Computer Science, Computer Engineering, Engineering, or Physical Science OR minimum 4 years of SQL experience and/or 4 years of Big Data ingestion experience.

  • Minimum 2 years of SQL experience (ability to develop, modify, troubleshoot and optimize complex queries)

  • Minimum 2 years of experience working in Oracle or SQL Server or Teradata databases (e.g. table creation, insert, update, deletes, indexing, optimization)

We Value:

  • Experience or knowledge of a major programming language (e.g. Java, Python, C#)

  • Experience or knowledge of a scripting language (e.g. Linux shell, Windows batch, Perl, VBS)

  • Experience working in a Red Hat Enterprise Linux and/or Windows environment

  • Excellent problem solving, design, coding and debugging skills

  • Experience working with mobile teams working in the Kansas City area and beyond

Must have or be eligible for a security clearance due to contractual requirements.ExemptHoneywell FM&T OverviewINCLUDES

  • Continued Professional Development
  • 1st Shift


  • Job ID: req158780

  • Category: Information Technology

  • Location: 6700 W 115th St, Overland Park, KS 66211 USA

Honeywell is an equal opportunity employer. Qualified applicants will be considered without regard to age, race, creed, color, national origin, ancestry, marital status, affectional or sexual orientation, gender identity or expression, disability, nationality, sex, or veteran status.


upload resume icon
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

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

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
ETL Developer (1855732)

Ivy Nextshares

Posted 2 months ago

VIEW JOBS 11/21/2018 12:00:00 AM 2019-02-19T00:00 The ETL Developer plays a vital role in the effective management of data and creates programs that support the organization and client demands. This position will use ETL tools to support all the steps like extraction, transformation, and load processes. This position is responsible for data integration, data warehousing, data migration, data management, etc. Responsibilities: * Provides development estimates and participates in project planning. * Participates in designing and developing complex reports, analysis, and ETL by writing Design Specifications description of framework, interfaces, services, report, business components and interaction between the components. * Responsible for ensuring quality delivery of code through static and dynamic testing techniques * Troubleshoot any complex data related issues as well as provide support to production. * Keep abreast of the current technologies and technological trends. Learn and prototype new technologies, and recommend their use in company products. * Analyze, document, and reverse engineer any type of SQL/SSIS base code and ETL processes. * Make recommendations on how to rewrite, modify, and redesign SQL and ETL based processes based on analysis. * Document and communicate software designs of complex systems. * Drive process improvement and improve the process efficiency. * Reduce and/or prevent production defects based on the continuous root cause analysis and process improvement. * Ensures adherence to coding standards for self as well as team. Requirements: * Bachelor's degree in Computer Science or related field. * Minimum 3 years' experience ETL/data integration * Expert-level SQL required. * Minimum 2 years' experience with Informatica or Microsoft SQL Server Integration Services (SSIS). * Excellent written and verbal communication skills. * Effective decision-making and critical thinking skills for problem identification and solution recommendation. * Ability to be flexible, set priorities and meet deadlines in a changing environment for self and team. * Ability to work independently and as part of a team while demonstrating initiative and using good business judgment. Preferred: * Informatica experience a plus. Required Experience Job Location Overland Park, Kansas, United StatesPosition TypeFull-Time/Regular Apply Ivy Nextshares Overland Park KS

ETL Developer