Job/Position DescriptionThe Texas Department of Family and Protective Services (DFPS) is currently seeking an Oracle Developer for a full-time position within the IT Data Management team. The Developer reports to the Data Management Manager within Information Technology Services (ITS). Works under limited supervision, with considerable latitude for the use of initiative and independent judgment. This position performs advanced (senior-level) data systems analysis; data development; and on-going support of applications used by DFPS staff. Some work involves extraction, transformation and loading (ETL) of data into the agency data warehouse; data warehouse development; data administration; and coordinating the planning and analysis of user requirements, procedures, and problems to automate processing or improve existing systems.As a member on the Data Management Team, the position requires strong knowledge of data warehouse development, ETL, Oracle, PL/SQL and SQL. Preferrable, the candidate should have knowledge of Informatica PowerCenter as well as business intelligence visualization tools such as Tableau. 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 DFPS to satisfy business needs.The mission of DFPS is to protect children, the elderly, and people with disabilities from abuse, neglect, and exploitation by involving clients, families, and communities. We are looking to grow our teams with people who share our energy and enthusiasm to get behind our mission of protecting those among us who are most in need.This position is classified as a full-time position (40 hours a week). Remote work options are available for workers living in Texas. Work outside of regular hours may be required; some weekend on-call duty may be required.Essential Job Functionsand#149; Performs analysis and research of application functionality and interprets requirements in order to support Application Development teams’ development.and#149; 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 code.and#149; Reviews database change request to ensure they meet standards and are consistent with the structural parameters within the existing database environment and are tracked electronicallyand#149; Supports application development team needs for new database structures and/or modifications to existing structures.and#149; Designs, codes, and modifies extract, transform, and load (ETL) logic to populate Agency data warehouse and data marts in order to support Agency reporting.and#149; Performs advanced data warehouse architect work which includes data warehouse design, data modeling, and metadata design.and#149; Reviews all application database change requests to determine any (downstream) effect on warehouse ETLs.and#149; Provides Database Administrator (DBA) support by verifying database structure changes have been applied correctly.and#149; Communicates and/or collaborates with other department teams to coordinate development efforts.and#149; Assists in the development and maintenance of documentation and ensures that the content of documentation is well organized, complete, and appropriate to the audience.and#149; Copy the URL in the preceding sentence to an Internet Explorer browser to apply to the job directly through the Texas Health and Human Services Career Portal.
Tableau SQL Database Administrator ETL Database administration (DBA) Informatica PowerCenter PL/SQL