Kaleeswari P.

Expert in Informatica power center developer with different database like Oracle,Teradata,Netezza

New Delhi , India

Experience: 8 Years

Kaleeswari

New Delhi , India

Expert in Informatica power center developer with different database like Oracle,Teradata,Netezza

15428.5 USD / Year

Immediate: Available

8 Years

Now you can Instantly Chat with Kaleeswari!

Chat Now

About Me

Informatica power center,Oracle teradata,netezza,Unix -8 years of experience

Informatica BDM-less than Year.

...

Skills

Development Tools

Informatica - 7 Years

Expert

Others

Software Engineering

Oracle 11g - 7 Years

Advanced

Database

Hive - 1 Years

Beginner

Positions

Project Manager (Team Lead)

Portfolio Projects

Blue shield of California

Company

Blue shield of California

Role

Frontend Developer

Description

Over 5 years of experience of leading multiple ETL projects of team members between 5 members.
Requirement gathering, data modelling and designing (Technical Design) reports and ETL interfaces as well as leading the team in coding, testing in both ETL and reporting phase.
Extensive involvement on Infrastructure monitoring, configuration, maintenance, load optimization and load balance.
Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
Designing and developing automation tools to generate a report to which is accurate data for various analysis which helps to optimize the process.
Experience with setting up access roles and privileges, code page setups, appropriate ETL migration activities and scheduling jobs using TIDAL or Auto-sys.
Developed mappings, sessions, worklet and workflows in Informatica as per STTM.
Developed Technical Design document.
Unit Test Case Document and performed unit testing.
Used Netezza and Oracle database for back end and provided extensive training for the peers on Netezza.
Prepared SQL query as part of development
Used UNIX to navigate around the system and check for specific files, the file’s contents, change permissions and see who the current users are.
Seeking clarification from the clients regarding STTM requirements in the daily status call.
Addressing and clearing the QA clarifications raised as part of development
Performed data loading activities manually as well as through Tidal.
Played a tester role in Member book of Records Project which needed writing test cases, sql queries.
Used Application Lifecycle Management tool for uploading test cases
Used JIRA for creating defects and seeking clarification from developers.
Managed Version control in different environments using SVN.

Show More Show Less

Skills

Informatica Oracle 11g Netezza Teradata

Tools

JIRA

Telstra

Company

Telstra

Description

Over 4 months of experience of leading ETL projects of team members 7.
Requirement gathering, data modelling and designing (Technical Design) reports and ETL interfaces as well as leading the team in coding, testing in both ETL and reporting phase.
Extensive involvement on Infrastructure monitoring, configuration, maintenance, load optimization and load balance.
Experience in Performance Tuning of Analysis, and rearchitecting the process model and node by implementing various techniques like partitioning techniques and adding required nodes, also identifying performance bottlenecks.

Show More Show Less

Skills

Data 3sixty AWS S3 Hive

Tools

JIRA

Pfizer

Company

Pfizer

Description

Requirement gathering, designing (Technical Design) reports and ETL interfaces as well as leading the team in coding, testing to till deployment.
Extensive involvement on Infrastructure monitoring, configuration, maintenance, load optimization and load balance.
Maintained compliance with quality as per the project specifications and ensured deliverables are delivered on time
Coordinated with ETL architects and process analysts for development and execution of system and integration test plans
Evaluated daily ETL development processes, design and code review procedures and mentoring team members
Coordinated with external business partners for enhancement of ETL development activities
Participated in all phases of ETL process development lifecycle
Provided extensive support for dry runs in production

Show More Show Less

Skills

Informatica Power Center Informatica BDM Oracle Hadoop Distributed File System - (HDFS) Hive

Tools

HP service manager

Blue shield of California

Company

Blue shield of California

Description

As part of Admin Communicating to Business on the Infrastructure requirement and status.
Responsible to manage Development, QA and Production environments.
Making sure that code is sync in all the environments.
Work on the Outages Handling, Patch installation and updates handling.
Handles Password Changes.
Bouncing Activities or Restarting the Services
Constantly keeping eye on whether the infrastructure is having readiness in the environment.
System level parameter checks CPU spike, Memory utilization, Number of parallel loads (sessions) running on each node.
Monitoring the loads (workflows) whether the loads are scheduled to respective timings.
Recovery or Re-start in loads in case of any failures.
Identifying the tardiness in loading process in case of any sessions are in hung status.
Monitoring Alerts, Load and Servers in regular basis