Kumar E Email and Phone Number
Brief Technical Expertise:• Over 10+ years of total IT experience in software development, designing and implementing Stand-alone software application with major focus on Data Warehousing and Database Applications.• Over 4 years of experience with ETL tool Informatica in a business area of Banking and Financial Services (BFS) and 6+ years in Healthcare.• Experience in Informatica BI Suite, Expertise in building projects and creating user applications using Informatica 8.6,9.1,9.6 and 10.1 product suites. • Experience in designing ETL process for Data Warehousing using ETL tools • Strong knowledge & understanding of SQL and ability to write SQL queries.• Proficient in analyzing, designing, and developing applications using ORACLE, DB2,Netezza, SQL Server and PostGresql. • Experience in Design, Development of Mappings using Informatica for supporting Data Extraction, Transformations, and Load Processing, in a corporate-wide-ETL solution • Involved in performance tuning of mappings and Contributed to process improvements & value additions• Versatile team player with proven Technical/Analytical/Problem Solving skills.• Have basic knowledge of the concepts of Reporting tool Business Objects(BO).• Solid experience in using the Remedy tool for creating Incidents, Problem tickets, and Change Requests.• Sound knowledge of ITIL framework - Incident Management, Change Management, and problem management.• Experience in scheduling the jobs in Control-M, Oracle Job Scheduler, and Unix using Crontab.• Experiencing using AWS S3 to upload file from On-Premises to AWS cloud using CLI commands.• Exposure to deploy the code using CICD pipeline (Jenkins, Github, JFrog and Consul)Technologies Used:Primary Skills:- Informatica Powercenter, and PowerExchangeDatabases :- Oracle, DB2, Netezza, SQL Server and PostgresqlReporting Tools : Business Objects (BO)Scripts :- Unix, Powershell ScriptScheduling Tools :- Control-M, Oracle Job Schedule and Crontab(Unix)Cloud Services: AWS S3 & its CLI CommandsCertified in AWS Solution Architect - Associate.
Virtusa
View- Website:
- virtusa.com
- Employees:
- 12588
-
Associate Bi Architect/Engineering ManagerVirtusa Jan 2024 - PresentChennai, Tamil Nadu, India
-
Lead Etl ConsultantVirtusa Jan 2020 - Dec 2023Chennai
-
System EngineerAstrazeneca May 2016 - Jan 2020ChennaiResponsibilities:• Providing the Technical ideas to the teams to enhance the performance and make the data availability Optimize to the business.• Build a working knowledge of the systems and business area to provide a high level of support.• Coordinate with front end and downstream teams on ease of data flow from source to business users• Create, develop, and track solutions to application errors reported.• Done over project documents and user manual for support team for clear understanding.• Taken care of Production issue and fixed it in a timely manner.• Supported priority Incidents, and request raised by business and fixed it before SLA.• Interacting with the clients on a regular basis to discuss day-to-day issues and matters.• Developing UNIX shell scripts for automating and enhancing/streamlining existing manual Scripts.• Automated and configured the jobs to run in Unix environment using crontab.• Have involved in migration of ETL components and testing of it from 8.6 to 9.6.• ETL Design and development of Mappings, Sessions, Worklets , Workflows.• Migrated Informatica objects from Development Environment to Testing Environment and then to Production Environment.• Supported upgrade activities from 8.6 to 9.6 and taken a sole ownership of End to End Testing ETL jobs.• Sound knowledge of ITIL framework - Incident Management, Change Management and problem management. -
AssociateCognizant Apr 2015 - May 2016ChennaiResponsibilities:• Gathered a requirement from onsite coordinator and complete the tasks assigned during the initial phase of project.• Worked with source team on the details of the files needed as part of the requirement, and report source data issues while testing and post production implementation on timely manner.• Designed the Functional Design Specification document, test cases, test data characteristics and scenarios.• Developed reusable mappings, sessions to generate the various reports.• ETL Design and development of Mappings, Sessions, Worklets , Workflows• Migrated Informatica objects from Development Environment to Testing Environment and then to Production Environment.• Involved in various phases like Analysis, Design, Development, Testing till Implementation.• Generate the reports which helps business to reduce the efforts and cost.• Communicate with business to clarify the requirements and deliver the reports as they expected.• Built reusable mappings which helps to meet the timelines and deliver the project on time.• Post implementation Monitored the production load and supported to fix the Production issues effectively.• Scheduled the jobs based on the pre-requisite’s condition using Control-M Scheduling tool.• Performed monthly/yearly activities on timely basis and Send reports to business. -
Programming AnalystCognizant Aug 2012 - May 2015IndiaDeveloping Applications With Informatica PowerCenter, Unix, DB2 and Netezza, and BMC Control-M
-
Programmer Analyst TraineeCognizant Apr 2012 - Jul 2012IndiaTrained in Abinitio, SQL, Business Objects (BO).
Kumar E Education Details
Frequently Asked Questions about Kumar E
What company does Kumar E work for?
Kumar E works for Virtusa
What is Kumar E's role at the current company?
Kumar E's current role is ETL Consultant - DW & BI | Informatica Powercenter | AWS Solution Architect Associate Certified.
What schools did Kumar E attend?
Kumar E attended Anna University Chennai.
Who are Kumar E's colleagues?
Kumar E's colleagues are Sawood Shariff, Purna Deepika K, Garima Gupta, Shubham Tiwari, Swati Karkare, Santhosh Kumar Boopathiraj, Garima Singh.
Not the Kumar E you were looking for?
-
-
-
Shree Rajha Kumar E.
Senior It Executive | Strategy Execution | Delivery Leadership | Product Management | It Governance | Cybersecurity | Ex-Dtcc | Ex-TcsChennai
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial