ETL Developer

8 - 10 years experience  •  Biotech/Pharma

Salary depends on experience
Posted on 09/21/17
Princeton, NJ
8 - 10 years experience
Biotech/Pharma
Salary depends on experience
Posted on 09/21/17

Job Overview

We’re currently in search of an ETL Developer to join our Princeton, NJ location. The ETL Developer will be responsible to provide end-to-end BI solutions and take our visualization and data warehouse initiatives to the next level. The ETL Developer should able to work independently to deliver time sensitive projects; collaborate with the business/technical teams and deliver solutions to business customers across Business Units.

Including but not limited to the following:

ETL Developer will work with SAP Business Objects Reporting, BO Data Services, Crystal Reports, Xcelsius Dashboard, Spotfire Data Services, Data Quality, Information Steward and Metadata Manager as well as traditional database technologies (Oracle, MS SQL Server). This role will interact with business customers at all levels and works with internal IT groups to troubleshoot and fix issues, move changes to production, and ensure the timely project delivery.



• Applying architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability

• Define the overall BI data architecture, including platform, ETL processes, BI reporting and Analytics and DW data marts

• Develop front-end, metadata and ETL specification to support business requirements for reporting across the organization

• Performance tuning and enforcing repository best practices

• Responsible for the design, set up and maintenance of both Production and Non-Production environments.

• Troubleshoot Production issues, identify root cause and migrate fixes

• Develop reporting standards and best practices to ensure data standardization and consistency

• Help to create and implement a long-term storage and business continuity strategy including backup & recovery and data storage and archiving

• Lead solution design based on input from governance, enterprise architecture, business requirements, business case, etc.

• Develop solution architecture principles, patterns, logical process, data and application work products.

• Define data integration process and collaborate with business analyst for various project needs

• Manage BI platforms including sizing, installation, upgrade, migration etc. for the SAP BO Reporting, BODS ETL, Crystal Reports, Xcelsius Dashboard, Data Quality, Information Steward and Metadata Manager

• Develop ETL data flows to extract data from Oracle, MS SQL databases, Excel spreadsheets, flat files, XML, Json and load into target data warehouse databases.

• Develop extract process using Restful API, perform data cleansing and data transformations

• Develop and maintain ETL Architecture and data warehouse data structures

• Responsible for designing and developing complex data integration systems as well as testing and troubleshooting it before it goes live

• Copy or extract data from the customer’s business process and load into the data warehouse so all of the information is up-to-date

• Strong acumen with clinical data to triage and resolve data related issues by collaborating with multiple data stakeholders

Education/Qualifications

•Bachelor’sdegree in Computer Science orEngineeringor equivalent discipline

Experience

This role should have 7 - 10 years of ETL/reporting Development and few years of experience as BI Architect. Experience with Development of data integration systems between operational and business intelligence systems, data modeling, data architecture, reporting and dimensional modeling. This role needs proven experience with industry standard ETL and reporting platforms including but not limited to SAP BODS, PL/SQL,T_SQL, SSIS, Informatica and SAP BO reporting.



• Minimum of 7-10 years of experience as ETL developer with 2- 5 years of proven experience as BI architect

• 7+ years development experience with SAP BO data services

• 7+ years development experience with BOE, Crystal Reports, BI Dashboard, Information Steward, Data Quality, Metadata Manager

• 5+ years as data warehouse/analytics systems architect for large scale projects

• 3+ years development experience with Informatica

• 2+ years of experience with Spotfire data visualization

• Good working experience with BO Information Steward

• Excellent communication and interpersonal skills

• Good understanding of clinical trial data



Preferred Skills

• Big data and Hadoop experience is preferred

• Great communication and should able to work as a team

• Experience with OBIEE and Oracle business intelligence applications

• Data Integration experience with Siebel CRM, eTMF and EDC systems

• Ability to lead medium to large size projects. This will include working with internal and contract resource teams

• Experience working with offshore teams is a plus.





• Minimum of 7-10 years of experience as ETL developer with 2- 5 years of proven experience as BI architect

• 7+ years development experience with SAP BO data services

• 7+ years development experience with BOE, Crystal Reports, BI Dashboard, Information Steward, Data Quality, Metadata Manager

• 5+ years as data warehouse/analytics systems architect for large scale projects

• 3+ years development experience with Informatica

• 2+ years of experience with Spotfire data visualization

• Good working experience with BO Information Steward

• Excellent communication and interpersonal skills

• Good understanding of clinical trial data



Preferred Skills

• Big data and Hadoop experience is preferred

• Great communication and should able to work as a team

• Experience with OBIEE and Oracle business intelligence applications

• Data Integration experience with Siebel CRM, eTMF and EDC systems

• Ability to lead medium to large size projects. This will include working with internal and contract resource teams

Job Number 2017-13441

Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.