Hi,
Please find the requirement below and let me know your interest.. *POSITION* *ETL/Data Warehouse Developer* *NYC, NY (LOCALS)* *6+ Months* *EAD GC/GC/USC* *Phone and F2F* MUST HAVE: ETL, Data Warehouse, Unix Commands and Shell Scripting, Data Modeling, Data Integration, Informatica PowerCenter DESCRIPTION: To develop dimensional models, ETL feeds and API calls. Ideally looking for an ETL developer level 3 with 4-5 years of experience with data integration. Job Title: IT Data Integration - ETL/Data Warehouse Developer (level 3) Job Overview: The IT Data Integration (ETL/Data Warehouse) is a centralized area which collects, massages, and summarizes information from diverse business data sources and prepares it for easy analysis and interpretation. Under no supervision, the Data Warehouse Developer Level 3 will understand all requirements needed for any level of data retrieval. The incumbent possesses an expertise in analyzing and retrieving complex data and verifying its integrity before storing in the data warehouse. Additionally, the incumbent is highly knowledgeable of Data Warehouse table design architecture and assists lower level developers with their table designs. Under minimal supervision, the Data Warehouse Developer Level 3 also prepares complex data for 3rd party operational software needs. Data is collected from multiple sources and distributed to specific programs found throughout the company. Additionally, the data transformation process requires documentation for the benefit of the intended receiver to understand how the data was calculated and transformed. The incumbent performs advanced and complex maintenance to the ETL tools. Additionally, the Level 3 consistently verifies data integrity and ensures optimal report performance. Furthermore, a Level 3 Developer assists lower level developers with assignments or projects and assists report writers with report performance optimization techniques *Essential Responsibilities:* - Analyze and evaluate business reporting needs as well as their relationship the Data Warehouse - Recommend solutions which might require external Data Warehouse changes - Analyze text and database sources to determine optimal data retrieval point - Plan new or modify existing tables using Dimensional Modeling design techniques - Create professional technical design documents also including source to target mapping details - Develop and implement ETL code and UNIX scripts - Utilize ETL tool options and database settings to achieve optimal speed - Assist lower level developers with design, development, and tuning - Assist report writers in selecting the best data for reporting needs and achieving optimal performance - Maintain healthy systems functions through patches, updates, and upgrades - On call 24-6 to ensure timely delivery of data regardless of any external interruptions *Specific Knowledge, Skills and Abilities:* - Expert understanding of data warehouse architecture - Advanced SQL tuning expertise - Ability to work on tight deadlines and constantly changing requirements - Knowledge of B&H policies and procedures - Articulate communicator and analytical thinker - Professional phone demeanor - Excellent grammar skills and writing ability - Detail-oriented, quick thinker, and problem solver *Education, Experience and Licenses:* - 4-5 years experience working with a large scale data warehouse - 4-5 years experience with advanced SQL coding and tuning, Oracle database preferred - Proficient with UNIX commands and shell scripting - High level utilization of a ETL data software, Informatica PowerCenter preferred - Experience in a corporate retail environment a plus *Thanks and Regards,* *Shilpi Bisht* *Sr. Technical Recruiter* *IDC Technologies* *1851 McCarthy Boulevard, Suite 116|Milpitas, CA , USA, 95035* *408-459-1965 [Direct]* -- You received this message because you are subscribed to the Google Groups "SAP Resource Center" 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/sap-resource-center. For more options, visit https://groups.google.com/d/optout.
