Kaleeswari P.

Informatica Developer

New Delhi , India

Experience: 8 Years

Kaleeswari

New Delhi , India

Informatica Developer

15428.5 USD / Year

Immediate: Available

8 Years

Now you can Instantly Chat with Kaleeswari!

Chat Now

About Me

Over the past around 8 Years of IT experience in Designing & development of ETL concepts using Agile methodology. Expertise in Data Warehousing Concepts like Star Schema, Snowflake Schema, Fact Table, Dimension Table, OLAP/OLTP, Logical Data Modeling...

Skills

Positions

Business Analysts

Software Engineer

Data Engineer

Portfolio Projects

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

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

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

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