Job Detail

Looking for a ETL Informatica Tester (Informatica, Data warehouse testing), in Irvine, CA Required Skills 3+ years Informatica Testing or Development Experience (Testing preferred) 3+ years DW/ETL QA testing experience (Beyond unit testing and Application Database querying as a Developer) prefer Data Warehouse related QA/Data Quality rather the Software testing. DW Testing experience with other ETL software will be considered as well but not preferred. Ab Initio, Datastage, SSIS, etc. Hands on experience with Informatica preferably with add ins DVO and/or IDQ but not required IDQ experience (2 + years) Hands on experience with Informatica preferably with add ins DVO Overview of Day to Day 7+ years of experience in systems analysis including data analysis, profiling and/or design Familiarity with Informatica, Oracle and UNIX are essential Metadata management and data integrity skills will be an added benefit UNIX experience is a plus Proficient in writing SQL queries using toad or any other front-end tool Proficient with Data Warehouse concepts Bachelor s degree in Computer Science or relevant discipline Sound data analysis skills required Strong teamwork skills essential Effective oral and written communication skills required Responsibilities Perform system and data analysis Responsible for primary development and execution of testing strategies Support, develop and test Data Warehouse jobs and data to support the business requirements Create test plans, scripts and document all phases of testing Identify, document and resolve data quality/data integrity issues Develop and or test ETL mappings, workflows/sessions and other DW jobs Coordinate work efforts with internal and external team members Respond to business data issues and resolves them Contributes to new concepts, techniques and standards Ensures adherence to locally defined standards for all developed components Assists developers, administrators and architects in all development and testing efforts