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

Job Description

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 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, onpremises, 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 highperformance data flows between cloud and onpremises 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 handson position requiring solid technical skills and excellent interpersonal and communication skills.

Essential Job Duties

Performs advanced (seniorlevel) 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 datadomain 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 privacybydesign 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 ETLbased applications for data migration, integration, and transformation between cloud platforms (AWS, Azure, Salesforce, Snowflake, OpenSystems) and onpremises 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 ETLrelated issues; provide postproduction 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 highquality 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 problemsolving 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/MilitaryCrosswalk/MOSC_InformationTechnology.pdf

Minimum Qualifications

• Bachelor's degree from an accredited fouryear 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 handson 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 oncall support for critical ETL systems
• Experience and education may be substituted on a yearforyear basis
• Total years of experience may run concurrently

Preferred Qualifications

• Bachelor's degree from an accredited fouryear 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 commandline tools
• Three (3) years of experience scripting languages (Linux Shell Script, RESTful API development and integration, JavaScript, Python, )
• Three (3) years of handson experience with IDMC AI on data integration, governance, and quality to prepare datasets for AI/ML models
• Three (3) years of handson experience configuring catalog templates for data dictionaries, domains, glossaries, business datasets, rules, and tagging

Knowledge/Skills/Abilities

• 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 highvolume, 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 highvolume 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.

Additional Information

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.