PROFESSIONAL SUMMARY:

• 6+ years of strong experience in designing and implementing Data Warehouse applications using ETL tools INFORMATICA Power Center 10.x&9.x & 8.x and Databases like Oracle, MS SQL Server.
• Very Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center, (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Full life - cycle project delivery experience from product definition to implementation including requirements and specification writing, design documentation, unit and system testing, optimization and performance analysis, quality assurance, and release into a production environment.
• Hands on experience in developing Stored Procedures, Functions, Views and Triggers, SQL queries using SQL Server and Oracle PL/SQL.
• Experienced in integration data sources like DB2, SQL Server, Oracle, Fixed Width and Delimited Flat Files, SQL Server into ODS.
• Experience in designing and developing complex mappings using various transformations like (Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner etc ) also created Mappings and Workflow’s . Worked with different data sources like Flat Files and Relational Databases.
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Proficient in using Informatica Workflow manager, Workflow monitor, pmcmd (Informatica command line utility) to create schedule and control Workflows, tasks and sessions.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server.
• Created Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2, and Type 3) mappings.
• Hands-on knowledge of Data warehousing ETL and OLAP reporting tools, methodologies, 3NF & Dimensional modeling, testing strategies
• Experience in creating entity relational & dimensional data models with Kimball Methodology (Star schema and Snowflake schema architectures, Fact/dimension tables)
• Expertise in migration process across different environments Dev/IT/UAT/Prod and developing several shell scripts to run/stop/monitor workflows/trap errors.
• Experience in UNIX shell scripting.
• Well acquainted with session partitioning and Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings. Trouble shooting and problem-solving applications with Informatica Debugger.
• Experience working on Informatica MDM to design, develop, test, review & optimize applications.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge Properties and Batch Group creation.
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects, Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation.
• Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages
• Worked with SIF API to interact with real time applications.
• Experience in configuring ActiveVOS in application server, MDM and integration with IDD applications.
• Extensive experience working as an onsite coordinator attending the project review meetings with clients gathering requirements, preparing High Level Design (HLD), Low Level Design (LLD), transitioning the requirements and design to offshore for the Build activity.
• Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) methodologies including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

CORE TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.x/ 9.x/8.x,OLTP,OLAP Informatica Power Exchange, Informatica Developer (IDQ), Informatica MDM 10.3

Data Base: Oracle 12c/11g/10g/9i, Sql Server 2005/2008 R2, DB2

Methodlogies: Waterfall,Agile

Operating System: Windows 98/NT/2000/XP, UNIX (Linux, HP-Unix, Solaris)

Other Software: Erwin,Sql developer for Oracle, MS Visio, MS Office, Bit Bucket, Bamboo, Jira, Service Now, Putty, Winscp, GIT Bash, Cyberark

Scripting Languages: Unix Shell Scripting

Autosys, Control: M, Tivol Work Scheduler

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Attending project kick-off meetings, gathering and analyzing the business requirements and assisting in development of one or more projects.
• Participate in design and analysis sessions with technical SME’s regarding requirements to ensure decision making of team and come up with best solution
• Developing mappings, sessions, workflows and UNIX scripts for proposed ETL solution in Informatica.
• Modifying existing mappings and workflows for enhancements of new business requirements.
• Developed mappings using various transformations like Update strategy, Lookup, Router, Filter, Sequence Generator, Joiner,Java,Expression.
• Worked with Task developer extensively in creating Reusable Sessions and created task such as email.
• Implemented various Performance Tuning techniques in Informatica.
• Involved in doing Error Handling using session logs and workflow logs.
• Developing stored procedures and SQL queries using Oracle and SQL server.
• When performance issues arise, determine the most effective way to increase performance including mapping, workflow changes.
• Tuning mapping logic and SQL queries to improve performance of a workflows by using ETL standards and partitioning methods.
• Migrated developed mapping objects from one folder to other folder in DEV using Import Export facility, from Dev to QA and to Prod Repositories by creating labels. Created External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate data from varied sources like DB2, flat files, xml files and loaded into landing tables of Informatica MDM Hub.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Used Repository manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Identified Golden Record (BVT) for Customer Data by analyzing the data and duplicate records coming from different source systems.
• Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Develop and implement Java User Exits for MDM (MDM User Exits) as per the Business validations
• Configured roles and user groups in SAM for ActiveVOS integration with MDM Hub Console.
• Integrated ActiveVOS with IDD by configuring approval workflow tasks in IDD.
• Configure and customize Informatica Data Director (IDD) application and E360 development like the subject areas, provisioning, business entity services and dependent lookup configuration.
• Created Test Plans and written test cases while doing Unit Testing, Integration Testing and worked with QA team in getting tested the code in QA Repository.
• Coordinate with DBA team in creating tables, migrating stored procedures and privileges.
• Triaging the incidents in production environment using Service Now tickets for root cause analysis, permanent resolution and SLA compliance for any issue in Project code functionality.
• Participating in Production and Application Support manual walkthrough meetings of various projects including design review, code review.
• Working with offshore team to discuss the project requirements and meet the goals as per project deadlines.
• Document and maintain the project related documents as per Confidential Inc. standards to ensure compliance with the external and internal audits
• Providing test supports for cross commits, one-time activity support and database failover support.
• Involved in reviewing the high-level design documents, Application Support manual documentation

