SUMMARY

• Over 10+ years of experience in systems Analysis, Design, Development, Testing and implementation of Data Warehouse applications.
• Strong knowledge in Informatica Powercenter suite which includes Mapping Designer, Workflow Manager, Workflow Monitor, Admin Console, Repository Manager and Data Quality(IDQ).
• Design, Development, Testing and Implementation of ETL processes using Informatica Cloud
• Worked on Datastage client tools like Datastage Designer, Datastage Director and Datastage Administrator.
• Good Knowledge about Data Warehouse, Data marts, OLTP, OLAP, Dimensional Modeling, Fact tables, Dimension tables and Star/Snowflake schema modeling Excellent in using highly scalable parallel processing infrastructure using parallel jobs with multi - node configuration files.
• Handful working experience in Datawarehousing development with data migration, data conversion and extraction/transformation/loading using Informatica Powercenter and IBM Datastage to extract & load data into relational databases like SQL Server, Oracle, Teradata, DB2.
• Extensive working experience with Powercenter components of Informatica server and client tools like designer, workflow manager, repository manager and workflow monitor.
• Extensively worked with Informatica mapping variables, mapping parameters and parameter files
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files
• Extensively worked with Informatica MDM (Master Data Management) in order to manage the high-volume data.
• Experienced in scheduling sequence, parallel and server jobs using Datastage Director, UNIX scripts and Autosys scheduling tools.
• Effectively used standardized transformation in standardizing the source data by using the existed rule sets like name, address and area etc for multiple countries and generated the valid and invalid data reports in Informatica Data Quality.
• Involved in Building of Customized Rulesets for the countries for which there are no default Rulesets in Data Quality.
• Designed and developed parallel jobs, server and sequence jobs using Datastage Designer.
• Experience in using different types of stages like Transformer, Aggregator, Merge, Join, Lookup, Sort, Copy, remove duplicate, Funnel, Filter, Pivot, Shared containers for developing jobs.
• Worked and extracted data from various data sources such as Oracle, DB2, Teradata, XML and Flat files.
• Developed shell scripts for invoking Informatica workflows and for running batch process.
• Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing and Performance Testing.
• Created local and shared containers to facilitate ease and reuse of jobs.
• Proven track record in addressing production issues like performance tuning, enhancement and memory issues.
• Imported the required Metadata from heterogeneous sources at the project level.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
• Experience in Production Support extensively worked on production support issues like performance monitoring and Job failures.
• Giving the value additions to the project by preparing the understanding documents and providingKnowledge transfer to the new resources in the project regarding the functional and technical aspects ofthe project flows
• Quick learner and adaptive to new and challenging technological environments.
• Project Management experience with excellent problem-solving, organization and leadership skills.

TECHNICAL SKILLS

ETL Tools: Informatica Powercenter, Informatica Cloud, Informatica MDM, IDQ IBM InfoSphere Datastage 11.5/9.1/7.5.2/7.1.1 , Parallel Extender

Databases: Teradata, SQL Server, Oracle, DB2 on Mainframe

Operating Systems: Windows, IBM AIX, SUSE Linux

Data Modeling Method: Logical, Physical Data Modeling, Star-Schema Modeling

Languages: SQL, PL/SQL, C, C++, Korn/Bash Shell Scripting

Scheduler: Autosys, Cron, Control M.

Project Methodology: Agile and Waterfall.

PROFESSIONAL EXPERIENCE

Confidential

Application Technology Management Senior

Responsibilities:

• Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software (Quality Stage v8.1, Web Service, Information Analyzer, Profile Stage, WISD of IIS 8.0.1).
• Prepared Data Mapping Documents and Design the ETL jobs based on the DMD with required Tables in the Dev Environment.
• • Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements & Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the SQL Server database.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Developed complex store procedures using input/output parameters, cursors, views, triggers and complex queries using temp tables and joins.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Creation of jobs sequences.
• Creation of the webservice files by pulling the data from Planisware application.
• Maintained Data Warehouse by loading dimensions and facts as part of project.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool (Autosys).
• Coordinate with team members and administer all onsite and offshore work packages.
• Analyze performance and monitor work with capacity planning.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Participated in weekly and daily status meetings.
• Participated in weekly incidents review meetings.
• Involved in resolving issue tickets related data issues, ETL issues, performance issues, etc.
• Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the session logs
• Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy. Created detailed Test Cases and Test sets and executed them manually.

Environment: IBM Infosphere Data Stage and Quality Stage 11.5, Web Services, SQL Server, Autosys, HP ALM QC center, Putty, Winscp, Accurev, Qlikview Alteryx. Agile Methodology, Planisware.

Confidential

Senior Informatica Consultant

Responsibilities:

