Hi Folks,
Hope you are doing well,
Please reply to raj@dyssinc.com
==============================================================
Job Title: ETL Lead (EDW)
Location: West Chester, PA
Duration: 6 - 12 Months
Here are the priorities - please send resumes only with these experience:
Lead Experience - Very Good (Primary)
Informatica Experience – Very Good (Primary)
Teradata – Average (Secondary) – Good is a plus
UNIX – Average (Secondary) – Good is a plus
| Job Title | ETL – Developer Lead who have the expertise knowledge in Informatica (ETL), Teradata (DB) and UNIX Shell Programming |
| Relevant Experience (Yrs) | BE in Computer Science/ Engineering, or more work experience in ETL Development (Informatica, Teradata and UNIX Shell Scripting).
At least 8-9 years' experience |
| 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 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.
Strong UNIX shell scripting is mandatory and should develop scripts to call Teradata tools / utilities as per the business requirements
Should have experience in Teradata (DB) and have worked extensively in BTEQ, Teradata SQL Assistant, Multiload, Fastload 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 the ability to understand the business requirement and develop the mappings in Informatica using UNIX and Teradata scripts
OBI reporting knowledge is a plus. |
| Total Experience Required | 8+ Years |
| Roles & Responsibilities | Should act a front-end for customers and represent as a ETL Development Lead (Onsite)
Should Manage a Team of 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.
|
|
Generic Managerial Skills
|
Should have excellent communication and client handling skills.
Must be a team player
Experience in coordinating with multiple teams and offshore team.
|
| Education | BS/B.E. in Computer Science/ Engineering |
Thanks and Regards,
Vikash Raj |Team Lead| Dynamic Software Services, Inc.|
766 Sutter Street -13.San Francisco, CA- 94109|
Office: 415-259-5613| Fax: 415-520-5437| raj@dyssinc.com
Yahoo IM: best_recruiter
Gtalk: vikash.bestrecruiter
No comments:
Post a Comment