Data Engineer - Intern

Job Description

• Ingestion pipeline from various connectors to consolidated warehouse 
  • Setting up CICD pipeline 
  • Schema Design
  • Create and mantain ELT pipelines using orchestration tools 
    • Data quality checks 
    • Apply business logic transformation based on business requirements 
• Setting up connectors with different BI tools 
  • Setting up connectors including data gateways from consolidated platform to platforms like Power BI and ThoughtSpot  
• Data Cataloguing 
  • Data governance and access control 
  • Documenting data transformation pipelines 
  • Documenting and managing Technical and Business Metadata

• Technical Proficiency:
  • Proven experience in ETL pipeline development using orchestration tools 
  • SQL skills and experience with RDBMS 
  • Proficiency in programming languages such as Python
  • Experience with cloud data warehousing solutions like AWS Redshift
• BI Tools Experience:
  • Hands-on experience setting up and configuring BI tools like ThoughtSpot and PowerBI.
  • Ability to optimize data models and schema designs for efficient BI tool performance.
• Data Management:
  • Knowledge of data cataloguing tools (e.g., Apache Atlas, Informatica, Alation).
  • Familiarity with data governance frameworks and best practices.

Current Employees apply HERE

Current Contingent Workers apply HERE

Search Firm Representatives Please Read Carefully 
Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company.  No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails. 

Employee Status:

Relocation:

VISA Sponsorship:

Travel Requirements:

Flexible Work Arrangements:

Shift:

Valid Driving License:

Hazardous Material(s):

Job Posting End Date:

*A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.