Job Description :
Title: Informatica Developer
Location: Thousand Oaks, CA
Duration: 6 months contract
Experience working with Informatica PowerCenter 9.x or higher
Requirements gathering and creating architectural, detail design documents and mapping documents.
Transformations of Informatica including complex lookups, stored procedures, update strategy, mapplets, etc.
Skilled in developing Informatica objects - mappings, sessions, and workflows based on the prepared low level design documents.
Experience in debugging mappings and identifying errors and error rows so that they can be corrected and re-loaded into a target system.
Performance tuning of Informatica Mappings, processes, and load routines.
Experience with Data Integration Web Services, Data Quality, and Data Validation Option.
Work with business requirements to identify and understand source data systems; provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
Map source system data to data warehouse tables
Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
Define and capture metadata and rules associated with ETL processes
Adapt ETL processes to accommodate changes in source systems and new business user requirements
Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same.
Provide support and maintenance on ETL processes and documentation
Experience automating ETL processes with Informatica PowerCenter.
Ability to perform relational and multidimensional modeling and schema creation.
Development of cube dimensions, measure groups, calculations, and any data management code for the partitioning schemes.
XML and corresponding XSD''s.
Database query/performance optimizations.
Experience with SQL Server, Oracle or DB2 in the areas of database administration, as well as schema design, database object development, management, optimization, and SQL programming