Participates in the development and maintenance of ETL processes that move data from operational systems to a Data Warehouse. Responsibilities include design, code, test, and production deployment and support of the ETL workflow. Responsible for configuration, tuning and implementation of ETL processes. Responsible for integrating the ETL tools with applications, web services, and/or data transport utilities. Has a deep technical understanding of at least one major rdbms platform. Has mentored more junior developers.
MAJOR DUTIES AND RESPONSIBILITIES:
*1. Assists in a leadership role for ETL activities including creating folders and users and managing ETL developer access. Assists in evaluating load monitoring and productivity tools. Assumes a senior advisory role for deployment of ETL code. Reviews and mentors less senior developers.
*2. Develops highly complex ETL code for data movement, data transformation, data quality, data cleansing and other ETL-related activities. Takes a leadership role in data load tuning.
*3. Develops new ETL designs that make full use of new technology. Develops ETL strategies that optimize technical resources.
*4. Identifies, documents and tracks all ETL related performance problems and taking a leadership role in their resolution where appropriate.
*5. Assists in evaluating, recommending and implementing tools and methods to automate ETL administration processes.
*6. Analyzes and identifies trends in ETL performance metrics. Designs, monitors and analyzes performance metrics programs for ETL performance and tuning and monitoring initiatives.
*7. Keeps current with industry best practices and trends in ETL practices, tools and techniques. Creates training program to educate others. Mentors junior developers.
8. Performs other duties as assigned or required.
*Denotes essential functions.
COMPETENCIES AND SKILLS:
Demonstrates working knowledge of more than one major RDBMS (excluding Access) platforms and operating systems.
Demonstrates the ability to provide ETL production support of critical data loads, Informatica workflow creation and administration, performance tuning of queries and data loads.
Demonstrates strong UNIX scripting skills. Able to mentor less senior developer's.
Demonstrates ability to design and develop complex database load and maintenance processes.
Demonstrates ability to organize, prioritize work, meet deadlines, and work independently.
Must possess excellent verbal and written communication skills along with excellent administrative and facilitation skills. Must be able to communicate difficult/sensitive information in a diplomatic and tactful way.
Works on projects of moderate to high complexity across two or more development environments. Works on multiple projects as a project team member. Considered a subject matter expert for a single business area or system. May coach more junior developers.
Demonstrates strong problem-solving skills. Able to determine tasks necessary to get a job done. Works independently.
EDUCATION AND/OR EXPERIENCE:
Bachelor's degree in Computer Science, Statistics, Math, Business Systems or Information Systems required.
Minimum of five years of IT and business experience, with participation on at least one full life-cycle Business Intelligence/Data Warehouse project required.
Or Master’s degree plus 3 years of experience in developing database load processes with database procedural languages, general programming languages, or an engine based ETL tool (Informatica, etc.).
Must have experience translating business requirements to technical specifications, creating mapping documents, developing ETL routines and testing ETL jobs.
Experience in health care or health payer systems is preferred.
Job Id 43151