Hello, Greetings from Avance.
We have an urgent requirement related to your profile with one of our client for *ETL/ Informatica Lead(Netezza) at **Washington, DC**. *If you are interested and available for the following position then please send your updated resume immediately. *Job Title: **ETL/ Informatica Lead(* *Netezza)Locations:* *Washington, DC* *Job Type: ContractProject Scope:* - Project is to create a master record for personnel that will aggregate data from 5 different systems includeing peoplesoft, active directory, etc. into *Netezza 7.0.4* - The resource needs to be self-starting and self-sufficient as they will only have one BA to work with and no other developers. They will be responsible for delivering the entire project from end to end. - They will need to be able to model, design table structures ddl mappings and will need strong SQL skills - They will use PowerCenter 9.6.1 (no upgrade work contrary to the profile) - They are now saying they need onshore instead of offshore (although they will confirm on Monday) for Mid-Sept through December - They are expecting several profiles to review by Monday if possible. They have historically used other vendors but are trying us out so we need someone strong that can be a foundation for growing our involvement in their BI group. - Apparently the data is not clean and they are asking for strong sql for profiling so I have pitched our IP tools for profiling, rules, and automation for INFA. They are very interested so we will likely set up a demo for next week to show our offerings. * Job Description: * - Proficient use of CASE tools (Embarcadero ER Studio preferred) *8**-10 year*s of prior software development experience required. - Proficient in Netezza 7.0.4 - Proficient on all Informatica 9.x Platform tools (Power Exchange, Power Center) - Design, Develop and Provide support in all aspects of data movement for a data warehouse environment residing on Netezza, with emphasis on the Extract-Transform-Load (ETL) process using Informatica. - Ability to administer ETL system and upgrade to new releases - Develop data warehouse process models, including sourcing, extracting, transforming and loading as per business requirements. - Design Extract-Transform-Load (ETL) Workflows for data migration from various sources to data warehouse using batch or incremental loading strategies. - Document database design including data modeling, metadata and business process flow for the new business integration requirements. - Create data model and reverse engineer data warehouse using CASE tools like ER Studio. - Create test plans and scripts for data warehouse testing, ranging from unit to integration testing. - Ensure delivered Data warehouse code is running and conforms to specifications and design guidelines. - Create Informatica mappings, transformations, stored procedures and functions to implement the data process flow defined by the business rules. - Document technical ETL specifications for data warehouse. Perform periodic code reviews and test plans to ensure data quality and integrity. • Navigate on the host server for file management, file cleanup and configuration tasks. Maintain Informatica on UNIX and Windows environments. Write Shell scripts, PL/SQL scripts and SQL scripts - Prior Experience in Upgrading Informatica Power Center versions. - Excellent communication skills with knowledge of ETL field, tools and technologies, implementations and solutions, as well as specific experience with the Informatica ETL tool - Excellent motivational skills required to ensure good team synergy and collaboration of cross functional teams. A strong facilitation and “positive” attitude will be mandatory. - Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning, and High Volume Data Loads - Excellent ability to multi-task. - Demonstrated proficiency with a database SQL language for user-defined database extracts or updates statements. *Company:* A Global IT consulting firm with several large customer engagements across Europe and US. It provides strategic business consulting, technology, engineering and outsourcing services to help clients leverage technology and create impactful and measurable business value for every IT investment. *About Us:* Avance Consulting Services is a global talent acquisition and executive search company. We work exclusively with some of the most reputed and admired clients across various sectors and geographies. -- Best Regards, Divya Sanisetty Technical Recruiter +1 732 276 9933 *Ext :* 476 [email protected] -- You received this message because you are subscribed to the Google Groups "project managment" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/project-managment. For more options, visit https://groups.google.com/d/optout.
