ETL Developer in Franklin, TN at Vaco

Date Posted: 10/7/2020

Job Snapshot

Job Description

TOP 3:

  • Expert SQL skills
  • Strong knowledge of sFTP (bonus if they have used Cleo)
  • Solid understanding of AWS (EC2, S3, SQS, Security groups)

Nice to have:

  • Strong knowledge of sFTP (bonus if they have used Cleo)
  • AWS Glue, Data Lake, SQS is a plus.

Job Overview / Scope:

  • Data base design and modeling experience.
  • Proficient in SQL development (complex queries, stored procedures, user defined functions) and performance tuning
  • Proficient in ETL design and development in at least one tool, such as SSIS, Informatica, Data Loader
  • Design and build database reports
  • Monitor, maintain and enhance production ETL processes
  • Respond, address and resolve issue tickets in a timely and professional manner
  • Write and maintain technical documentation
  • Collaborate with internal and external Clients as well as Developers and Business Analysts to define and understand technical requirements
  • Follow industry and company standards, security guidelines, and best practices for ETL and database development
  • Provide recommendations on tools to monitor and support all environments and implement as necessary
  • Create process and systems improvement recommendations to assist the business in achieving its goals and objectives, leveraging best practices and professional experiences
  • Participate in requirements gathering and definition efforts
  • Provide accurate estimates in support of project planning efforts
  • Respond quickly and effectively to defects and system outages
  • Adheres to HIPAA and HITECH specifications in all aspects of solution architecture

  • Bachelors degree in Computer Science or other degree with related experience
  • Minimum 5+ years of ETL development and Migration experience
  • 2+ years of developing experience in the Amazon Cloud Environment AWS (S3, EC2, RDS, VPC)
  • AWS Glue, Data Lake, SQS is a plus.
  • Advance of FTP/SFTP
  • Logical thinker with ability to develop well-structured designs for complex applications
  • Effective in fast paced environment
  • Collaborative/enjoys working in teams
  • Self-starter/motivator

Job Requirements