Job Title: ETL Developer Duration:6 Months Location: Boston,MA Need Locals Need Only GC's or US Citizens
Job Description: Participates in and is responsible for the creation and maintenance of the Clinical Data Warehouse. Works closely with the data warehouse development team lead, customers, business analysts and other colleagues in the ITS department to analyze operational data sources, determine data availability, define the data warehouse schema and develop ETL processes for the creation, maintenance, administration and overall support of the data warehouse. From a day to day operations and project perspective, the work of the data warehouse developer will be directed by the data warehouse team lead.Collaborate with clinical application users, business analysts, colleagues and ITS management to define the data model and processes to create, maintain and administer the clinical data warehouse. Three to five years of experience maintaining and administering a multi-terabyte sized Oracle data warehouse in a UNIX (AIX) environment. Hands-on experience using Informatica Power Center for loading and maintaining a data warehouse is required. Demonstrated analytical, problem-solving and conceptual skills. Excellent oral and written communication skills and the ability to communicate effectively with non-technical people. Thorough understanding of the relational database model and experience in designing, modeling, developing and supporting data warehouses. Experience working with diverse data sources. Knowledge of SQL query optimization and performance tuning. Experience in entity relationship data modeling and data modeling tools. Knowledge of star and snow-flake schemas. - Develop strategy and coordinate between DBAs and Application support engineers in ITS to populate and maintain the data warehouse in order to support the clinical intelligence applications. - Maintain the Oracle Data warehouse. Keep the RDBMS and related products upgraded as appropriate. - Reorganize database structures (partition tables, indices etc.) as needed for performance and scalability. - Implement appropriate security mechanisms provided by the RDBMS as required by the applications. - Implement automatic and semi-automatic processes for incremental refresh of the data warehouse with changes in application data and ensure that they are executed without impacting the operational systems. - Maintain data warehouse backup/recovery environment. Implement appropriate backup strategy and develop recovery procedures. - Closely monitor performance, identify problems and implement solutions. Ensure the database is running at optimum speed and efficiency. - Maintain good working relationship with peers, superiors and application users. - Performs other duties as assigned or as necessary. - Oracle and/or Informatica certifications would be a plus. - Bachelor's degree in Computer Science, Business, or Engineering or equivalent work experience is required -- Please send me your updated resume immediately position will get closed within an hour. Regards, Neil Johnson Sr.US IT Recruiter 203-652-1444 x 174 [email protected] -- You received this message because you are subscribed to the Google Groups "Open Source J2EE frameworks" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/open-source-j2ee-frameworks. For more options, visit https://groups.google.com/d/optout.
