Shravan, ETL | Bench Resource on Contract

Shravan (RID : 6v6vluu47p8w)

ETL

Location : HYDERABAD, India

Experience : 4.4 Year

Rate: $13 / Hourly

Availability : Immediate

Work From : Offsite

Category : Information Technology & Services

Shortlisted : 0

Total Views : 9

Key Skills

ETL INFORMATICA SQL JIRA SSMS ORACLE 11G

Discription

Shravan

Professional summary:

Having 4.4 years of experience in implementing Data Warehousing and Data Integration applications using ETLtools - Informatica cloud (IICS CDI) andInformatica Power Center 10.x.
Extensively worked on IICS CDI components like Mappings, Mapping Configuration Tasks, Task flows, Data transfer Task, Synchronization Task, Replication Task,PowerCenter Tasks, File Listener Tasks
Experience in Creating complex mappings using Aggregator, Expression, Joiner, Filter, sorter, Union, Sequence Generator, Connected & Unconnected Lookup, Router, Union, Hierarchy Builder, Hierarchy Parser, Source and Target transformations using IICS mapping canvas.
Having good knowledge on Implementing Slowly Changing Dimensions Type-1 and Type-2
Experience in Creating Input Parameters / In-out Parameters from Parameter panel in Data Integration. Created and used Parameter files in different MCTs.
Good experience on Informatica PowerCenter 9.x/10.x components like Mapping Designer, Workflow Manager and Workflow Monitor & Repository Manager.
Experienced in integration of various relational and non-relational sources such as Oracle, SQL Server, XML files, Fixed -Width and Flat Files.
Main areas of expertise are analyzing, documenting, developing, testing, code deployments, Job monitoring of the data warehousing and data Integration projects.
Involved in Performance tuning at SQL Queries, source, target, mappings, sessions, and system levels.
Experience in identifying Bottle necks in the Informatica mappings and tuned the same using Informatica Performance Tuning Technique’s.
Monitored sessions using the workflow monitor, which were scheduled, running, completed, or failed. Debugged mappings for failed sessions.
Experience in extracting the data by using Incremental Loading.
Hands on Experience on Dynamic Target File Generation.
Performed Unit testing and has created test scripts for the interfaces developed.
Good Knowledge on Data warehousing techniques using different Data Warehouse Schemas, Slowly Changing Dimensions and Fact tables etc.
Worked on UNIX Commands.
Experience in creating the parameter files to parameterize Source connections, target Connections, Filename, session log names, mapping parameters and variables etc.
Migratedrepository objectsfrom development environment to QAand toproduction environment.
Monitored sessions using the workflow monitor, which were scheduled, running, completed, or failed. Debugged mappings for failed sessions.

SQL:

Has extensive experience in creating table with IntegrityConstraints as per the database design.
Has an extensive experience in writing ComplexSQLQueries, Joins and SubQueries.
Has experience in creatingviews and Indexes.
Hands on experience in Using Analyticalfunctions like Rank, DenseRank, RowNumber.

UNIX:

Has experience in writing basic shell scripts and calling the shell scripts. Worked on Unix Commands.

Qualifications

Bachelor of Technology from Andhra University - 2011

Professional Experience

Working as Software Engineer at Confidential from Jun 2023 to till date.
Worked as Senior Software Engineer at Confidential from Dec 2019 to May 2023.

Technical Skill Set: