- Location
- Noida, Uttar Pradesh, India
- Job type
- Full-time
Required skills
- AWS
- data models
- database
- ETL
- Hive
- middleware
- OLAP
- Oracle
- production support
- Snowflake
- SQL
- BI tools
- SDLC
About the role
Axtria - Ingenious Insights
Website:
axtria.com
Job details:
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
- 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 on 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
Click on Apply to know more.
This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.