Abhishek Kumar
Noida
Summary
Dynamic data professional with over 4 years of IT experience specializing in data analysis, design, development, implementation, and support of data warehousing solutions. Demonstrated expertise in extracting, transforming, and loading data from diverse sources within the healthcare and transportation sectors. Skilled in delivering optimized data integration solutions while collaborating effectively with stakeholders and cross-functional teams to drive project success. Committed to leveraging technical proficiency in Informatica PowerCenter, IICS, SQL, and Unix scripting to enhance organizational data strategies.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Senior Associate Consultant
Infosys
Noida, India
01.2025 - Current
- Experienced in the ETL process, including designing workflows, creating mappings, and developing scripts to ensure efficient data integration.
- Created comprehensive test cases aligned with enhancement requirements and original story specifications to ensure accurate validation.
- Handled diverse data sources such as flat files, tables, and XML, with targets including relational tables and CSV files for seamless data integration.
- Performed unit testing in the development environment and conducted regression testing in the Pre-Prod environment to ensure stability and functionality of enhancements.
- Managed deployments across environments (Dev to QA to Prod)
- Experienced in analyzing and resolving defects identified during SIT, ensuring timely fixes and smooth progression to subsequent testing phases.
- Experienced in executing and monitoring jobs in higher environments using IBM Work Scheduler.
Associate
Cognizant
Noida, India
08.2021 - 12.2024
- Created Informatica Mappings to build business rules to load data using Transformations.
- Targets generated as reports for data audits, log files, and CSV outputs to support compliance and operational insights.
- Worked on Service Now to plan the production changes as per the change Management process.
- Scheduled and Monitored all batch jobs using Control-m scheduler.
- Identified root cause and provided a solution to the business on issue pertaining to the Application.
- Supported ELS (Enterprise Level Support) activities post-production deployment to ensure stability and resolve any postrelease issues.
Education
Bachelor's Degree - Information Technology
Kalinga Institute of Industrial Technology
Odissa, India06-2021
Skills
- Informatica PowerCenter 1053
- IICS
- Oracle SQL
- Unix Shell
- Putty
- WinSCP
- IBM Work Scheduler
- Control-M
Certification
- Infosys Certified Informatica PowerCenter Developer
- Infosys Certified MySQL Associate
- Microsoft Fabric
Timeline
Senior Associate Consultant
Infosys
01.2025 - Current
Associate
Cognizant
08.2021 - 12.2024
Bachelor's Degree - Information Technology
Kalinga Institute of Industrial Technology