Project Leader
Axtria · Noida · onsite · Posted 70d ago
Undisclosed3–8 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
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
Sourced from naukri
Skills
bidbmsInformaticaMDMReltioHiveetl toolamazon web servicesredshiftIICSSQL AzureAppliancesNetezzaOracle DBDesigning EtlPLSQLSQLData WarehousingSnowflakeETLMicrosoft AzureSQL ServerPharmaceuticalLife SciencesBig Data
About Axtria
Axtria
Software Product
2.8k+
employees
2010
16 years old
Gurgaon/Gurugram, Haryana
India
About
Axtria provides cloud software and data analytics solutions to the life sciences sector, enhancing product commercialization and improving healthcare outcomes.
Industries
Software ProductInternetIT Services & Consulting
Employee ratings
783 reviews
2.8/ 5
Culture
2.6
Career growth
2.7
Work-life
2.6
Employees rate it well for
Work Life Balance200Senior Management101Salary94Learning88Work Culture84
Find them on