OnBenchMark Logo

Neeraj (RID : 210ulpgouyad)

designation   Data Engineer

location   Location : Noida

experience   Experience : 9 Year

rate   Rate: $15 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Information Technology & Services

Shortlisted : 1
Total Views : 40
Key Skills
Data Engineer SQLServer Snowflake SQL PLSQL AWS
Discription

ProjectExperience

Project#1

Project                           :                MerckSDCP&Dataonboarding

Domain                         :                 LifeScience.

Role                                :                LeadETLDeveloper.

Technologies               :                Talend, Airflow, AWS Glue Amazon Redshift, PostgreSQL,Oracle

 

Description:

Merck & Co., Inc. is an American multinational pharmaceutical companyheadquarteredinKenilworth,NewJersey.ItisnamedaftertheMerckfamily,whichset up Merck Group in Germany in 1668. The company does business as MerckSharp &Dohme outside the United States and Canada. Across thebiopharmaceutical industry, it takes many scientists many years to design, make andtest thousands of new molecules in order to find the one or two that may be tested inclinical trials. Each discovery is refined, optimized and scrutinized before it can betested in humans. Merck scientists are using preclinical data to conduct translationalresearch to identify biomarkers that can be used in the clinic to provide surrogatemeasuresofefficacy forourinvestigational candidates.

 

ThisProjectistoprocessallthepre-clinicaldatafromvariousScientistsacrosssourceslike files, Oracle, MS SqlDb to Datawarehouse for Analytics and Reporting for theBusinesstomake decisions

 

RolesandResponsibilities:

    • InvolvedinETL Design toprocessesDataloadinto Factand Dimensionstables.
    • InvolvedinETLtestingfor variousdatafiles.
    • Involvedindevelopmentofpackages,Jobsconfigurationandjobscheduling.
    • InvolvedinErrorAnalysisfor trackingerrorfilesrecordsandforanalyzingthedata.
    • Canidentifybugsandfixthemquickly.
    • WorkedwithdifferentDataSourceslikeSQLServer,Oracle,RedshiftDbDifferent formsoffilesetc.
    • Involvedintestingofthe Jobs.
    • Successfullyreachedthedefinedstretchedgoalsforall theperiodssetbytheClients.

 

 

Project#2                  Project                           :                Johnson&JohnsonDataAnalytics&DataScience

Client                              :                Johnson&Johnson.

Domain                         :                LifeScience.

Role                                :                LeadETLDeveloper.

Environment               :                                                   Talend,AWSServices,AmazonRedshift,PythonPostgreSQL,Oracle

Duration                       :                April2020–Nov2021Description:

Johnson & Johnson DePuySynthes SalesAnalytics and Reporting solution delivered on the OneMDData&Analyticsplatformtoprovideconsolidated,harmonizedviewofsalesmetricsacrossallDPSfranchises&hospitalaccountsinformation(limitedtotheUnitedStates).

Sales consultants, regional managers, Area Vice Presidents, and internal Commercial Operationspartners will leverage this solution to track selling activities to drive sales growth and trackperformanceagainstsalesobjectives.Thefieldsales organizationwillrequiremobiledeviceaccess

 

RolesandResponsibilities:

      • Involvedin ETLDesigntoprocessesDataloadintoFactandDimensionstables.
      • InvolvedinETLtestingforvariousdatafiles.
      • Involvedindevelopmentofpackages,Jobsconfigurationandjobscheduling.
      • InvolvedinErrorAnalysisfor trackingerrorfilesrecordsandfor analyzethedata.
      • Canidentifybugsandfixthemquickly.
      • WorkedwithdifferentDataSourceslikeSQLServer,Oracle,RedshiftDbDifferentformsoffilesetc.
      • Involvedintestingofthe Jobs.
      • Successfullyreachedthedefinedstretchedgoalsforall theperiodssetbytheClients.
 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!