Description
AS23084
ETL Developer (Sr)
Pleasanton, CA
Position type: w2
Contract duration: 13months + (strong possibility of extension)
INFORMATIC POWERCENT 8.6 or higher a must
Works with Technical Lead; Assists with data load related architecture and technical design; Develops ETL mappings; Development and maintenance of database systems to extract, cleanse, transform, load and maintain data; Ensures compliance with industry best practices; Performs code review; Coordinates and develops process automation/job scheduling; Perform testing, code review; Performs defect analysis.
Top 3 - 5 Daily responsibilities
Develop and Unit Test Informatica Transformation Jobs from Source to Target
Complex SQL Staging output tables for Data Mart Build
Document Coding standards and Defect Management Tracking
Top 3 - 5 Required Skills
3-5 years Informatica Powercenter 8.6 a must
3-5 years PL/SQL
Technical Documentation and Industry Standards for Developing ETL
Facts and Dimensional Development for Data Warehousing
Desired skills
HealthCare and/or Pharmacy Experince in Data Warehousing
Retail Exeperience in Data Warehousing
Soft Skills
Good Verbal and Excellent Email Communication
Ability to troubleshoot and articulate a issue or problem
Ability to work with other developers and analyst
Ability to receive constructive feedback
Ability to resolve conflicts with desired outcome in mind
Ability to take direction