SUMMARY:

• Around 8 years of extensive experience in Information Technology with special emphasis on design and development of ETL Process, building Data Warehouse/EDW, performance on Data Integration Services, Database Testing.
• Expertise in SQL, PL/SQL,Triggers, Index Design and Tuning.
• Experience with on Informatica Power Center 9.x/10.2.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflakes Schema Modeling, Fact and Dimension tables, Pivot Tables.
• Good experience and knowledge on SQL Queries for manipulation of data.
• Expertise in Data Cleansing at staging level with utilization Informatica Power Center.
• Expertise in Performance Tuning, Indexing and Partitioning techniques on sources, targets, mappings and workflows .
• Expertise in defect tracking process, familiar with defect reporting and tracking using defect tracking tool like HP Quality Center 10.
• Experience in developing Shell Scripts on UNIX and experience with UNIX command line.
• Experience in Scrum framework and its implementation in fast-paced Agile Development environment.
• Good experience in manual testing (Test case design, test data preparation, Test case writing).
• Having Confidential domain experience
• Excellent communication, interpersonal skills, quick Learner, versatile, adaptable, team player and detail-oriented with professional work ethic.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter (10.2/9.6.1/9.1/8.6 ).

Database: Teradata14.0,Oracle 12c/11g/10g/9i/7i, MS SQL Server (2012,2014,2016).

BI/Reporting Tools: Tableau,Crystal Reports.

Languages: SQL, PL/SQL, UNIX Shell Scripts.

Operating Systems: UNIX/LINUX, Windows, MS Windows Server, MS DOS

Other Applications: Toad, SQL Developer, Control M, Autosys.

Server: MS SQL Server, LINUX Server

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

• Requirement gathering and analysis for new components and change in existing components.
• Attending daily weekly and bi-weekly status meeting on development with project lead, project manager and Client.
• Daily status reporting over daily calls and by mails to project lead and weekly calls and status reports to mangers and client.
• Estimation analysis of code design development and deliverables.
• ETL development to complete the code and load the data into data ware house using informatica power center 10.1 version.
• Code review of all the ETLs, Unit test case documents, Design, IQA, EQA documents, completed by team with proper review check list.
• Production implementations activities before code is migrating to PRODUCTION environment with all scheduling, deliverables components and documents.
• Support for testing and deployment in QA and production environments.
• Resolving issues relating to technical and functional components and escalating matters requiring immediate attention to the immediate supervisors.
• Defect prevention and casual analysis activities.
• System and business knowledge build.
• Development and enrichment of compliance documentation for existing and new application components.
• Knowledge transfer of existing application to team members.
• Performance tuning of long running queries of existing applications.

Hardware: Intel Pentium based PC

Operating System: Windows 7, UNIX

Languages: Teradata SQL, UNIX shell scripting

Special software: Informatica Power center 9.6,10.2 for ETL development, Taradata studio for SQL on Teradata 14.0, Toad for Oracle SQL, Putty, WinScp for UNIX, Oracle 11g, Mainframe, ARA uDeploy,EDW LIVE,Servicenow, MS Office.

Confidential, NYC, NY

ETL Informatica Developer

Responsibilities:

• Worked in Informatica 9.6/10.1 to perform ETL from various sources to the central data warehouse.
• Involved in gathering the requirements, Design and Development.
• Created high-level, low-level design documents, ETL specification documents, data model document and test document.
• Worked with connected and unconnected look-up and configured the same for implementing complex logic.
• To implement business rules created robust mapping, mapplets and reusable transformation using Informatica Power Center and its different transformation including Joiner, Look-up, Rank, Filter, Router, Expression, Aggregators, Sequence Generator, Sorter, Update Strategy.
• Extensively used ETL to load data from Flat files.
• Unit testing ETL code to ensure it can be delivered and run in a system testing environment.
• Object migration to different environments and managing the releases.
• Extensively used Reusable transformations and Mapplets are built wherever redundancy is needed.
• Help with the analysis of issues raised during QA/UAT/PROD phases and Data Reconciliation.
• Developed Unit test cases and involved in unit test to check for consistency.
• Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion.
• Created Stored Procedures to transform the Data and worked extensively on PL/SQL for various needs of the transformations while loading the data.
• Extensively used dynamic parameters and created workflows, worklets.
• Coordination with project team in various levels of development and testing
• Ensure the ETL code delivered is running, conforms to specifications and design guidelines.
• Good working experience in Tableau Dashboard and extensive uses of Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc.
• Build number of UNIX Shell scripts for PL/SQL programs to schedule them on Control M.

