PROFESSIONAL SUMMARY:

• 8 Years’ experience as an ETL Developer
• Experienced in Database development and Data warehousing and ETL process using Informatica Power Center 9.x/8.x/ 7.1.3/7.1.1/6.2.
• Experience in SQL performance tuning
• Hands on experience in Shell scripting and UNIX. Experience in writing PLSQL stored procedures
• Based in North Carolina, NC and available immediately for a phone / virtual interview
• 8+ years of IT experience and technical proficiency in the field of Data Warehousing teamed with Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development & testing and full life cycle Implementation of Data Warehouse.
• Experience in software development methodologies such as Waterfall and Agile.
• Strong Data Warehousing experience in Application development & Quality Assurance testing using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manager)
• Experience in creating complex Informatica Mappings using Source Qualifier, Expression, Router, Aggregator, Lookup and other transformations in Informatica and well versed in debugging an Informatica mapping.
• Knowledge in OLTP/OLAP System Study and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Strong at Object Oriented Analysis and Design, programming technical skills along with ability to learn new emerging technologies and adapt quickly.
• Strong SQL experience in Coding and Query tuning. Well versed with Oracle SQL tools like TOAD, SQL developer and SQL Plus.
• Hands on experience in Shell scripting and UNIX.
• Experience in writing PLSQL stored procedures to integrate and achieve business functionality.
• Experience in creating efficient and effective BRD (Business requirement document), TAD (Technical Architecture document), MDD (Mapping Design Document) and TDD (Technical design document) involving data mappings.
• Actively participated in Informatica upgrade activities (from Version 8.x to 9.1) and configured domains, nodes, Integration Services and Repository Services.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Good expertise to communicate with Informatica Vendor for configuration/application related errors and complexities.
• Knowledge of Migration, backup, recovery, tuning, tracing and troubleshooting.
• Ability to work on Informatica Administrator (Admin Console) and Repository Manager Clients.
• Ability to work in teams as well as individually, quick learner and able to meet deadlines.
• Under gone training on MSTR, OFSAA, OBIEE and gained knowledge on the same.
• Experience in scheduling of ETL jobs using Control-M.

TECHNICAL SKILLS:

Operating Systems: Windows, Unix

Databases: Oracle 8i, 10g & 11g, SQL, Teradata, DB2,Exadata

Languages: SQL, Shell Scripting, PL-SQL, Python

ETL Tools: Informatica 9.1,9.6,8.x - Workflow Monitor, Workflow Manager, Repository Manager, Designer, Metadata Manager, Rule Point, Informatica Administrator, IDQ, DVO

Data Modeling: Erwin 4.x

Tools: Edit Plus, SQL Plus, Toad, SQL Developer, Putty, BO 6.5, Cognos, Rally, OBIEE, MSTR, OFSAA, Service Now

Packages: MS Office (MS Access, MS Excel, MS Outlook, MS Power point, MS Work)

PROFESSIONAL EXPERIENCE:

ETL/ Sr. Informatica Developer

Confidential, Charlotte, NC

Responsibilities:

• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Day to day interactions with Data Modelers and Business Analyst to understand the requirements and the impact of the ETL on the business.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Monitoring the Data Quality, generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Mapplets and used them in different Mappings.
• Conducted a series of discussions with team members to convert Business rules into Informatica mappings
• Extracted data from Oracle database transformed and loaded into Oracle DB according to the business specifications.
• Created multiple operational and finance reports and Charts and scheduled them to run Hourly, Daily, monthly according to client requirements for the periodic analysis using SSRS 2008.
• Worked on complex Source Qualifier queries, Pre and Post SQL Queries in the Target.
• Used Teradata Utilities like fast load, multi load and fast export.
• Used Application Lifecycle Management for defect tracking between developers, data analysts and testers.
• Extracted data from heterogeneous sources like Oracle, SQL Server
• Worked with Session logs and Workflow logs for Error handling and troubleshooting in Dev environment.
• Developed procedures and functions using PL/SQL.
• Created number of database Triggers according to business rules using PL/SQL
• Wrote PL/SQL stored procedures & triggers, cursors for implementing business rules and transformations.
• Generated interactive reports using SQL Server Reporting Services (SSRS 2008) as per the client's request.
• Involved heavily in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistant.
• Optimized SQL queries for better performance.
• Worked with PL / SQL to create new stored procedures and modify the already existing procedures as per the change requirements from users.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Perform impact analysis of the existing process of RRP-variant and designing the solution for automating input and output processes to/from RRP.
• Modified old crystal reports by adding new business requirements using SSRS and Create reports in SQL server using SSRS as per the requirements provided by the Front-End users.
• Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to code ETL Mappings for new requirement changes.

