PROFILE:

• IT professional with around 8 years of experience in the Development and Implementation of Data warehousing with Informatica PowerCenter, OLTP and OLAP using Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Exposure with Installation and Configuring of Informatica tools.
• Solid experience in Ralph Kimball Methodology, Bill Inmon Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact tables, Dimension tables.
• Strong Data warehousing experience using Informatica PowerCenter 9X/8x.
• Experience in implementing the complex business rules by creating transformations, re - usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets and Mappings, and SQL Stored Procedure, and Triggers.
• Developed Slowly Changing Dimension Mappings of type I, II and type III (version, flag and time stamp).
• Used Incremental Aggregation to update the values in Summary tables.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization and identifying performance bottlenecks.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Experience using Repository Manager to create Repository, User groups, Users and managed users by setting up their privileges and profiles.
• Extracted data from various sources like Oracle, Flat file, SQL SERVER, DB2, XML files, COBOL files loaded into Oracle database.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and Denormalization Concepts.
• Experience with UNIX shell scripting for File validation and SQL programming.
• Practical understanding of Star Schema and Snowflake Schema Methodology using Data Modeling tool Erwin 4.0/4.2.
• Hands on experience in writing, testing and implementing Triggers, Stored Procedures, Functions, Packages at database level and form level using SQL.
• Highly adaptive to a team environment and proven ability to work in a fast-paced teaming environment with excellent communication skills.
• Excellent problem solving, interpersonal and communication skills with experience working in fast paced, challenging and dynamic environment. Highly motivated with passion for learning.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.X, 8.X, 7.X, SSIS 2008.

Data Modeling: Erwin, MS Visio

Databases: Oracle 11g,10g/9i, SQL Server 2005/2008 R2, Teradata

Database Tools: Oracle SQL Developer, SQL Server Management Studio, Toad

Data Analysis and Documentation: SAS, R, Microsoft Office Suite 2013, 2016 - Excel, PowerPoint, Word.

Languages: SQL, PL/SQL, T: SQL, XML, HTML

Scripting Languages: Unix Shell Scripting, Windows Shell Scripting, PMCMD

Scheduling Tools: Control M, Informatica Scheduler

Reporting Tools: Cognos 8, Crystal Reports

Operating Systems: Windows 2000/XP/Vista/7/8/8.1/10, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Worked on Data Conversion and Data Analysis efforts of current Legacy System (Mainframe) transformation into Oracle.
• Performed Technical Analysis to meet the agreed business requirements which involves determining the technical changes need to perform, by identifying source tables, staging tables, target tables, and Informatica transformations that needs to be modified.
• Extend the source and target tables by making changes to the tables in the database.
• Designed and Developed the Extraction, Transformation and Loading of the data using Informatica PowerCenter Designer, PowerCenter Workflow Manager and PowerCenter Workflow Monitor tools.
• Worked on Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplets and Transformation Developer.
• Involved in the development of Informatica mappings and tuned them for better performance.
• Extensively used Source Qualifier, Expression transformation, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations against Oracle Hyperion/Essbase and OBIEE.
• Used Update Strategy and Lookup transformations to do the duplicate record check and update the data the information about the Invoices.
• Created session tasks, worklets and workflows to execute the mappings and monitored session using Workflow Monitor.
• Used ETL to load data from flat files, Oracle-to-Oracle database.
• Extensively used SQL statements to enhance query performance and data retrieval according to business requirements.
• As part of the Data Conversion process, stored data in the Data Warehouse about customers, Dealers. There were two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.

Environment: Informatica 9.5.1/ 8.6, Oracle 11g/10g, MS SQL Server 2008, flat files, Windows, Cognos, SQL and UNIX.

Confidential, Bellevue, WA

Sr. ETL/ Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Worked on dimensional modeling to design and develop STAR schemas by identifying the facts and dimensions.
• Worked with PowerCenter Designer tools in developing Mappings and Mapplets to extract and load the data from flat files, XML files and Oracle (source) and loaded into Oracle (target).
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Created reusable Mapplets, transformations to load data from operational data source to Data Warehouse and involved in Capacity Planning and Storage of data.
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Developed complex mappings such as Slowly Changing Dimensions Type 2, Type 3, type 1- Time Stamping in the Mapping Designer.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre-session jobs. Did performance tuning to improve the load. Wrote complex SQL Queries involving multiple tables with joins.
• Experience in using Automation tools like Control M for scheduling workflows.
• Experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Scheduled and run the ETL jobs using Control M Scheduling tool depending on the business requirement to load the data into DW.
• Monitoring the ETL and Control M jobs in the Production environment.
• Scheduled ETL Informatica workflows daily, Weekly and monthly based on the business requirement.
• Converted SQL/Procedures and SQL Loader scripts to Informatica mappings.
• Used the Target Load Ordering with Stored Procedures to update database.
• Used Variables and Parameters in the mappings to pass the values between sessions.
• Worked with Informatica Debugger to debug the mappings in Designer.
• Involved in tuning the Session and Workflows for better Performance.
• Implemented Optimization/performance tuning techniques to identify bottlenecks- Query tuning (Explain Plan, SQL Trace), table partitioning, memory tuning and cache management.
• Debugged and sorted out the errors and problems encountered in the production environment.
• Generated Adhoc reports using Business objects.
• Developed Desktop Intelligence and Web Intelligence Reports Using Business objects.
• Created graphical representation of reports such as Bar charts, Pie charts as per requirements.
• Created & tested reports using Business Objects functionality like Queries, Sections, Break points, variables, Formulae etc.
• Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.

