Position: Senior ETL Developer
Location: Alpharetta, GA
Duration: 12 months
Best rate: $45/Hr Best
Must be able to attend in-person interview at own expenses if requested by the
client!!
Below is a questionnaire the client manager would like the perspective
consultant to fill out.
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
Below is a questionnaire the client manager would like the perspective
consultant to fill out.
Applicant Name:
Position: Data Warehouse ETL Developer
Date:
1. Why are you looking for a new position?
A:
2. What do you like the most/least about your current position?
Likes:
Dislikes:
3. What motivates you?
A:
4. Tell me about your favorite project that you have had and why.
A:
5. Tell me about your least favorite job. Why?
A:
6. What are your short and long term career goals?
Short-term:
Long-term:
7. What are your salary expectations if this job were to go
permanent? A:
8. Although the team is not a 24x7 team, this position involves
rotating with other back-end developers on weekends to check to make sure data
is loaded Monday morning for our daily dashboard report. You must have
experience supporting a data warehouse operationally, ensuring daily loads are
completed on-time; No ETL tools (i.e. Informatica, AbInitio) are used in this
data warehouse. Is any of this a problem? Explain A:
9. Out of a TOTAL of 100%, what percentage of each of the following
data warehousing tasks are you most experienced in compared to the others?
Requirements gathering %
Analysis & Design %
ETL Development %
Report Development %
Support/Operations %
100%
10. When using SQL, why would you use a self join? A:
11. Have you used Informatica before, how long and to what extent?
12. If a business customer requested a report containing customer
name, address, DOB and SSN, how would you handle that request? A:
13. What is the largest table that you have worked with in terms of
rows and/or total volume? A:
14. Largest database? A:
15. Please rate your proficiency of the following skills or concepts
based on this scale (0=none/general knowledge, 1=novice, 2=proficient,
3=expert).
Languages
SQL (Oracle) =
PL/SQL =
Perl =
Shell Scripting (Ksh, Csh, Sh) =
Databases
Oracle 8 or 9i Rating = , Years Experience =
Others (NCR Teradata, Netezza) =
O/S
Solaris =
Unix =
Linux =
Windows =
Tools
Data Modeling Tools (i.e. Oracle Designer) =
OLAP Tools (i.e. Microstrategy, Business Objects) =
Other Reporting Tools (name them)
Concepts/Tasks:
Data Warehousing Rating = , Years Experience =
Performance Tuning Rating = , Years Experience =
eCommerce Rating = , Years Experience =
Thanks & Regards,
Angela Thomas
Account Manager
Data Group Inc
[email protected]
www.datagroupinc.net
Certified MWBE & SBE Company
--
You received this message because you are subscribed to the Google Groups "SAP
ABAP" 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/sap-abap?hl=en.
