SUMMARY

• 8+ years of IT experience in System Analysis, Design, coding and testing of Data Warehousing implementations using Informatica PowerCenter 7.x/8.x/9.x.
• Managed all phases of ETL development on assigned projects including reviewing technical documentation, allocating ETL development work, conducting design reviews, coordinating packaging and release deployments and testing of solutions in highly complex environments.
• Proficient in using Informatica PowerCenter clients such as Repository Manager, Mapping Designer, Workflow Designer and Workflow Monitor.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier, XML parser Transformation.
• Worked extensively with Dimensional modeling (Star schema and Snowflake schema), Data migration, Data cleansing, ETL Processes for data warehouses
• Data and Database Migration including Mainframe to PC database conversions and Data Mapping, retrieval, cleansing, consolidation, mapping, and reporting for client review.
• Worked exclusively on implementing the types of slowly changing dimensions (SCDs) - Type 1 and Type 2 in different mappings as per the requirements.
• Experience in UNIX Shell Scripting.
• Experience in using the Informatica command line utilities like pmcmd to control workflows in non-windows environments.
• Good understanding in writing Test plans, Test cases, Unit testing, System testing, Integration testing and Functional testing.
• Knowledge about the architecture of the Teradata database and experience in Teradata Unloading utilities like Fast export.
• Involved in Writing, testing and implementation of the PL/SQL triggers. Stored procedure, function, packages and complex SQL queries for extracting the data to system.
• Involved in Performance Tuning of the Data Warehouse.
• Good knowledge in Reporting tools like Cognos, OBIEE.
• Good knowledge in interacting with Informatica Data Explorer (IDE), and Informatica Data Quality (IDQ) using different transformations.
• Knowledge in Informatica Master Data Management (MDM) concepts.
• Worked with Informatica Powercenter Express client tool Informatica Developer
• Extensive experience in Software Development Life Cycle (SDLC) of data warehouse systems.
• Strong skills in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
• Worked with various SQL Editors such as TOAD and SQL Plus.
• Experience working on Informatica Scheduler for job scheduling.
• Knowledge of JavaScript and HTML.
• Knowledge of Python.
• Ability to achieve project goals within project constraints such as scope, timing and budget.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently.
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.

TECHNICAL SKILLS

Databases and tools: Oracle 8i/9i/10g/11g, Oracle financials R12/11i, Microsoft SQL Server 2005/2008, Teradata 13/14, MS Access, SQL Developer, Netezza 7.0, Toad

ETL Tools: Informatica Power Center 7.x/8.x/9.x., Informatica Data Quality,Informatica Power exchange, Informatica BDE, Pentaho Data Integration, web services, SSIS, Talend RTX 4.1, Informatica B2B Data Transformation Studio 8.6

Data Modeling: Erwin

Scheduling: Informatica Scheduler, Tidal, CA Autosys 11.3

Reporting tools: OBIEE, Cognos

Languages: SQL, PL/SQL,T-SQL, C, UNIX Shell Scripting

Operating Systems: Microsoft Windows (XP, 7, 10), Mac 9, X, UNIX, Linux

Packages: Microsoft Suite (Project, Visio, excel, access, word, PowerPoint )

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Informatica ETL Developer

Responsibilities:

• Designed and developed ETL processes to load data from wide range of sources like flat files and Oracle Databases using Informatica.
• Extensively used Informatica client tools Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor,
• Developed various mappings and mapplets using different transformations like Source qualifier, Joiner, filter, sorter, aggregator, update strategy, sequence generator, lookup, normalizer, update strategy, router, XML, SQL Transformations in the mappings.
• Involved in working with mapping variables and parameters.
• Created reusable Transformations and mapplets.
• Optimized the current mappings and workflows and ensured daily repository backup is taken.
• Involved in testing the mappings by creating and executing unit test plans based on system and validation requirements.
• Successfully Implemented Slowly Changing Dimensions. Used Type 2 dimension with date time stamping to keep the history of changes.
• Customization designs and work around for various business requirements in R12.
• Involved in versioning and managing/deployment groups in Informatica environment.
• Experienced in writing complex SQL queries and PL/SQL Functions/Procedures.
• Involved in performance tuning of ETL processes and optimization of SQL queries.
• Setting up Sequential and Concurrent Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Used Teradata utilities fastload, multiload, tpump to load data.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Used Teradata system Priority Schedule in controlling the load of the system.
• Involved in Writing Shell scripts to automate the Pre-Session and Post-Sessions Processes.
• Configured and used the Debugger to troubleshoot the Informatica mappings.
• Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Collect and link metadata from diverse sources, including relational databases Oracle, XML and flat files.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Worked with Stored Procedure Transformation for time zone conversions.
• Involved in identifying application bottlenecks and opportunities to optimize performance.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.

Environment: Informatica Power Center 9.6/9.5, Informatica Power Center Express, Oracle 11g, Oracle Financials R12/ 11i/ 11.5, PL/SQL, SQL*Plus, UNIX, Teradata 13, SQL Server 2008, Web services, UNIX Shell scripting.

Confidential, San Francisco, CA

Informatica ETL Developer

Responsibilities:

• Designing and understanding mappings for extracting & loading data to/from heterogeneous sources including Oracle/ SQL Server databases to optimize data workflows and ensure data quality.
• Worked extensively across fixed width flat files, handled the null records, exceptional records, space records and gained hands on with data level accuracy.
• Used Mapplets, Parameters, User defined functions (UDF) to implement object orientation techniques and facilitate the reusability of code.
• Created mappings with various transformations like source qualifier, expression, stored procedure, router, update strategy, lookup, aggregator, union to handle complex queries.
• Worked on Slowly Changing Dimensions (SCD) Type 1, 2 and 3 to keep track of historical data.
• Installed B2B data exchange, server plugin, client plugging and configuring with PowerCenter.
• Setting up Applications, creating partners, creating templates and assigning profile Id's.
• Configured source files with profile Id's in dx-configuration.xml file.
• Created JMS services to read source file for each partner and assigning to real-time workflow.
• Configured JMS to pass source as BUFFER and pass DataByReference to Data Transformation.
• Installed Data Transformation Engineer Studio.
• Involved in Writing Shell scripts to automate the Pre-Session and Post-Sessions Processes.
• Involved in Unit testing and System Testing of Informatica mappings and Workflows.
• Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Worked with Informatica Data Explorer (IDE), and Informatica Data Quality (IDQ) using different transformations like Parser, labeler, Address Doctor.
• Extracted source data from COBOL files using Informatica tools and created mapping using transformation mainly Normalizer, Lookup, Expression.
• Wrote complex SQL Queries involving multiple tables with joins.
• Created flexible mappings/sessions using parameters and variables
• Created ETL jobs to generate and distribute reports from MySQL database using Pentaho Data Integration.
• Used various functions like round, replace and different kinds of date functions to compare the data elements across the feeds for consistency.
• Setting up Sequential and Concurrent Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Extensively used various Performance tuning Techniques to improve the session performance (Partitioning etc.)
• Data migration from Oracle Environment to Hadoop Hbase Environment.

Environment: Informatica Power Center 8.6/9.5, Informatica Power exchange 9.0, Informatica Data Quality, Informatica B2B Data Transformation Studio 8.6, Informatica BDE, Oracle 10g, MySQL, SQL*PLUS, Pentaho Data Integration, PL/SQL, UNIX, Hadoop - HDFS, Hbase, Map reduce, CDH4.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Involved in performance tuning in Informatica.
• Coordinated with technical teams for designing and scheduling of Informatica workflow procedures using Autosys scheduler.
• Worked on HIPAA & HL7 compliance data using Informatica.
• Created reusable transformations and mapplets.
• Defined and worked with mapping parameters and variables.
• Tuned Informatica Mappings and Sessions for optimum performance.
• Fine-tuned the mappings by analyzing data flow and Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Lookup, Joiner and Aggregator transformations.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load.
• Worked with Cognos Reporting tool.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Developed and tested IDQ mapping for cleansing customer data using transformations like Address doctor, labeler etc.
• Worked on Slowly Changing Dimensions (SCD) Type 1, 2.
• Developed scripts to perform both unit as well as system integration testing.
• Worked on Talend RTX ETL tool, develop jobs and scheduled jobs in Talend integration suite. Extensively used the concepts of ETL to load data from AS400, flat files to Salesforce.
• Modified reports and Talend ETL jobs based on the feedback from QA testers and Users in development and staging environments.

Environment: Informatica Power Center 8.6, Oracle 11g, PL/SQL, Talend 4.1, Cognos, CA Autosys 11.3, Informatica Data Quality.

Confidential, Denver, CO

Informatica ETL Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
• Worked on Informatica Power Center 8.6.1 tool - Source Analyzer, warehouse designer, Mapping Designer& Mapplets, and Transformations.
• Created global repository, Groups, Users assigned privileges using repository manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Created flexible mappings/sessions using parameters and variables.
• Extensively performed unit testing and system or integration testing.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Used database objects like Sequence generators and Stored Procedures for accomplishing the Complex logical situations.
• Moving SSIS jobs to Informatica platform.
• Extensively used ETL to load data from COBOL Flat Files, Oracle database.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Server manager/Workflow manager.

Environment: Informatica Power Center 8.6, Informatica Power exchange 8.6.1, DB2, SQL, PL/SQL, Oracle 11g, UNIX Scripting, SSIS, Windows 2000.

Confidential

Database Programmer

Responsibilities:

• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Worked on Informatica Power Center 7.1. Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer to map the sources to the target, Mapplets and Transformation Developer.
• Extensively used ETL to load data from COBOL Flat Files, Oracle database, DB2 database.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Debugging and validating the mappings.
• Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Involved in the Performance Tuning of Database and Informatica.
• Extensively performed unit testing and system or integration testing.

Environment: Informatica Power Center 7.1, SQL Server 2005, Oracle 8i, PL/SQL, DB, Windows XP, UNIX.

Confidential

ETL Developer

Responsibilities:

• Worked on Informatica Power Center 7.1. Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer to map the sources to the target, Mapplets and Transformation Developer.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Created flexible mappings/sessions using parameters and variables.

Environment: Informatica Power Center 7.1, Oracle 8i, PL/SQL, SQL*Plus, Windows XP.