Hi Friends,
Please have a look into below requirement and let me know if you have any suitable consultants. please send your responses at sireesha@lucidtechinc.com along with your consultant updated profile and contact details.
Job Title: Informatica with Netezza
Location: –ATLANTA,,,GA
Project Name:
eComm Analytic Platform
Project Description:
(What project will the NPW be working on?)
Design, Development and operations associated with the eCommerce Datamart and associated projects.
Job Description:
(What will the NPW do on that project?)
** The position is located in any of the following: Atlanta, Bothell or St. Louis and we would like the candidates to be LOCAL one of those areas. **
Pls indicate PREFERRED LOCATION in SUPPLEMENTAL SECTION as well as where the candidate resides. **
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
att.com/wireless 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
Skills Inventory
Skill Experience Need
1) SQL Expert Required
2) PL-SQL Expert Required
3) Data Warehousing Expert Required
4) Perl Intermediate Desired
5) Design Tools Expert Required
6) Informatica Expert Required
7) Netezza Expert Required
8) Oracle Intermediate Required
9) BS computer science or related Expert Required
Sireesha | Lucid Technologies, Inc
Office: 214-385-4144 Ext: 104,
Direct: 214-329-4553,
Job Portal with built in Application Tracking System (ATS) www.LucidJobs.com
No comments:
Post a Comment