Environment: Informatica 9.5.1/ 8.6, Oracle 11g/10g, MS SQL Server 2008, Flat files, COBOL files, Windows, Business Objects XI, Control M, UNIX

Confidential, Columbus, OH

Sr. ETL Developer

Responsibilities:

• Involved in the team during the entire ETL process and development of data marts using Informatica PowerCenter.
• Developed Transformation logic and created various Complex Mappings and Mapplets using the designer.
• Created set of Reusable Transformations and Mapplets.
• Implemented Type III Slowly Changing Dimensions.
• Debugged a valid mapping to gain Troubleshooting information about Data and Error Conditions.
• Employed Informatica PowerCenter Workflow Manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Worked on Partitioning of the Sessions and Performance Tuning of Informatica.
• Created Multiple Sessions and executed workflows using Workflow designer and viewed the results using workflow monitor.
• Fine-tuned transformation and mappings for better performance.
• Worked with PMCMD command line program to talk with the Informatica server.

Environment: Informatica PowerCenter 9.1/ 8.6, Windows, Unix, Oracle 11g, SQL Server 2005/2000, Flat files, Toad, Cognos 8.0

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

• Business Analysis and Requirement Collection.
• Worked on Dimensional modeling to Design and Develop STAR Schemas.
• Used ER-win to identify Facts and Dimensions.
• Extracted Source Data using Informatica tools and stored procedures from Source systems. Used Informatica Transformations, Mapping Designer, and Mapplets to Develop ETL programs (Source Data mart) and to implement business rules.
• Extensively used almost all the transformations, which includes (Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Stored Procedure, Joiner, Normalizer, and XML Source Qualifier).
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Performed Adhoc queries using PL/SQL developer to check for consistency of the data in the tables and to update the tables as per the requirements.
• Wrote stored procedures for dropping and re-creating indexes for efficient Data Load.
• Tuning of SQL queries for better performance.
• Optimizing the mappings by changing the logic to reduce run time
• Developed the mappings to extract the data on incremental load basis
• Developed reusable transformations for Date Conversion.
• Extensively involved in Fine tuning the Informatica (mappings and Sessions), Stored Procedures, SQL to obtain optimal performance and throughput.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.
• Used Cognos for generation of reports.

Environment: Informatica PowerCenter 8.6, Erwin, Cognos 7.0, Oracle 9i, SQL Server 2005, DB2, Unix Shell Scripting, SQL, PL/SQL, Windows XP, Unix.

Confidential

ETL Developer

Responsibilities:

• Interacted with end-users and functional analysts to identify and develop business requirements and transform them into technical requirements.
• Involved in the SDLC process beginning with the design of dimensional modeling in building the data warehouse.
• Extracted data from Oracle, flat file and XML sources.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into the dimension, facts, and lookup tables simultaneously from different source systems.
• Created sessions and workflows.
• Worked with email, command tasks, Mapplets, Reusable Transformations and worklets.
• Handled slowly changing dimensions of Type 1/ Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Involved in performance tuning of the sessions.
• Extensively used PL/SQL for database related functionality.
• Used Pmcmd commands to run the Informatica mappings using Unix Scripts.
• Created UNIX Scripts for creating the indexes, altering the default table spaces and analyzing the tables.
• Involved in unit testing and documentation of the ETL process.

Environment: Informatica PowerCenter 8.1.1, Oracle 9i, DB2, PL/SQL, TOAD8.0, Windows XP, Unix Shell Scripting, ERWIN 4.0, SQL loader.

Confidential

ETL/ Informatica Developer

Responsibilities:

• Extracted Data from Different Sources using Informatica PowerCenter.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplet Designer
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyzed, designed, constructed and implemented the ETL jobs using Informatica.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.

Environment: Informatica Power Center 8.x/7.x, Oracle 10g, MS SQL SERVER 2005, SQL, PL/SQL, SQL*Loader, Windows XP, UNIX Shell Script.