RRC - ETL Developer/Database Administrator IV (00007980)
Organization: RAILROAD COMMISSION OF TEXAS
Primary Location: Texas-Austin
Work Locations: RRC Headquarters 1701 N Congress Avenue Austin 78701
Job: Computer and Mathematical
Employee Status: Regular
Standard Hours Per Week: 40.00
State Job Code: 0214
Salary Admin Plan: B
Salary (Pay Basis): 5,784.58 - 8,333.33 (Monthly)
Number of Openings: 4
Overtime Status: Exempt
Job Posting: Nov 14, 2019, 11:46:39 AM
Closing Date: Jun 1, 2020, 11:59:00 PM
Note: Four positions available.
The Railroad Commission of Texas (RRC) is currently seeking an extract, transform and load (ETL) developer for a full-time position within the Information Technology Services division. This position performs advanced (senior-level) data systems analysis that includes data fixes; ETL and data warehouse development; data administration to include data structure modeling and development; and on-going support of applications used by RRC staff. As an ETL Developer, the position requires strong knowledge of data warehouse development, ETL, Informatica, Oracle or Microsoft SQL Server, and SQL. The position requires an ability to communicate effectively, both verbally and in writing, and the ability to manage projects against established timelines with minimal supervision. This position also requires the ability to learn and apply new technology, work independently or in a team environment, and collaborate with all levels of staff within RRC to satisfy business needs. The ETL Developer reports to the Program Director, Technology Modernization within the Information Technology Services Division. The ETL Developer works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
Essential Job Duties
Designs, codes, and modifies extract, transform, and load (ETL) logic to populate data warehouse and data marts in order to support reporting.
Performs analysis and research of application functionality and interprets reporting requirements in order to develop technical specifications for data warehouse ETL's and data marts.
Practices current development methods/techniques and establishes development standards (which include coding standards, documentation standards, and testing standards) to ensure the quality and maintainability of ETL's.
Communicates and/or collaborates with business area reporting stakeholders to coordinate development efforts in support of reporting needs.
Assists in the development and maintenance of documentation and ensures that the content of documentation is well organized, complete, and appropriate to the audience.
Ensures project schedules are met, and/or re-negotiated, and approved prior to target dates.
Communicates progress and issues affecting work assignments to the Team Lead and/or Project Manager as soon as possible.
Manages work activities for short and long range performance assignments, communicating with management and other team members in a timely and effective manner.
Follows established change management code migration processes.
Mentors junior level staff in the development, testing, and deployment of new ETL's.
Performs advanced data warehouse architect work which includes data warehouse design, data modeling, and metadata design.
Supports application development team needs for new database structures and/or modifications to existing structures.
Reviews database change request to ensure they meet standards and are consistent with the structural parameters within the existing database environment and are tracked electronically.
Provides Database Administrator (DBA) support by verifying database structure changes have been applied correctly.
Reviews all application database change requests to determine any (downstream) effect on warehouse ETLs.
Verifies ETL population was successful and complete.
Consults the Data Dictionary for any dependencies and additional information that the data admin request may require.
Reviews/explains plans for new or modified queries for performance and suggests alternative ways to resolve any performance issues.
Provides on-call support on a rotating schedule.
Performs other duties as assigned and required to maintain unit operations.
State Classification #: 0214
State Classification Title: Database Administrator IV
Salary Group: B26
Military Occupational Specialty Codes (MOS):
Army – 25B, 255A
Navy – CT, 682X, 182X
Coast Guard – IT, C4|10, ISM
Marine Corps – 0670, 0671, 8846, 8848
Air Force – 3D0X4, No military equivalent for officers.
Additional military crosswalk information may be found at http://www.hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_PlanningResearchandStatistics.pdf
Graduation from an accredited four-year college/university with major coursework in Computer Science; Information Technology; Business/Computer/Management Information Systems; Data Processing, or a related field.
Two (2) years' experience in ETL development and data warehouse monitoring.
Four (4) years' experience programming using Oracle or Microsoft SQL Server, T-SQL, PL/SQL, systems analysis, systems design, other relevant information technology experience.
Five (5) years' experience with SQL.
Two (2) years' experience soliciting end-user and system requirements.
Experience may have occurred concurrently.
Experience may be substituted for education on a year-for-year basis.
At least five (5) years' full-time ETL development and data warehouse monitoring using Informatica.
At least five (5) years' full-time IMS development.
At least four (4) years' experience soliciting end-user and system requirements..
At least four (4) years' experience in database design.
Experience may have occurred concurrently.
Knowledge, Skills, and Abilities
Knowledge and 5 years of experience with Oracle databases with some of that experience being Oracle version 12c
Knowledge of Oracle SQL version 12c and/or PL-SQL version 12c
Knowledge of Microsoft SQLServer
Knowledge of Informatica PowerCenter or similar tool.
Knowledge of database object migration/validation tools required
Knowledge of data analysis, evaluation, and testing techniques and protocols.
Knowledge and understanding of ETL development; monitoring; batch or data processing in an automated scheduled environment.
Knowledge of database structures and theories
Knowledge of master data, metadata, reference data, data warehousing, and business intelligence principles and process, including technical architecture;
Knowledge of enterprise information management processes and methodologies; relational database management systems; metadata management, and business intelligence and business analytics tools;
Knowledge of local, state, and federal laws and regulations relevant to data management and data governance;
Knowledge of technology across all network layers and computer platforms;
Knowledge of operational support of networks, operating systems, internet technologies, databases, and security applications.
Knowledge and experience with the Software Development Life Cycle (SDLC) and project planning.
Skill in understanding and implementing database change requests.
Skill with Microsoft Office tools, particularly with Word, Excel, PowerPoint, Visio, and SharePoint.
Skill in complex problem solving and critical thinking.
Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various personnel in governmental entities.
Ability to identify and define user task needs.
Ability to document issues, risks, and defects.
Ability to communicate effectively in a technical environment, including on-the-job training with coworkers, project team members, and IT management.
Ability to lead and work cooperatively in a team environment
Ability to work Monday - Friday 8:00 AM - 5:00 PM including flexible hours, nights, weekends and/or holidays.
Remarks: There are four (4) available positions. Official transcripts, DD214 or DD1300, copies of license/certifications, or other minimum requirement validations will be requested at the time of the job offer.
THE RAILROAD COMMISSION OF TEXAS ONLY ACCEPTS ONLINE APPLICATIONS FOR THIS POSTING.
Due to the high volume of applications we do not accept telephone calls. Only candidates selected for interview will be contacted. Notifications to applicants are sent electronically to the email address you provide.
The Railroad Commission of Texas is an Equal Opportunity Employer and does not
discriminate on the basis of race, color, national origin, sex, religion, age
or disability in employment or in the provision of services.
The Railroad Commission of Texas is a smoke-free workplace