Environment: Informatica Power center 9.6.1, Oracle 11/10g, SQL server 1.5.5, SSRS, PL/SQL, IDQ, LSF (Job scheduling), Teradata, UNIX shell scripting, Application Lifecycle Management (ALM) for defect tracking.

ETL/ Informatica Developer

Confidential, San Francisco, CA

Responsibilities:

• Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to code ETL Mappings for new requirement changes.
• Involved in Data Analysis.
• Estimation, Requirement Analysis and Design of mapping document and Planning for Informatica ETL.
• Involved in designing STAR Schema for the business processes.
• Analysis of Source, Requirement, existing OLTP system and Identification of required dimensions and facts from the Database.
• Designed, developed, implemented and maintained Informatica PowerCenter and IDQ 8.6.1 application for matching and merging process.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, the Mapping Designer to map the sources to the target.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.6.1.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Developed various Mappings, Mapplets, and Transformations for data marts and Data warehouse .
• Developed the transformation logic for both reference as well as transactional data flow from Legacy to New, and New to Legacy systems.
• Involved in creation of Data Warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.
• Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Utilized of Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Extensively worked on Autosys to schedule the jobs for loading data.
• Worked on Power Exchange for change data capture (CDC).
• Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager and accessing Mainframe DB2 and AS400 systems .
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Scheduled various daily and monthly ETL loads using Control-M.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Involved in Informatica Data Masking & Data Subset Data Mapping.
• Executed conversion maintenance on existing legacy system.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.

Environment: Informatica Power Center 8.6.1, Oracle 10g, Power Exchange 8.6, MS SQL Server 2008, UNIX (Sun Solaris5.8/AIX), SSRS, UltraEdit-32, Data Marts, Erwin Data Modeler 4.1, FTP, Control M, MS-Excel, MS-Access, IDQ, DB2, UNIX Shell Scripting, Data Modeling, PL/SQL, Autosys

ETL Developer

Confidential

Responsibilities:

• Understand PL\SQL code, go through the design documents and understand process flow that has to be followed in Informatica.
• Creation of Mapping Documents for SOURCE feeds to STG and STG to TGT.
• Review & Understand the schematic diagrams for depicting the pseudo mapping logic, and workflow logic.
• Creation of Unit test cases for each component in workflow and for other tasks as part of ETL process.
• Serve as a core member of agile teams that drives user story analysis and elaboration.
• Build the Informatica mappings, sessions, workflows, and other various reusable Informatica objects (Mapplets & reusable transformations) as per the defined logic in Design Documents.
• Unit testing the ETL workflow & mappings - fixing the defects which came out of unit testing and if needed, make modifications to the documents to ensure that those are up to date as per the functionality in the system.
• Extensively worked with History and Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations.
• Extensively used DVO tool for Unit Testing before pushing code to QA.
• Worked on UNIX shell scripts. Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions.
• Hands on crontab scheduling to run jobs as per requirements.
• Work in Production Support for all the applications which are currently running using PLSQL/Informatica code.
• 24*7 on call support for production issues.
• Monitor all processes running in PROD and reply to users for any business/technical questions.
• Enhancements on current code as per user requirements or based on current situations.
• POC on Proactive Monitoring.

Environment: Informatica 9.1, 9.5 and Oracle 11g, UNIX, Toad, Putty, WinScp, Win Merge