Informatica ETL Developer

Description

The ETL Developer role will help with developing the foundational technical architecture support for deploying a new Informatica environment in Informatica 8.3. This person will also play a key role in developing the data integration solutions for the NYMEX integration. Individual will be responsible for developing ETL mappings for STATS mainframe elimination project using Informatica. Person should have strong background in Data Warehousing, dimensional modeling and Oracle (PL/SQL) development to integrate Informatica processes to work in conjunction with existing PL/SQL ETL processes.ResponsibilitiesIntegration Tasks Design strategy to integrate Nymex fee and volume data into CME Groups data warehouse Develop ETL maps using Informatica to integrate Nymex fee and volume data Develop process to move Informatica packages from Dev to QA and Production. Standards Development Document Create Best Practices document for transformation usage Document best practices for tool usage strategy comparing Java, PL/SQL vs. Informatica Document Create ETL Standards Naming Conventions Map Design Standards Metadata Management Standards Best practices for handling slowly changing dimensions Infrastructure/Production Support Tasks Develop Disaster Recovery Develop restart recovery processes and procedures Document Repository Setup and usage Standards and Mapping Standards Develop code migration standards and procedures Support Environment Migrations Document Security Architecture Development Support Task Development and manage cross team scheduling standards and thread management (Manage Cross Team Runbook) Develop Shared components Develop File Management and Input/Output Feed hub Develop Batch control processes Design/Develop Shared Error/exception/reject management handling Develop Target Record Deletion Process Design and Develop shared maplets for time, input/batch control, load processes Skill sets required 4+ Years developing Informatica solutions in a Unix/Linux environment Experience with high volume datasets from various sources (Cobol, Text Files, XML, Relational) Experience with multithreading and parallel processing using Informatica Experience with common Data Warehousing terminology Experience using Informatica integrated with web services Experience in developing and documenting environment setup processes, procedures and shared components Experience supporting multiteam environments Experience with general scheduling tools such as UC4