PROFESSIONAL SUMMARY:

• Over 7+ years of IT experience in all phases of Data Warehousing and Business Intelligence including Requirements Gathering & Analysis, Design, Development, Testing and Production support.
• Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions, and Workflows using Informatica Power Center.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica Power Center tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor).
• Experience in designing/developing complex mapping using transformations like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Normalizer, Joiner, Sequence Generator, Connected and Unconnected Lookup and Update Strategy.
• Extensive experience in Data Warehousing, ETL, Design, Development, Implementation, and Testing of Data Warehouse/Data Mart Systems.
• Experience working in IDQ (Informatica Developer Tools) to perform data cleansing, data matching, data conversion, exception handling, data profiling, reporting and monitoring.
• Used Address validator, Parse Transformation, Join Analysis Transformation to perform IDQ activities.
• Used IDQ to perform Unit testing and create Mapplets dat are imported and used in PowerCenter Designer.
• Involved in tuning the Oracle PL/SQL queries by using Indexing, Hints and Parallel execution process.
• Proficient in the integration of various data sources involving multiple relational databases like Oracle, MS SQL Server, DB2, Netezza, Teradata, XML and Flat Files (fixed width, delimited).
• Worked wif PLSQL Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Proficient in developing and maintaining various PLSQL/Database objects like packages, functions, stored procedures, triggers, tables, Views, Materialized views, Indexes, Sequences, partitions, etc.
• Experience in developing SQL*Loader control programs and PL/SQL validation scripts for validating the data load from staging area to production.
• Strong Knowledge on Oracle Architecture and Database Design using Normalization and E/R diagrams.
• Excellent conceptual knowledge of Oracle 10g/11g, Data Warehouse Concepts, ETL, Data modeling, and Dimensional Modeling.
• Strong experience in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes.
• Created different types of validation and reconciliation scenarios using the data from different databases, including Oracle, Teradata, MSSQL, and MySQL.
• Good understanding of Data modeling concepts ER Diagrams, UML, Use Cases, Normalization, and De - normalization of Tables, Excellent analytical, problem-solving skills wif strong technical background and interpersonal skills.
• Experience in Scheduling Informatica sessions for automation of loads in Autosys, Control M, UC4.
• Expertise in understanding the Business process, writing Test Plans, Test Strategies, Test Cases, Executing scenarios as part of designing.
• Experience working wif offshore and onsite coordination.
• Flexible, enthusiastic and project-oriented team player wif solid communication and leadership skills to develop a creative solution for challenging client needs.
• Able to work independently and collaborate proactively & cross-functionally wifin a team.

TECHNICAL SKILLS:

Data Warehousing Tools (ETL): Informatica Power Center 10.1.1,9.6.1, 9.5.1,8.x, Informatica Data Quality 10.1.1,9.6.1,9.5.1,8.x, Informatica Data Validation Option (DVO), Informatica Cloud, Informatica Analyst, Informatica PowerExchange, Informatica Metadata Manager

RDBMS: Oracle, DB2, Teradata, SQL Server, PostgreSQL, Mysql

Reporting Tools: Power BI, Tableau

Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating Systems: Windows, UNIX, Linux, Centos

DB Utilities: TOAD, SQL* Loader, SQL Developer, SQL* Plus

Applications/Other Tools: MS office, Win SCP, Autosys, Putty, JIRA, Cherwell Service Management, Nagios, Splunk

WORK EXPERIENCE:

Confidential, St. Louis, MO

Informatica Developer

Responsibilities:

