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. Knowledge of various data warehouse support solutions and software -- To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/CBE-Software-Engineer?hl=en
