091412-03 TWSS - ETL Lead / Project Manager @ 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 / Project Manager

Location: West Chester, PA

Duration: 12 Months

Rate: Open

Need someone who has at least 12+yrs experience and good with leading an onsite & off shore team with Project Mgmt Exp.

Technical/Functional Skills:

  • Expertise in End-to-End applications 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 allocate work to Offshore and get it delivered within the committed timelines
  • Capacity Management & Offshore Work Management
  • Should gather requirements and give it to Offshore and get the work completed at Offshore
  • Project Status Reporting to Customers
  • Gather requirements from customers and give it to Offshore and get the work completed at Offshore
  • Perform Code reviews / Unit Testing on the components delivered at Offshore and release it to production
  • Should have strong Analytical & 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
  • Should have a good knowledge on Teradata
  • Should have good knowledge on Teradata Functions / Parallelism, Explain Plan analysis and Performance tuning

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