Sr ETL Developer and Lead
Pleasanton, CA

Job Description

* Sr. ETL Developer with Informatica, IDQ, Power Center, BI, Oracle and strong SQL Skills
* Translates and transforms business requirements into data models (Conceptual, Logical and Physical) using Erwin.
* Analyze source system data using profiling tools.
* Designs dimensional data models for Highly scalable data warehouse.
* Interacts with OLTP systems and translated relational models into dimensional models.
* Maintains Data Model repository.
* Design data models in Data Modeling tools (Erwin).
* Knowledge of RDBMS platforms (e.g. Oracle) with experience in generating DDL.
* Show fundamental knowledge of application development cycle. Demonstrate an intermediate understanding of the application development cycle.
* Responsible for demonstrating appropriate, clear, concise, and effective written and oral communications in all interactions to build relationships and accomplish day to day work and projects.
* Follow established design patterns and has awareness of user experience standards. Responsible for individual components of design.
* Create technical documentation. Responsible for maintaining and validating current documentation.
* Responsible for components of integration within a module.
* Successfully completes projects, tasks, and initiatives by embracing a team-first approach. Works in collaboration with team and offers feedback, where appropriate, to complete individual and group efforts. Shows the ability to adjust and be flexible to change by adapting approach when necessary. Mentors less experienced staff.
* Has ownership in success of projects. Responsible for estimating and delivering on individual task within project.
* Follow established coding standards. Submit code for review and deliver quality, unit test code.
* Show fundamental knowledge and follow secure coding processes and writing, accessing, and following established security protocols.
* Responsible for continuous self-study, trainings, partnering with more senior members of team, and/or seeking out opportunities to broaden scope to stay up to date with industry and organizational trends. Seeks feedback from senior team members for development and effectively incorporates feedback into work and behaviors.
* &n