RAJA RAJESWARI P

Phone: +1-317-***-****

Email: advjly@r.postjobfree.com

Experience Summary

More than 4 years’ experience in the Information Technology industry

Working as ETL developer and having good knowledge on ETL tools like Informatica Powercenter and repoting tools like Power BI

Experience in Agile Development and worked on production support

Good knowledge of Data Warehousing

Worked on scripts in MS SQL server and Oracle

Strong analytical and problem-solving skills

Experience with organization

Visa Details

UK Workpermit Visa – Validity till 2nd June 2019

USA L2 Visa – Validity till 24th June 2023

Skills

OPERATING SYSTEMS: MS Windows

LANG/ TECH: SQL, PL/SQL

DATABASES: Oracle 19/ 12, MS SQL server

DW Supporting tools: Microsoft Power BI, Informatica Powercenter, Control-M

SDLC Models – Agile Methodology

Experience in detail

Network Rail

ETL Factory – Track DST

Nov 2020 – Till date

Role – ETL Developer & Data Engineer

Network Rail is the "not for dividend" owner and operator of Britain's railway infrastructure, which includes the tracks, signals, tunnels, bridges, viaducts, level crossings and stations -- the largest of which we also manage. We aim to provide a safe, reliable and efficient rail infrastructure for freight and passenger trains to use.

Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager

Involved in Root cause analysis in source systems, creating new table structures and modifying existing tables

Worked on Informatica variables and parameters

Designed and developed complex mappings by using Lookup, Normalizer, Joiner, Expression, Update Strategy, Sequence generator, Aggregator, Filter, Router, SQL transformation, Sorter, etc. transformations to implement complex logics while coding a mapping

Developed staging (Truncate & Load method), Foundation (Type2), Business Model (Type2) and Reporting Model (Type1) mappings

Implemented relational Error Logging in Informatica

Implemented record versioning for AUDIT tables and designed the logic within Expression Transformation in Informatica mapping level

As part of SQL remediation, oracle analytical queries converted into Informatica mappings

Prepared release notes documents for code migration

Tools: Microsoft Power BI, Informatica PowerCenter 10.1, SQL Server 2016, Oracle PL/SQL, Control-m, Agile Jira

Network Rail

ETL Factory – Track DST

Sep 2018 – Oct 2021

Role – ETL Developer

Developing mappings in Informatica to extract Oracle data to SQL Server

Understanding of existing Data Warehousing system and various layers

Create the plan for Deployment for testing and production

Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager

Designed and developed complex mappings by using Lookup, Normalizer, Joiner, Expression, Update Strategy, Sequence generator, Aggregator, Filter, Router, SQL transformation, Sorter, etc. transformations to implement complex logics while coding a mapping

Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager

Involved in debugging and identifying the issues in Informatica mapping

Involved in unit testing

Worked on Power BI reports to understand the production issues

Created multiple reports in Power BI

Developed Power BI dashboards and reports

Tools: Informatica PowerCenter 9.6.1, Power BI, SQL Server 2012, Agile Jira,

Education

MCA, Manipal University, 2012

Contact this candidate