*Reply to [email protected]* Hi, Client is looking for an *ETL/Informatica Developer - NYC, NY. *This is a 6 months contract position. Local candidates only. F2F interview required.
*Position Objective:* 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. *Principal Accountabilities:* *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:* 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; *Please complete the following skills-matrix and send back with your updated resume. * Full Name: Degree Major: Total IT Experience: Total *ETL/Informatica Developer exp*: Total exp with Informatica: Total shell scripting exp: Total SQL query-writing exp: Total exp with PowerCenter: Total exp working with and able to demonstrate knowledge of complex Informatica transformations: Total exp working with very large data sets in ETL projects: Total exp working on UNIX platforms – AIX: Total exp in ETL performance tuning /optimization: Total exp with the Informatica command line utilities: Total exp drafting ETL specifications: Total exp developing complex ETL mappings: Total exp in Track record communicating issues and follow-up through issue resolution: Do you have knowledge of ETL concepts especially as applied to Informatica? Y/N Do you have knowledge of data analysis, data transformation, conceptual data modeling, data transformation and metadata management? Y/N Do you have knowledge of data design for various applications? Y/N Do you have knowledge of SQL? Y/N Do you have knowledge of various RDBMS, Mainframe, Unix: Hourly rate: Day Phone #: Evening Phone #: Cell Phone #: Availability: Current City/State: Work Status (US Citizen / Green Card / Others): Have you applied recently for this requirement earlier through any one else? Y/N: * If you qualify for this position, are available immediately and are interested, please send your resume, rate and contact information to *mailto:[email protected]?subject=etl/Informatica Developer - NYC, NY <[email protected]?subject=etl/Informatica%20Developer%20-%20NYC,%20NY>* * Please ensure you complete and copy/paste the above-completed matrix with your response *Thanks and Regards Tom BeyondTekIT Tel: 714-857-2002 - Ext -819 Fax: 714-364-9705 [email protected] www.beyondtekit.com* --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SAP ABAP" 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.com/group/SAP-ABAP -~----------~----~----~----~------~----~------~--~---
