Senior ETL Developer

DESIRED QUALIFICATIONS:

• 7-10 years’ experience in ETL development positions.
• Experience with Oracle RDBMS, Informatica PowerCenter, and other data management tools
• Demonstrated ability to communicate and collaborate effectively with both technical and non-technical resources
• Successful experience working in small, highly-collaborative, teams; particularly in an Agile Scrum development environment.
• Experience with reporting tools such as OBIEE and Tableau
• Higher education and/or academic medical center experience a plus.

EDUCATION & EXPERIENCE (REQUIRED): 

Bachelor's degree and seven years of relevant experience in computer science, or engineering or a combination of education and relevant experience.

KNOWLEDGE, SKILLS AND ABILITIES (REQUIRED):

• Understanding of software engineering principles and skills working on Unix/Linux/Windows Operation systems, Version Control and Office software.
• Strong programming skills, relational database skills with expertise in Advanced Sql and PL/Sql.  Skills in Shell Programming and any Object Oriented Programming language.
• Mastery in Business Intelligence and Data warehousing concepts and methodologies.
• Expert in Data Modeling and designing data warehouse from heterogeneous OLTP sources.
• Ability to design Physical and Reporting Data models for seamless cross-functional and cross-systems data reporting.
• Able to design complex ETL’s extracting data through XML files, RDBMS and Flat file sources.
• High expertise on Databases, data acquisition, ETL strategies and tools and technologies like Informatica, Datastage and others.
• Should be able to write custom ETL programming form complex data processing and transformations using any programming language, such as PL/Sql, Python, Java, etc.
• Extensive experience in data analysis and root cause analysis and proven problem solving and analytical thinking capabilities.
• Mastering in Reporting/Analytics and data visualization tools like OBIEE, and Business Objects, Tableau, and Qlikview including Design, Development and Administration functions.
• Ability to prioritize workload and work with minimal supervision.
• Experience with scripting language like Python, Shell, JavaScript, HTML5.
• Broad understanding of multiple existing and next generation Business intelligence tools and technologies.
• Ability to mentor lower level developers on definitive tasks.

• Constantly perform desk-based computer tasks.
• Frequently sitting.
• Occasionally stand/walk.
• Rarely writing by hand; lift/carry/push/pull objects that weigh up to 10 pounds.

* - Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of his or her job.

• Interpersonal Skills: Demonstrates the ability to work well with Stanford colleagues and clients and with external organizations.
• Promote Culture of Safety: Demonstrates commitment to personal responsibility and value for safety; communicates safety concerns; uses and promotes safe behaviors based on training and lessons learned.
• Subject to and expected to comply with all applicable University policies and procedures, including but not limited to the personnel policies and other policies found in the University's Administrative Guide, http://adminguide.stanford.edu.