Job Description :
Job Description:

Position Title: ETL Specialist III
Position Type: 5+ Months Contract with possible extension
Location: Richfield, MN

Must be USC/GC and willing to work onsite in MN. Interviews will be conducted over the phone.


Job Description:

Client is seeking a Informatica ETL Developer with Salesforce Data Integration experience, to contribute toward the success of our technology initiatives.

ETL Specialist-III - ETL Specialist with Salesforce Data Integration Experience. Must work onsite.

Responsibilities
Designs, develops, automates, and supports complex applications to extract, transform, and load data.
Ensures data quality.
Develops logical and physical data flow models for ETL applications.
Codes, tests, implements, and automates complex processes.
Plans and conducts Informatica ETL unit and development tests; monitors results and takes corrective action.
Oversees basic and advanced transformation activities such as normalization, cleansing, aggregation, summarization, and integration.
Translates data access, transformation, and movement requirements into functional requirements and mapping designs.
Designs automation processes to control data access, transformation, and movement.
Ensures source system data availability and update accessibility, data integrity, restart ability, and error handling.
Leads technical staff and clients to investigate, analyze and resolve complex technical problems related to system functions, environment, and procedures.
Identifies and manages interfaces, service levels, standards and configurations.
Provide System and Application Administration for Informatica PowerCenter and PowerExchange
Understands existing Informatica ETL environment, translates into new environment requirements and plans tasks to meet those requirements
Develops PowerCenter Workflows and Sessions, and also sets up PowerExchange connections to database and mainframe files
Provide solutions for data warehousing and Informatica ETL Processes to support Data Integration and Reporting requirements
Demonstrates working knowledge of Informatica PWC & PWX 8.6.1 or 9.x, SQL Server 2005/2008 or equivalent databases, SQL, Oracle, Windows server 2003/2008, Autosys Scheduling, Mainframe data files, Web Services and XML

Successful applicants will exemplify Clients ethical principles of uncompromising integrity, respect for others, accountability for decisions and actions, and good citizenship.

Qualifications
Basic Qualifications:
Bachelor''s degree or equivalent work experience
At least 5 years’ experience within an information technology (IT) environment
At least 3 years’ experience with design, development, automation and support of Informatica to extract, transform and load data

Preferred Skills/Experience:
Technical expertise in systems development and support for technology of Informatica PowerCenter and PowerExchange for Salesforce.com
Salesforce Integration experience is a plus
Excellent technical, logical, analytical and problem-solving skills to provide insight on development and application support
Strong development leadership skills
Plans and organizes tasks to meet needed deadlines
Excellent organizational, interpersonal, verbal and written communication skills
Comprehensive understanding of the data process requirements, and its impact on business functions
Demonstrated ability to analyze technical information, evaluate products, services and vendors and make recommendations