3 Years Experienced Informatica ETL Developer
Resume:
RAMKUMAR K S
#**/*, **** ****, ** Layout, Near Kadirenahalli circle, Bangalore – 560070 +91-720******* ********.*****@*****.***
Having 3 years of experience in development of extraction transformation loading methodology for supporting
Data transformations and processing in corporate wide ETL Solutions using ETL tool Informatica power center.
3 years total experience in ETL development using Informatica Power Center 9, Oracle.
Have a good work experience in processing relational database, flat file formats.
Experience in handling CSV files with multiple delimiters
Experienced in understanding the requirements, S-T mappings and preparing Technical design Documents.
Have good knowledge on overall architecture of HRMS payroll
Have good experience on configuration management tool - SVN
Well-known knowledge on different schemas of data warehouse.
Having involved in doing POCs using Informatica MDM for new requirements
Good work experience Agile methodology
Comprehensive knowledge in SQL.
Have good knowledge on data modeling
Involved in Peer reviews, proactively initiated brain storming sessions to produce the best solutions.
Quick learner and Excellent Team player, ability to meet tight deadlines and work under pressure.
Bachelor of Engineering - Computer Science & Engineering from PT LEE CN college of
Engineering and technology, Kanchipuram, Tamil Nadu.
Diploma - Computer Science & Engineering from Sri Krishna Polytechnic College, Arakkonam,
Directorate of Technical Education, Chennai, Tamil Nadu.
Company : MIMsys technologies Pvt, Ltd, Bangalore.
Duration : May 2015 –till date
Designation : Junior Software Engineer
Role : ETL Developer
ETL tool : Informatica Powercenter 9
Database : Oracle 11g
Configuration management tool : SVN
Defect tracking tool : JIRA
Project 1: HRMS– Agent Sync
Company : MIMSYS technologies Pvt, Ltd, Bangalore.
Environment : Informatica Power Center 9
Database : Oracle 11g
Role : ETL Developer
Team Size : 03
Place : Bangalore
Duration : May 2015 to till date
Description:
MIMSYS HRMS is a flexible, reliable, easy-to-use and yet comprehensive application which goes beyond the core payroll activity of administrating employees’ salaries in the organization. MIMSYS HR and Payroll transforms administrative tasks to enable a more streamlined workflow. In this module, we receive unprocessed flat files that would be further transformed with respect to agent sync and also created headers such as agent_name, agent_code, agent_city, agent_country, candidate_name etc. The processed data would be loaded into Oracle 11g
Responsibilities:
Analyzing functional and requirements specifications.
Understanding the data model for Agent sync
Creating ETL jobs for Agent sync
Cleansing the data according to target tables
Applying the transformations such as Expression, Sequence generator, Aggregator, Router
Loading the data targets such as agent-base and agent-hist
Using debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
Monitoring Workflows and Sessions using Workflow Monitor.
Checking in and out the ETL scripts using SVN
Reporting the daily status to manager and clients.
Maintaining status reports and creating MOMs.
Communicating with business customers to discuss the issues and requirements.
Giving KT to new joiners.
Project 2: HRMS– Referral Sync
Company : MIMSYS technologies Pvt, Ltd, Bangalore.
Environment : Informatica Power Center 9
Database : Oracle 11g
Role : ETL Developer
Team Size : 03
Place : Bangalore
Duration : Jan 2017 to till date
Description:
MIMSYS HRMS is the complete HR cycle from Position definition to Position budget control along with requirement management including application data bank. The system also offers recruitment management cycle, employee training etc. In this module, we receive unprocessed flat files that would be further transformed with respect to referral sync and also created headers such as referrer_name, referee_id, referee_name, referee_email, referee_phone etc. The processed data would be loaded into Oracle 11g
Responsibilities:
Analyzing functional and requirements specifications.
Understanding the data model for Referral sync
Creating ETL jobs for Referral sync
Cleansing the data according to target tables
Applying the transformations such as Expression, Sequence generator, Normalizes Transformation, Router Transformation
Loading the data targets such as referral-base and referral-hist
Using debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
Monitoring Workflows and Sessions using Workflow Monitor.
Checking in and out the ETL scripts using SVN
Reporting the daily status to manager and clients.
Maintaining status reports and creating MOMs.
Communicating with business customers to discuss the issues and requirements.
Giving KT to new joiners.
Project 3: HRMS– Direct Sync
Company : MIMSYS technologies Pvt, Ltd, Bangalore.
Environment : Informatica Power Center 9
Database : Oracle 11g
Role : ETL Developer
Team Size : 03
Place : Bangalore
Duration : May 2015 to till date
Description:
MIMSYS HRMS is the complete HR cycle from Position definition to Position budget control along with requirement management including application data bank. The system also offers recruitment management cycle, employee training etc. In this module, we receive unprocessed flat files that would be further transformed with respect to direct sync and also created headers such as candidate_name, candidate_id, candidate_city, candidate_email, candidate_phone, profile_header etc. The processed data would be loaded into Oracle 11g
Responsibilities:
Analyzing functional and requirements specifications.
Understanding the data model for direct sync
Creating ETL jobs for Referral sync
Cleansing the data according to target tables
Applying the transformations such as Expression, Sequence generator, Router
Transformation
Loading the data targets such as direct-base and direct-hist
Using debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
Monitoring Workflows and Sessions using Workflow Monitor.
Checking in and out the ETL scripts using SVN
Reporting the daily status to manager and clients.
Maintaining status reports and creating MOMs.
Communicating with business customers to discuss the issues and requirements.
Giving KT to new joiners.
Father’s Name : Sivanath K R
Nationality : Indian
Date of Birth : July 30, 1990
Gender : Male
Residential Address : 16/1, 3rd floor, 9th Main Road, RK Layout, Near Kadirenahalli circle,
BSK 2nd stage, Bangalore – 560070, Karnataka, India
Contact this candidate