Environment: ETL Informatica (10.2), Informatica MDM 10.3Unix shell scripting, Oracle 12c, SQL, PL/SQL, CyberArk, IBM TWS, Service Now, Bitbucket (GIT), Bamboo, JIRA, Microsoft SQL Server, SQL Developer, SharePoint.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
• Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target.
• Extracted data from various source systems like Oracle, SQL Server, and flat files and loaded into relational data warehouse and flat files
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and more.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Debugged and resolved load failures by verifying the log files. Supported QA Testing in fixing the bugs and helped to resolve various data issues.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Maintained a very good interaction with analysts, Project Managers, architects and testers to have efficient and better results.
• Developed SQL scripts to validate the databases tables and reports data for backend database testing.
• Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a order as a part of the daily loading into the Warehouse.

Environment: Informatica Power Center 10.x/9.6,, Oracle 11g, MS SQL Server, TOAD, PL/SQL, SQL, Flat Files, XML, UNIX Shell Scripting, Windows 7/8, MS Office (Word, Excel, PowerPoint).

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Designed and Developed complex mappings, reusable Transformations for ETL using Informatica PowerCenter.
• Created complex SCD type 1 & type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformations.
• Performed data manipulations using various Informatica Transformations like Aggregate, Filter, Update Strategy, and Sequence Generator etc.
• Extensively worked on Power Center Designer, Workflow Manager.
• Developed Transformation logic using Informatica.
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings.
• Created profiles to analyze the structure of source data. Created and applied rules in profiles
• Extensively used Change data capture concept in Informatica as well as in the Oracle to capture the changes to the data mart.
• Worked on Dimension and Fact tables, developed mappings and loaded data into the data warehouse.
• Created Informatica parameter files and User Defined Functions for handling special characters.
• Written SQL overrides in source Qualifier according to business requirements.
• Actively participated in Scrum Meetings.
• Implemented variables and parameters in the mappings.
• Created workflows and worklets for designed mappings.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Data Profiling, Cleansing, Standardizing using IDQ and integrating with Informatica suite of tools.
• Applied the rules and profiled the source and target table's data using IDQ.
• Generated UNIX shell scripts for automating daily load processes.
• Scheduled and unscheduled workflows and used UNIX command tasks to automate the entire process of fetching the source file from a different path and FTP it onto the server.
• Generated completion messages and status reports using workflow manager.
• Involved in writing ETL specifications and unit test plans for the mappings.
• Performed Developer testing, Functional testing, Unit testing for the Informatica mappings. Extensively used Informatica Data Validation tool to build and test unit test cases.
• Redesigned some of the mappings in the system to meet new functionality.
• Used workflow Monitor to monitor the performance of the Jobs.
• Extensively worked in the performance tuning of the ETL process at mapping and transformation level.
• Migrated the mappings to the testing and production environment

Environment: Informatica PowerCenter 9.5, IDQ, DB2, SOAP UI, UNIX, Oracle 11g, PL/SQL,, SQL Server 2008Tivoli Workload Scheduler 8.4, TOAD 9.7.2.

Confidential, Beaverton, OR

Informatica Developer

Responsibilities:

• Worked on different data sources such as Oracle, Delimited and fixed-width flat files.
• Extracted data from flat files, COBOL files using normalizer transformation and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Deployment Group using Repository Manager.
• Used the export and import commands in UNIX for inserting the data into tables in DB2.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Developed UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Use the Change Data capture (CDC) option to capture the data whenever the inserts, updates, and deletes underlying these events as soon as they occur and transfer into multiple targets without intermediate queues or staging tables.
• Worked closely with the Business Users to get the requirements of the project.
• 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.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business needs.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Written documentation to describe program development, logic, coding, testing and changes made.
• Written Shell scripts to archive the files that are older than a year and modify the file names according to the end user defined names and concat the multiple source files into single large file

Environment: Informatica Power Center 8.6.1, Oracle 10g, DB2, SQL Server 2005/2008, PL/SQL, XML, Toad, MS Access, Windows 2003, UNIX, AutoSys, Business Objects Crystal reports XI.

Confidential

Informatica Developer

Responsibilities:

• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center Designer.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Experience in Create, backup, restore for Informatica Repositories.
• Maintain all necessary updates and/or patches for the ETL environments.
• Monitors and tunes ETL repository and system for performance improvements
• Ability to perform root cause analysis, performance monitoring and application related issues
• Coordinate deployments that include Informatica deployments as well as probably Unix Shell Script and Database DDL deployments
• Write Repository Queries in support of developments and Production statistics
• Developed Mappings for the Category, Specification, Code, Type areas.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data)
• Providing solutions to improve efficiency (e.g., reduce costs while maintaining or improving performance levels).
• Optimized SQL queries for better performance using Hints, Indexes and Explain Plan.
• Involved in the development and testing of programs, Informatica mappings and update processes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Developed schedules to automate the update processes and Informatica Sessions/Batches.

Environment: Informatica Power Center 8.x, Oracle 9i, TOAD, SQL, PL/SQL, UNIX