Associate
Axtria - Ingenious Insights
Noida, Uttar Pradesh, India
- 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