Please send the updated resumes to mike@thoughtwavesoft.com with the subject line ( 071812-03 TWSS - ETL Lead w/ Teradata ) 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. Technical 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.