Badges
agarwalankita504 has not unlocked any badges yet.
Certifications
agarwalankita504 has not earned any certificates yet.
Work Experience
senior associate
Cognizant Technology Solutions• August 2022 - Present• bangalore,remote
Senior Associate at Cognizant, Bangalore August 2023 — Present Client: US Healthcare · Working as Senior Data engineer. · Worked with business analyst to understand the business and to design the architecture of data flow. · Requirement gathering analysis and end user meetings. · Involved in analysis, design, coding, testing and production activities. · Setup the platform and environment for development and migration. · Worked with Matillion tool to create Orchestration and transformation jobs involving snowflake. · Designed and developed pyspark jobs to extract the data from oracle database, transform and writing to Aurora database. · Involved in creating pipelines through Jenkins and bitbucket. · Worked with Airflow to orchestrate the job. · Used Agile methodology Via Jira for developing the application. · Deploy code to QA and production environment via Bitbucket and Jenkin. · Prepared workbook, Runbook, components list, migration documents. · Involved in production activities and supported the project even after the prod release. · Having Knowledge on time travel, scheduling task, zero copy cloning, Snowpipe, Stream in snowflake. Senior Associate at Cognizant, Bangalore October 2022 — July 2023 Client: UK Insurance · Worked with business analyst to understand the business and to design the architecture of data flow. · Requirement gathering analysis and end user meetings. · Involved in analysis, design, coding, testing and production activities. · Worked with Informatica client tools: Mapping /Mapplet designer, Source analyzer, Target designer, Transformation developer, Workflow manager and Workflow monitor. · Designed and developed Informatica mappings to load data from various heterogeneous sources like Oracle, xml files, Flat files, SQL server, Kalido. · Used Agile methodology Via Azure devops for developing the application. · Prepared workbook, Runbook, components list, migration documents. · Involved in production activities and supported the project even after the prod release. · Responsible for unit testing and integration testing of mappings/workflows and raising defects in tools like Service Now and Silva. · Deploy code to production environment via ClearCase. · Involved in UAT support via ESR. · Worked on the migration of data from SQL server using Snowflake and AWS S3.
technology lead
Infosys Ltd.• February 2018 - August 2022• Bangalore
Technology Analyst/Technology Lead at Infosys, Bangalore February 2018 — August 2022 Client: US Bank · Current state system analysis · Design the use case flows to convert the flow from mainframe to ETL. · Rewriting of flows in Informatica PowerCenter designer to transform and load the data to Oracle DB · Conversion of CA7 schedules to Autosys · Handling the Oracle schema changes in lower lanes and DDL preparation for deployment in UAT and PROD · Creating packages using SVN to install the jobs in Production. February 2018 — August 2022 Client: US Bank · Worked extraction of Business rules from legacy application using industry standard tool like Averi source · Participated in Mainframe Modernization CoE activities. · Developed tool to extract Mainframe SMF log data by analyzing various SMF record types (30, 110, 101, 14, 15) and their layouts. · Developed REXX scripts to extract JCL rules and report it in CSV. · Worked on POC of mainframe batch migration to Datastage tool.
application developer
IBM• April 2014 - January 2018• Bangalore
Application Developer/Associate System Engineer at IBM, Bangalore April 2014 — January 2018 Client: Singapore Bank and US insurance · Worked on Change requests as per Client requirements. · Involved in Technical Design documentation, · Coding and Unit Testing (Online & Batch components) using COBOL, DB2, VSAM, JCL, Eazytrieve, CICS, File Aid, Expeditor, Changeman, Infoman, Endeavour, JIRA, CRT, Clarity · Closely worked in SIT and UAT · Deployment and post implementation support. · Resolving user query and production Support and timely resolution of the issue to meet the SLA.
Education
Gautam Buddh Technical University, Lucknow
B.Tech• June 2009 - April 2013• Percentage: 75.6
Links
agarwalankita504 has not updated links details yet.