ETL Developer at OakBrook

8 views

Skip to first unread message

Lalitha Prabhakar

unread,

Sep 7, 2011, 5:11:25 PM9/7/11

to lal...@frontiertechllc.com

Client is redbox – phone followed by onsite interview 6+ months

We are looking for an ETL Developer. The right candidate will possess good understanding of ETL process architecture and will demonstrate a solid grasp of data integration techniques. Primary job duties will include design, development, maintenance and support of ETL processes as well as working with internal/external teams to accommodate new and changing features and business system requirements.

Responsibilities:

Designs, develops and improves complex ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on business requirements.

Ensures accurate, appropriate and effective use of data; including data definition, structure, documentation, long-range requirements, and operational guidelines.

Performs metadata validation, reconciliation and appropriate error handling in ETL processes.

Augments application development support including updates to data models, creation and maintenance of data access code (typically stored procedures), and optimization of existing SQL.

Reviews database design and integration of systems and makes recommendations for enhancements or improvements.

Monitors ETL process activity and utilization, with particular strengths in performance tuning highly transactional data integration package in both the development and production environments including remotely located servers.

Troubleshoots data issues, validates result sets, recommends and implements process improvements.

Works with end-users to help identify issues and to refine requirements.

Has excellent communication (oral and written) and interpersonal skills, is a proficient problem solver, has the ability to acquire new skills quickly and thrive in a collaborative team environment.

Provide 24x7 on-call support for production systems.

KNOWLEDGE, SKILLS AND ABILITIES:

· Bachelor of Science in Computer Science or equivalent experience.

· 2+ years experience in design and development of complex near-real time and batch ETL processes.

· 1+ years experience with SSIS.

· 1+ years experience with SSRS / SSAS.

· Deep understanding of database design and modeling principals.

· Hands on experience working with data warehousing concepts, terminology and architecture.

· Knowledge of data profiling and cleansing techniques.

· Highly proficient in Transact SQL, stored procedures, query execution plans, etc.

· Ability to proactively identify, troubleshoot and resolve live ETL process issues.

· Experience running and supporting BI environments with multiple metadata sources.

· Experience working in agile environment including creating of automated build, testing, integration and data refresh processes.