Job Description

Summary

Supports the full life cycle of product development processes for creating new products and services; provides in-depth 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 end-user, 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. Monitor's data load operations to ensure accuracy.

• Bachelor's degree or equivalent combination of education and experience
• Bachelor's 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 Hands-on 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, Performance-tuning and work on migration of database jobs in between different environments.

• 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 on-site meetings
• Ability to write lengthy procedural, step-based narrative test materials including the necessary testbed set-up 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

• Hybrid Model
• May require evening and weekend work