Please share the Profile-------A...@dyssinc.com

*ETL **Informatica** Lead*

*West Chester, PA*

*Long term, Contract*

*Total Experience Required:* 8+ Years

*Technical/Functional Skills: *

·         Expertise in End-to-End testing in a Data Warehousing environment

·         Strong Data Warehousing knowledge is required and should have a
clear understanding of end-to-end data flow in a typical Data Warehouse

·         Should have lead a team at Offshore and own the deliverables from
Onsite

·         Should gather requirements and give it to Offshore and get the
work completed at Offshore

·         Should have strong SQL knowledge

·         Should have expertise in ETL Development specifically in
Informatica tool

·         Good knowledge in working with Informatica Power Center
8.x/7.x/6.x/5.x. (Designer, Repository manager, Repository Server
Administrator console, Server Manager, Work flow manager, Workflow
monitor).

·         Experienced in developing, designing and reviewing Informatica
work products like Mappings, Mapplets, Reusable transformations, Sessions,
Workflows, Worklets, Schedulers and experienced in using Mapping
parameters, Mapping variables, Session parameter files

·         Extensively worked on Informatica Power Center Transformations
such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner,
Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence
Generator, Normalizer, Union, and XML Source Qualifier

·         Should design complex Mappings and expertise in Performance
Tuning in Informatica.

·         Should have a good understanding on the Informatica PDO (Push
Down Optimization) concepts and its working methodology

·         Strong UNIX shell scripting is mandatory and should develop
scripts to call Teradata tools / utilities as per the business requirements

·         Should have a good knowledge on Teradata(DB) Architecture

·         Should have good knowledge on Teradata Functions / Parallelism,
Explain Plan analysis and Performance tuning

·         Should have good experience in Teradata (DB) and have worked
extensively in BTEQ, Teradata SQL Assistant, Multiload, Fast load, TPT
(Teradata Parallel Transporter) and Fastexport utilities. CLDM knowledge is
a plus.

·         Should have written complex queries in Teradata and also have
strong analytical skills to analyze the business requirements

·         Should have good experience in UNIX Shell Scripting and should
have developed Teradata BTEQ scripts from UNIX

·         Should have the ability to understand the business requirement
and develop the mappings in Informatica using UNIX and Teradata scripts

·         OBI reporting knowledge is a plus.

*Roles & Responsibilities:             *

·         Should act a front-end for customers and represent as a ETL
Development Lead (Onsite).

·         Should manage a 6-7 member team at offshore and co-ordinate with
them regularly to get the deliverables on time and also should manage the
offshore in-front of customers.

·         Should have the ability to dedicate the work to Offshore and get
the work done from them through proper communication channel and also by
following the process.

·         Participate and Manage clients calls by understanding their
requirements, preparing a proper plan and ensuring delivery on time

·         Understanding the business needs and should develop the HLD and
LLD and provide quality solutions

·         Deliverable activities like reviews walk through, requirement
analysis, effort estimation, approvals from customers etc.

 Regards,

*Alok Kumar*

[image: Description: dyssinc]

|*Dynamic Software Services, Inc.*|
766 Sutter Street -13.San Francisco, CA- 94109|
Office: 4152595570| Fax: 415-520-5437| a...@dyssinc.com <hsi...@dyssinc.com>

IM---kumaralok.recruiter

|*www.dyssinc.com*|