Position: Informatica ETL Developer/Programmer (Technical Lead)
Location: Austin, TX (hybrid)
Hours: Typically, within 8:00 AM – 5:00 PM, Monday – Friday (excluding agency holidays)
Description
We are seeking two experienced Informatica ETL Developers/Programmers to work on a project involving the migration of mainframe data (IMS COBOL) to Oracle (12c or 19c) using Informatica (10.2.n and 10.4.n versions). The role involves advanced Informatica development tasks including data modeling, database management, and ETL Data Interfaces.
Responsibilities:
- Develop and manage Informatica workflows and mappings for data movement.
- Create technical documentation for processes and interfaces.
- Lead a team of ETL developers and contribute to code development.
- Translate COBOL programs, VSAM, and IMS to relational database structures.
- Refactor database ETL scripts from IMS databases to Oracle RDMS.
- Determine database requirements and develop data models for new projects.
- Perform root cause analyses related to information issues.
- Create graphics and flow diagrams for database design and modeling.
- Provide feedback and guidance to meet tight deadlines.
- Assist with Informatica-related knowledge transfer or training.
Skills and Qualifications
Minimum Requirements:
- Bachelor’s Degree or equivalent related work experience.
- 5+ years experience in data modeling, database design, PL/SQL procedure writing, and advanced ETL mapping.
- 3+ years experience with Informatica PowerExchange for IMS or Informatica PowerCenter, including creating, debugging, and unit testing workflows.
- 2+ years experience with Oracle as a source or target.
- 2+ years experience with Data Modeling software such as ER/Studio, Erwin, or Toad Modeler (Toad Modeler preferred).
- 1+ year experience in hierarchical and relational database design concepts, including IMS Databases and VSAM structures.
- 1+ year experience translating COBOL programs, VSAM, and IMS to relational database structures.
- Experience with documenting complex database concepts, data governance, ETL processes, and creating ERD diagrams and UML parent/child data relationship diagrams.
- Ability to work well within a small, diverse team under various competing deadlines.
- Good communication skills, self-motivated, organized, thorough, and efficient.
Preferred (Optional):
- 8+ years reviewing data storage and flow, generating advanced SQL queries, and developing data models.
- 8+ years experience in Informatica processes and procedures, including writing and revising documentation.
- 8+ years experience leading Informatica-related technical direction and troubleshooting.
- 7+ years experience in relational database design with Oracle RDBMS.
- 5+ years experience with hierarchical and relational database design, including IMS Databases and VSAM structures.
- 3+ years experience using Informatica/PowerExchange Navigator and static maps and Change Data Capture (CDC).
- 1+ year experience or knowledge with Microsoft SSIS.
Term of Service
- Each worker is estimated to be engaged for 700 hours through August 31, 2025.
PriceSenz is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, age, sex, sexual orientation, gender identity, national origin, or disability.