SUMMARY:

• 8+ years of extensive experience in the field of Information Technology with special emphasis on Data warehousing ETL technologies using Informatica PowerCenter.
• Strong Data Warehousing experience using Informatica with extensive experience in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x
• Good experience in all phases of software development life cycle (SDLC) including system design, development, integration, testing, deployment and delivery of applications.
• Extensive experience in architecture design of Extract, Transform and Load environment using Informatica Power Center.
• Experience in Developing ILM Data Archival Entities, Jobs, retention Archive Restore.
• Experience in Data Modeling (Physical & logical data modeling) using data Modelers.
• Experience in Data Analysis, Data Cleansing and Data Validation
• Experience in Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited FlatFiles, DB2, COBOL files & XML Files.
• Created complex and reusable mappings using Lookup, Joiner, Aggregator, Stored procedure, Update Strategy and various other transformations.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Good working knowledge on Teradata components such as FLOAD, MLOAD, BTEQ and Fast Export.
• Worked in High Level and Low Level Design for Cognos reports
• Hands - on experience in Star and Snowflake schema design.
• Successfully implemented slowly changing dimensions (SCD Type1/2/3).
• Expertise in identifying and designing facts and dimensions.
• Expertise in testing Datawarehousing strategies for ETL mechanism developed by Informatica.
• Experience in Integration of various data sources like Oracle, Teradata, SQL Server, DB2 and Flat Files.
• Extensive experience in UNIX shell scripting and Job scheduling using Control-M & AutoSys.
• Good experience in writing SQL Queries and Stored procedures, functions, cursors and packages using SQL Programming.
• Databases: Expertise in databases like Teradata, Oracle 9i, 10g, SQL Server, MySQL and DB2.
• Expertise in TOAD(Tool for Oracle Application Developers) and PVCS (Version Control)
• Experience in working on different operating systems like Windows 2007/Vista/XP/2003/2000 and UNIX.
• Skilled in applying various forms of testing to ensure product quality including: Unit Testing, Integration Testing and Quality Assurance Testing.
• Experience in interacting with Business users in analyzing the Business process requirements and Transforming them into documenting, designing, and rolling out the deliverables

SKILLS:

ETL Tools: Informatica Power Center 9.5/9.1/8.6.1/8.5/8.1/7. x/6.x, Source Analyzer, Mapping Designer, Workflow Monitor,Workflow Manager, Data Cleansing, Data Quality, InformaticaAnalyst 9.1, InformaticaDeveloper 9.1, Repository, Metadata, Data Mart, OLAP, OLTP, ILM, Webservices, PowerMart 5.1/4.7.2, Informatica Data -Analyzer 9.1, PowerExchange 8.

Data modeling tool: Erwin 7.x/ 4.2/3.x, Microsoft Visio

RDBMS: Oracle 11g/10g/9i/8i, IBM-DB2, MS SQL Server, Teradata, Netezza 6.0.4 MS Access

Web Tools: HTML, DHTML, XML, CSS, Java Script

Other tools & Utilities: SQL* Plus, TOAD, Auto Sys

Languages: SQL, PL/SQL, TSQL, C, C++

Scripting languages: UNIX Shell Scripting, Perl Scripting

Operating systems: Windows 2000/2003/NT/XP, UNIX (Sun Solaris, AIX),LINUX

EXPERIENCE:

Confidential, Saint Louis, MO

ETL Informatica Developer

Responsibilities:

• Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse.
• Responsible for developing ETL processes/programs with Informatica Power Center to extract data from the client's operational databases, Transform and filter the data, and Load it into Target database.
• 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.
• Used Informatica Power Center Work Flow manager to create sessions with the task developer and workflows with workflow manager to run the logic embedded in the mappings.
• Created mappings with Informatica PowerCenter 9.1 using Transformations (Expression Transformation, Router Transformation, and Stored Procedure Transformation etc) and Look ups.
• Designed, developed and documented multiple interfaces using Informatica ETL tool.
• Developed complex mappings using multiple sources and targets in different data environment like Oracle, flat and XML files.
• Worked on developing BTEQ Scripts.
• Involved in Data Profiling using Informatica Data Quality IDQ 9.1.
• Created and Monitored Batches and Sessions using Informatica Server and workflow Monitor.
• Analyzed session log files in session failures to resolve errors in mapping or session configuration
• UNIX Shell Scripts for processing/cleansing incoming text files.
• Written Teradata Stored Procedures, Teradata scripts and calling at pre and post session.

