Informatica Developer Oracle
Resume:
NAVEENA GUNTURU
*******.***@*****.***
Summary
Over 9+ years of Data Warehousing experience with ETL tool Informatica PowerCenter 9.x/8x/7x Tools (Designer, Workflow manager, Workflow monitor, and Repository Manager), in design, development, administration, developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, scheduling Workflows and sessions.
Experience in Interacting with Business Users to gather Business Requirement Specifications (BRS) and Prepare Technical Specifications.
Worked on various active & passive transformations like Aggregator, Expression, Filter, Sorter Router, Lookup, Update Strategy, Stored Procedure, Normalizer and Sequence Generator.
Used debugger to test and fix the mappings.
Involved in extensive Performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
Extensively used Workflow Manager and Workflow Monitor for creating and monitoring workflows and sessions.
Strong Experience and knowledge in creating Stored Procedures, functions, indexes, cursors and triggers using Oracle 10g/9i.
Expertise in testing, debugging, validation and tuning of mappings, sessions and workflows in Informatica.
Strong programming skills in Sql, Pl/Sql and UNIX shell scripting.
TECHNICAL SKILLS
ETL Tools
Informatica Power Center 9.x/8.x/7.x.
Reporting Tools
BOXI R3
Databases
Oracle 11g/10g/9i/8i, DB2, MS SQL Server
Tools
Quality Center 10,Tidal,Toad,WINSCP,SVN
Environment
UNIX, LINUX, IBM-AIX, Win 2000/NT/XP
Languages
UNIX Shell Scripting, SQL, PL/SQL, C, HTML,XML
Education
Master’s in computer applications 2005 osmania university.
Bachelor’s in commerce 2002 osmania university.
Professional Experience:
Siemens Corportation Atlanta,GA Nov 2018 -till date
ETL / Informatica developer
This project involves development, support and roll out of various Data Warehouse and Data Marts, which holds critical data for top most management in Siemens Industry. The data getting loaded include sales, orders, invoices, shipments, Incentives, ticketing data, Customer information, CRM etc.
Responsibilities:
Gathering requirements for change requests
Preparation of design document and UTP documents
Create robust and quality BI solution for enterprise to support business needs.
To determine feasibility of the requirements and estimate effort.
To ensure proper and latest data availability for client.
To make sure all the daily orders and invoices get loaded into the warehouse.
Involved in Development of Mappings for new requirements for the dataflow into Data mart using Informatica
Involved in code review.
Fixing Job failures and finding root cause to avoid similar issues in future.
Involved in creating UNIX SHELL scripts to fetch data from different servers and also scheduling workflow.
Working with DBAs for performance tuning of long running jobs, handling production support effectively.
Environment: Informatica Power Center 10, Oracle, UNIX (Solaris), MS SQL Server, SQL, PL/SQL, UC4 Scheduler,Webfocus,TOAD, Shell Scripts.
Atlanticus Holdings Corporation. Atlanta, GA Feb 2013 – Oct 2018
ETL / Informatica developer
Atlanticus Holdings Corporation is a financial holding company with investments primarily in companies focused on providing financial services. This project mainly loading settlement files into a central repository to send to investment partners, Loading and removing on boarding Companies information.
Responsibilities:
Responsible for Business Analysis and Requirements Collection.
Responsible for data analysis.
Design the Data Mart model using Star Schema methodology.
Created Complex mappings using Connected/Unconnected Lookup, Aggregator and Router
transformations for populating target table in efficient manner.
Created events and tasks in the work flows using workflow manager
Provided production support by monitoring the processes running daily.
Developed Informatica Mappings, Sessions and Workflows as per client’s
standards.
Prepared design specifications for Informatica mappings.
Tuning Informatica Mappings and Sessions for optimum performance.
Involved in Informatica configuration changes for ETL deployment.
Developed shell scripts for data retrieval and ETL processes.
Developed and scheduled Tidal jobs by creating .
Environment: Informatica Power Center 9.0.1, Oracle, Tidal, Windows 98, UNIX (Solaris), MS SQL Server, SQL, PL/SQL, SQL*Loader, TOAD, Shell Scripts.
COX COMMUNICATIONS Atlanta GA (August 2012 TO JAN 2013)
VERIZON INVENTORY REPORTING (ETL/ Informatica Developer)
This project is to allow Cox Retail stores to have Verizon phone inventory available for in-store purchase. Cox will send a file daily to Verizon that provides details on the phones sold on a per store basis that is DSR file. In this way we are improving the customer experience, increase sales by having actual Wireless inventory in Cox Retail locations. Customers will be able to purchase Wireless service and leave the Cox Retail store with an activated phone.
Responsibilities
Interacted with various business people and gathered the business requirements and translated them into technical design specifications/documents and created HLD/LLD documents of all the business processes that helped technical team in understanding.
Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
Extensively designed, developed, tested complex Informatica mappings, Mapplets and to extract data from external flat files, XML files, oracle tables using Informatica.
Responsible for creating interfaces using different types of mappings using various transformations like Expression, filter, router, Aggregator, Look up, Joiner, Stored Procedure, Update Strategy, Etc.
Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
Worked with mappings to dynamically generate parameter files used by other mappings.
Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
Experience working with DB Partitioning in Oracle.
Extensively involved in identifying performance bottlenecks in targets, sources, mappings, and sessions and successfully tuned them for maximum performance using best practices.
Experience working with Onsite offshore model.
Environment: Informatica Power Center 9.1.0, Oracle 11g, TOAD 10.6, SQL, PL/SQL, UNIX, IBM AIX, MS SQL Server, OBIEE.
T-MOBILE Seattle WA (OCT 2011 –JULY 2012)
SCMS (COMMISSIONS) / (ETL/ Informatica Developer)
A commission data source management solution that automates commissions payments in a timely, accurate and agile manner for the enterprise. It will be flexible, intuitive and have the capability to centralize compensation modeling, processing, reporting, dispute resolution and analytics. Eliminates manual processing, operating inefficiencies and legal exposure with a systematic solution.Respond to sales driven compensation initiatives that drive Commission design changes and reporting needs without development. Provides next-day reporting of previous-day activity and commission period-to-date totals viewable via a web portal Understand inaccurate payment and generate notifications of any incorrect payments .
Responsibilities
Interacted with various business people and gathered the business requirements and translated them into technical design specifications/documents and created HLD/LLD documents of all the business processes that helped technical team in understanding.
Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
Extensively designed, developed, tested complex Informatica mappings, Mapplets and to extract data from external flat files, XML files, oracle tables using Informatica.
Responsible for creating interfaces using different types of mappings using various transformations like Expression, filter, router, Aggregator, Look up, Joiner, Stored Procedure, Update Strategy, Etc.
Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for the delta process to extract only the additional data added during that period.
Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
Worked with mappings to dynamically generate parameter files used by other mappings.
Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
Extensively involved in identifying performance bottlenecks in targets, sources, mappings, and sessions and successfully tuned them for maximum performance using best practices.
Extensively used UNIX Shell scripts to call oracle packages and catch exceptions and used sendmail UNIX script to send emails to the teams.
Extensively used UNIX shell scripts to provide scripts for Automation jobs.
Development of database scheduler scripts and applications using UNIX Shell Scripts, PL/SQL and SQL Scripts.
Environment: Informatica Power Center 9.1.0, Oracle 11g, TOAD 10.6, SQL, PL/SQL, UNIX, IBM AIX, MS SQL Server, TIDAL.
Satyam Computer Services India Jan 07 – March08
Oracle Developer
Responsibilities:
Created database objects like tables, views, Sequences, Directories, Synonyms, stored procedures, function, packages, Cursor, Ref Cursor and Triggers.
Involved in analysis, design, coding and Testing
Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs
Front End Screen was developed using Forms 6i.
Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
Used SQL LOADER to upload the information into the database.
Used Crystal Reporting for generating reports based on user portfolio data.
Used Explain Plan for query optimization.
Created Database design and converting them into database objects.
Wrote test cases and performed Unit testing
Planned version control of production source code using Harvest.
Involved in writing Technical Specification Documentation
Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs
Environment: Oracle 8i Database,DB2,SQL, PL/SQL, Sql Navigator and SQl PLUS
Contact this candidate