SUMMARY:

• 6+ years of experience in Information Technology with emphasis on Data Warehouse/Data Mart development using developing strategies for Extraction, transformation, and loading (ETL) in Informatic PowerCenter from various database sources.
• Strong work experience in ETL life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse using PowerCenter, Designer, Workflow Manager and Workflow Monitor.
• Involved in informatica upgrade projects from one version to another version.
• Involved in understanding of Business Processes, identification of dimensions and Facts for OLAP applications.
• Strong knowledge of understanding Data Modelling.
• Comprehensive experience of working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management.
• Extensive experience in developing Stored Procedures, Functions, Triggers and Complex SQL queries.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Well versed in Data modelling concepts incorporating dimensional modelling (star and snowflake schema), logical and physical data modelling.
• Experience in Information Technology with a strong background in Database development and strong eSkill’s for Data warehousing using Informatica.
• Extensive experience in developing ETL applications and statistical analysis of data on databases ORACLE, DB2, MySQL and SQL Server .
• Superior SQL skills and ability to write and interpret complex SQL statements and alsoskill full in SQL optimization and ETL debugging and performance tuning.
• Experience in developing of on - line transactional processing (OLTP), operational data store (ODS) and decision support system (DSS) (e.g., Data Warehouse) databases.
• Hands-on knowledge of enterprise repository tools, data modelling tools, data mapping, tools, data profiling tools, and data and information system life cycle methodologies.
• Experience with dimensional modelling and architecture experience implementing proper data structures for analytical reporting from an enterprise data warehouse .
• Implemented Change Data Capture (CDC) with Informatica Power Exchange.
• Used Informatica Power Exchange to access VSAM files also worked on Flat files, and XML files
• Strong in implementation of data profiling, documenting Data Quality metrics like Accuracy, completeness, duplication, validity, consistency.
• Good skills in analysing trend charts from score cards to analyse the threshold which is to be considered in further development
• Have good skills on understanding and development of business rules for its Standardization, Cleanse and Validation of data in various formats.
• Extensively worked on informatica PowerCenter transformations as well like Expression, Joiner, Sorter, Filter, Router and other transformations as required.
• Very strong knowledge on end to end process of Data Quality requirements and its implementation.
• Experience in Extraction, Transformation and Loading (ETL) data from various data sources into Data Marts and Data Warehouse using Informatica power centre components (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Informatica Administration Console).
• Strong Experience in developing Sessions/Tasks, Worklets and Workflows using Workflow Manager tools - Task Developer, Workflow & Worklet Designer.
• Experience in performance tuning informatic mappings and sessions to improve performance for the large volume projects.
• Experience in debugging mappings, identified bugs in existing mappings by analysing the data flow and evaluating transformations.
• Good experience in writing UNIX shell scripts, SQL scripts for development, automation of ETL process, error handling and auditing purposes.
• Expertise on Agile Software Development process.
• Extensive experience of providing IT services in Retail, Healthcare, Financial and Health care industries.
• Experience on Informatica designer tools - transformations, reusable transformations, mappings, and mapplets, DT Studio includes DT/Engine, DT/Designer and DT console.
• Experience working with database objects like triggers, stored procedures, functions, packages, views, and indexes.
• Proficient in performance tuning of Informatica Mappings, Transformations, and Sessions experienced optimizing query performance.
• Worked extensively with Informatica Workflow Manager (using tools such as Task Developer, Worklet and Workflow Designer, and Workflow Monitor) to build and run workflows.
• Expert in using Informatica Power Exchange CDC (Change Data Capture) with Oracle database including DC (Data conversion).
• Involved in Tuning SQL performance Tuning.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in informatica.
• Experience in Task Automation using UNIX Scripts, Job scheduling and Communicating with Server using pmcmd.
• Good experience in writing UNIX shell scripts, SQL scripts for development, automation of ETL process, error handling and auditing purposes.
• Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica PowerCenter 9.x/8.x/7.x/6.x ETL tool.
• Extensive experience and knowledge of the project lifecycle, including requirements gathering, development and execution.
• Coordinated offshore efforts and day-to-day activities,
• Expertise in Data Modelling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modelling using ERWIN 4.x/3. x.
• Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.
• Implemented SCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1, 9.6/9.1/8.6/8.1/ , Siperian/Informatica 10.0/9.1