Environment: Informatica PowerCenter 9.1/8.6.1, Informatica ILM Data Archive, UNIX shell script, Oracle 11g, IDQ 9.1, Teradata, SQL Server, SSIS, SSRS, Qlikview, Erwin, PL/SQL, TOAD, Agile Scrum

Confidential, Enfield, CT

ETL Informatica Lead Developer

Responsibilities:

• Involved in creating Technical Specification Document (TSD) for the project by conducting meeting with the users to meet their business requirements.
• Attended the meetings with business integrators to discuss in-depth analysis of design level issues.
• Responsible for developing ETL processes/programs with Informatica Power Center to extract data from the client's operational databases, Transform and filter the data, and Load it into Target database.
• Developed strategy and proto-types for Information Lifecycle Management (ILM) centered on archiving and purging in support of multiple large scale OLTP systems.
• Delivered end-to-end Data Archive and Data Subset solutions using Informatica Power Center, ILM and TDM.
• 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.
• Used Informatica Power Center Work Flow manager to create sessions with the task developer and workflows with workflow manager to run the logic embedded in the mappings.
• Involved in extracting data from about five legacy systems.
• Involved in migrating the ETL platform from Informatica 8.6.1 to Informatica 9.1.0.
• Created mappings with Informatica PowerCenter 9.1 using Transformations (Expression Transformation, Router Transformation, and Stored Procedure Transformation etc) and Look ups.
• Designed, developed and documented multiple interfaces using Informatica ETL tool.
• Developed the Dashboard reports using Cognos Report Studio.
• Implemented performance tuning techniques of the ETL programs to load the data efficiently using FLOAD, MLOAD & Fast Export.
• Worked in debugging using Session Log messages, Server Messages, Client Messages
• Scheduled various daily and monthly ETL loads using scheduler tools
• Worked on developing BTEQ Scripts.
• Involved in Data Profiling using Informatica Data Quality IDQ 9.1.
• Used Informatica Data Quality to cleansing data and Data Virtualization to monitor the data quality.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Created Parameterized, Drill Down and Aggregation reports in MS SQL environment using SSRS 2012.
• Created and Monitored Batches and Sessions using Informatica Server and workflow Monitor.
• Analyzed session log files in session failures to resolve errors in mapping or session configuration
• Involved in Qlikview Designing, Data Modeling and Loading data from Multiple Data sources.
• Developed complex queries using different data providers (Stored Procedure, Free hand SQL) in the same report.
• Involved in Production Support in resolving issues and bugs.
• Coordinating tasks and issues with Team Project Manager on daily basis
• Acted as one of the key point of contacts performing onsite/offshore coordination.
• Responsible for coordinating the work and also transfer knowledge to the offshore crew.

Environment: Informatica PowerCenter 9.1/8.6.1, Informatica ILM Data Archive, UNIX shell script, Oracle 11g, IDQ 9.1, Teradata, Control-M, SQL Server, SSIS, SSRS, Qlikview, Erwin, PL/SQL, TOAD, Agile Scrum

Confidential

Sr. Informatica Lead Developer

Responsibilities:

• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• In the analysis, design and development of all the interface’s using Informatica Power center tools in interface team and interfaced with all the other tracks for business related issues
• Business Analysis and Requirement Collection.
• Used Erwin to provide initial physical models to meet current naming standards and/or DDL for assigned projects.
• Used PowerExchange to retrieve all sources of enterprise data without having to develop custom data-access programs.
• Extensively worked on Power Center Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor.
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Implemented Archival and Retirement Projects using ILM tool.
• Created Informatica mappings to populate data into fact tables and dimension tables.
• Responsible for populating warehouse-staging tables.
• Created SSIS packages to extract data from OLTP to Data Warehouse systems and scheduled jobs to call the packages and Stored Procedure
• Involved in Migration of SSRS 2005 to SSRS 2012.
• Defined Target Load Order Plan and to load data correctly into different Target Tables.
• Developed complex mappings using multiple sources and targets in different data environment like Oracle, flat and XML files.
• Involved in generating reports using Cognos
• Created and ran the unit test scripts for base data mart, remediate unit test defects and modified code accordingly.
• Deployment and Migration of Informatica mappings and workflows from dev to test and deployment groups.
• Used various transformations like Unconnected /Connected Lookup, Aggregator, Joiner, Stored Procedure.
• Used PMCMD commands of Informatica in UNIX to schedule sessions and jobs.
• Developed PL/SQL codes for pre-processing complex data calculations coming from Oracle tables.
• Involved in design phase of Qlikview and created design documents
• Worked on SQL tools like TOAD to run SQL Queries to validate the data.
• Written UNIX Shell Scripts for processing/cleansing incoming text files.
• Written Oracle Stored Procedures, SQL scripts and calling at pre and post session.
• Performed Unit testing, Integration testing and generated various Test Cases.
• Created, updated and maintained ETL technical documentation..

