Dear fellow professionals, We have a requirement for a *ETL Developer *with one of our major clients *Pepsico *in *Purchase,NY *for a *7 months contract position*.* *Please send your *updated resume* to [email protected] if you are interested to apply with your expected hourly rate on Corp-Corp. **
*QUESTIONS* 1. What do you understand from the term business intelligence (please explain in 2 sentences at most), and why do we need a data warehousing system instead of reporting directly against a transactional system (2 sentences at most)? 2. How do you de-duplicate (remove duplicates) from a source file (not database). Meaning: source file has duplicates but when you write the target file, it should not have duplicates - Please provide answer in 3 or less lines, covering a scenario that you encountered in your experience. 3. When to use UN cached lookup and when to use Cached lookup? and why? - Please provide answer in 3 or less lines, covering a scenario that you encountered in your experience. *Position: * ETL Developer (6 - 8 years experience) ** *Location- *Purchase,NY *Duration*- 7 months *Position responsibilities:* - The ETL developer (6 - 8 years experience) is able to design, document, develop, test, install and support complex data extract, transformation and load (ETL) programs. - This person will be responsible for designing, coding and testing changes various data environments. - Work various teams to maintain and enhance systems. - This person will work in conjunction with other IT/development and business groups to understand functionality, scalability, performance, security and integration requirements from the database perspective, and translate these requirements into functional, scalable and reusable components within the respective development framework. - Common packages development platforms are (Informatica, MS-DTS, Teradata, Oracle) *Position Description:* - Extensive experience with Informatica, Oracle, Unix development and problem resolution. - Must have scheduling application experience, preferably Control-M. Business Objects experience desirable. - Architecture experience nice to have. - * Technical lead experience - Work management for developers, prioritization, tracking, and planning - * Clear understanding of concepts and architecture associated with business intelligence/data warehousing - * Full SDLC, Incident/Configuration/Release management experience strongly desired. Strong requirements development management and testing planning/scenario creation/test case creation experience required - * Strong analytical/problem-solving skills, with the ability to quickly gain alignment on proposed solutions - * Strong communicatio and coordination, extensive business partner/end-user interaction - * Should have worked on a large team - Need to have ability to quickly respond to requests, learn to navigate the organization, and have the capability to start operating independently in a short amount of time - * Multi-tasking, flexibility and adaptability, and ability to have and maintain a 'big picture' of the application at all times - * Inclination and aptitude towards process improvement via identification of opportunity areas and quick alignment/resolution *Role and Responsibilities:* - * Support Informatica component for Bottler, MSA, SAP, EDW, and SIPS interfaces. - * Troubleshoot issues encountered with the STAR2 interfaces, work closely with frontline support to resolve issues and plan out specific tasks as applicable. - Provide quick response to architect requests for analysis associated with work intake items (new work that might require fact-finding, analysis, prototyping etc. - Communicate and coordinate with EDW baseline team, Business Run Team, SIPS baseline team, and other teams/members as necessary. - Prepare task lists and ensure alignment and execution, as necessary Function as baseline support/development technical lead as and when required. - Plan and coordinate testing across multiple teams, track and report status, create cycle plan, scenarios etc. - Support overall break-fix and baseline release development. - Support data preparation and testing effort for break-fix and baseline releases. ** *Skillsets:* *Required: *Informatica,Oracle,SQL,UNIX *Desired: *Business Objects,TIBCO *Required Qualifications:* - Business partner interaction a must - Strong communication skills - Ability to clearly communicate a concept - Must have worked on a large team and an aggressive application (development/support) with daily SLA's. Warm regards, Ashish Mohanty Computech Corporation | 30700 Telegraph Road, Suite 4555| Bingham Farms| Michigan 48025 *Ph:* (630)-296-8724, EXT - 724 |*Fax:* 248-712-0930| *Email:* [email protected] | www.computechcorp.com | -- You received this message because you are subscribed to the Google Groups "KNOW.IT" 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/know_it_az?hl=en.
