Senior ETL Developer

Senior ETL Developer

Senior ETL Developer

Job Description:

This person leverages the latest ETL/ELT technologies including data pipeline designprinciplesand integration patterns as a basis forsupportinganalytics and an enterprise data warehouse. Performs complex and senior leveldata integration pattern design and development activities in support of maintaining both legacy and modern data sourcing.

Performs all aspects of thedevelopmentlife cycle. Delivers results through impeccable work ethic and perseverance to seek growth.

• Education:
  
  Bachelors or masters degree in computer science, Computer Engineering, IT, or a closely related technical field.
• 6 years ofETL,development,and /or database architectural design experience.
• 2 years of experience with writing andoptimizingexisting complex SQL queries.
• 2 years of database application development experience
• 3years of professional experience with database technologies and ETL/ELTtoolsand scripting.

• Knowledge of modernizing orconsolidatinglegacy siloed databases.
• Strong knowledge across multiple database technologies including both columnar and row indexed relational DBs such as Vertica and SQL Server.
• Knowledgeofschema driven design, development, and administration.
• Advanced knowledge of SQL, relational databases, query authoring
• Ability to execute
  
  SQL, T-SQL, ETL/ELT scripting, and automation techniques.
• Knowledge of common tools for Linux (logs, piping, redirections, grep, sed, yum)
• Knowledge of Linux scripting (Python, Perl, shell scripts)
• Experience with architecting data modeling and meeting requirements for data visualization or reporting tools
• Knowledge of data concepts around change data capture, andslowly changing dimensions

• Creates, develops,modifies, andmaintainsdatapipelinesforinternal and external facing dataapplicationsas part of an Agile/SCRUM engineering team.
• Collaborate heavily with data modeling and subject matter experts based ondata driven industry best practices.
• Deliverssolutionsto provide full product life cycle support,collaborating within and across teams, databasedevelopmentand deployment.
• Explores new technologies and development techniques to foster innovation.
• Coordinates and communicates with users, developers, and product ownersto design and implement solutions thatservicesthe end user.
• Mentors anddevelopsjunior engineers through code reviews,co-development and best practices.
• Assembles large and complex data sets that meet business requirements.
• Develops design patterns, standards, documentation, etc. and works with other developers for implementation.
• Providedataintegrationoversight for Third Party integrations and database core components.