Project Leader

4-6 Years

This job is no longer accepting applications

Job Description

Job Title: -Project Leader- Snowflake, MDM

Job Location: -Gurgaon/Noida/Bangalore/Pune/Hyderabad

Job Responsibilities: -

Participates in requirements gathering and research, proposes technology solutions, and develops solutions within agreed upon timelines. Understand the underlying data and flow of data.
Design, implement, and support data warehousing – implement business rules via stored procedures, middleware or other technologies; define user interfaces and functional specifications
Design and implement OLTP and OLAP data models
Build ETL pipelines with ability to implement complex business rules
Build MDM capabilities such as match-merge, affiliation, DCR mgmt
Evaluate, design, and maintain multiple database environments; identify data sources, construct data decomposition diagrams, provide data flow diagrams, and document the process; write codes for database access, modifications and constructions including stored procedures and database server configuration
Well versed with SQL and PL/SQL with ability to create, debug, optimize store procedures / SQL statements
Troubleshoot and resolve data quality issues, database performance issues, database capacity issues, replication and other distributed data issues
Resolve performance issues by looking at query plans, create appropriate indexes, resolve dead locks, and create table hints
Closely work with other IT teams including Analysts and Product Managers to troubleshoot, modify, and enhance existing BI assets
Develop, implement, and maintain change control and testing processes for modifications to databases
Implement SDLC processes including creating STTM documents, system design, code reviews, deployment plans, enhancements, status reporting etc
Client engagement including requirements management, user acceptance
Provide hypercare and production support of implemented data engineering solution
Impact assessment, incident/problem management, change request estimation and implementation
Pharma experienced
Trained or hands on exposure to Gen AI technologies is a plus
Some working exposure to data governance / MDM / BI tools is desirable

Job Requirements: -

Overall, 4-6 years of rich experience in the Pharmaceutical / Life Sciences Domain.
Independently he/she should be able to create ETL design, implement, deliver complex ETL code for simple to complex Data Integration/ Data Warehousing project assignments.
Should have strong expertise and working experience in at least 1 ETL tool like Informatica, Matillion, IICS, Snowflake
Should have expertise and working experience in at least 1 DBMS/appliances among Redshift, Netezza, SQL Server, Oracle, Snowflake, HIVE/Bigdata, AzureSQL
Should have exposure to Customer / Product MDM using any tool (Reltio, Informatica)
Experience of working on AWS or Azure cloud