SUMMARY:

• Over 12 years of experience in Informatica PowerCenter development.
• Strong experience in ETL using Informatica PowerCenter (Mapping Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, Mapplet Designer, and Repository manager).
• Good exposure on optimizing the SQL and performance tuning using Explain Plan.
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post - implementation review.
• Creating detail technical design document and user manual for new joiners.
• Experience in SQL, T-SQL, PL/SQL, SQL Loader, SQL Plus and MS-SQL.
• Extensive knowledge on the PowerCenter components as PowerCenter Designer, PowerCenter Repository Manager, Workflow Manager and Workflow Monitor.
• Thorough knowledge in creating ETLs to perform the data load from different data sources and good understanding in installation of Informatica.
• Experienced in developing the mappings and transformations using PowerCenter Designer and executing the mappings through Work Flow Manager from multiple sources to multiple targets.
• Knowledge in full life cycle development of data warehousing with experience in ensuring quality and compliance to coding standards.
• Good experience with data cleansing, data analysis, data profiling and necessary test plans to ensure successful execution of the data loading processes.
• IBM data quality tools of DataStage were used to help with the cleansing for migration.
• Hands on experience using Pushdown Optimization (PDO).
• Good experience with data cleansing, data analysis, data profiling and necessary test plans to ensure successful execution of the data loading processes.
• Strong at developing complex mappings with custom transformations and XML Sources.
• Experienced in developing Stored Procedures, Functions, Views and Triggers, SQL queries using SQL Server and Oracle PL/SQL.
• Involved in understanding client requirements, analysis of functional specification, technical specification preparation and review of technical specification.
• Involved in the identification of bugs and enhancement of existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experienced with industry Software development methodologies like Waterfall, Agile within the software development life cycle.
• Excellent communication skills and ability to work effectively and efficiently in teams and individually.

TECHNICAL SKILLS:

Informatica Power Center 9.x/8.x Oracle 10g, SSRS, SQL Server DB2, MS Access 2000, SQL, PL/SQL, Transact SQL, UNIX Shell Scripting, Java, DOS, Windows 98, 2000, XP, Vista, Win7, Win 8, UNIX, TOAD for Oracle/Data Analysts, HP Quality Center, HP Service Manager, DataStage, COBOL/JCL/REXX

PROFESSIONAL EXPERIENCE:

Confidential, Livonia, MI

Senior ETL Developer

Responsibilities:

• Involve in requirements gathering, data modeling and designed Technical, Functional & ETL Design documents.
• Implement mappings to extract the data from various sources VSAM file/Mainframe DB2/Oracle, XML files and load into oracle and Teradata using Teradata utilities like MLoad, TPump and Fast Export.
• Design and implement slowly changing dimension mappings to maintain history.
• Use PowerExchange to capture the changes in the source data.
• Created Complex mappings for delivering the incremental comparative reports to the EPIC team. These extracts contain changes after the comparison between the MDM EPIC data brought into MDM to the PVD (Provider verification data).
• Use Teradata utility FastLoad for bulk loading and TPump and MLoad utilities for loading less and larger volumes of data.
• Designed and developed Technical and Business Data Quality rules in IDQ (Informatica Developer) and created the Score Card to present it to the Business users for a trending analysis (Informatica Analyst).
• Tuned performance of Outbound ETL. Performed CDC based on MDM last update date, which is indexed and maintained by MDM. Used the parameterization template mapping/session for each base object, and had that as first task in the Workflow.
• Implement ETL balancing process to compare and balance data directly from source and warehouse tables for reconciliation purposes.
• Create and work with generic stored procedures for various purposes like truncate data from stage tables, insert a record into the control table, generate parameter files etc.
• Design and develop staging and error tables to identify and isolate duplicates and unusable data from source systems.
• Simplify the development and maintenance of ETL by creating Mapplets, Re-usable Transformations to prevent redundancy.
• Write and implement generic UNIX and FTP scripts for various purposes like running workflows, archiving files, to execute SQL commands and procedures, move inbound/outbound files.
• Design and execute test scripts to validate end-to-end business scenarios.
• Use session partitions, dynamic cache memory and index cache to improve the performance of ETL jobs.
• Implement mappings to extract the data from various sources VSAM file/Mainframe DB2/Oracle, XML files and load into oracle and Teradata using Teradata utilities like MLoad, TPump and Fast Export.
• Resolve complex technical and functional issues/bugs identified during implementation, testing and post production phases.
• Identify and document data integration issues and other data quality issues like duplicate data, non-conformed data and unclean data.
• Assist team members in functional and integration testing.
• Automate and schedule Workflows, UNIX scripts and other jobs for the daily, weekly, monthly data loads using AutoSys Scheduler.
• Create standard reports using business objects features like combined queries, drill down, drill up, cross tab, master detail etc.

