SUMMARY

• Over 6+ years of extensive experience with Informatica PowerCenter in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica PowerCenter 10.x/9.x/8. x.
• Data Analysis experience with user Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Extensive working experience in design and development of Data warehouse, marts and ODS.
• Worked on Data warehousing development with data migration, data conversion and extraction/transformation/loading using Informatica PowerCenter to extract & load data into relational databases like SQL Server, Oracle, Teradata, DB2.
• Extensive work experience in Informatica Data Integration Tools - Such as Repository Manager, Designer, Workflow Manager, Workflow Monitor and Scheduled workflows using Workflow Manager.
• Experience in Informatica PowerCenter for Data integration between source & Target which includes development of Joiner, Aggregator, Lookup, Salesforce Lookup, Router and Sorter transformations.
• Extensively worked with Informatica mapping variables, mapping parameters and parameter files.
• Experience in several facts of MDM implementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match, Data Load, Data Migration, Trust Score validation.
• Experience in working with business analysts to identify and understand requirements in order to create Technical Design Documents.
• Excellent communication, client interaction and problem-solving skills.
• Extensive knowledge in optimizing techniques such as concurrent caching, Auto memory calculations, partitioning and using push down optimization.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle12c /Oracle11g, MS SQL Server, DB2, XML files and Flat Files into the staging area, Data Warehouse and Data Mart.
• Strong experience with star and snow flake schema, dimensional Data Modelling, facts, dimensional and slowly changing dimensions.
• Implemented Slowly Changing Dimensions (SCD) Type 1 and Type 2 for initial and history load using Informatica. knowledge of Informatica CDC (Change Data Capture) Implementation experience of CDC using stored procedures, triggers and using Informatica power exchange.
• Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expertise in RDBMS, database Normalization and Denormalization concepts and principles.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Developed shell scripts for invoking Informatica workflows and for running batch process.
• Extensive experience in designing the architecture for extract, transformation, load environment and development of mapping and process using Informatica PowerCenter.
• Experienced in Performance Tuning at Mapping, Session and database level, tuning mappings, Pipeline Partitioning to speed up data processing.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experienced in using different scheduling tools - Control-M, Auto Sys, Maestro/TWS & Cron Job.
• 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.
• Created mapping documents and workflows and data dictionaries.
• Excellent analytical skills in understanding client’s organizational structure.
• Excellent problem-solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10.x/9.x/8.x, Informatica Master Data Management (MDM), Data Quality Tool (IDQ), Informatica Cloud.

Database: Oracle 12c,Oracle 9i/10g/11g, SQL Server 2014/2008/2005 and Teradata 14.0

Data Modeling Tools: Erwin 4.1, TOAD, MS Visio, SQL *Loader, Star and Snow Fake Schema.

Scheduling Tools: TWS, Auto Sys, Maestro, Cron Tab, Control - M, Informatica Scheduler

Languages: SQL, T-SQL, PL/SQL, C, C++

Scripting Languages: UNIX Shell Scripting, Korn Shell, Bash shell scripting

Operating Systems: Windows, MSDOS, Linux, Unix, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Informatica/Data Warehouse Developer

Responsibilities:

• Created mappings using Designer and extracted HR and Payroll data from various sources like Flat file, relational sources, XML, Normalized data and transformed data according to the requirement.
• Responsible for Business Analysis and Requirements gathering.
• Front end used for HR and Payroll processing was Oracle PeopleSoft and Analytical database was Oracle.
• Worked on Informatica PowerCenter tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Worked with heterogeneous source to Extracted data fromOracle database, XML and flat files and loading to a relational Oracle warehouse.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Performed tuning of SQL queries and Stored Procedures for speedy extraction of data, to resolve and troubleshoot issues in OLTP environment.
• Captured data changes with the help of SCD Type 1 and Type 2 mappings and also utilized MD5 to accomplish Dimension, Facts and error record loading.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Troubleshooting of long running sessions and fixing the issues related to it.
• Created UNIX shell scripts to facilitate moving and archiving of files in folder. Also created shell script to dynamically create list file to load multiple flat files into a table.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Involved in the development of PL/SQL stored procedures, functions and packages to process business data in OLTP system.
• Developed mapping parameters and variables to support SQL override.
• Carried out changes into Architecture and Design of Oracle Schemas for both OLAP and OLTP systems.
• Worked with Services and Portal teams on various occasion for data issues in OLTP system.
• Worked with the testing team to resolve bugs in ETL mappings before migrating to production.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Worked with production team to resolve data issues in Production database of OLAP and OLTP systems.
• Designed Informatica Mappings and Workflows to be re-star table after a failure.
• Designed tables required for the execution of the ETL processes using Erwin.
• Extracted data stored in a multi-level hierarchy using Oracle Stored Procedures.
• Loaded Customer data in multiple levels (rows) using Oracle Stored Procedures and Cursors.
• Used XML Parsers and Generators to handle inbound and outbound XMLs in Informatica.
• Loaded Dimension, Fact and Exception tables and automated email generation when exceptions occurred.
• Provided excellent support during QA/UAT/Beta testing by working with multiple groups.
• Optimized the SQLs and Informatica mappings which handled millions of records.
• Improved performance using Oracle Partitions, Indexes and other Performance Tuning techniques.
• Developed re-usable components in Informatica, Oracle and UNIX
• On-Call/Production Support provided during day-time and off-hours.
• Actively participated in Install/Deployment plan meetings.
• Proved accuracy in doing sanity checks, smoke tests after the install of new scripts used by ETL.
• Prepared Data Mapping documents, process documents, Re-start ability Matrix to help on-call team reduce the turnaround time when there is an issue.
• Efficiently handled multiple projects during resource crunch.
• Provided Training to the team with the functional and technical knowledge.

Environment: Informatica PowerCenter 10.1/9.6, Workflow Manager, Workflow Monitor, Informatica PowerConnect/PowerExchange, Data Analyzer 8.1, Toad, PL/SQL,SQL loader, Linux, Teradata, Micro Strategy and Tableau.

Confidential, NY

Sr. Informatica/Data Warehouse Developer

Responsibilities:

• Created the technical documentation of the architecture of the data warehouse, including the physical components and their functionality following the client standards.
• Worked on building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created stored procedures, views, user defined functions and common table expressions.
• Designed appropriate ETL routines and mappings using Informatica PowerCenter 9.6.1/9.1 based on the requirements and technical designs.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Dimensional data modeling using Data Modeling, Star Join Schema/Snowflake modeling, fact and dimensions tables, physical and logical data modeling using ERWIN data modelling tools.
• Assisted in designing the technical solution based on business requirements, including the structure of data warehouse fact and dimension tables, as well as the management of allocated dollars, custom-defined hierarchies and ledger-based transactional data using historical facts, slowly changing dimensions, and durable keys.
• Conducted unit testing on data model changes, ETL, and data warehouse loads to ensure accurate results within the context of defined requirements. Review unit testing conducted by other developers and provide feedback on methodology and identify gaps in assumptions that undermine the integrity of results.
• Written PL/SQL scripts created stored procedures and functions and debugged them.
• CreatedIDQ mappings using Consolidation, Key Generator, Match, Merge, Exceptional, Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica PowerCenter.
• Created Mapplets, reusable transformations and used them in different mappings. Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Used Informatica PowerCenter for extraction, loading and transformation (ETL) of data in the data warehouse.
• Gathered data from different kind of sources like Excel, Flat files, Sql server and Oracle etc.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads and Developed reports based on issues related to the data warehouse.
• Created profiles, rules, scorecards for data profiling and quality using IDQ.
• Worked on improving data warehouse solutions by translating business requirements into robust, scalable, and supportable solutions that work well within the overall system architecture.
• Scheduled Jobs using the IDQ Scheduler by Deploying the Workflow's as an Application to the Data Integration Service for running the workflows.
• Used debugger to test the mapping and fix the bugs and identified the bottlenecks in all levels to tune the performance and Resolved the production support tickets using remedy.
• Transformed bulk amount of data from various sources to Teradata database by using BTEQ, MLOAD and TPUMP scripts.
• Collaborated with our Data Warehousing peers, leads and other stakeholders to further expand and develop the Enterprise Data Warehouse platform.
• Transferred data using Teradata utilities like SQL Assistant, Fast Export and Fast Load.
• Developed monitoring scripts in UNIX and moved Data Files to another server by using SCP on UNIX platform.

