SUMMARY

• 5.5+ years of IT experience with expertise in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems (DSS) using ETL tools Informatica Power Center with RDBMS like Oracle, MS SQL server, Teradata and MySQL databases.
• Excellent experience in designing and development of ETL Methodology using Informatica PowerCenter 10.2, 9.6.1/9.1.1
• Having experience in working with ORACLE 11g/10g, MySQL, SQL Server 2012/2014, Teradata 16/14 databases.
• Having good experience in Teradata utilities like BTEQ, MLOAD, Fast Load and TPT.
• Interacted with end - users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
• Worked extensively in design and analysis of Requirements, Development, Testing and Production deployment.
• Prepared various types of documents like requirements gathering, ETL specification, Data Mapping, Test cases, Data dictionary etc.
• Expert in writing SQL query using multiple databases like ORACLE, SQL Server, Teradata, MySQL etc.
• Experience in Task Automation using UNIX Scripts, Job scheduling and communicating with Server using PMCMD command .
• Experience in integration of various data sources into staging area .
• Performed Unit testing, System testing, Integration testing and users for UAT and prepared test report in different phases of project.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.
• Designed and developed complex mappings, Mapplets, tasks and workflows and tuned it.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
• Good understanding of the Data modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling .
• Moderate experience in Informatica Change Data Capture Management
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations like Mapplets .
• Extensively used Slowly Changing Dimension (SCD) technique in business application.
• Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for a company merger projects. Heavily created mapplets, user defined functions, reusable transformations, look-ups .
• Conducted Unit tests, Integration tests and Customer Acceptance tests (UAT) .
• Working experience in Agile and Waterfall methodologies.
• Experience working with Onsite and Offshore model and while working in that project ensured proper work assignment and review.

TECHNICAL SKILLS

ETL TECHNOLOGY: Informatica PowerCenter 10.2, 9.x

DATA WAREHOUSE: Star Schema, Snowflake schema

DATA MODELLING: Erwin 9.5/7.1

DATABASES: Oracle 12c/11g/10g, MS SQL Server 2012/2014, Teradata 16/14

OPERATING SYSTEMS: Windows, AIX, Sun Solaris, UNIX

APPLICATIONS: MS Office, Toad 9.2/8.6

Others: Quest, TOAD, SQL*PLUS, SQL*Loader, WinSCP, Putty, Rally

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Documented Data Mappings/ Transformations as per the business requirement.
• Prepared Technical Design documents and Unit Test cases.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star 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 tables.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
• Used SQL editor TOAD to run SQL queries to view and validate the data loaded into the warehouse.
• Created summarized tables, control tables, staging tables to improve the system performance and as a source for immediate recovery of database
• Migrated Mappings, Sessions, Workflows from Development to Test and then to UAT environment .
• Wrote hundreds of SQL query for data analysis to validate the input data against business rules .
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning .
• Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger .
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Improved performance testing in Mapping and the session level.
• Worked with UNIX shell scripts for job execution and automation.
• Coordinated with Autosys team to run Informatica jobs for loading historical data in production.
• Maintaining bug, status using JIRA tool.
• Created different parameter files and started sessions using these parameter files using pmcmd command to change session parameters, mapping parameters, and variables at runtime.
• Tuned the mappings by removing the Source/Target bottlenecks and Expressions to improve the throughput of the data loads.

Environment: Informatica PowerCenter 10.2, Cognos 11, SQL, Oracle 12c, Teradata 16, TOAD, Control M, Shell Scripting, Rally

Confidential, Milwaukee, WI

Informatica Developer

Responsibilities:

• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Participated in data analysis, data profiling, and data dictionary and metadata management. Used SQL to do the Data Profiling.
• Collaborated with Business users to collect requirements and prepared ETL technical specifications .
• Developed, supported and maintained the ETL processes for exporting data from multiple sources into data mart tables.
• Implemented customer history data capture for catalogue tables using SCD Type 2.
• Designed mappings for Slowly Changing Dimensions (Type 1 &Type 2), used Lookup (connected and unconnected), Update strategy and filter transformations for loading historical data.
• Experience in debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data.
• Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, data flow's and target system in order to provide maximum efficiency and performance.
• Worked extensively with Informatica tools such as Source Analyzer, Warehouse Builder and Workflow Manager .
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression and sequence generator transformations in extracting data in compliance with the business logic developed.
• Wrote SQL overrides in source qualifier to filter data according to business requirements.
• Wrote Unix shell scripts for scheduling Informatica pre/post session operations.
• Created different parameter files and started sessions using these parameter files using pmcmd command to change session parameters, mapping parameters, and variables at runtime.
• Tuned the mappings by removing the Source/Target bottlenecks and Expressions to improve the throughput of the data loads.

Environment: Informatica Power Center 9.1.1, Oracle 10g, SQL*Plus, SQL Server 2012, UNIX Shell Scripting, Cognos, JIRA.

Confidential, Milwaukee, WI

Informatica Developer

Responsibilities:

• Worked with the business team to gather requirements for projects and created strategies to handle the requirements.
• Used Informatics CDC Power Center for extraction, transformation and loading data from heterogeneous source systems into target database.
• Designed and developed complex mappings using Mapping Designer to move data from multiple sources and transformed data into a common target area.
• Prepared Technical Design documents and Test cases .
• Created Sessions and Workflows and extracted data from various sources, transformed data according to the requirement and loaded into data warehouse.
• Performed data validation, data profiling, data auditing and data cleansing activities
• Created mappings with different look-ups like connected look-up, unconnected look-up, Dynamic look-up with different caches such as persistent cache etc.
• Created various Mapplets and re-usable transformations as part of mapping design.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning .
• Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger .
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Written several Teradata BTEQ scripts to implement the business logic.
• Improved performance testing in Mapping and the session level.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Documented Mappings, Transformations and Informatica sessions.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.

Environment: Informatica PowerCenter 8.6.1, SQL Server 2008, Oracle 10g, PL/SQL, UNIX, Teradata 14, Cognos 9