Deevika

Deevika

ETL Developer
India

About Me

Having 2.5+ years of experience in Data Warehousing and ETL process using Informatica PowerCenter and Informatica data quality. I have good experience in working with different databases like Oracle, SQL server.

Having …

Experience

ETL Informatica Developer

Mindtree
Sep 2021 - Present · 4 years 9 months

I have 2.5+ years of experience in IT industries with good working knowledge of Informatica powercenter 10.4Version and also having good knowledge of data warehousing concepts.
Good knowledge of different databases like Oracle,SQL server
and I was part of all the phases of software developer life cycle and I have development and enhancement project experience.Currently working in a company Mindtree as a ETL informatica developer and Iam Looking for better opportunities, also need to explore more different company culture, work environment and different client facing experience.

ETL Developer

Mindtree Bangalore
Sep 2021 - Present · 4 years 10 months

Establishing the Source and Target connections Using Informatica Power Center to extract, transform and loading of data into data warehouse from various sources.
Extracted data from Oracle database to staging layer and applied business logic to load.
Created complex mappings which involves Unconnected, Connected Lookup, Mapplets, Slowly Changing Dimensions by implementing both SCD type1 and SCD type2 transformations.
Creating Various Transformations like Expression, Aggregator, Rank, Joiner, Sequence Generator, Lookup, Filter, Update Strategy etc.
Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
Used SQL tools like SQL Developer to run SQL queries and validate the data loaded into the target tables.
Providing weekly status of the project to the Project Manager and resolving the issues based on Priority.
We Automated the Job run through Control-M
Interacting with the client and understanding the business requirements.
Conducted ETL process to Extract, Transform and Load the data into Data warehouse.
Backtracking the target table whenever the data issues come in the reports and provide the solution by monitoring performance tuning for the long running sessions and implement the required recommendations.
Working in Performance improvement Process.
Verifying the data counts on Source & Target by Comparing the data generated through ETL.
Involved in applying transformation rules to implement the business requirements.
Creating mapping for specific business requirements and data analysis for business users.
Extracting data from various sources and transformed the data based on user requirements using Informatica PowerCenter.
We Automated the Job run through Control- M

Skills

Microsoft Excel SQL Server Informatica PowerCenter ETL Oracle SQL Professional Issue Settlement Microsoft Outlook Microsoft Word Performance Tuning Informatica PowerCenter Informatica Data Quality Oracle SQL Control-M Unix Agile ETL Testing Data Warehousing Data Integration Data Analysis Data Processing SDLC SQL Developer Jira SCD Type 1 SCD Type 2 Expression Aggregator Rank Joiner Sequence Generator Lookup Filter Update Strategy Mapplets
Report this Profile?