Job Title: -Project Leader- Snowflake
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
- 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
- Experience of working on AWS or Azure cloud
