Senior ETL Developer
Resolution Technologies, Inc.
Nashville, TN
Senior ETL Developer
Senior ETL Developer Job Description:
This person leverages the latest ETL/ELT technologies including data pipeline design principles and integration patterns as a basis for supporting analytics and an enterprise data warehouse. Performs complex and senior level data integration pattern design and development activities in support of maintaining both legacy and modern data sourcing. Performs all aspects of the development life cycle. Delivers results through impeccable work ethic and perseverance to seek growth.
Senior ETL Developer Minimum Qualifications:
- Education: Bachelor's or master's degree in computer science, Computer Engineering, IT, or a closely related technical field.
- 6 years of ETL, development, and /or database architectural design experience.
- 2 years of experience with writing and optimizing existing complex SQL queries.
- 2 years of database application development experience
- 3 years of professional experience with database technologies and ETL/ELT tools and scripting.
Senior ETL Developer Preferred Skills:
- Knowledge of modernizing or consolidating legacy siloed databases.
- Strong knowledge across multiple database technologies including both columnar and row indexed relational DBs such as Vertica and SQL Server.
- Knowledge of schema 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, and slowly changing dimensions
Senior ETL Developer Key Responsibilities:
- Creates, develops, modifies, and maintains data pipelines for internal and external facing data applications as part of an Agile/SCRUM engineering team.
- Collaborate heavily with data modeling and subject matter experts based on data driven industry best practices.
- Delivers solutions to provide full product life cycle support, collaborating within and across teams, database development and deployment.
- Explores new technologies and development techniques to foster innovation.
- Coordinates and communicates with users, developers, and product owners to design and implement solutions that services the end user.
- Mentors and develops junior 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.
- Provide data integration oversight for Third Party integrations and database core components.
About the Company
Resolution Technologies, Inc.
Resolution Technologies is a leader in staffing and consulting. We help clients find top talent to help them meet their key business objectives while positively impacting their bottom line.
Here at Resolution Technologies, we understand that serving our clients and consultants is what matters most and promise to never lose sight of that! We take the time to understand your individual needs through face-to-face interaction and strive to always make sure your objectives are met. Resolution Technologies is a full-service Professional Staffing and Executive Search Firm specializing in Technology, Finance & Accounting, Manufacturing Ops, Human Resources, and Marketing/Sales offering flexible solutions for our clients ranging from contract, contract-to-perm, and direct perm placements. Whatever your needs are, we promise to provide unrivaled quality and service.