080712-05 TWSS - ETL Lead @ West Chester, PA PDF  ICON_SEP Print ICON_SEP  Email
Written by   

Dear partner,

Please go through the below requirement and send me the suitable profiles with best rate and contact details to -- CLOAKING

Submit Resume
First Name (*)
Invalid Input
Last Name
Invalid Input
Email (*)
Invalid Input
Job Position (*)
Invalid Input
Contact Number (*)
Invalid Input
Submit Resume (*)
Invalid Input

Job Title: ETL Lead

Location: West Chester, PA

Duration: 6 - 12 months

Rate: Open

Technical/Functional Skills:

  • Must have overall 10+ years of experience.
  • 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.


Mike Smith | Director - Resources 

Thoughtwave Software & Solutions, Inc.

E-mail | Web URL| Linked-in 

Ph: 630-448-6681 Ext # 112 | Fax: 630-689-5746