Merck KGaA

Data Engineer I

Posted On

Nov. 6, 2024

Location

Bangalore, Karnataka

Experience Level

C - Professional (1-3 years)

Job Type

Full-time

Apply By

Jan. 7, 2025

Job Description

Job Title: Data EngineerJob Location: Bangalore In this role, you will be part of a growing, global team of data engineers, who collaborate in DevOps mode, in order to enable Merck's Life Science business with state-of-the-art technology to leverage data as an asset and to take better informed decisions. The Life Science Data Engineering Team is responsible for designing, developing, testing, and supporting automated end-to-end data pipelines and applications on Life Science’s data management and analytics platform (Palantir Foundry, AWS and other components). The Foundry platform comprises multiple different technology stacks, which are hosted on Amazon Web Services (AWS) infrastructure . Developing pipelines and applications on Foundry requires: Proficiency in SQL / Java / Python (Python required; all 3 not necessary)Proficiency in PySpark for distributed computationFamiliarity with Postgres and ElasticsearchFamiliarity with HTML, CSS, and JavaScript and basic design/visual competencyFamiliarity with common databases (e.g. JDBC, MySQL, Microsoft SQL). Not all types requiredFamiliarity with any cloud infrastructure/tools with respect to data engineering This position will be project based and may work across multiple smaller projects or a single large project utilizing an agile project methodology. Roles & Responsibilities: Develop data pipelines by ingesting various data sources – structured and un-structured – into Palantir FoundryParticipate in end-to-end project lifecycle, from requirements analysis to go-live and operations of an applicationActs as business analyst for developing requirements for Foundry pipelinesReview code developed by other data engineers and check against platform-specific standards, cross-cutting concerns, coding and configuration standards and functional specification of the pipelineDocument technical work in a professional and transparent way. Create high quality technical documentationWork out the best possible balance between technical feasibility and business requirements (the latter can be quite strict)Deploy applications on Foundry platform infrastructure with clearly defined checksImplementation of changes and bug fixes via Merck's change management framework and according to system engineering practices (additional training will be provided)DevOps project setup following Agile principles (e.g. Scrum)Besides working on projects, act as third level support for critical applications; analyze and resolve complex incidents/problems. Debug problems across a full stack of Foundry and code based on Python with SparkWork closely with business users, data scientists/analysts to design physical data models Education B.Sc. (or higher) degree in Computer Science, Engineering, Mathematics, or related fields Professional Experience 5+ years of experience in system engineering or software development3+ years of experience in data and analytics.0-2 years of experience for intern in data analytis SkillsHadoop GeneralDeep knowledge of big data, distributed file system concepts, map-reduce principles and distributed computing. Knowledge of Spark and differences between Spark and Map-Reduce. Familiarity of encryption and security in a Hadoop cluster.Application Development Familiarity with HTML, CSS, and JavaScript and basic design/visual competency. Experience with any data visualization tool like Tableau is a plus.SparkDeep understanding of Apache Spark framework and proficiency in building spark pipelines.Data management / data structuresMust be proficient in technical data management tasks, i.e. writing code to read, transform and store dataXML/JSON knowledgeExperience working with REST APIsSCC/GitMust be experienced in the use of source code control systems such as GitETL Experience with developing ELT/ETL processes with experience in loading data from enterprise sized RDBMS systems such as Oracle, DB2, MySQL, etc.AuthorizationBasic understanding of user authorization and authenticationProgramming Must be at able to code in PythonMust have experience in using REST APIsSQL Must be an expert in manipulating database data using SQL. Familiarity with views, functions, stored procedures, and exception handling.AWS General knowledge of AWS Stack (EC2, S3, EBS, …)IT Process ComplianceSDLC experience and formalized change controlsWorking in DevOps teams, based on Agile principles (e.g. Scrum)ITIL knowledge (especially incident, problem and change management)Languages Fluent English skills Specific information related to the position:Physical presence in primary work location (Bangalore)Flexible to work CEST and US EST time zones (according to team rotation plan)Willingness to travel to Germany, US and potentially other locations (as per project demand)

Jobs at Bangalore

Capgemini

AWS Devops | 4 To 9 Years | Pune & …

Experienced Professionals

Bangalore, Karnataka

Data Engineer I Apply Now

Job Description

Jobs at Bangalore

More Jobs at Merck KGaA

Actively Recruiting Companies at Bangalore, Karnataka

Data Engineer I