OBIEE,BI: Framework manager, Query studio, Report studio

Programming Languages: SQL, PL/SQL, HTML, Basic UNIX SHELL SCRIPTING

Database: Oracle 9i/10g/ 11g,, DB2, MS SQL Server 2010/ 2005,Operating System: Windows 98/NT/2000/XP/7, UNIX

Programming Tools: SQL*PLUS, SQL* Loader, Siebel Analytics TOAD 10.0, Putty

Office Tools: MS PowerPoint, MS Word, MS Excel

Scheduling tools: DAC,Control M, Skybot, Robot, Crontab, UC4, Mastero

Defect Management: HP Quality Centre, HP ALM, JIRA, Service Now

Internet Tools: HTML, XML, XSLT

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

ETL Informatica Developer

Responsibilities:

• Extensively used Informatica to load data from Oracle and flat files into the target Oracle database.
• Used various transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy and Stored Procedures.
• Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Created and scheduled workflows using Workflow Manager to load the data into the Target Database.
• Involved in performance tuning of Targets, Sources, and Mappings. Improved performance by identifying performance bottlenecks.
• Experience in working with Informatica Power Center
• Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail and timer for scheduling of the workflow.
• Involved in Scheduling reports using Cognos Scheduler.
• Involved in meetings to gather information and requirements from the clients.
• Involved in Designing the ETL process to extract, translate and load data from flat files to warehouse data base.
• Used Debugger to validate mappings and also to obtain troubleshooting information about data by inserting Breakpoints.
• Created Multidimensional models in Cognos transformer using Framework Manager Packages & Cognos Reports.
• Extensively used Variables, Breakpoints, and Sorted inputs.
• Documented the number of source / target rows and analyzed the rejected rows and worked on re-loading the rejected rows.
• Created UNIX shell scripting and automation of scheduling processes.

Environment: Informatica Power Center, Cognos, ETL, PL/SQL Developer, Oracle, UNIX, Microsoft SQL Server.

Confidential, Denver, CO

ETL Informatica Developer

Responsibilities:

• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer &Mapplet and Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures using Informatica Power Center.
• Implemented logical and physical data modeling with STAR schema techniques in Data Mart.
• Performance tuning of Informatica sessions for large data files has been done by increasing block size, data cache size and, sequence buffer length.
• Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Procedures and Joiner etc.
• Extensive experience in extraction of data from various sources like relational databases Oracle, SQL Server, Flat Files, MS Access & XML Files and DB2.
• Used Informatica Power Center Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Worked on creating profiles, profile models, rules and mappings with IDQ.
• Created Profiles using IDQ rules and filters.
• Developed several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica Power Center and IDQ.
• Implementation of SCD type1/type2/type3 in existing ETL interfaces for capturing slowly changing dimensions.
• Performed planning and execution of large data conversion.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Source data was extracted from Oracle, SQL Server, flat files, COBOL sources
• Implemented Change data capture and incremental logics in inventory ETL Interfaces by identifying the audit columns for the data.
• ETL mapping Documents for every mapping and Data Migration document have been developed for smooth transfer of project from development to testing environment and then to production environment.
• Worked in debugging using Session Log messages, Server Messages.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i in accordance with requirements and specifications.
• Used TOAD to run SQL queries.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
• Responsible for the analyzing and comparing complex data from multiple sources (Oracle, flat files).
• Responsible for writing Unix Shell Scripts to schedule the jobs.
• Actively interacted with business analysts.
• Worked with Business analysts and the DBA for gathering requirements and for project coordination.

Environment: Informatica Power Center v9.1, IDQ, Oracle 11g, IMS Database (DB1), DB2, Teradata, SQL, Flat Files, Putty, Windows-XP (Client), Mainframe, Unix, AS/400, TOAD 9.0, MS Visio, ILM, Informatica servers on Unix and Power Exchange.

