ABHIMANYU KUMAR
Kolkata
Summary
With over six years of experience in Data Analytics, I specialize in ETL development, primarily using Informatica and Matillion. My extensive expertise encompasses both Snowflake and Oracle SQL as an ETL Developer.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Senior Associate
Axtria India Private Limited
Noida, UP
12.2021 - Current
- Achieved comprehensive understanding of pharmaceutical industry and its fundamental concepts
- Worked as ETL developer with primary focus on enhancing data quality for end users
- Optimized whole ETL process for essential pharmaceutical data by implementing sophisticated data cleansing and validation techniques
- Enhanced the performance of data warehousing environment by implementing indexing and partitioning strategies, which cut down data load times by 60%, and supported faster analytical queries
- Worked on complex data migration strategy from legacy Redshift database into modernized Snowflake database
- Led a team of five ETL developers in high-stakes project, coordinating tasks and fostering collaboration
- Automated and scheduled an existing ETL pipeline through Airflow which in turn reduces the operational activities by 50%
- Collaborated with cross-functional teams to drive successful completion of complex projects within deadlines.
Programmer Analyst
Cognizant Technology Solutions
Kolkata, WB
04.2018 - 12.2021
- Developed various complex mappings, sessions, workflows, and parameter files in Informatica PowerCenter
- Developed multiple automated RDM load jobs, encompassing comprehensive data loading from the source to BO tables using Informatica PowerCenter
- Performed data validation and performance testing utilizing Batch View and SoapUI
- Deployed jobs using PMCMD commands in Jenkins
- Achieving Basic MDM exposure involved creating batch jobs, batch groups, validating metadata, and setting up new users
- Engaged in executing data quality functions, including data quality audit/assessment and data profiling to reduce the data redundancy by 80%
- Work in collaboration with diverse business and technical teams to collect requirements for data quality rules and suggest enhancements for their optimization
- Used Address Doctor and email Verification service for cleansing of address and email records.
- Written Complex queries in Oracle SQL to perform unit testing and data validation
- Involved in performing data quality functions - data quality audit/assessment, basic data profiling
- Scheduled workflows for job automation to minimize dependencies by 60%.
Education
B. Tech - Electronics and Communication Engineering
Meghnad Saha Institute of Technology
Kolkata, WEST BENGAL2017
High School Diploma -
D. A. V Public School
Patna, India2012
Science -
D. A.V Public School
Patna, India2010
Skills
- ETL Tools: Informatica Power Center, Matillion, IDQ
- Database: Oracle SQL, PLSQL, MYSQL, SQL Server, Snowflake, Redshift
- DWH Concepts, Data Model, ER and Dimensional Model
- Domain: Pharma, Life Science
- Therapeutic Areas: Respiratory, Renal and Immunology
- Datasets Used: Xponent, DDD, 867, Omnichannel digital activity
- Reporting Tool: Power BI
Certification
- Microsoft Certified Azure AI Fundamentals- AZ-900
- AWS Certified Cloud Practitioner- CLF-01
Timeline
Senior Associate
Axtria India Private Limited
12.2021 - Current
Programmer Analyst
Cognizant Technology Solutions
04.2018 - 12.2021
B. Tech - Electronics and Communication Engineering
Meghnad Saha Institute of Technology
High School Diploma -
D. A. V Public School
Science -
D. A.V Public School
Similar Profiles
Komal JaragKomal Jarag
Senior Associate at Axtria Ingenious Private LimitedSenior Associate at Axtria Ingenious Private Limited
INDRANIL SENGUPTAINDRANIL SENGUPTA
Tax Manager at RSM US Integrated Services India Private Limited (formerly Known as RSM Delivery Center (India) Private LimitedTax Manager at RSM US Integrated Services India Private Limited (formerly Known as RSM Delivery Center (India) Private Limited
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited
PRITAM VERMAPRITAM VERMA
Management Intern at Shiv Shakti EnterprisesManagement Intern at Shiv Shakti Enterprises
Niladri Bose MajumderNiladri Bose Majumder
Senior Angular Developer at Stableone Software Solutions Limited (A Unit of Agpaytech)Senior Angular Developer at Stableone Software Solutions Limited (A Unit of Agpaytech)