US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 6th Sep 2024
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