ETL Developer
Written by Kim Ann Nichols, August 5, 2019
DESCRIPTION:
The Senior ETL Developer will be responsible for design and development of ETL in support of data management. The role will cover full systems development life cycle (SDLC) phases including requirements gathering, data analysis, system design, development, implementation, and post-implementation support. During the design phase, the role will work closely with the Data Architect to produce data models that follow industry best practices and company standards. During the development phase, the role will perform database development, and ETL (extraction, transformation, and loading) development. This role serves as a lead and/or mentor to peers and less experienced Developers.
QUALIFICATIONS
- Bachelor’s Degree in Business Administration, Computer Science, Mathematics, Engineering, or related field with programming and database systems coursework or equivalent database development experience.
- 4+ years of experience in an ETL Developer role with exposure to Data Management, Data Warehousing, or Business Intelligence
- 5+ years of experience with SQL
- Experience with data warehouse tasks consisting of mapping, architecture design, requirements management, profiling, analysis, integrity checking, impact analysis, etc.
- Experience in gathering business requirements from cross functional teams Proficient with SQL Server Integration Services (SSIS), MSSQL and Visual Studio on projects using waterfall and agile methodologies
- Experience with SDLC processes and TFS or comparable source control tool
Preferred
- 6+ years of experience ina n ETL Developer role with exposure to Data Management, Data Warehousing, or Business Intelligence
- Experience with SQL Server Integration Services (SSIS) version 2016, MSSQL Server 2016, and Visual Studio 2015
Experience with the following tools:
- OLAP (SSAS or comparable product)
- ERWin, ERStudio, or other comparable data modeling tool
- Redgate, or other comparable data comparison tool
- Star and snowflake schemas
- Experience with data analysis in the healthcare industry
- Experience in a team or project lead role, with a focus on mentoring
RESPONSIBILITIES:
- The Senior ETL Developer will be responsible for design and development of ETL in support of data management.
- The role will cover full systems development life cycle (SDLC) phases including requirements gathering, data analysis, system design, development, implementation, and post-implementation support.
- During the design phase, the role will work closely with the Data Architect to produce data models that follow industry best practices and company standards.
- During the development phase, the role will perform database development, and ETL (extraction, transformation, and loading) development. This role serves as a lead and/or mentor to peers and less experienced Developers.
ABOUT 3RP
3RP is a leading-edge Oracle consulting partner located in Scottsdale, Arizona. At 3RP we combined all
three facets of ERP in one. The three dimensions of the enterprise wide technology implementation are
Consulting, Software and Managed Services. Giving our customers 3RP, not just ERP.