SUMMARY

• Over 8 years of experience in Information Technology with a strong background in Database development and Data warehousing.
• Good experience in designing, Implementation of Data warehousing and Business Intelligence using ETL tools like Informatica Power Center (designer, workflow manager, workflow monitor and repository manager).
• Created Mappings in Mapping Designer to load data from various sources using Transformations like Transaction Control, Lookup (Connected and Un - connected), Router, Filter, Expression, Aggregator, Joiner and Update Strategy, SQL, Stored Procedure and more.
• Excellent Knowledge on Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Change Data Capture, Dimensional Data Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data Marts, OLAP, FACT and Dimensions tables, Physical and Logical data modeling.
• Experience in developing Transformations, Mapplets and Mappings in Informatica Designer and creating tasks using Workflow Manager to move data from multiple sources to target.
• Worked on Informatica Data Quality 9.1(IDQ) tool kit and performed data profiling, cleansing and matching and also imported data quality files as reference tables.
• Worked in different phases of the projects involving Requirements Gathering, Design, Development, Deployment, Testing and Maintaining.
• Good Knowledge on Database architecture of OLTP and OLAP applications and Data Analysis.
• Experience in E-R modeling, developing Database Schemas like Star schema, Snowflake schema used in relational, dimensional and multidimensional modeling.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Strong experience working with different RDBMS like Oracle, Sybase, MS SQL Server 2008 SQL, PL/SQL, SQL* PLUS, SQL* Loader, TOAD, Stored Procedures, Triggers.
• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle (SDLC).
• Hands on experience in PL/SQL (Stored Procedures, Functions, Packages, Triggers, Cursors, Indexes) and UNIX Shell scripting.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Hands on experience working in LINUX, UNIX and Windows environments.
• Experience in working Production Support and migrated the code from DEV to QA to Production
• Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.
• Good experience in ETL technical documentation.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 10.1/9.6/9.5/9.1 , PowerExchange 10.1

RDBMS: Oracle 12c/11g/10g/9i/8.0, SQL Server 2008/05/00, DB2, XML, Sybase

Methodologies: Star schema and Snowflake schema

Languages: SQL, PL/SQL, C, XML, HTML,UNIX Shell Scripting

Operating system: Windows, Unix, Linux

BI Tools: OBIEE

Protocols: TCP/IP, FTP, SFTP, SCP

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Worked with managers, business analysts as well as other teams to gather the business requirements.
• Understand full software development lifecycle (SLDC) for ETL processes.
• Parsed high- level design specification to simple ETL coding and mapping standards.
• Analyzing Session log files to resolve errors in mappings and manage session configuration.
• Creating mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Datawarehouse.
• Created complex workflows, with multiple sessions, worklets with consecutive or concurrent sessions.
• Maintained stored definitions, transformations rules and targets definitions using Repository Manager.
• Developed monitoring scripts in UNIX.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the target.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created mapplets to use them in different mappings.
• Validate the required data at the database level by using tool Toad.
• Migrated the code into QA (testing) and supported QA team.
• Worked with export and import utilities in Repository Manager.
• Performance Tuning at various levels including Target, Source, Mapping and Session for large data files
• Use debugger to test the mapping and fix the bugs and identified the bottlenecks in all levels to tune the performance.
• Maintained Functional and Technical specifications documents.
• Checked session and error logs to troubleshoot problems.

Environment: Informatica Power Center 10.1/9.1, Power Exchange 10.1, Oracle 11g/10g, DB2, Sybase, SQL, PL/SQL, Flat files, XML, Toad, UNIX, Shell scripts, FTP.

Confidential, Atlanta, GA

Sr.Informatica Developer

Responsibilities:

• Analyzed business needs and information requirements, determined the optimal approach for obtaining data from diverse source system platforms.
• Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplet Designer and Transformation Developer.
• Designed and created mappings, sessions and workflows and schedule the workflow as per the Functional & Technical specifications.
• Designed mappings using Connected/Unconnected Lookups, Filter, Expression, Aggregator and Router transformations for populating data into targets.
• Coordinated with Informatica Admin to setup the environment and to move objects to different repositories and folders.
• Worked with different kinds of Code migration including XML import/export, folder migration, deployment groups and Manual migration.
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Extracted and loaded data from XML documents by using XML Parser and Generator transformations.
• Defined Target Load Order Plan for loading data into different Target Tables.
• Implemented Slowly Changing Dimensions methodology to keep track of historical data.
• Analyzed Session log files to resolve errors in mapping and managed session configuration.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Involved in Unit and System testing of developed mappings.
• Scheduled jobs using UNIX scripting and Informatica scheduler. Determine production schedule of data extraction processes. Production support transition.
• Maintained naming standards and warehouse standards for future application development, and also created functional and technical specification documents.

Environment: Informatica Powercenter 9.6,9.1,OBIEE 11g, Oracle 11g,SQL, PL/SQL, Flat files, XML, Toad, PL/SQL Developer tool, UNIX, Shell scripts.

Confidential, Kansas City, MO

ETL/Informatica Developer

Responsibilities:

• Used Informatica Power Center 9.1 for extraction, transformation and load (ETL) of data.
• Created Mappings using Mapping Designer to load the data from Salesforce, transform data according to business rules and load it back to Salesforce.
• Created complex Informatica mappings to load the data. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, and Look up, Sequence generator.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve the performance.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Created unique primary key values to replace missing primary keys using Sequence Generator Transformation making reusable to use the same Sequence Generator in multiple mappings.
• Created various tasks like sessions, Worklets and workflows in the workflow manager to test the mapping during development.
• Used Workflow monitor to see the workflows running and get the session properties and session log.
• Extensively used Informatica debugger to figure out the problems in mapping.
• Carried out unit and integration testing for Informatica mappings, sessions and workflows.
• Created and scheduled workflows based on demand, run on time and run only once.
• Wrote UNIX shell scripts for various purposes.
• Experience in Agile methodology.
• Assisted the team in the development of design standards and codes for effective ETL development and implementation.

Environment: Informatica Powercenter 9.1, Oracle 11g/10g, OBIEE 11g, SQL, Flat files, Oracle SQL Developer, Toad, Unix, Shell scripts.

Confidential, Pittsburgh, PA

ETL/Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing and participated document review meetings.
• Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplet Designer and Transformation Developer.
• Designed and created mappings, sessions and workflows and schedule the workflow as per the Functional & Technical specifications.
• Extracted the data from Oracle11g/10g, XML, Flat files load the data in to Oracle data warehouse.
• Designed mappings using Connected/Unconnected Lookups, Filter, Expression, Aggregator and Router transformations for populating target tables.
• Coordinated with Informatica Admin to setup the environment and to move objects to different repositories and folders.
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Extracted and loaded data from XML documents by using XML Parser and Generator transformations.
• Worked on Repository Manager to manage & assigned permissions to Folders.
• Defined Target Load Order Plan for loading data into different Target Tables.
• Implemented Slowly Changing Dimensions methodology to keep track of historical data.
• Analyzed Session log files to resolve errors in mapping and managed session configuration.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Worked extensively in PL/SQL procedures to load the data.
• Involved in Unit and System testing of developed mappings.
• Scheduling Informatica jobs using ESP.
• Scheduled jobs using UNIX scripting and Informatica scheduler. Determine production schedule of data extraction processes. Production support transition.
• Maintained naming standards and warehouse standards for future application development, and also created functional and technical specification documents.

Environment: Informatica Powercenter 8.6, Power Exchange(PWX), Oracle 11g/10g, DB2,, SQL, PL/SQL, Flat files, XML, Toad, PL/SQL Developer tool, ESP, NT Server, UNIX, Shell scripts, FTP.

Confidential

Informatica Developer

Responsibilities:

• Understand the customer Requirements and Technical specification documents.
• Participating in the review of the detail Architecture and design for the project.
• Worked on ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation.
• Used Informatica Powercenter/Power Exchange to extract/transform and load data from different operational data sources like Oracle, Sql Server, XML, Flat files in to staging area (Oracle) and load in to Oracle data warehouse.
• Developed the various mappings using various transformations like source qualifier, joiner, filter, router, expression transformations etc.
• Involved in the design of incremental load.
• Developed standard and re-usable transformations and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improved the performance of the mapping Involved in performance tuning on Informatica in all levels.
• Developed huge workflows with Worklets, event waits, assignments, conditional flows, email and command tasks.
• Applied slowly changing dimensions in various complex Mappings to load data from source to target.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Validate the required data at the database level by using tool Toad.
• Files data move to another server by using FTP on UNIX platform.
• Used Toad for DDL’s and to validate the data.
• Resolving technical issues across projects.

Environment: Informatica Powercenter 8.6/8.1(Repository Manager, Designer, Workflow Manager and Monitor) Power Exchange, Oracle 10g, Sql Server, PL/SQL, XML, Flat files, Unix, Shell Scripts, Toad, Windows NT

Confidential

ETL Developer

Responsibilities:

• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Delivered responsibilities as Analyst and Programmer including interaction with Business Users to Gathering requirements, Created Technical Specifications, Design, Development and Maintenance.
• Analyzed source data, extracted, transformed, and loaded data in to target data warehouse based on the requirement specification using Informatica Powercenter.
• Developed data Mappings between source and target systems using Mapping Designer.
• Involved in complete SDLC including analysis, design, development, implementation, QA and maintenance of various software applications.
• Worked with various heterogeneous sources such as Oracle10g, Teradata and Flat Files to load the data into the target Oracle data warehouse.
• Developed complex Informatica mappings using Filter, Sorter, Aggregator, Look up, stored procedure, Joiner, Router transformations for populating target table.
• Written PL/SQL stored procedures in Oracle and used in mapping to extract the data.
• Solved common name and address data problems by Informatica Data Quality’s (IDQ) address cleansing and identity matching rules, which reduce project risk and make the quick.
• Used debugger to test the mapping and fixed the bugs and identified the bottlenecks in all levels to tune the performance.
• Extensively used the Informatica Debugger for debugging the Mappings to check the Business rules implemented correctly or not.
• Resolved the production support tickets using solution manager.
• Maintained Functional and Technical specifications documents
• Worked with Workflow Manager Tasks such as Email, Command, Event raise, Event wait, Decision, Assignment.
• Supported post-production maintenance.

Environment: Informatica Powercenter 8.6/8.1 and Power Exchange/Power Connect, Oracle 10g, SQL, PL/SQL, Flat files, TOAD 7.3, Erwin, UNIX, Shell scripts, Windows NT.