• Responsible for feasibility analysis of the requirements from ETL perspective, Client Interaction, Design, Testing, support and Documentation.
• Design scheduling structure of Informatica jobs to be executed within operational calendar.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Developed Cloud mappings to extract the data for different regions.
• Design, Develop and Implement complex Informatica mappings to extract data from various sources (Oracle/Teradata/flat file/xml) using different transformations and Load it in to various target (Oracle/csv/flat-file) data warehouse environments.
• Proactively worked to analyze and resolve all Unit testing and UAT issues.
• Facilitate/lead reviews (walkthroughs) of technical specifications and program code with other members of the technical team.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Worked with database operations and Informatica admin teams to fix performance issues.
• Proactively worked on analyzing the data and data management activities.
• Worked on developing and troubleshoot Stored Procedures, Functions, Cursors and Triggers at Database level using PL/SQL.
• Extensively worked on Change management to promote codes to different environment.
• Validate data in the reports using Micro strategy and provide update on business queries.
• Created Informatica mappings as part of enhancement to fix production bugs.
• Written UNIX shell scripts to automate manual tasks.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Involved in code walkthroughs and documentation.
• Involved in Informatica uplift activities from version 9.1 to 9.6.1 and fixing post migration issues
• Provided on-call support to resolve critical production issues.
• Mentor offshore team on new code implementations/migrations.

Environment: Informatica Cloud, Informatica PowerCenter, SQLServer, Azure Sql Server, Control M.

Confidential

Senior Informatica Consultant

Responsibilities:

• Collaborated with Business People for requirements gathering and Participated in translating the business requirements into technical requirements.
• Involved in effort estimation for the requirements in the project and prepared mapping documents based on client requirement specifications.
• Designed simple and complex mappings using Informatica Powercenter to load the data from source using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy, Normalizer, SQL, Rank and Router transformations into CRDB database (Oracle).
• Worked on Informatica Master Data Management in the process of managing high volume incoming data.
• Extensively used Informatica functions and parameters & variables in the transformations at mapping level.
• Wrote SQL queries for pre-sql and post sql fields in source qualifier transformation with appropriate schema names for extracting only the required rows for optimal performance.
• Worked on Informatica Master Data Management (MDM) in the process of managing high volume incoming data.
• Tested the queries in SQL navigator for integrity and identifying data errors.
• Used Debugger to fix errors in the mappings and to check the data flow.
• Created sessions, event tasks, decision tasks and workflows using Powercenter.
• Partitioned sessions for concurrent loading of data into the target tables.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Developed UNIX Shell Scripts for scheduling the sessions in Informatica.
• Used Pre Session and Post Session to send e-mail to business users through Workflow Manager.
• Created parameter files to change the load date and configured that parameter at session level.
• Used Toad as an advanced SQL,PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures,triggers, and functions to implement business rules.
• Created scripts to migrate data from CRDB Database to CCAR Staging area (SQL server) and developedmappings and workflow in staging area.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions and validations basedn design specifications for unit testing and system testing.
• Worked with the QA team to Trouble shoot and resolve any QA or UAT issues.
• Migrated Mappings from Development environment to QA, QA to Production environment.
• Coordinated with the reporting team to develop the MicroStrategy reports.
• Ongoing support has been provided for production issues by looking after the errors in daily loads andplayed an active role in resolving them.
• Based on the assigned JIRA tickets, added and modified Informatica mappings and sessions to improvePerformance, accuracy, and maintainability of existing ETL functionality as requested by the users.
• Worked on new column additions to existing target and source tables in ETL as per new businessrequirements.

Environment: Informatica Powercenter 9.5, Data Quality, Informatica MDM, SQL Server, Oracle 11g, TOAD, UNIX Shell Scripting, SQL, PL/SQL, MicroStrategy,

Confidential

Senior Informatica Consultant

Responsibilities:

• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access and Flat files.
• Used Informatica data services to profile and document the structure and quality of all data.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Solid Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Used Loader utilities including SQL Loader and Teradata utilities (FASTLOAD, FASTEXPORT, and MULTILOAD).
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
• Used Debugger wizard to troubleshoot data and error conditions.
• Responsible for Best Practices like naming conventions, and Performance Tuning.
• Developed Reusable Transformations and Reusable Mapplets.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Worked with Shortcuts across shared and non-shared folders.
• Responsible for migrating the code using deployment groups across various Instances.
• Optimized SQL queries for better performance.
• Created PRE-SQL and POST-SQL scripts which need to be run at Informatica level.
• Responsible for Unit Testing of Mappings and Workflows.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.

Environment: Informatica-Power Center 9.0.1, 9.5.1, Intormatica Data Explorer, Power ExchangeMetadata Manager, Web Services, Oracle 10g, Teradata V13.10, AutoSys