SUMMARY

• 7+ years of IT experience in Design, Analysis and development of software applications and implementation of Data warehousing using ETL Tool Informatica PowerCenter 9.5.1/9.1/8.5. x/8.1.x with Oracle, Teradata, DB2 databases on windows and UNIX platforms.
• Strong experience in the Implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Informatica Power Center9.x/8.x, Teradata 12/13, Oracle 9i,10g &11g.
• Extensively worked with data warehousing, Business Intelligence, ETL methodologies, technologies, using Informatica - Power Center Client tools - Designer, Repository manager, workflow monitor.
• Strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Highly Proficient in Data Modeling, Strong in Data Warehousing concepts, Dimensional, Star Schema and Snowflake Schema methodologies.
• Have good hands on experience in Installing, Configuring Informatica server, client and repository.
• Strong experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using complex transformations like Expressions, Routers, Lookups, Source Qualifiers, Aggregators, Union, Rank, Filters, Update Strategy, Joiners, Normalizers etc.
• Creating Workflows with Worklets & Tasks and Scheduling using Workflow Manager and also worked on Autosys scheduler tools for scheduling the jobs.
• Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon (Type-1, 2) and CDC (Change Data Capture).
• Involved in the performance tuning of Informatica mappings by using Informatica Push Down optimization (PDO), which provides the same performance impact as a BTEQ script but also provide a good data lineage.
• Did performance tuning of Informatica components for daily incremental loading.
• Extensive experience in error handling and problem fixing in Informatica.
• Extensive database development skills using utilities like BTEQ, FAST LOAD, MULTI LOAD, FAST EXPORT, TPUMP and TPT (Teradata Parallel Transport) in Teradata Database
• Extensive knowledge and Hands on experience in Unix shell scripting and Windows Batch Scripting.
• Extensively used mapping parameters and variables to provide the flexibility and parameterized the workflows for different system loads.
• Hands on experience in Unit testing and Integration testing.
• Involved in full Life Cycle Development including System Analysis, Design, Data Modeling, Implementation and Support of various applications in Data Warehousing, and OLAP applications.
• Good working knowledge in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Experience working in AGILEMETHODOLOGY and ability to manage change effectively.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9.5.1/9.1/8.5. x/8.1.x (Informatica Power Mart 6.2/5.1/4.7, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Informatica server, PowerConnect, Power Analyzer, ETL, Informatica Power Exchange, Metadata, Pentaho, Data Mining, Datamart, OLAP, OLTP, SQL* Plus and SQL*Loader

Data Analysis: Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer, Erwin 4.5/4.0/3.0

Databases: Oracle 10g/9i/8i/8.0/7.0, SQL DB, Teradata, MS SQL Server 2000/7.0/6.5 , DB2, Unix Shell Scripting, SQL, PL/SQL, ISQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, HTML, DHTML, XML, MS Access 7.0/97/2000

Data Reporting: Tableau, Qlik view

Others: Unix Shell Scripting, Autosys, TOAD, Transact SQL, SAS, SQL*Plus 3.3/8.0, SQL Navigator, Microsoft Access, Share point, HTML, DHTML, XML, C, Java, Software Development Life Cycle.

PROFESSIONAL EXPERIENCE

Confidential, Akron-OH

Sr ETL Developer

Responsibilities:

• Involved in requirements gathering, data modeling and designed Technical, Functional &ETL Design documents.
• Implemented ETL Balancing Process to compare and balance data directly from source and warehouse tables for reconciliation purposes.
• As a release architect, managed various release activities including environment planning, release planning and dependency, project dependencies, architecture review, etc.
• Designed and executed test scripts to validate end-to-end business scenarios.
• Implemented Mappings to extract the data from various sources Oracle, XML files and load into oracle and Teradata using Teradata utilities like Mload, Tpump, and Fast Export.
• Designing and developing OWB mappings to provide business with the interface specific product.
• Creating ETL Interfaces and Packages using ODI, SSIS, and OWB
• Designed and implemented slowly changing dimension mappings to maintain history.
• Used Teradata utility Fast Load for bulk loading and Tpump & Mload utilities for loading less and larger volumes of data.
• Used session partitions, dynamic cache memory, and index cache to improve the performance of ETL jobs.
• Created standard reports using Business Objects features like Combined Queries, Drill Down, Drill Up, Cross Tab, Master Detail etc.
• Worked with XML sources and targets.
• Created and worked with generic stored procedures for various purposes like truncate data from stage tables, insert a record into the control table, generate parameter files etc.
• Architecture oversight to various project teams, a key leadership role for the architecture redesign, data governance, security, new developments, and major enhancements.
• Designed and developed Staging and Error tables to identify and isolate duplicates and unusable data from source systems.
• Simplified the development and maintenance of ETL by creating Mapplets, Re-usable Transformations to prevent redundancy.
• Wrote and implemented generic UNIX and FTP Scripts for various purposes like running workflows, archiving files, to execute SQL commands and procedures, move inbound/outbound files.
• Used Power Exchange to capture the changes in the source data.
• Generated Tableau Data Extract (TDE) files direct from Informatica Power Center and published TDE files directly to Tableau Server and Tableau Online from Informatica Power Center.
• Used session partitions, dynamic cache memory, and index cache to improve the performance of ETL jobs.
• Resolved complex technical and functional issues/bugs identified during implementation, testing and post production phases.
• Design and develop incremental OWB mappings.
• Identified & documented data integration issues and other data quality issues like duplicate data, non-conformed data, and unclean data.
• Assisted team members in functional and Integration testing.
• Automated and scheduled Workflows, UNIX scripts and other jobs for the daily, weekly, monthly data loads using Autosys Scheduler.
• Actively involved in Daily check in meetings to discuss on the production issues and resolved.

Environment: Informatica PowerCenter 9.1/8.6, Oracle 11/10g, PL/SQL, Teradata 13.1, OWB 11, ODI 12c, Autosys, TOAD

Confidential Windsor, CT

Informatica Developer

Responsibilities:

• Involved in various phases of the software development life cycle right from Requirements gathering, Analysis, Design, Development, and Testing to Production.
• Meeting deadlines to deliver the business value with in the Sprint Cycle.
• Analyzed the requirements and framed the business logic for the ETL process.
• Extensively used ETL to load data using Power Center from source systems like Relational Tables, Flat Files, and Sales Force Objects into staging tables (DB2) and load the data into the target database (DB2).
• Developed mappings to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, Joiner, Normalizer transformations, Filter etc.
• Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the different bottlenecks.
• Defined Target Load Order Plan for loading data into Target Tables.
• Worked with TWS Scheduler to automate the workflows.
• Performed and documented the unit testing for validation of the mappings against the mapping specifications documents.
• Writing Shell scripts to Load Tables, Truncate tables, Automate workflows in TWS. Also, wrapped session PMCMD commands in shell scripts for batch processing using TWS Scheduler.
• Created pre-session, post session, pre-SQL and post-SQL commands in Informatica.
• Worked on performance tuning of Informatica mappings.
• Used the Debugger in debugging some critical mappings.
• Experience working with multiple Fortune 500 clients on tools like Talend, Oracle Warehouse Builder (OWB), ODI etc.
• Extensive experience working with tools like DB2Visualizer 8.0.12, TOAD for Oracle 9.6.1, SQL Developer
• Attending Meetings for Sprint Demos, Retrospectives, Sprint Planning, Grooming Sessions, Stand up Meetings, Collaboration Meetings etc.

Environment: Informatica Power Center 9.1, Oracle 11g, DB2, SalesForce.com, UNIX Shell Scripting, OWB 11, ODI 12c, TWS Scheduler 8.5.1/9.2.

Confidential, Austin TX

Informatica ETL Developer

Responsibilities:

• Worked with Business analysts and users to gather, clarify and finalize functional requirements.
• Involved in Project planning and implementation throughout the project life cycle.
• Conducted meetings with Business users & SME for requirement clarifications.
• Prepared FR (Functional Requirements) and high/low level design document and estimates.
• Created technical design document that meets the business requirements following all Industry defined standards.
• Translated Business requirements to technical/system requirements and communicated it to team.
• Followed best practices in designing ETL processes for long term solutions.
• Designed Data model and used Informatica designer for developing various mappings.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator.
• Worked with XML targets for the data coming from SQL server source.
• Query tuning and SQL Query override used in Source Qualifier transformation to pull historical data from database not earlier than the given date i.e. the change data capture (CDC).
• Worked with Expression, lookup, sequence generator, Normalizer, router transformations for cleansing and validation of data to load into XML and flat file targets.
• Worked with re-usable sessions, decision task, control task and Email tasks.
• Parameterized the whole process by using the parameter file for the variables.
• Imported XSD file to create the xml target and create the Hierarchical Relationship and normalized views.
• Edited the views and created new views according to the business requirement.
• Used Debugger within Mapping Designer to test the data flow between source and target and to troubleshoot the issues with Mappings.
• Designed and build a web services integration to download user activity data to flat files.
• Implemented the logic by using HTTP transformation to query the web server.
• Configure and setup a secure FTP connection to the vendor using the Informatica Managed File transfer software.
• Created complex Shell scripts for various set of actions that would automate the process of executing the actions like validating the presence of indicator files.
• Encrypting and compressing the xml and flat files using PGP Compression algorithm like ZIP and PGP Encryption algorithms like TripleDES, Blowfish, AES-256 and CAST5 using MFT.
• Pushing the compressed and encrypted xml files and flat files generated to the external vendor using MFT.
• Involved in Unit testing and system integration testing (SIT) of the projects.
• Assist the team members with the mappings developed as part of knowledge transfer.

Environment: Informatica PowerCenter 8.6.1/ 8.1.1 , Windows Server 2008, MS-SQL Server 2005, Batch Scripting, Microsoft Project plan, Debug, Quality Center, Perl Scripting, XML Targets, Flat Files, MFT server (Managed File Transfer), VLTrader V4.2, Tidal 5.3.1.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Created documentation of Design Specifications and Technical Sessions.
• Extensively used Informatica Power Center 8.5.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.
• Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Implemented weekly error tracking and correction process using Informatica.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order Processing Information table and Audit Log tables.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL scripts to automate the process.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and the Target Data.
• Experience working in agile methodology and ability to manage change effectively.

Environment: Informatica PowerCenter 8.5.1, Oracle 10g, Flat Files, TOAD 9.7.2, PL/SQL, SQL* PLUS, Teradata, UNIX Shell scripting.

Confidential

Informatica developer

Responsibilities:

• Development, Testing, Implementation & Training ofusers.
• Prepared ETL Specifications and design documents to help develop mappings.
• Created mappings for Historical and Incremental Loads.
• Used Version Control to check in and checkout versions of objects.
• Tuned Source, Target, Mappings, Transformations and Sessions for better performance.
• Supporting daily loads and work with business users to handle rejected data.
• Prepared and maintained mapping specification documentation.
• Use Debugger to test the mapping and fixed the bugs.
• Used Mapping Variables and Mapping Parameters to fulfill the business requirements.
• Implemented Type I and Type II slowly changing Dimension to maintain all historical information in Dimension Tables.
• Involved to prepare technical and functional specification.
• Performance analysis and tuning of SQL statements of projects.
• Imported data from different sources to Oracle tables using Oracle SQL*Loader
• Wrote Oracle PL/SQL, stored procedures and triggers to populate data.
• Involved in writing complex SQL statements for reports.
• Worked closely with client to research and resolve user testing issues and bugs.

Environment: Informatica PowerCenter, UNIX, PL/SQL, TOAD, Oracle 8i, SQL, SQL*Loader.