Environment: Informatica Power Center 9.x,Oracle, SQL server, XML files, Tableau, UNIX, SQL/PLSQ.

Confidential

ETL Informatica Developer

Responsibilities:

• Developed Data Flow diagrams to create Mappings and Test plans from OLTP systems staging to Data warehouse.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Teradata, Oracle, SQL Server, Flat files and loaded into target.
• Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping.
• Enhanced Performance on Informatica sessions using large data files by using partitions.
• Working on ETL coding using Informatica tool to extract, transform, cleanse and load data.
• Developing Power Center mappings using various transformations like Aggregator, Normalizer, Union, XML etc.
• Worked on ETL coding using Informatica tool to cleanse, enrich and standardized data from various sources into staging.
• Created, Updated and maintain ETL technical documents.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Created Unix Shell Scripts to Schedule the jobs in Control M.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.

Environment: Oracle11g, informatica Power Center 9.x, UNIX, SQL, PL/SQL

Confidential

ETL Informatica Developer / Data Analyst

Responsibilities:

• Understanding Client business requirements and converting them into technical requirements and creating the requirement document for the team members
• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Extensive use of ETL process to load data from different RDBMS, XML and flat files.
• Designed the solution around the ETL Informatica Tool integrating with the client provided resources
• Participated in Test case building and execution for validating the ETL system.
• Provided implementation plan for smooth transition into the Production environment
• Used Informatica Repository Manager to create repositories and users and set permissions.
• Experience in Performance tuning of SQL queries and mainframe applications.
• Involved in Data Extraction from Oracle, Flat files, Mainframe files using Informatica.
• Debugged the mappings extensively, hard coding the test data to test the logics going instance by instance.
• Handle the migration process from Development, Test and Production Environments.
• Closed the defects following the defect lifecycle
• Provided the support for the further optimization of the ETL products
• Identify the complete dataflow for the IPDS product.
• Responsible to generate Preliminary Data Cleanse reports for each IPDS customer.
• Raising DCMO requests to update the inventory in BFG.
• Analyzing the data to fix the issues and generating reports.
• Coordinating across different components to resolve data issues to smoothly orders progress.
• Responsible for reviewing peer test cases.
• Experience in writing test cases and execute the test cases.

Environment: Oracle10g, Informatica 9.x, IDQ, UNIX, informatica Power Center 9.x.

Confidential

ETL Developer / Data Analyst

Responsibilities:

• Involved in various level of project as an ETL expert, starting from requirement specifications to deploying the tested product in Production.
• Worked on numerous Data Patches using SQL Loader and PL SQL Script to source new columns inILDR (Data Mart)
• Extracted and transformed data from Flat Files and Oracle and then loaded into Oracle using Informatica Power Center.
• Created Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, Mapplets using Informatica Designer tool, which includes Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplets Designer.
• Developed mappings for the Initial loads of the dimensions and incremental loads including Type1 and Type2.
• Involved in gathering Business Requirement and developing new interface for same.
• Heavily working on Performance Tuning for existing Informatica interfaces.
• Designed & Developed various Source system interface using Informatica Powercenter 8.6 Suite.
• Designed and developed several ETL scripts using Informatica / UNIX shell scripts.
• Dealing with the P-refs (Automatic generated unique number for each CRF request) in case of any amendment required in Customer Inventory.
• Interacting with the clients to fix the defects\issues in case of any discrepancy
• Handling the project and the team.
• Improved the performance of ETL process by indexing and caching.
• Proactively identify and interact with the system estate owner of the contract to understand the system and collect the data for analysis.
• Involve in Preparing scope and plan documents.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Generating a PDF format document which shows the clear picture about the inventory and the applied charges for the customer to sign-off.

Environment: Oracle 10g, Informatica Power Center 8.6

Confidential

Developer

Responsibilities:

• Understanding the requirements and developed ETL design document to develop mappings.
• Efficient in creating source, target databases and developing strategies for Extraction, transformation and loading (ETL) mechanism using Informatica PowerCenter Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables.
• All sorts of production support activities.
• Dockets/issue resolving within SLA timeframe.
• Billing activities on daily and monthly basis.
• Creating tables, Views, Synonyms.
• Involved in creating PL/SQL objects like Procedures, Functions and triggers.
• Knowledge transfers session to the new comers in the team.

Environment: Oracle 9i, Informatica Power center 8.6, Unix, Crystal Reports.