Candidate’s Name:Pramod Kumar Date: 04-NOV- 21

 REQ ID: DTJP00026095 Position: Senior Analyst, Data Engineering - India

Interviewer Name:

Please use this form as a guide to evaluate the applicant’s qualifications for employment. Check the
appropriate numeric value corresponding to the applicant’s level of qualification and provide
appropriate comments in the space below.

Rating Scale: 5. Outstanding 2. Below Average - Does not meet

requirements
4. Excellent - Exceeds
requirements 1. Unable to determine

3. Competent - Acceptable NA - Not applicable to this candidate

proficiency

Requirements Rating

5 4 3 2 1

Communication Skills: Overall assessment of 4

candidate’s communication skills.

Comments: candidate has good at personal skills

Candidate’s Understanding of the Position: 4

Assess candidate’s knowledge of the position and its

requirements.

Comments: very good understanding on the position and roles responsibilities

Relevant Functional/Special Skill Set: Explore the

candidate’s knowledge and past working experiences in
the required technical skills.

4.5
Skill Set (Name) 1: Informatica
 4.5
Skill Set (Name) 2 SQL

Skill Set (Name) 3:

Skill Set (Name) 4:

Skill Set (Name) 5.

Comments:

Technical Evaluation Tool Name Used (If applicable):

Tool Evaluation Score: 3.5

Organizational Fit: 4

Review the candidates’ potential to fit DELLEMC’s

organization and culture.

Comments:, Candidate is very professional and has good experience working in Good Cultured
Companies

Overall Evaluation: 4

Please add appropriate comments:

