ETL Developer

Description

• 60% of this role is initially assisting in the identification of process changes/enhancements and the documentation/requirement definition within the data engineering team.
• Must have a strong background in data analytics delivery and data warehousing
• Must be strong in SQL queries, stored procedures, query optimization and performance tuning
• Data engineering background to include: analyzing current state, document the use of tools, primarily SSIS, adopt any ETL tool, create documentation, process and test.
• Assessing current state/process and documenting current issues and willing to learn/adapt to other ETL tools outside of SSIS
• Documentation and building of new technical documents based on review of trouble tickets
• Must be able to help understand and define current state and ensure new enhancements as well as assist in implementing changes

Responsibilities

• • 8+ years of data engineering experience within ETL/Informatica, SQL and SSIS
• • Strong background working within Agile
• • 8+ years of data management experience including data modeling, data integrity and data quality
• • 6+ years RDBMS such as SQL Server, Oracle or MySQL
• • 6+ years of experience writing relational database queries (SQL) for stored procedures, query optimization and performance tuning
• • 6+ years of experience with ETL Tools (SSIS)
• • 6+ years of experience with large data and analytic environments
• • 2+ years of experience with Agile practices
• • Experience with Autosys or other automation/scheduling tools