*Hi ,*
*Please find below our hot requirement from the client* Position Title Senior ETL Developer Primary Skill ETL Other Skills Informatica ETL Netezza Appliance Database Partitioning, Performance, and Tuning Duration 6 Months to Hire Location Alpharetta, GA Description *GC EAD or US citizen Need Local* Job Purpose Analyze, design and build reporting solutions around a variety of web-related performance and visitor behavior in the eCommerce Reporting Datamart (called the eDatamart). This individual will serve as one of the ETL developers on our eCommerce reporting team working the back-end (architecture, ETL dev and operations). The candidate filling this role must be well-rounded in skills related to data warehousing throughout the project life-cycle from analysis through report development and operations. The eCommerce reporting team consists of data warehousing specialists including ETL developers, analyst/reporting developers and operations. The team reports on all external customer-facing websites by owning and running a large in-house data mart (up to billions of rows per table) that tracks various clickstream, order and subscriber metrics for the eCommerce channel; in addition to other tools. This role will design solutions to solve complex integrated reporting requirements for various reporting releases. This will be accomplished by reviewing specification requirements with project members, provide ETL development and testing for implementing new requirements, provide necessary documentation and transfer knowledge to operations developer to sustain the new job(s). All members of the back-end of the team cover operations on an as needed basis. You may also be asked to work on special ad hoc queries related to a given project. The position requires experience with OLTP, data modeling (3rd normal and relational), aggregations and slowly changing dimensions. The position would be best suited to an individual that has a passion for data and analytics. This is a highly technical role requiring critical thinking, logic, organization, self-motivation and attention to detail from analysis through implementation and post-production QA. During the project work-cycle the developer will interface with the source systems? technical teams, business teams, reporting analyst and others. Therefore the ability to communicate with a variety of users, from directors to end-users, and perform well under tight deadlines in a fast-paced production environment is critical to success in this position. % Of Time Function 30% Analysis 30% Design / Data Modeling 30% Develop & Test ETL code 5% Report Development 5% Operational Tasks Education B.S. in a related field (Computer Sciences or Computer Engineering preferred) or equivalent experience required. Experience 5+ years in database and application design and development 4+ years in data warehouse design and development 3+ years in maintaining a production data warehouse Minimum 3 years experience in eCommerce reporting/analytics 1+ years leading date warehouse developers Skills and Abilities Languages: SQL, PL/SQL, Perl O/S: Solaris, Linux, Windows Database: Oracle 9i, Ansi SQL 92 Design Tools: CASE tools esp. Oracle Designer or Erwin Other: - Shell scripting (Korn shell, ksh scripting) - Experience in web technologies such as HTTP, web architecture (multi-tiered), HTML, Java, JavaScript. - Database Partitioning, Performance, and Tuning - Informatica ETL software - Netezza Appliance - Industry experience in eCommerce or telecommunications - Business Objects or similar end user reporting tool Mark Syscom Technologies, Inc. Phone: 703-565-2313 Fax: 703-991-5645 [email protected]
