RRC - Cloud Data Developer - (Database Administrator IV) - ITS

The Railroad Commission of Texas is a state agency with primary regulatory jurisdiction over the oil and natural gas industry; pipeline transport and pipeline safety; natural gas utilities; the LP-gas industry; and surface mining operations. You can find more details about us on the Railroad Commission of Texas website here: https://www.

rrc.texas.gov/about-us/. To support our mission to serve Texas, we need great people to join our team. We provide a great working environment along with outstanding benefits, including: Generous paid time off, including vacation, sick time, and at least 12 paid holidays per year Telework options for eligible positions Flexible work schedules Retirement pension with a 150% agency match - you can watch this YouTube video that describes this amazing benefit https://www.

youtube.com/watch?v=AJI6M7g73-w 401(k), 457(b) and Roth Health premiums 100% paid for full-time employees Tuition Reimbursement Wellness and Exercise Leave Career development programs/opportunities for advancement For a complete list of our total compensation package, please visit our website at https://www.rrc.texas.gov/about-us/jobs/.

To view benefits available to all State of Texas employees, visit the Employee Retirement Systems website at https://ers.texas.gov/benefits-at-a-glance.

The Railroad Commission of Texas (RRC) seeks an Informatica Intelligence Data Management Cloud (IDMC) Cloud Data Developer to provide support for the critical agency Data Warehouse (DW) that supports Lone. Star Oil and Gas applications, and GIS Enterprise cloudification applications. The IDMC Cloud Data Developer will work as a Data Governance Specialist, designing, building, and optimizing secure enterprise data governance and pipelines using Informatica Data Management Cloud (IDMC).

This role bridges technical data engineering and data governance, ensuring that data ingestion, transformation, and storage adhere strictly to organizational data quality, metadata management, and compliance standards. The candidate will be a data governance and ETL developer who designs and delivers governance frameworks, metadata management, and catalog solutions using Informatica IDMC.

The candidate will bridge business requirements and technical implementation, ensuring data is governed across cloud, on-premises, and hybrid environments. In addition to data governance tasks, the candidate will be responsible for designing, developing, testing, and maintaining data integration solutions and pipelines using the IDMC API and related ETL tools.

The role involves working closely with data architects, analysts, and project teams to ensure accurate, secure, and high-performance data flows between cloud and on-premises systems. This role provides technical leadership for data consumption, as well as the configuration, maintenance, and performance of critical data pipelines with complex data flows across multiple platforms, using multiple tools and technologies, including SQL Server Integration Services and Snowflake.

The candidate is expected to perform complex ETL task flows development and research work. Candidates must also be capable of planning and assigning work to others and of reviewing and analyzing user requirements, procedures, and problems to automate processes or improve existing systems. The successful person will work with minimal direction, with considerable latitude for initiative and independent judgment.

This is a hands-on position requiring solid technical skills and excellent interpersonal and communication skills.

Performs advanced (senior-level) Informatica Intelligence Data Management Cloud (IDMC) Governance and Data Developer work. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment. Employees at this level may fully perform highly complex database administration work and may: Coordinate and provide IDMC triage support to troubleshoot and resolve functional and performance issues encountered in production, development, and test environments Design, recommend, and implement procedures necessary for task flows and the pipeline.

Develop standards, guidelines, policies, and procedures designed to ensure the integrity of the IDMC environment Configure & enhance Informatica Cloud Data Governance & Catalog (CDGC) and IDMC governance features Implement metadata ingestion, cataloging, asset organization, classifications, domains, business glossaries, and metadata relationships Set up scanners/connectors to onboard enterprise data sources into governance/catalog environments Translate governance requirements into technical configurations, workflows, rules, and repeatable processes Support stewardship workflows, ownership, policies, definitions, and data-domain structures Collaborate with lineage, data quality, architecture, integration, security, and business teams to improve data discoverability and trust Drive compliance with privacy laws (GDPR, CCPA) and implement privacy-by-design frameworks Define data retention, archival, and lifecycle policies Enable data quality rules, dashboards, and data products in IDMC Drive PII identification, classification, and protection strategies Experience implementing enterprise governance frameworks Knowledge of data privacy regulation Design & Development: Create and enhance ETL task flows, mappings, and transformations in IDMC, ensuring alignment with data architecture and business requirements.

Be able to build the Fact & Dimensions table, populate data with Push Down Optimization Integration & Migration: Develop and maintain ETL-based applications for data migration, integration, and transformation between cloud platforms (AWS, Azure, Salesforce, Snowflake, Open. Systems) and on-premises databases Performance & Optimization: Optimize data workflows for speed, scalability, and resource efficiency; monitor and improve ETL performance Data Quality & Governance: Implement and manage data quality rules, governance policies, and metadata management in IDMC Testing & Support: Perform unit and integration testing; troubleshoot and resolve ETL-related issues; provide post-production support Documentation: Document workflows, mappings, and integration processes for clarity and auditability Collaboration: Work with project managers, technical leads, and business users to meet deadlines and deliver high-quality solutions Knowledge in IDMC and related ETL tools; experience with Snowflake, Salesforce, SQL Server, Oracle, and Linux environments Review IDMC Release Readiness, work on Release Types, Preparation, Deployment, and Upgrade tasks, and patches as required Align roadmap, platform improvements, and service standards with the IDMC Service Owner Participate in solution designs and architectural reviews Communicating operational impacts with technical and business stakeholders Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions Creates and/or maintains guidance documentation Adheres to and recommends information systems security requirements and processes in use at the agency.

