SUMMARY

• Over 3+ years of experience in Information Technology with emphasis on Data Warehouse/Data Mart development using developing strategies for extraction, transformation, and loading (ETL) in Informatica Power Center 9.6.1/9.5.1/9.1.1/8.6.1/8.1.1/7.1.2 from various database sources.
• Good knowledge on Informatica Powercenter administration.
• Strong Data Warehousing ETL experience of usingInformatica9.x/8.x, Powercenter Client tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Involved in understanding of Business Processes, identification of dimensions and Facts for OLAP applications.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle, MS SQL Server, DB2, My Sql and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Extensive experience in developing Stored Procedures, Functions, Triggers and Complex SQL queries
• Used Informatica Power Connect forSAPto pull data fromSAP R/3.
• Comprehensive experience of working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management.
• Good working knowledge of various Informatica designer transformations like Source Qualifier, Dynamic and Static Lookups, connected and Unconnected lookups, Expression, Filter, Router, Joiner, Normalizer and Update Strategy transformation.
• Extensively used Teradata Utilities like Tpump, Fast-Load, Multi-Load, BTEQ and Fast-Export.
• Experience in integrating Hadoop with Informatica Power Center also involved in moving Hadoop process to Informatica process.
• Experience inTask Automationusing UNIX Scripts, Job scheduling and Communicating with Server using pmcmd.
• Extensively used Autosys, Control-M and Maestro for Job monitoring and scheduling along with Production on call support.
• Good knowledge with Informatica cloud.
• Experience on working with Webservices like SOAP UI and REST API.
• Highly motivated and goal-oriented individual with a strong background in SDLC Project Management and Resource Planning using Agile methodologies & Waterfall Methodologies.
• Experience in handling multiple tasks and work independently as well as in Team.
• Excellent interpersonal and communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.5.1/8.6.1/8.1.1 , SSIS, IBM Datastage

RDBMS: Oracle 10g/9i/8i, Teradata 14/12, DB2, SQL Server 2008 R2/2012, MySQL, Sybase

Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling, Erwin, Microsoft Visio.

QA Tools: Quality Center, Selenium

Operating System: Windows, Unix, Linux

Reporting Tools: Cognos, Business Objects, Tableau

Languages: Java, XML, UNIX Shell Scripting, SQL, PL/SQL, Perl

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential, Minnesota

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rule and responsible for developing, support and maintenance for the ETL process using Informatica PC.
• Involved in informatica Upgrades process from one version to other versions.
• Created / updated ETL design documents for all the Informatica components changed.
• Extracted data from heterogeneous sources like oracle, DB2, XML, Flat File and perform the data validation and cleansing in staging area then loaded in to Data Warehouse Teradata using Teradata Utilities & Informatica.
• Written Teradata BTEQ, M-LOAD, F-LOAD also used TPT in Informatica.
• Created Informaticatransformations/mapplets/mappings/tasks/worklets/workflows using Power Center to load the data from source to stage and stage to core/base.
• Made use of various Power Center Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Rank, Router, Sequence generator, Union and Update Strategy transformations while creating mapplets/mappings.
• Made use of reusable Informatica transformations, shared sources and targets.
• Used Mapping parameters & Variables.
• Implemented various loads like daily loads, weekly loads, and quarterly loads and on demand load using Incremental loading strategy and concepts of changes Data Capture (CDC).
• Identifiedperformance issuesin existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Created mappings for Type1, Type2 slowly changing dimensions (SCD) / complete refresh mappings.

Environment: Informatica Power Center 9.6.1, IDQ, Oracle 10g, Sql Server, Teradata 14.0, Flat File, XML, UNIX shell scripting.

Informatica Developer

Confidential, Springfield, IL

Responsibilities:

• Developed common routine mappings, Made use of mapping variables, mapping parameters and variable functions.
• DevelopedInformaticamappings, Reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier, and Joiner, designed complex mappings involving target load order and constraint based loading Create/build and run/schedule Workflows and Work lets using the Workflow Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Coded Database triggers, functions and Storedprocedures and written many SQL Queries. Helped coding shell scripts for various administration activities for daily backup.
• Involved in Physical schema implementation, objects like table-space, table rollback segments, created database structures, objects, and their modification as and when needed.
• Used versioning and shared folders for better control onInformaticajobs among the team and across different projects.
• Worked on slowly changing dimension Type2.
• Mapped the source and target databases by studying the specifications and analyzing the requirements.
• Involved in performance testing of jobs.
• Troubleshoot day to day database issues.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.

Environment: Power Center 9.x, Oracle 10g, IDQ, SQL, PL/SQL, UNIX (AXI), Erwin, Toad, Linux(Solaris).

Informatica Developer

Confidential

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Center 9.1.
• Extensively used ETL to load data from Flat file, MS Excel, which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 10g.
• Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, update strategy, Lookup, sequence generator, joiner, Stored Procedure.
• Analyzed the session, event and error logs for troubleshooting mappings and sessions.
• Provided support for the applications after production deployment to take care of any post-deployment issues.

Environment: Informatica 9.x, Oracle 10g, Flat Files, SQL Programming, Unix, Windows, MS Excel, SQL *Plus.