Environment: Informatica PowerCenter 10.1,InformaticaData Warehouse, IDQ, MDM, Teradata, Oracle, Teradata, SQL Server 2014, Autosys Scheduler Tool, UNIX, Toad, PL/SQL, Power Connect, DB2.

Confidential - Long Beach, CA

Informatica/Data Warehouse Developer

Responsibilities:

• Involved in Designing High Level Technical Documentation based on specification provided by the Manager.
• Involved in planning, building, and managing successful large-scale Data Warehouse and decision support systems.
• Worked on PowerCenter9.5 Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Requirement gathering and Understanding of the Functional Business processes and Requirements given by the Business Analyst.
• Created Teradata External loader connections such as M Load, Upsert and Update, Fast load while loading data into the target tables in Teradata Database.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Extensively used Informatica PowerCenter for extracting, transforming and loading into different databases.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ)
• Writing complex SQL queries for extracting the data, to perform Data Analysis and Data Validation.
• Extensively used Teradata Utilities like Fast-Load, Multi-Load, BTEQ & Fast-Export.
• Created and monitored workflows and tasks using Informatica PowerCenter Work flow Manager.
• Performance tuned ETL processes at the mapping, session and Database level.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2008 with high volume data.
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Involved in end to end system testing, performance and regression testing and data validations and Unit Testing.
• Performed Testing, Debugging, Validation and Performance Tuning of Data Warehouse to develop optimum solutions for data warehouse deliverables.
• Involved creating the tables in Teradata and setting up the various environments like DEV, SIT, UAT and PROD.
• Analyzed the existing application programs and tuned SQL queries using Execution planned SQL Profiler.
• Analyzed newly converted data to establish a baseline measurement for dataquality in data warehouse.
• Managed Change Control Implementation and coordinating daily, monthly releases and reruns.
• Used UNIX scripts for automating processes.

Environment: Informatica PowerCenter 9.1.0, Informatica Data Warehouse IDQ, MDM, Teradata, DB2, Oracle 11g, PL/SQL, TOAD, SQL SERVER, XML, UNIX, Windows.

Confidential

ETL/Informatica Developer

Responsibilities:

• Created high level design, technical design documents and mapping documents based on business requirements
• Responsible for defining the naming standards for data warehouse.
• Created program to implement Change Data Capture CDC using Informatica to perform inserts, updates, and delete operations.
• Develop and maintain data models and data maps for data warehouse system and operational data store.
• Used Change Data Capture (CDC) to simplify ETL process when working in data warehouse applications.
• Created Informatica tasks and workflows to execute ETL processes.
• Wrote complex SQL Query as per business requirement to fetch the data from relational tables.
• Optimized complex SQL query to improve performance.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Created Slowly Changing Dimension SCD type1, type2, Slowly Growing Targets, and Simple Pass Through Informatica mappings to meet business requirements.
• Worked on XML source/target and used XML Source Qualifier, XML Parser and XML Generator transformation.
• Using Informatica PowerCenter created mappings and mapplets to transform the data.
• Performed Unit testing, Integration testing/User Acceptance testing for ETL/SQL/Unix script codes
• Developed UNIX shell scripts to run the workflows and SFTP source/target files from various systems and Informatica process automation
• Executed Autosys command/box to run the Informatica workflows.

Environment: Informatica PowerCenter 9.6 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Autosys, DB2, Oracle12g, TOAD, SQL*Plus, Windows, UNIX, Shell Scripting