Confidential, Pittsburgh, PA

ETL Informatica Developer

Responsibilities:

• Gathered requirements and implement them into source to target mappings.
• Integration of data sources like SQL server and MS access and non-relational sources like flat files into staging area.
• Designed custom reports via SQL Reporting Services to align with requests from internal account teams and external Clients.
• Effectively worked on Mapping Designer, Workflow Manager, and Workflow Monitor.
• Extensively used Sequence Generator in all mappings and fixed bugs / tickets raised in production for existing mappings in common folder for new files through versioning (Check in and Checkout) on an urgency through support for QA in component unit testing and validation.
• Used shortcuts for sources, targets, transformations, Mapplets, and sessions to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Created POC data quality mappings in Informatica Data Quality tool and imported them into Informatica PowerCenter as Mappings, Mapplets
• Applied slowly changing Dimensions Type I and Type II on business requirements.
• Extensively worked on performance tuning and also in isolating header and footer in single file.
• Worked on large amounts of data independently executing data analysis, utilizing appropriate tools and techniques (Interpreting results and presenting them to both internal and external client.
• Wrote SQL queries to create end-user reports /Developing SQL Queries and stored procedures in support of ongoing work and application support.
• Used Cognos Transformer to build multidimensional cubes
• Designed & executed test scripts and test scenarios, reconciling data between multiple data sources and systems.
• Involved in requirement gathering, Design, testing, and project coordination.
• Project planning and scoping, facilitating meetings for project phases, deliverables, escalations and approval. Ensure adherence to SDLC and project plan.
• Worked on Multidimensional Models and created Reports in Report Studio using Cubes as a data source.
• Raised change requests, analyzed and coordinated resolution of program flaws and fixed them in DEV and Pre-Production environments, during the subsequent runs and PROD.
• Perform analysis profiling on existing data and identify root causes for data inaccuracies, Impact Analysis and recommendation of Data Quality.
• Precisely documented mappings to ETL Technical Specification document for all stages for future reference.
• Scheduled jobs for running daily, weekly and monthly loads through control-M for each workflow in a sequence with command and event tasks.
• Created requirement specifications documents, user interface guides, and functional specification documents, ETL technical specifications document and test case.
• Responsible for studying the existing data warehouse and working on migrating existing PL/SQL packages, stored procedures, triggers and functions to Informatica PowerCenter.
• Fine-tuned ETL processes by considering mapping and session performance issues.
• Responsible for Creating workflows and Worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Maintained the proper communication between other teams and client.

Environment: Informatica PowerCenter 9.1, Oracle11g,Erwin r7,SQL, PL/SQL, Flat Files, AutoSys, MS SQL Server 2008, Windows XP,TOAD, UNIX

Confidential

Informatica Developer

Responsibilities:

• Followed Agile-Scrum methodology to design, develop, test and deliver the code.
• Modify existing business logic in Informatica ETL flows.
• Design new ETL flows as per the mapping sheets.
• Involved in ETL developing, creating required mappings for the data flow using Informatica.
• Used transformations like Source qualifier, Filter, Aggregator, Joiner, Expression, Lookup, Router, Sorter and Union.
• Involved in designing the mapplet and reusable transformations according to the data flow requirements.
• Validated the output according to the specifications.
• Enhancements in existing mappings according to the business logic.
• Attended daily scrum calls to post the required status update.
• Testing activities involve Unit Test Plan Preparation, Unit Testing, Sprint Testing, UAT and performance testing.
• Gathering reporting requirements and making enhancements to any existing logic if required.
• Developed Oracle PL/SQL packages, procedures and functions
• Coded Oracle SQL to create ad-hoc reports on an as-needed basis
• Used Oracle Warehouse Builder to implement changes to the operational data store, as well as create data marts
• Involved in the data analysis for source and target systems. Good understanding of Data warehousing concepts, Star schema and Snow-flake schema.
• Involved in supporting and maintaining Oracle Import, Export and SQL*Loader jobs.

Environment: Informatica PowerCenter 9.1, MS SQL Server 2008, Windows XP, UNIX