ETL Developer
RPC Inc. - Atlanta, GA

This job posting is no longer available on RPC Inc.. Find similar jobs: ETL Developer jobs - RPC jobs

Title: System Programmer Analyst – ETL Developer

Hiring Manager: TBD

Summary of Position:

This position is responsible for designing, building, and testing ETL (extract, transfer, and load) processes. The ETL developer will be able to design and implement a plan for all types of data movement or modification approved by management. The ETL developer will have full understanding of each step in the ETL Process and be able to write ETL programs with scripts, packages, and mappings. The ETL developer will be responsible for the analysis, development, quality assurance, implementation, monitoring and administration of the ETL process.


1. Understand the data structure and meaning in both the source and target BI systems

2. Identify and assess data sources

3. Create source/target mappings

4. Apply business rules as transformations

5. Implement navigation methods/application

6. Design and specify source data detection and extraction processes

7. Design and develop transformation code/logic/programs for environment

8. Design and develop data transport and population processes for environment

9. Unit test source data detection and extraction processes for environment

10. Build and unit test data transformation processes for environment

11. Build and unit test source data transport and population processes for environment

12. Work with production data to monitor and report on data conditions and quality

13. Design data cleanup processes

14. Adapt ETL processes to accommodate changes in source systems and new business user requirements

15. Define and capture metadata and rules associated with ETL processes

16. Coordinate with program-level ETL architect to ensure compliance with standards and consistency with long-term infrastructure plans

Required Qualifications:

1. 4+ years of ETL application development experience

2. 2+ years of ETL design experience

3. Excellent knowledge of MS SQL, T-SQL, and stored procedures

4. Strong understanding of SDLC best practices with emphasis on BI practices

5. Good time management and organization skills

6. Curious, self-motivated, independent work skills

7. Excellent verbal and written communication skills with all levels of the organization

8. Proficient in coaching others

9. Proficient in estimating project effort and duration

Preferred Qualifications:

1. Bachelor

's Degree in Information Systems 2. SQL Server 2008, 2012 database experience 3. Experience related to the oil and gas industry Salary Level: D Travel Requirements: 15% Position Location: Atlanta or Houston

RPC Inc. - 2 years ago - save job
About this company
RPC, Inc. (RPC) provides a range of specialized oilfield services and equipment to independent and oil and gas companies engaged in the...