Technical Environment: Informatica PowerCenter 9.1/8.6, Oracle 11/10g, PL/SQL, Teradata 13.1, AutoSys, TOAD 9.x, Tableau, Informatica Data Quality (IDQ), Oracle Financials, Shell Scripting, Oracle SQL *Loader, OBIEE, SSIS, Sun Solaris UNIX, Windows-XP

Confidential, Phoenix, AZ

ETL Developer

Responsibilities:

• Interacted with business and analysts to create the functional specs.
• Worked on a project, where we are sourcing the data from the MDM tables and bringing in to the Netezza dB and creating dimension and fact mappings based on the business logic for the reporting team.
• Reviewed and created the design required to support all reporting needs.
• Got signoff on report and dashboard template.
• Built logical data objects (LDO) and developed various mappings, Mapplet/rules using Informatica data quality (IDQ) based on requirements to profile, validate and cleanse the data.
• Optimized the SSRS reports through the use of aggressive scoping of data and judicious use of aggregate tables and materialized views and Caching techniques.
• Created SQL Server reports, handled sub reports and defined query for generating drill down reports and drill through reports using SSRS 2005/2008.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel spreadsheet.
• Developed reports and intelligent dashboards for global sales team.
• Involved in performance tuning required for slow running reports, designing of performance enhancing structures on database.
• Coordinated with database administrator team to make sure database gets executed correctly at DataStage and production instances before loads can start.
• Used nested stored procedures with complex control flow logic to feed SSRS reports.
• Reverse engineered the data model from ERwin.
• Created DataStage tables/mappings/setting the trust level -HDD in Siperian for Customer Master System.
• Used the metadata of Informatica repository tables
• Modeled OBIEE RPD to use Informatica Repository tables to generate reports for ETL loads
• Implemented Mappings to extract the data from various sources VSAM file/Mainframe DB2/Oracle, XML files and load into oracle and Teradata using Teradata utilities like MLoad, TPump and Fast Export.
• For tracking the current status of loads, current/historic performance, throughput, differentiating long running jobs, view performance trends for individual Informatica sessions and developed metrics to view ETL performance.
• Used statistical functions like regression to view the performance trends.

Technical Environment: Oracle Business Intelligence Suite) OBIEE 11.1.6/11.1.5 , Informatica PowerCenter 9.5.1, Informatica Multi-Domain MDM 9.1, SSIS, SSRS, Informatica B2B DX DT v 8.0, Informatica Data Quality (IDQ), Oracle 10g/11g, BI Publisher, TOAD, Teradatav12, SQL, SQL Server 2000/2005, Redgate, Windows 7

Confidential, Chanhassen, MN

ETL Developer

Responsibilities:

• Analyzed the source data coming from different sources and worked with business users and developers to develop the Model.
• Involved in dimensional modeling to design and develop STAR Schema, Using ER-win to design Fact and Dimension Tables.
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mappings and complex transformations (Aggregator, Joiner, Lookup (Connected and Unconnected), Source Qualifier, Filter, Update Strategy, Stored Procedure, Router and Expression).
• Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for different types of tests in customer information, monthly and yearly loading of data.
• Fixed invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extracted data from various sources like IMS Data Flat Files and Oracle.
• Used environment SQL commands in workflows prior to extracting the data in the ETL tool.
• Wrote complex SQL scripts to avoid Informatica joiners and Lookups to improve the performance, as the volume of the data was heavy.
• Created sessions, reusable worklets and batches in workflow manager and scheduled the batches and sessions at specified frequency.
• Created Stored Procedures for data transformation purpose.
• Monitored the sessions using Workflow Monitor.
• Used stored procedures to create a standard time dimension, drop and create indexes before and after loading data into the targets.
• Worked with Teradata BTEQ utilities for ETL development and design.
• Removed bottlenecks at source level, transformation level and target level for the optimum usage of sources, transformations and target loads.
• Created Mappings, Mapplets and Transformations, which remove any duplicate records in source.
• Implemented efficient and effective performance tuning procedures.
• Performed benchmarking and these sessions were used to set a baseline to measure improvements against.
• Tuned source system and target system based on performance details, when source and target were optimized, sessions were run again to determine the impact of changes.
• Used ServerManager to create schedules and monitor sessions. And to send the error messages to the concerned personal in case of process failures.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.