• Responsible for Business Analysis, Requirements Collection and HLD creation
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Extensively used Informatica Data Quality transformations - Parser, Standardizer, Match, Association, Consolidation, Merge, Address Validator, Case Converter, and Classifier.
• Created MDM mappings using IHA best practices to capture the errors and have a clean load using Informatica power center.
• Created functional document wif MDM data model configuration, source system definition, data mapping and cleansing requirements, trust score and matching rule definitions.
• Designing & developing cleansing and standardization scenarios to cleanse Address, Telephone Numbers, Email ID using IDQ Cleanse Adapter.
• Created various data quality mappings in Informatica Data Quality tool and imported them into Informatica PowerCenter as mappings, Mapplets.
• Extracted the raw data from Salesforce to staging tables using Informatica Cloud.
• Developed Cloud mappings to extract the data for different regions.
• Developed the audit activity for all the cloud mappings.
• Worked cooperatively wif the team members to identify and resolve various issues relating to Informatica and Callidus Cloud Compensation Application.
• Automated/Scheduled the cloud jobs to run daily wif email notifications for any failures.
• Experience using various Teradata utilities such as Fastload, Multiload, TPump, BTEQ (to invoke these utilities & queries).
• Developed PowerExchange CDC mappings to retrieve data from Oracle to staging tables in Oracle.
• Strong experience on Informatica Metadata Manager, involved in pulling metadata from multiple sources into Metadata Manager to run the end to end Data Lineage.
• Modified existing mappings for enhancements of new business requirements.
• Documenting the ETL mapping strategies and transformations involved in the extraction, transformation and loading process.
• Participated in weekly status meetings and conducting internal, external reviews as well as formal walk through among various teams and documenting the proceedings.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Defined Target Load Order Plan for loading data into Target Tables.
• Proficient in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon’s (SCD’s), Change Data Capture (CDC).
• Extensive development, support, and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data warehousing.
• Developed many Proof of concepts (POC’s) related to Meld parameterization.
• Ensured timely execution of test cases in ALM on a daily basis and reporting defects, if found.

Environment: Informatica Power Center 10.1.1, Informatica Cloud 10.1.1, Informatica DataQuality 10.1.1, Informatica MDM 10.1.1, Informatica DVO, Metadata Manager, SQL Query Analyzer, Teradata, SQL Server 2012, Toad, SQL Developer, Putty, Unix

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Involved in production support and development projects working as Informatica developer, which included full life cycle development including design, ETL strategy, troubleshooting reporting etc.
• Interaction wif Business SME's on requirement gathering, understanding the business and functional requirements.
• Collaborated wif the end users to identify technical requirements for the development project based on their business requirements.
• Developed Informatica mappings, reusable transformations and created PL/SQL Stored procedures/packages for extracting data from source systems to staging and processing and loading to the data warehouse.
• Developed informatica mappings, mapping configuration task and Task flows using Informatica cloud service(ICS).
• Worked on the installation and setup ETL (Informatica cloud) applications on Linux servers.
• Utilized Informatica Data Quality (IDQ) for data profiling and matching/removing duplicate data, fixing the bad data, fixing NULL values.
• Used IDQ (Informatica Data Quality) as data Cleansing tool to create the IDQ Mapplets and to correct the data before loading into the Target tables.
• Monitored and cleansed data using Informatica Data Quality (IDQ) - source data profiling using Informatica Analyst and creating mappings in Informatica Developer to apply cleansing and business rules.
• Developed PowerExchange CDC/Real Time mappings to retrieve data from Oracle.
• Optimized/tuned mappings for better session performance and eliminated bottlenecks by analyzing session statistics and throughput.
• Defined mapping/session parameters and variables according to the requirements and performance related issues.
• Performance tuned Informatica mappings by adopting explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Involvement in Project efforts estimation.
• Involved in the Performance Tuning & Preparation of unit test cases.
• Involvement in code deployment and post production deployment activities.
• Tracking and fixing the defects being raised in previous releases.
• Created several Functions, Procedures, Packages, and Triggers according to the Clients requirements in further enhancement projects.
• Tuning the performance of SQL statements using HINTS, INDEXES, and procedures using EXPLAIN PLAN and SQL Trace. Developed a set of views to fine tune the performance tuning process.
• Developed Complex SQL queries using various joins and also extensively used various dynamic SQL's in stored procedures and functions.
• Created database objects like Tables, Indexes, Sequences, and Views.
• Used UNIX shell scripting for execution of Informatica workflows.

Environment: Informatica Power center 10.0,9.6.1, Informatica Cloud, Informatica Data Quality 10.0,9.6.1, Informatica Analyst 9.6.1,10.0, Informatica DVO, SQL, PL/SQL, Oracle 11g, Teradata, SQL Developer, Oracle Hints, Unix.

Confidential, Phoenix, AZ.

Informatica Developer

Responsibilities:

