RRC - Cloud Data Developer - (Database Administrat

Please paste the following URL into a browser to view the entire job posting on the CAPPS Careers page.https://erphcmprd.cpa.texas.gov/psp/candidateportal/EMPLOYEE/HRMS/c/HRS\_HRAM\_FL.HRS\_CG\_SEARCH\_FL.GBL?Page=HRS\_APP\_JBPST\_FLandAction=UandFOCUS=ApplicantandSiteId=1andJobOpeningId=106940andPostingSeq=1Agency InformationThe 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 yearTelework options for eligible positions Flexible work schedulesRetirement 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 RothHealth premiums 100% paid for full-time employeesTuition ReimbursementWellness and Exercise LeaveCareer 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. Job DescriptionThe 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 LoneStar 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.Essential Job DutiesPerforms advanced (senior-level) Informatica Intelligence Data Management Cloud (IDMC) Governance an 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 environmentsDesign, 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 environmentConfigure and enhance Informatica Cloud Data Governance and 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 IDMCDrive PII identification, classification, and protection strategiesExperience implementing enterprise governance frameworksKnowledge of data privacy regulationDesign and 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 and Dimensions table, populate data with Push Down OptimizationIntegration and Migration: Develop and maintain ETL-based applications for data migration, integratio