Technical Environment: Informatica Version 9.1, Oracle 9i, Teradata v2r6, UNIX Shell Scripting, SQL Server 2008, SQL, PL/SQL

Confidential, Groton, CT

Sr. Informatica Developer

Responsibilities:

• Analyzed, designed and developed Business Intelligence technical solutions leveraging off the shelf technologies such as OBIEE and Informatica.
• Participated in the full development life cycle from developing business intelligence requirements to QA and production deployment.
• Adhered to best Data Warehousing practices when modeling Business Intelligence solutions
• Designed STAR Schema Data Warehouse Models using Facts and Dimensions
• Enhancing the existing mappings to implement SCD Type 2.
• Oversaw ongoing development and operations of Oracle 11g and 10g enterprise data warehouses (ETL using SAP Data Integrator/Data Services, PL/SQL, Oracle Data Integrator, and SSIS).
• Backup support for Sybase and underlying database. Participated in unit, system, acceptance, and validation tests.
• Involved in extracting source data from spreadsheet and flat files both Direct and Indirect.
• Created SSIS Packages to migrate slowly changing dimensions. Expert knowledge SQL Queries, Triggers, PL/SQL Procedures, Packages to apply and maintain the Business Rules.
• Communicated both functional and technical designs and changes to all appropriate agents
• Collaborated with and mentored current development staff in the use of Business Intelligence (OBIEE), Informatica and Oracle coding language based on numerous prior development activities in these environments.
• Worked with financial executives to design and develop financial reports/budgets. Built database and ETL (transform and load) process in SQL Server (SSIS).
• Developed mappings to extract data from SQL Server, Oracle, Flat files, DB2, Mainframes and load into Data warehouse using the PowerCenter, Power exchange.
• Utilized prior knowledge of related tools and obtained knowledge of other technologies in support of the organization projects.
• Created SQL queries to pull out data and metrics from the database and assisted in creating the Physical database for MDM and the Data Mart.
• Worked as an MDM global Business Process Analyst ensuring the smooth flow of business activities for Asia pacific region.
• Evaluation and selection of various MDM technologies and products in view of the client requirements.
• Executed PL/SQL on oracle table in order to view successful transaction of data and Built reports and report models using SSRS to enable end user report builder usage.
• Worked on SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Translates data file formats (ETL) in Access, Microsoft Import/Export Wizard, SSIS. Strong experience in RUP Business modeling process.
• Responsible for the data management and data cleansing activities using Informatica data quality(IDQ)
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Responsible for the data management and data cleansing activities using Informatica data quality(IDQ)
• Involved in OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDM.
• Utilized Informatica Data Quality (IDQ) for data profiling and matching/removing duplicate data, fixing the bad data, and fixing NULL values.
• Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Worked on SQL tools like TOAD and SQL Developer to run SQL Queries and validate the data.
• Scheduled Informatica Jobs through Autosys scheduling tool.

Environment: Informatica Power Center 9.1, Informatica Data Quality (IDQ) 9.0.1, Informatica IDQ Analyst,Windows-XP (Client), Informatica Data Quality (IDQ), Power Designer, Power Exchange, Work Flows, ETL, Oracle 11g, Teradata, XML, SSRS, Web-Services, MS SQL Server, TOAD 9.6.1, Unix Shell Scripts, Autosys.

Confidential

Programmer Analyst

Responsibilities:

• Involved in understanding and capturing of requirements.
• Extracted business rules, entity relationship models, process models and cross reference in the application.
• Prepared high level/low level design documents.
• Worked on the analysis, development and testing phases of the project.
• Constructed new COBOL and DB2 programs as per specifications and standards provided by Citi Cards.
• Involved in the quality check and standards of the program using ASA tool for technical issues while testing.
• Created own region for testing
• Converted VSAM files to DB2
• Involved in the Unit Testing and User Acceptance Testing (UAT) and ensure the completeness of the testing.
• Managed resolution of UAT issues.
• Involved in modelling the UAT regions.
• Ran a series of programs in a chain so as to simulate the testing as it takes place in production environment.

Technical Environment: PowerCenter, IBM Mainframe, OS/390 JCL, COBOL, SQL, DB2, VSAM, File-AID, Spufi, ChangeMan