This site uses cookies. To find out more, see our Cookies Policy

Sr ETL Developer in Overland Park, KS at Genesys Talent LLC

Date Posted: 3/12/2019

Job Snapshot

Job Description

The SR ETL Engineer 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:
  • Participates in all phases of SDLC: from system analysis and design thru development and test to deployment.
  • 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 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.
  • Analyze, document, and reserve engineer any type of SQL/SSIS base code and ETL processes.
  • Make recommendations on how to rewrite, and redesign SQL and ETL base processes based on analysis.
  • Document and communicate software designs of complex systems.
  • Reduce and/or prevent production defects based on the continuous root cause analysis and process improvement
  • May lead a team of developers to ensure that the projects are successfully completed.
  • Provide peer mentoring of more junior team members.
  • Ensures adherence to coding standards for self as well as team.


Requirements:
  • Bachelor’s degree in Computer Science or related field.
  • Minimum 7 years’ experience as a Developer; minimum 2 years’ experience as a Lead or Senior Developer.
  • Knowledge and experience using advance SQL programming concepts like CTE (Common Table Expressions)
  • Minimum 5 years’ experience with ETL tools like Informatica or Microsoft SQL Server Integration Services (SSIS).
  • Excellent written and verbal communication skills.
  • Demonstrated experience of project estimation and planning.
  • 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:
  • Financial Services industry experience.
  • Hands on experience using Informatica 10 or high will be a plus.