PROFESSIONAL SUMMARY:

• Over 6 years of experience in IT industry in Analysis, Design, Development and Unit Testing of Data warehousing with Informatica power center Vs 8.6/9.X/10. X.
• Experience in Oracle database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables within committed timelines.
• Expertise in maintaining data quality, data organization, metadata and data profiling.
• Data Analysis experience with user Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Extensive experience with development, testing, debugging, implementation, documentation and production support.
• Worked in data warehouse development life cycle, dimensional modeling, repository management, implementation of Confidential, Snowflake schemas and slowly changing dimensions.
• Knowledge in performance tuning of sources, transformations, targets, mappings, worklets, workflows, sessions and batches.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Experience in using the Informatica command line utility PCMD to schedule and control sessions and batches.
• Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat Files, VSAM files, etc to RDBMS like Oracle, SQL Server etc.
• Proficient in using Informatica Server Manager to create and schedule sessions and batches.
• Experience in PL/SQL Programming (Stored Procedures, Functions and Triggers).
• Experience in UNIX shell scripting, automation of ETL processes using Cron tab.
• Good knowledge in interacting with Informatica Data Quality (IDQ).
• Experience on creating profile, rules and mappings with IDQ.
• Expertise in using Erwin, Designer 2000, Toad, SQL *Loader and PVCS.
• Well experienced in designing and developing master/detail, cross tab, drill - down, chart, adhoc and complex reports using BI tools like Business Intelligence.
• Excellent communication, client interaction and problem-solving skills.
• Expert in Dimensional Data Modeling, using Data Modeling, Confidential -Join Snowflake Schema Modeling, FACT & Dimensions Tables, Logical & Physical Data Modeling using ERWIN and Oracle Designer.
• Proficient in generating reports using Business Objects, XI R2 functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
• Solid Expertise in Oracle Stored Procedures, Triggers, Index, Table Partitions and experience in Loading data from Flat Files, XML Files, Oracle, DB2, SQL Server into Data Warehouse/Data Marts using Informatica.
• Expertise in RDBMS, database Normalization and Denormalization concepts and principles.
• Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Oracle.
• Created tables and views based on the layout sent by Clients.
• Created mapping documents and work flows and data dictionaries.
• Good knowledge of Data Warehouse concepts and principles - Confidential Schema, Snowflake, SCD, Surrogate Keys, Normalization/ De-normalization.
• Very well conversant with Oracle 9i/10g/11g and SQL Server 2005/2008, Analytical Functions, Database Design, Query Optimization and Performance tuning.
• Experience with IMPORT/EXPORT, Data-Pump, Sql-Loader and built-in packages in Oracle.
• Worked extensively in Development of large Projects with complete END to END participation in all areas of Software Development Life Cycle and maintain documentation.
• Quick adaptability to new technologies and zeal to improve technical skills.
• Good analytical, programming, problem solving and troubleshooting skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.2/9.6/9.1/8.6/8.5/8.1 , IDQ (Informatica Data Quality) (Workflow Manager, Workflow Monitor, Repository manager and Informatica Server).

Databases: Oracle 8.x/9i/10g/11g, DB2, MS SQL Server 2000, Sybase, Oracle Express

Database Utilities: SQL Plus, Oracle DBA Studio, SQL Loader, ODBC, Toad, Erwin, PVCS, Designer 2000 and Discoverer 2000 and MSVisio

Control: M, Autosys

Languages and Packages: SQL, PL/SQL, Shell Scripting (Csh, Ksh, Bourne), Cobol

Operating Systems: Unix (Sun-Solaris, HP-UX, AIX), Windows 95/98/NT/2000/XP

Testing Tools: Mercury Test Director

IBM 3090, IBM ES: 9000, Z OS/1.8 IBM Compatibles

PROFESSIONAL EXPERIENCE:

Confidential, Milford, MI

Sr. ETL/Informatica Developer

Responsibilities:

• Performed data analysis and gathered columns metadata of source systems for understanding requirement feasibility analysis.
• Analyzed business requirements, designs and wrote technical specifications to design/redesign solutions.
• Involved in complete software development life cycle (SDLC) including requirement gathering, analysis, design, development, testing, implementation and deployment.
• Developed technical design documents (HLD and LLD) based on the functional requirements.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Created and maintained source-target mapping documents for ETL development team.
• Provided requirement specifications and guide the ETL team for development of the ETL jobs through Informatica ETL tool.
• Developed Mappings and Workflows to generate staging files.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Worked on multiple projects using Informatica developer tool (IDQ) of latest versions 9.x.x.
• Involved in migration of the maps from IDQ to power center.
• Applied the rules and profiled the source and target table's data using IDQ.
• Created multiple Mapplets, Workflows, Tasks, database connections using Workflow Manager.
• Recovered the failed Sessions and Batches.
• Extracted the data from DB2, CSV and Flat files.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance. Understanding the Functional Requirements.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Worked closely with analysts to come up with detailed solution approach design documents.
• Developed test cases and testing.

Environment: Informatica Power Center 9.6, Informatica Power Exchange 9.1, oracle 11G, HP-Unix, Informatica Data Quality (IDQ), Windows NT/2000, DB2 Visualizer, File Zilla etc.

Confidential, San Antonio, TX

Sr. ETL/ Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center 9.1 Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ)
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one-time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables. Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Rank, Update, Router and Sequence generator.
• Developed and scheduled Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Did performance tuning at source, transformation, target, and workflow levels.
• Used PMCMD, and UNIX shell scripts for workflow automation.
• Wrote PL/SQL stored procedures using Toad.
• Used Informatica Power Analyzer and Informatica Analytics for developing Dashboards, Alerts, Reports, Indicators and adhoc Query Reporting.
• Used PVCS for version control.
• Applied Velocity methodology throughout the development life cycle of application.

Environment: Informatica Power Center 9.6, Informatica Data Quality (IDQ), I, ORACLE 9i, Oracle Apps 11.0/10.7, DB2 UDB, HP-UX, Windows NT/2000, TOAD, PVCS 6.7.10, Win SCP, Erwin.

Confidential

ETL/Informatica Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 9.0.1
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings, which involved Slowly Changing Dimensions, implementation of Business Logic, and capturing the deleted records in the source systems.
• Installed and Configured Informatica Power Center client tools and connected with each database in Data Ware house using repository server. Check the data quality using IDQ.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Coded PL/SQL scripts.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process
• As a Data Warehousing team member, involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the banking data from various source systems feeds using Informatica, PL/SQL and Unix Shell scripts.
• Involved in Data Extraction, Staging, Transformation and Loading and worked with Oracle Application Integration
• Creating Informatica mappings for populating the data into dimension tables and fact tables from ODS tables.
• Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations.
• Created Informatica Mappings with PL/SQL procedures/functions to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and update strategy.
• Created sessions and batches. Used parameter files to pass variable values.
• Generated Reports using Business Objects.
• Created Dimension objects keeping in view of the end-user requirement. Created User Prompts, Conditions and Filters to improve the report generation.
• Used Hierarchies for providing drill down options for the end-user.
• Created Master Detail and Cross Tab Reports.

Environment: Informatica Power Center 9.0.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 11g, UNIX, Flat files, Windows XP professional, SQL, PL/SQL, SQL Server 2000, DB2, IBM AIX, Win SCP, Windows 2000/NT. Environment.

Confidential

ETL Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a Confidential schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Pulling data from multiple data sources like redshift, Flat files and Json files.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Scripted complex SQL queries and procedures and executing them using informatica.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.
• Wrote shell scripts to transfer files from multiple sftp/ftp servers to informatica local servers.

Environment: Informatica Power Center 9.XX, 10.2.0 (Power Center Designer, workflow manager, workflow monitor), UNIX, Oracle, Sql-server, AWS