Resource 1 is in need of an Informatica ETL Developer for a 3-6 month contract in Chicago , IL . Individual 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 integration with another merged company. 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. Integration Tasks: Design strategy to integrate fee and volume data into client s Datawarehouse Develop ETL maps using Informatica to integrate 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 mapplets 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 multi-threading 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 multi-team environments Experience with general scheduling tools such as UC4
Apply to this job