• Involved in project planning, development, assign tasks to various team members and tracking their activities.
• Used Informatica to extract, load and transform operations. dis role participates in the design and the movement of data from the operational and external environments to the business intelligence environment.
• Designed and developed Informatica mappings to build business rules to load data.
• Extensively worked on Informatica Lookup, Aggregator, Expression, Stored Procedure and Update Transformations to implement complex rules and business logic.
• Developed complex Informatica ETL jobs to migrate the data from flat files to the database.
• Performed thorough data profiling to understand the quality of source data and to find data issues using Informatica Data Quality.
• Worked wif Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Involved in massive data profiling using Informatica IDQ prior to data staging.
• Created IDQ Mapplets for address cleansing, telephone cleansing and SSN cleansing and used them as Informatica Mapplets in Power Center.
• Involved in supporting the application until it is completely stable in Production.
• Co-ordinating wif offshore teams for the deliverables.
• Conducting reviews wif Business SME's for the design, Code, Unit Test Plan, and cases.
• Extracted source definitions from databases like Oracle and Flat files into the Power center repository.
• Importing Source/Target tables from the respective databases and created reusable transformations and mappings using Designer Toolset of Informatica.
• Involved in the Performance Tuning & Preparation of unit test cases
• Resolving if there are any issues in transformations and mappings.
• Involved in requirements analysis and design and also source system analysis to derive the business logic, validation of data mappings for enhancement releases.
• Coding Oracle PL/SQL Stored Procedures, Functions, and Packages
• Analyzing the Defect Resolution document for implementation of the requirements.
• Developing database scripts for each release and deploying them using WorkBench.
• Involvement in code deployment and post production deployment activities.
• Carrying impact Analysis for the changes made in source system and implementing the required changes in target DW environment

Environment: Informatica Power center 9.5.1, Informatica Data Quality 9.5.1, Oracle 11g, Teradata, Flat Files, Unix.

Confidential

Informatica Developer

Responsibilities:

• Used Informatica 9.1 to extract, transform and load data from multiple input sources.
• Worked wif Business Analyst to gather business requirements and Involved in weekly team meetings.
• Reviewed the business requirements and created an internal and external design for Informatica jobs.
• Involved in the transfer of data to Connects Promotion Manager.
• Worked wif the Connect3 support team to maintain the Informatica jobs and Data Analyzer.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, SQL Server, Excel, DB2 and loading to Oracle target database.
• Extensively used various types of transformations such as Expression, Normalizer, Joiner, Update strategy, Lookup (Connected and Unconnected) to load the data.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Devised extensive PL/SQL Stored Procedures and Triggers to populate the base tables on daily basis and implementing business rules and transformations.
• Performed Mapping Optimizations to ensure maximum Efficiency.
• Extensively used complex SQL queries to unit test the system and to test the existing project also used to validate the data in data warehouse.
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of the session and Scheduled Workflows using AutoSys.
• Implemented complex mapping such as Slowly Changing Dimensions (Type II) using Flag.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers.
• Involved in unit, system and end-to-end testing of the design.

Environment: Informatica Power Center 9.1, Teradata, Oracle 10g, SQL Server, DB2, PL/SQL, AIX, Flat files, SQL*Loader, TOAD, UNIX

Confidential

ETL Developer

Responsibilities:

• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor.
• Extracted the data from the flat files and other RDBMS databases into the staging area and populated onto data warehouse.
• Developed and documented data Mappings/Transformations and Informatica sessions.
• Responsible for definition, development, and testing of processes/programs necessary to extract data from client’s operational databases, Transform and cleanse data, and Load it into Datamart’s.
• Used the Informatica Designer, Source Analyzer, and Mapping Designer.
• Created complex mappings in Power Center Designer using Aggregator, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Used Informatica Power Center Workflow manager to create sessions, batches to run wif the logic embedded in the mappings.
• Implemented Type 1 and Type 2 slowly changing dimensions.
• Used the update strategy to effectively migrate data from source to target.
• Designed several mappings to extract the data from the Flat file sources and Relational Sources.
• Designed and developed complex aggregator, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Used Informatica as an ETL tool to extract data from Oracle manufacturing applications to Target system.

Environment: Informatica Power Center 9, Oracle 10g, DB2, PL/SQL, TOAD, SQL Plus, SQL Loader.