BIDW ETL Developer - Contractor Specialist

  • Location

    Oakland, United States

  • Sector:


  • Job type:


  • Contact:

    Leric Arcigal

  • Job ref:


  • Published:

    over 1 year ago

  • Expiry date:


ETL (Informatica) Developer - C D W As an ETL developer, you will be a member of technical team to build and support complex applications using Informatica. You will be responsible for developing, testing, implementing and supporting applications. The candidate will be working closely with ETL Leads/Managers. Responsibilities Coding, testing, modifying, debugging, documenting and implementation of Informatica maps. Review and Analyze functional requirements, mapping documents, assist in problem solving and trouble shooting. Work with different application groups and deliver effective solutions. Assist in technical specifications and other deliverable documents. Develop test cases and plans to complete the unit testing. Support System testing. Work with multiple teams and report to technical leads. Able to work in multiple projects simultaneously. Production support and maintenance of applications. Performance Tuning of Informatica Mappings, processes and load routines. Qualifications Bachelors Degree in Computer Science or related area of study. 7 + years of experience working with large scale applications. 6 + years of experience with Informatica tool set with good working experience in Informatica 8.6.1. Must have sound experience using databases such as Oracle. Data Warehouse/ETL design and development methodologies knowledge and experience is required. Strong Unix and Shell Scripting experience is must. Broad-based cross-functional IT experience in application development and interface design is essential. Must be able to interpret the transformation rules and develop the software components to support the same. Excellent Analysis and problem solving skills. Must work well in a collaborative, team environment as well as independently. Excellent communication skills both written and verbal. Healthcare domain knowledge will be an added advantage. Bachelors degree required. 7 + years of experience working with large scale applications preferred, but 3+ years required. (Will not use Informatica.) Will mostly be using SQL, SAS and Tableau. SQL is required. Tableau is required. SAS is preferred. 1. Create Report Code in SAS/SQL 2. Match Legacy report data with new data structure 3. Experience creating data structures to support visualizations 4. Experience with BI Tools like Tableau, SAS Grid, etc. 5. Excellent communication skills 6. Team player 7. Partner with UI/UX and Tableau developers to create visualizations using data extracts