Recommendation: (Please summarize your perceptions of the candidate’s strengths and any
concerns that should be considered:

• . Having around 4.3yrs. of Experience in Data warehousing using ETL tool as -

Informatica Developer.
• Extensively used ETL methodology for supporting Data Extraction, Transformation
and Load processing, in a corporate-wide-ETL Solution using Informatica.
• Experience in working with large scale Data Warehouse Development projects using
 Teradata & Oracle relational database technology.
• Experience in Teradata Performance Tuning and join indexes and collect statistics.
• Experience in design and development of Informatica mapping & workflows.
• Extensively worked on Informatica Designer Components Source Analyzer, Target
Designer, Mapping Designer, Transformation Developer, Workflow Manager.
• Used various transformations like Source qualifier, Aggregator, lookup, Filter,
Sequence generator, Router, Update Strategy, Expression, Sorter etc.
• Experience in Performance Tuning the mappings.


Good to go

Pramodh Kumar

Mob: 9849208949

Email: Pramodhinfo@[Link]
Objective:
To be associate with a progressive organization that give me the scope to apply my skills and
knowledge and involve myself as a part of a team that dynamically works towards the growth of
an organization.
Professional Summary:
• Having around 4.3yrs. of Experience in Data warehousing using ETL tool as -Informatica
Developer.
• Extensively used ETL methodology for supporting Data Extraction, Transformation and
Load processing, in a corporate-wide-ETL Solution using Informatica.
• Experience in working with large scale Data Warehouse Development projects using
Teradata & Oracle relational database technology.
• Experience in Teradata Performance Tuning and join indexes and collect statistics.
• Experience in design and development of Informatica mapping & workflows.
• Extensively worked on Informatica Designer Components Source Analyzer, Target
Designer, Mapping Designer, Transformation Developer, Workflow Manager.
• Used various transformations like Source qualifier, Aggregator, lookup, Filter, Sequence
generator, Router, Update Strategy, Expression, Sorter etc.
• Experience in Performance Tuning the mappings.
• Good knowledge in SQL
• Good work experience in designing Data Warehousing applications, implementations and
enhancements of the business applications using Informatica Power Center 9.6.
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Involved in knowledge sharing and knowledge transfer to the new members of the project
& Preparation of knowledge transfer documents.
• Deploy the Data Stage code to SIT and will compile the Jobs.
• Experience in Data Stage Tool to load the JSON data into the tables.
• Executing the Data Stage Jobs and taking the test results and will update in Jira board.
• Create a Data Stage Package for integration for QA environment and will attach the DS
file in the Jira.

Professional Experience:
• Worked with Fintellix Solutions Bangalore from July 2017 to Sep 2019.
• Working with Legato Health Care Technologies LLP Bangalore from Sep 2019 to till date.
Educational Qualifications:

 Bachelor of Technology in (CSE) 2016 from JNTU Anantapur, Andhra Pradesh.

Skills Summary:

ETL Tool : Informatica Power center 9.6

Databases : Oracle 11g, SQL Server
Tools and Utilities : SQL Developer, AWS, Putty, Jira, Wiki.
Operating system : Windows 2000/XP/07, UNIX

Project #1

Project Title : Rehab

Client : Aim Specialty
Role : Informatica Developer
Environment : Oracle, UNIX, Win SCP, Jira, Wiki

Description:

The AIM Rehabilitative Program uses evidence-based clinical practice guidelines in the
rehabilitative services industry to maximize a member’s functional outcomes, coordinate
integrative health care decisions, improve the member’s total cost of care, and optimize provider
satisfaction.
Our program provides a clinical appropriateness review process that encompasses the
appropriate duration of rehabilitative services at the appropriate place of service, with the goal of
maximizing the member’s functional improvement, while at the same time enhancing and
simplifying the provider’s experience in the delivery of care.

Responsibilities:

 Collecting the requirements from the business analyst and the product owner.
 Analyze the data based on the requirements to implement the business logic.
 Creating the cases from the Appian UI based on the Scenario’s and data will populate to
the source table.
 Verify the Schema and the payload file from the Source.
 Execute the DDL and DML Scripts in the database.
 Execute the Data Stage job to populate the data in to target tables.
 Implementing the CDC approach in the Base tables to maintain the history data.
 Validating the data from the Source JSON file and the target tables.
  Create the Test Scenarios and will update the test results in the Jira.

Project #2

Project Title : AWS

Client : Argus
Role : Informatica Developer
Environment : Informatica 9.6, SQL , UNIX, Winscp

Description:
Amazon Redshift is a fast, scalable data warehouse that makes it simple and cost-effective to
analyze all your data across your data warehouse and data lake. Redshift delivers ten times faster
performance than other data warehouses by using machine learning, Sql Server query execution.
Migrating the code from Sql Server to Redshift and process the US data for different case study.

Responsibilities:
• Extensively used Informatica Client Tools – Source Analyzer, Target Designer,
Transformation Developer, Mapping Designer, and Mapplets Designer to develop
mappings.
• Used designer debugger to test the data flow and fix the mappings.
• Performed Data Extractions, Data Transformations, Data Loading, Data Conversions and
Data Analysis.
• Working on different transformations like Source Qualifier, Lookup, Joiner, Aggregator,
Expression, Filter, Router, Sequence Generator, Update Strategy etc.
• Involved in creating Sessions & Workflows.
• Developed workflows and tasks using Informatica Power Center Work flow Manager.
• Involved in creating the unit test cases and taking the recon document.
• Prepared the process documents and handed over to production support team to monitor
the production runs.

Project #3

Project Title : DATAMART

Client : PayPal
Role : Informatica Developer
Environment : Informatica 9.6, SQL Developer, UNIX

Description:
DATA MART is a data warehouse used to consolidate data of PayPal customers
including customer account, verification, and restriction details. It is developed for
generating reports according to client requirements. This is to minimize the effort of
report developers and generate the reports in less time span as per the client’s
requirement. This includes a user interface which provides self-service portal using which
clients can get the data in report as per their requirement without manual intervention.

Responsibilities:

Has involved full phase development to load data through ETL informatica with different
sources
Developed stage table using informatica ETL to generate all fields into one table.
Developed full relational data model to load data into table using SCD Type 1 Model.
Developed SCD Type 2 model, to generate 1 digit for downstream, to further generate 20-
digit account number for each 19-digit corresponding account number.
Developed mapping to convert the IST date time fields to PST time with day light saving
using reusable transformation.
Developed mapping to load KYC/KYB documents into object table with encrypted format
using java transformation.
Provide an instruction to scheduler team to schedule all module through UC4.
Regular attend the resolve the issues such as application outage, production issues.
Interaction and coordination with various application teams for resolving issues.
 Strong skills in coding and debugging Teradata utilities for ETL processing huge
volumes of data throughput.
 Involved in Unit Testing.
 Prepared the process documents and handed over to production support team to monitor
the production runs.
 Prepared the project overview document and submitted to the Client.