DirectClient: Railroad Commission of Texas (RRC)
Solicitation#455-17107
Title: Informatica Developer
Location: 1701 N. Congress Ave., Austin, Texas 78752
Duration: Until 8/31/2021 with possible extension upto 8/31/2021
Last date for submission: July 20, 2021 (2.00 PM-CST)
Note: Remote allowed during COVID-19 and 100% onsite after the pandemic
DESCRIPTION OF SERVICES:
The Texas Railroad Commission ITS division requires the services of two experienced Informatica developer technical resources preferably with experience moving mainframe data (IMS COBOL) to Oracle (12c or 19c) via Informatica on-prem ( and versions) hereafter referred to as Worker, who meets the general qualification of a Developer/Programmer Analyst - Emerging technology.
Performs advanced (senior-level) Informatica specific developer/programmer analyst work including data modeling, implementing, designing and managing database systems, data warehouses, and ETL Data Interfaces.
Informatica ETL Developer/Programmer – working lead
• Able to lead a team of ETL developers to include individual contribution in development of code.
• Development of ETL mappings and workflows for data movement with PowerCenter.
• Performs discovery of and translation of COBOL programs, VSAM, and IMS to relational database structures.
• Refactoring of database ETL scripts from mainframe IMS databases to Oracle RDMS.
• Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems.
• Obtains data model requirements, develops and implements data models for new projects, and maintains existing data models and data architectures.
• Performs root cause analyses (RDA) related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems.
• Creates graphics and other flow diagrams (including ERD) to show complex database design and database modeling more simply.
• May plan, assign, and/or supervise the work of others and capable of working with minimal supervision
• Performs related work as assigned.
Experience with Informatica Navigator to create mainframe Capture Registrations.
Practical experience with static maps and Change Data Capture (CDC) for bulk data movement.
Creation of technical documentation for process and interface documentation is a key element of this role, as the Team is working on release one of a minimum four release effort.
Ability to review the work of others, troubleshoot, and provide feedback and guidance to meet tight deliverable deadlines is required.
The Worker will apply their expert knowledge of Informatica workflow and mapping development, in understanding and leading the direction of the team, and assistance with Informatica-related knowledge transfer or training of staff is needed for development of Informatica mappings and workflows to support the needs of internal Mainframe Transformation project teams.
WORKER SKILLS AND QUALIFICATIONS
Minimum
Years Skills/Experience
- Bachelor’s Degree or equivalent related work experience.
5+ Experience in Data Modeling, Database Design, PL/SQL procedure writing, and advanced ETL mapping.
3+ Experience using Informatica PowerExchange for IMS including creating from scratch ETL mappings from IMS to a RDBMS. ---OR---Experience using Informatica PowerCenter including creating, debugging, and unit testing workflows.
2+ Experience with Oracle as a source or target.
2+ Experience using Data Modeling software such as ER/Studio, Erwin, or Toad Modeler (Toad Modeler preferred).
1+ Experience in hierarchical database and relational database design concepts including direct experience in IMS Databases, VSAM structures.
1+ Experience performing discovery of and translation of COBOL programs, VSAM, and IMS to relational database structures.
- Experience in the documentation of complex database concepts, data objects, data governance, data ETL processes, and database schemas including the creation of ERD diagrams and UML parent/child data relationship diagrams.
- Experience with taking convoluted and unfactored database structures and unmodeled data and having an end-to-end vision for both logical, physical and conceptual database construction and architecture.
- Experience with Informatica Navigator to create mainframe Capture Registrations.
- Experience with static maps and Change Data Capture (CDC) for bulk data movement.
- Ability to work well within a small, diverse team under various competing deadlines.
- Good communication skills (interpersonal, listening, written and oral), be self-motivated, organized, thorough, and efficient.
Preferred (Optional)
Years Skills/Experience
8+ Reviewing data storage and data flow to develop data models to ensure data integrity.
4+ Generating advanced SQL queries and using other data interrogation methods.
8+ Reviewing and interpreting business requirements and design specifications and translating them into Informatica mappings and workflows.
8+ Writing, revising, and verifying Informatica processes and procedures (including interface control documents, process workflows in Visio, and operational processes for Informatica).
8+ Leading the Informatica-related technical direction of a small team, to include the ability to troubleshoot and review code for staff knowledge transfer or training.
8+ Skill with data movements/Extracts (ETL) from Mainframe applications (prefer IMS COBOL).
7+ Experience in relational database design concepts including direct experience in Oracle RDBMS.
5+ Experience in hierarchical database and relational database design concepts including direct experience in IMS Databases, VSAM structures.
8+ Development with Informatica on-premise software. Experience must be with Navigator data mappings or with PowerCenter workflow development.
Experience using Informatica PowerExchange for IMS including creating from scratch ETL mappings from IMS to a RDBMS. ---OR---Experience using Informatica PowerCenter including creating, debugging, and unit testing workflows. ---OR--- A combination of experience in Informatica PowerExchange and PowerCenter that has a minimum of 3 years in one and a total of over 8 years combined.
3+ Experience using Informatica/ PowerExchange Navigator to create mainframe Capture Registrations.
3+ Experience with static maps and Change Data Capture (CDC) for bulk data movement.
1+ Experience or knowledge with Microsoft SSIS