Reference # 19-00104 Title ETL Integration Developer
Location Glendale, ARIZONA
Position Type Contract
Experience Level Contract
Start Date / End Date 04-03-2019 --- 04-03-2020
Description
Key Responsibilities:
The Informatica ETL Developer will be working in the Client ETL team to design, develop and maintain data provisioning solutions that require ETL resources. This resource will be assigned to a project focused on data requirements associated with the Policy Administration System(Client) platform. The candidate will need to understand business and technical requirements and translate this into data integration designs and deliverables. The solutions must align with client's ETL standards and guidelines. The data integration solutions will be based on Informatica with Oracle 12c database. The position also requires supporting the SDLC process in terms of testing, and deployment. This resource may be allocated to more than one initiative at a time based on skills demand and size of initiatives, and will be expected to adeptly manage tasks, timelines, priorities and communicate effectively to optimize workload. The candidate for this position may become involved in other technical platforms, tools and skills of the Analytics & Data Services team over time, this role may not be limited to Informatica ETL development only. Thus the ideal candidate will welcome the opportunities to broaden their experience in data provisioning and analytics related tools and competencies.
Essential Duties/Responsibilities:
" Design and Develop ETL programs primarily using Informatica PowerCenter, PL/SQL, Unix Shell Scripts
" Extract, transform & load into dimension model structures of EDW & data marts
" Performance improvement & tuning of Informatica mappings, SQL & PL/SQL scripts
" Strong SQL skillset with demonstrated experience on Oracle
" Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.
" Create necessary documentation as per SDLC standards
" Update the project documentation
" Upload the code to version control tool (GIT)
" Perform Unit Testing of ETL Programs and support QE on End-to-End testing
" Work with deployment team in the code migration across the SDLC environments
" Triage the Production issues and work on the code fixes
" May participate in a 24x7 rotational on-call responsibility

Job Requirements
Key Requirements and Technology Experience:
" Bachelors in Computer Science or Engineering desired or equivalent education and/or related work experience
" Minimum 6-7 years of experience in implementation of BI projects in a large scale enterprise data warehouse environment
" Minimum 5 years' experience with Informatica Power Center
" Minimum 5 years of experience in ETL Architecture and ETL products especially on Informatica 9 and above
" Minimum 2 years' experience with Informatica Developer
" Proven hands-on experience in using Informatica components such as Designer, Workflow Manager, Workflow Monitor, Repository Manager, etc
" Knowledge of end-to-end SDLC process in EDW & BI projects
" Dimensional Modeling and Data warehouse, ODS concepts, such as star schemas, snowflakes and normalized data models
" Converting functional specifications into ETL technical specifications and source to target mappings
" Informatica PowerCenter Certification is preferred