Hi, Good Morning.
Hope you are doing GREAT. Please let me know if you have any consultant for this position. *Location:* NYC *Duration:* 3-6 Months *Description:* Thanks & Regards,* Position Objective:* (Write a brief statement regarding the objective of the position. Please define your acronyms.) Review and understand business data requirements for data warehousing projects, applications and Business Intelligence (BI)/Business Objects (BO) Reporting Systems and perform data analysis and data administration activities such as creation of data dictionaries, data transformations, assess data quality and recommend data quality improvements, identify data augmentation and data integration required to support the corporate projects, define data mart specifications etc. *Major Opportunities and Decisions:* (Describe the more difficult and/or complex challenges or opportunities and decisions faced in doing work, improving processes or meeting customer needs. Where must position focus to be successful?) *Principal Accountabilities:* (List 6-8 major areas of responsibilities in order of importance, and purpose of these activities. In addition, identify percent of time normally spent and whether the activity is an essential or minor function.) *Activity* *Purpose* *%time* *E/M* Review and understand business data related ETL requirements for database, application and reporting projects. · Develop and make enhancement on new and existing data systems. · Participate in the development plans and resource estimation for task planning. · Assist with the development of logical data models. 20% Develop ETL functional design specifications from and to source and target data stores or as a support for various applications. · Work with application development teams from initial specification drafting through implementation; · Create ETL specifications; 30% Develop Informatica ETL Workflows. · Develop ETL code both in Informatica and at the shell script level. 50% ______________________________________________________________________________________________________ *Skills and Knowledge:* (Identify core competencies, key specialties, technical, human relations or managerial skills, and knowledge areas necessary to accomplish responsibilities and desired end results.) *Competencies/Skills: * - Excellent Customer Relations – forms productive relationships with customers and development teams. - Excellent writing and communication skills. - Excellent analytical skills. *Knowledge: * - Strong knowledge of ETL concepts especially as applied to Informatica. - Strong knowledge of data analysis, data transformation, conceptual data modeling, data transformation and metadata management. - Strong knowledge of data design for various applications. - Good knowledge of SQL. - Good knowledge of various RDBMS, Mainframe, Unix. - Good knowledge of Project Life Cycles methodologies. - Strong verbal and written communication skills. * * *Education and Experience:* (Identify types and length of education and experience needed to acquire the necessary skills and knowledge to accomplish the desired end results.) *Education:* BA/BS Degree or equivalent experience, preferably in Computer Science or Information Management Systems. *Experience:* - 5 years + experience with Informatica. - 3 years + shell scripting experience. - 3 years + SQL query-writing experience. - 1 year + experience with PowerCenter. - Experience working with and able to demonstrate knowledge of complex Informatica transformations. - Experience working with very large data sets in ETL projects. - Experience working on UNIX platforms - AiX. - Experience in ETL performance tuning /optimization; - Experience with the Informatica command line utilities; - Experience drafting ETL specifications; - Experience developing complex ETL mappings; - Track record communicating issues and follow-up through issue resolution; *Other Requirements:* (Consider other specific requirements essential to the successful performance of position responsibilities and accountabilities, e.g., travel. Identify the frequency of action and weight involved with the physical demands of essential functions performed by the position, if applicable. Occasional 0-33% of time; Frequent – 34-66% of time; Constant – 67-100% of time) Thanks & Regards, Madhukar Resource Manager** Vanceva Technologies, Inc Alpharetta, GA-30005 Direct: 678-799-8602 ** Fax: (866) 471-3906(Fax) Email:*[email protected]* <[email protected]> www.vancevatech.com<file:///C:/Documents%20and%20Settings/ambica%20soni/Application%20Data/Microsoft/Signatures/www.vancevatech.com> *D**isclaimer: **We respect your on-line privacy. This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th US Congress this mail cannot be considered Spam as long as we include contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line and we will remove your name from the mailing list. I am sorry for the inconvenience caused to you.* --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.co.in/group/us_itgroups?hl=en -~----------~----~----~----~------~----~------~--~---