Sense of ownership and pride in your performance and its impact on success Critical thinker and problem-solving skills Good time management skills Perform other duties as assigned and required to maintain unit operations. For Military Crosswalk information, please visit: https://hr.sao.texas.gov/Compensation/Military.

Crosswalk/MOSC_Information. Technology.pdf

Bachelor's degree from an accredited four-year college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, or a related field is generally preferred. Two plus (2+) years of experience hands on experience in with Informatica IDMC CDGC, metadata management, lineage, and governance workflows Two plus (2+) years of experience hands on of hands-on experience in operating and maintaining the Cloud Data Governance & Catalog (CDGC) platform: configuration, metadata onboarding, scanners, lineage capture, template management Two plus (2+) years of experience in the ability to translate governance concepts into scalable platform processes Two plus (2+) years of experience in IDMC, Data warehousing concepts, and ETL methodologies Two plus (2+) years of experience in Cloud platforms (AWS, Azure) Two plus (2+) years of experience with ETL Informatica Power Exchange Change Data Capture (CDC) Two plus (2+) years of experience in database design, Physical and Logical Database modeling, ER Diagram, Slowly Changing Dimension, snowflakes & star schemas, and Facts & Dimensions tables Five plus (5+) years of experience in supporting data quality and governance tools Five plus (5+) years of experience in on-call support for critical ETL systems Experience and education may be substituted on a year-for-year basis Total years of experience may run concurrently

Bachelor's degree from an accredited four-year college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, or a related field is generally preferred Eight (8) years of experience with Software Development Lifecycle and Best Practices Five (5) years of experience working with the Snowflake database platform Five plus (5+) years of experience in Linux scripting and command-line tools Three (3) years of experience scripting languages (Linux Shell Script, RESTful API development and integration, JavaScript, Python, ) Three (3) years of hands-on experience with IDMC AI on data integration, governance, and quality to prepare datasets for AI/ML models Three (3) years of hands-on experience configuring catalog templates for data dictionaries, domains, glossaries, business datasets, rules, and tagging

Knowledge and professional experience with Microsoft Power BI. Knowledge, working with BI Dashboards, BI reports. Experience working with large data sets and data visualization tools like Power BI, Tableau, Qlik, or similar reporting tools. Knowledge of Agile methodologies for software development and management. Knowledge of the state of Texas Public Information Request requirements.

Knowledge of current industry standards associated with development methodologies. Experience overseeing projects and development of high-volume, scalable environments. Experience overseeing standardized quality assurance procedures. Experience with the upgrade/migration of older environments to current platforms. Experience working on Business Intelligence teams in high-volume production environments.

Skills in complex problem solving and critical thinking. Knowledge of statistics and analyzing data sets, data models, database design development, data mining, and segmentation techniques; and of record keeping, including security procedures for handling, protecting, and distributing confidential data. Skill in the use of a computer and applicable software, in analyzing problems and devising effective solutions, in conducting data searches, in evaluating and translating large amounts of data, and in critical thinking.

Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail; to communicate effectively; and to provide guidance to others.

Work Hours: Standard office hours for Commission employees are 8:00 a.m. to 5:00 p.m., Monday through Friday. Our agency offers alternative schedules for employees, provided they do not adversely affect operations or service levels and standard hours of operation are maintained. The Commission may also offer telework in accordance with the agency's approved Telework Plan.

Alternate work schedules may be discussed with the hiring manager during the interview process. APPLICATIONS SUBMITTED THROUGH WORK IN TEXAS: Work In Texas (WIT) applicants must complete the CAPPS Recruit Prescreening Questionnaire to be considered for the posting. To complete the Prescreening Questionnaire, go to CAPPS Recruit to register or log in: https://capps.

taleo.net/careersection/ex/jobsearch.ftl?lang=en Remarks: There is one available position. Official transcripts, DD214 or DD1300, copies of license/certifications, or other minimum requirement validations will be requested at the time of the job offer. Criminal background checks will be conducted on all final candidates.

An applicant who has been convicted of a criminal offense relevant to the position may be disqualified from employment. Important Information For All Applicants The Railroad Commission of Texas does not sponsor employment visas or participate in employer-sponsored immigration programs. The agency does not provide employer support for applications to extend or obtain employment authorization, including employer attestations, training plans, or other documentation required for participation in programs such as STEM Optional Practical Training (STEM OPT).

Applicants should consider this policy when determining whether the position meets their employment authorization requirements. The agency will complete employment eligibility verification and other documentation required by applicable law. The agency does not provide discretionary immigration sponsorship or program-specific employer documentation beyond those legal obligations.

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 to 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 tobacco-free workplace.