ETL validation tool Resume

SUMMARY

Having around 3.6 years of IT experience as an Informatica, PL/SQL developer and Python. Summed up wif excellent Technical, Analytical and Project Execution skills.
Expertise knowledge and hands on experience wif Informatica Power Center 9.5.1.
Expert in Extraction, Transforming and Loading (ETL) data flows using Informatica; creating mappings/workflows to extract data from Oracle, SqlServer and Flat File sources and load into various Business Entities.
Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations.
Expertise in creating database objects, Optimizing and Performance Tuning of existing PL/SQL objects by using Oracle Hints, Explain Plan, by creating Index and Partition table.
Experienced in BI Reporting tools such as Business Objects Crystal.
Knowledge of big data techniques such as Hadoop file system, Map Reduce and Hive query language.
Exposure of coordinating wif client and internal team for successfully achieving teh requirements of teh project wif quality and time management.
Well familiar wif in RDBMS concepts and constructs along wif Database Objectscreation such as tables, views, complex procedures, functions, triggers, packages and indexes.
Involved in teh design of Data warehouse using Star - Schema methodology and convert data from various sources to oracle tables.
Adroit in end-to-end implementation of Mappings, Transformations, Workflows, worklets, parameter files, sessions, lookup etc. in Informatica.
Extremely motivated, able to work smoothly even under pressure, meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies.

TECHNICAL SUMMARY:

Operating Systems: Windows, UNIX

ETL Tools: Informatica Power Center 9.1/8.x

Hadoop Ecosystem: HDFS, HIVE, Map Reduce, SCOOP

Languages: SQL, PL/SQL, Transact- SQL, UNIX Shell Scripting, Python, JAVA

RDBMS: Oracle 10g/11g, SQL Server (2005/2008)

Database Tools: SQL Developer, SQL Plus

BI Tools: Jasper Report, Business Objects Crystal Report XI

Ticketing Tools: JIRA

Other Tools: Putty, WinScp

PROFESSIONAL EXPERIENCE

Confidential

ETL validation tool

Technology and Tools: Python, XML, pycharm, ETL Tool Informatica Power Center, HTML, HDFS, HIVEMap Reduce, SCOOP

Responsibilities:

workflow files exported from repository Manager
As a Team Member, TEMPhas been involved in teh following:
Developed python script which read XML file as an input and validate teh naming conventions of workflow, session, mapping, transformation as provided in teh Lookup file.
Script reports all teh error in teh log file through teh Python script.
Involved in creating teh front-end for ETL validation tool by Django framework.
Fetch data from RDBMS to Hadoop Ecosystem through Scoop.
Understanding of Partition and bucketing concept in Hive and designed both managed and external tables in hive to optimize teh performance.
Developed HIVE query for analyzing.

Confidential

Senior Analyst

Responsibilities:

Developed Informatica mappings and mapplets by using various transformations like Lookup, Joiner, Expression, Aggregator, Update Strategy, etc.
Involved in creating database objects for Transaction database.
Used Explain Plan and TKProf utility to find teh bottleneck query for optimization.
Involved in creating ETL validation script in Python.
Performed unit testing and documented teh unit test plan and its results.

Confidential

Software Developer

Technology and Tools: ETL Tool Informatica Power Center (8.x, 9.x), Oracle (SQL, PL/SQL), SQL ServerTransact- SQL, UNIX Shell Scripting, SQL Developer, Crystal Report, Putty

Responsibility

Used Informatica Power center for (ETL) extraction transformation and loading data from heterogeneous source systems.
Involved in writing UNIX Shell scripting to meet business requirements.
Overseeing teh migration of teh database from staging area to Data warehouse usingETL tool (Informatica).
Involved in creating mapping, mapplets, lookups, session, workflow etc. using Informatica to implement teh business requirements.
CreatedPL/SQL scriptsto extract and load teh data from teh database usingUTL FILE package.
Responsible for creating, modification and unit testing of database objects i.e. packages, procedure, triggers, functions, sequences and others database objects in PL/SQL and Transact SQL.
Used Explain Plan, Oracle hints and creation of indexes to improve teh performance of SQL statements.
Worked on advance PL/SQL concept such as Collections, Ref Cursors and Dynamic SQL.
Worked onSQL Loaderto load data from flat files and also involved in taking monthly backup through Import/Export utility.
Responsible for conducting manual testing and designing test cases for database objects.
Involved in teh development of business intelligent report in Crystal and Jasper report.
Responsible for resolving teh defects which are raised in SIT and UAT environment using bug

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship