Informatica Developer

Supports the full life cycle of product development processes for creating new products and services; provides indepth knowledge of technical products or families of technologies. Addresses complex business and technical product integration issues.

Essential Job Functions

• Establishes and enforces data warehousing standards at the client site to meet client requirements and business needs.
• Determines data warehousing strategy; selects tools and techniques including middleware data cleansing tools and/or data management systems to provide the solution to data and client issues and other matters of significance and to meet business needs.
• Conducts research into new data warehouse applications and determines viability for adoption.
• Evaluates existing subject areas stored in the data warehouse and determines where data should be stored.
• Assists in several components of the overall architecture of the data warehouse system.
• Documents tasks for enduser technical and managerial review to ensure high quality customer service.
• Provides descriptive analyses of customer product and market trends and identifies and resolves data issues.
• Performs quality assurance testing of data integration and report development. Monitors data load operations to ensure accuracy.

Basic Qualifications

• Bachelors degree in computer science mathematics or related field preferred
• Five years of experience in Informatica Power Center 10.x Power Exchange 10.x
• Design develop and maintain robust Informatica PowerCenter mappings and workflows that process huge volumes of data across multiple platforms.
• Solid experience with performance tuning of Informatica processes in partitioned database environment.
• Advanced SQL UNIX Shell Scripting skills and ability to write complex Stored Procedures.
• Strong knowledge and Handson experience in complex data transformations dealing with large volume of data.
• Experience working with COBOL/mainframe file structures using Power Exchange
• Design and develop DB2 Procedures and UNIX Shell Scripts for Data Import/Export Data Conversions Performancetuning and work on migration of database jobs in between different environments.

Other Qualifications

• Good Communication skills to communicate with customers support personnel and management
• Good organization skills to balance and prioritize work
• Analytical and problem solving skills
• Good consulting skills; can effectively interact with client during project team teleconferences and onsite meetings
• Ability to write lengthy procedural stepbased narrative test materials including the necessary testbed setup steps
• Ability to work cooperatively as a part of a global professional team that may be distributed across geographies and time zones
• Ability to complete assigned responsibilities independently in a given timeframe with minimal managerial and technical support