Environment: Informatica PowerCenter 8.6, Teradata (FLOAD, MLOAD, BTEQ), Informatica ILM, Unix, Power Exchange, IDQ, WinXP, PL/SQL, Oracle 11g,SQL*Plus, Control-M, TOAD, ERWIN, Teradata, Flat files, MS Excel.

Confidential

Informatica Developer

Responsibilities:

• Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse.
• Interacting with the Informatica Middleware team to migrate the code from the 7.4 production environment to 8.6 Development.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Extensive worked on debugging and troubleshooting the Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting.
• Involved in setting up the environment for the new version.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Responsible for Unit Testing and creating unit test plans and preparing unit test cases.

  Interacting with system testing team and resolve the issue reported by the testing team.

Environment: Informatica Power Center 7.4/ 8.6, Oracle 10g/11g, PL/SQL, SQL Server, Flat Files, UNIX, Windows XP, Teradata, Control M, Unix Shell Scripting

Confidential

Informatica Developer

Responsibilities:

• Responsible for gathering the user requirements and discuss with Business Analysts to acquire the functional and Technical specifications
• Analyzed the source data coming from Oracle ERP system to create the Source to Target Data Mapping.
• Interacted with the Data Architect in Creating and modifying Logical and Physical data model.
• Used Informatica Repository Manager to create Repositories and Users and to give permissions to users.
• Worked with DBA's in optimizing the Major SQL Query's in the process of performance tuning.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Responsible for identifying the bottlenecks and tuning the performance of the Informatica mappings/sessions.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Designed and developed mapping using various transformations like Source Qualifier, Sequence Generator, Expression, Lookup, Aggregator, Router, Rank, Filter, Update Strategy and Stored Procedure.
• Worked with Tidal Enterprise Scheduler to schedule jobs and batch processes.
• Experience in using AppWorx software to schedule and run jobsfor custom writtenprograms.
• Worked Extensively with Informatica Power Exchange in extracting the data from Mainframes
• Used Autosys and Informatica Scheduler to schedule jobs for the files and other sources to be extracted and load to target EDW on a daily/weekly/monthly basis.
• Created Unit Test plans and involved in primary unit testing of mappings.
• Created UNIX shell scripts for Informatica post and pre session operations
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.

Environment: Informatica Power Center 7.4/8.5, Oracle 10g, Teradata, Fast Export, Flat files, TOAD 8.6, UNIX

Confidential

Informatica Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively worked on Power Center Client Tools like Repository Admin Console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Extensively worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzed the source data coming from different sources (Oracle, DB2, XML, QCARE, Flat files) and worked on developing ETL mappings.
• Good experience in installation of Informatica Power Exchange.
• Developed complex Informatica Mappings, reusable Mapplets and Transformations for different types of tests in research studies on daily and monthly basis.
• Implemented mapping level optimization with best route possible without compromising with business requirements.
• Created Sessions, reusable worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Worked on fixing invalid Mappings, testing of Stored Procedures and Functions, and Integration Testing of Informatica Sessions.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Worked extensively on SQL, PL/SQL, and UNIX shell scripting.
• Generated XML files to deliver to Thompson Reuters. we also had to convert the existing First Logic (FL) code into Informatica Data Quality (IDQ).
• Performed Data profiling for data quality purposes.
• Proven Accountability including professional documentation, and weekly status report.
• Performed Quantitative and Qualitative Data Testing.
• Documented flowcharts for the ETL (Extract Transform and Load) flow of data using Microsoft Visio and created metadata documents for the Reports and the mappings developed and Unit test scenario documentation for the mentioned.

Environment: Power Center 7.4, DB2, Oracle 10g, UNIX, Win XP Pro, TOAD, Autosys

Confidential

ETL Developer

Responsibilities:

• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Extensively worked on Informatica client tools like Designer, Workflow Manager and Workflow monitor.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others.
• Created Workflow, Work lets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Extensively involved in migration of ETL environment, Database objects and EDW.
• Tested data integrity among various sources, targets and various performance related issues.
• Debugging and problem resolution in Reports and Forms. Generated master-detail, matrix groups and tabular reports.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center, Windows, Sun Solaris, SQL Server, Oracle 8i, PL/SQL, UNIX Shell Scripting