| Urgent hiring- Informatica Developer Programmer 3-Remote at Remote, Remote, USA |
| Email: [email protected] |
| From: Sradha Suman Nayak, Adventa tech [email protected] Reply to: [email protected] Title: Informatica Developer Programmer 3 Location: Remote Duration: 6 months Visa: USC/GC Moi: Skype Client : The Texas Railroad Commission Minimum Years Skills/Experience - Bachelors 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. ---OR--- 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 Keywords: green card procedural language Urgent hiring- Informatica Developer Programmer 3-Remote [email protected] |
| [email protected] View all |
| Sat Sep 07 01:43:00 UTC 2024 |