PROFESSIONAL SUMMARY:

• 7+ years of experience in IT industry with strong background in Data Warehousing, Business Intelligence and ETL process using Informatica PowerCenter/Informatica Cloud/Power Exchange.
• Data integration with SFDC and Microsoft Dynamics CRM using Informatica cloud.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Database experience using Oracle, SQL Server, Azure SQL Server, SAP HANA, Teradata, DB2 and MS Access.
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Maintenance of History retention tables.
• Experience in UNIX Operating System and Shell scripting.
• Good understanding of Views, Synonyms, Indexes, Joins, and Sub-Queries.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Experience in writing SQL queries and PL/SQL to implement business rules and validation.
• Experience in Data Modeling tool- Erwin and Data Warehousing Concepts
• Extensive experience using database tool such as Sql Server Management Studio, SQL*Plus, SQL * Loader and TOAD
• Experience with System Development Life Cycle (SDLC).
• Automation of the business process using Control M, Autosys and Tidal.
• Working knowledge on BI tools - Tableau, OBIEE, Business Objects.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter, Informatica Cloud, Power Exchange.

Data Modeling: Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Databases: Oracle, MS SQL Server, AZURE Sql Server, SAP HANA, Sybase, MySQL, Teradata and DB2

Languages: SQL, PL/SQL,C, C++, Unix Shell Script, Visual Basic

Web Technologies: HTML, XML, Java Script

Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader, SSMS

Operating Systems: Windows XP/Vista/7, UNIX, MS-DOS and Linux

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

ETL Informatica/Cloud Developer

Responsibilities:

• Understanding the business rules and sourcing the data from multiple source systems.
• Interacted with users and supported multiple projects for OLM HK team (Retail, Residential, Industrial and International).
• Extracted the raw data from Microsoft Dynamics CRM to staging tables using Informatica Cloud.
• Developed Cloud mappings to extract the data for different regions (APAC, UK and America).
• Refreshing the mappings for any changes/additions to CRM source attributes.
• Developed the audit activity for all the cloud mappings.
• Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.
• Generated automated stats with the staging loads comparing with the present day counts to the previous day counts.
• Created Filewatcher jobs to setup the dependency between Cloud and PowerCenter jobs.
• Created and developed mappings to load the data from staging tables to EDW DataMart tables based on Source to Staging mapping design document.
• Implemented Type1, Type2, CDC and Incremental load strategies.
• Followed ETL standards - Audit activity, Job control tables and session validations.
• Used Exceptional mappings to generate dynamic parameter files after the staging loads.
• Used Shared folders to create reusable components (Source, target, email tasks).
• Developed single dynamic ETL mapping to load more than 30 reference tables.
• Used Sql queries to validate the data after loading.
• Maintained and automated the production database to retain the history backup tables to 30 days.
• Developed/Automated (PowerCenter/IDQ) jobs through Control M.

Environment: Informatica Cloud, Informatica PowerCenter, SQLServer, Azure Sql Server, Control M.

Confidential, San Francisco, CA

ETL / Informatica developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Loading data to the staging tables following the Data Integrity rules of Interface Design Specifications.
• Used source external tables to load the data to the staging tables.
• Created mapping documents to outline data flow from sources to targets.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Developed and scheduled the Jobs using Autosys Scheduler.

Environment: Informatica PowerCenter 9.0.1, Flat files, Excel files, Oracle11g, Erwin, Autosys, UNIX

Confidential, San Jose, CA

ETL Developer

Responsibilities:

• Working with business users and business analyst for requirement gathering and business analysis.
• Designing and customizing data models for Data warehouse supporting data from multiple sources.
• Extracted data from flat files, Excel files and transformed the data based on user requirement using Informatica Power Center.
• Performed analysis on quality of source data to determine accuracy of information being reported.
• Debugging the mappings and used session log files to trace errors that occur while loading.
• Performance tuning by optimizing the mappings and sessions.
• Performed Unit Testing and tuned for better performance.
• Used the backend data to calculate the metrics rolling to the customer level on a Quarterly basis.
• Working with quality and operational metrics in supply chain business unit for top customers.
• Optimized the SQL queries using Explain Plan.
• Built WebI reports provided OLAP functionality and worked extensively with data warehousing.

Environment: Informatica PowerCenter 9.0.1, Flat files, Excel, Oracle11g, Teradata, MySQL, SQL, Business Objects XI 3.1.

Confidential, San Francisco, CA

ETL / Informatica developer

Responsibilities:

• Gathered user requirements and designed source to target data load specifications based on business rules.
• Used Informatica Power Center to load data from Flat Files to DB2, XML files to DB2, Flat Files to Oracle.
• Staged vendor data as provided by the vendor .Applied transformation logic to extract datasets.
• Analyzed Data warehouse and data elements documents received from the vendor Morningstar.
• Used Tic stream to download Global Equity data files, validated and staged the data.
• Applied data validations and loaded the source data to the target tables using Informatica.
• Created control files and used SQL Loader to load the data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading.
• Worked on performance tuning for the workflows that took longer time to load the data.
• Automation of workflows to run daily and monthly jobs.
• Created and maintained various UNIX Shell Scripts for loading process.
• Created deployment groups, migrated the code into different environments.
• Developed Oracle PL/SQL Stored Procedures, Performance and fine Tuning of SQL.
• Performed Unit testing by executing the SQL scripts and comparing the source with target data.
• Created and documented ETL test Cases and Validations.

Environment: Informatica PowerCenter 9.0.1, Flat files, XML, Oracle11g, DB2, SQL, PL/SQL and UNIX.

Confidential, San Francisco, CA

ETL Consultant

Responsibilities:

• Loaded Data from various Salesforce.com (SFDC) objects into Oracle database tables.
• Developed mappings where data from Oracle data sources is updated to the respective SFDC objects.
• Used Power Exchange for Oracle E-Business Suite to import an Oracle E-Business Suite as a source definition.
• Used Apex Explorer to query Account, Contacts and Generation assets tables in SFDC.
• Created Web service source and target in mapping designer and published Web services.
• Used Web service consumer as source and developed mapping to target depending on the business requirement.
• Implemented Upsert logic for the incremental load.
• Developed slowly changing dimension Type 2 mappings to maintain the history of the data.
• Implemented automated schedule of ACH file transfer from oracle server to US bank and Comerica bank server.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Worked on performance tuning for the sessions that took longer time to load to the target.
• Generated WSDL’s in Power Center Web service hub.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Designed and implemented custom business intelligence solutions Metadata and Dashboards and Reports using the Oracle BI Analytics platform.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.

Environment: Informatica PowerCenter 9.0.1, SFDC, Web services, Oracle10g/11g, SQL Server 2008 Enterprise Edition, SQL, PL/SQL, UNIX, Flat files, XML, Erwin, OBIEE 10.1.3.4.1 .

Confidential, Waukegan, IL

Informatica developer

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developing several mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables and Parameter files in Mapping Designer.
• Created reusable transformations and mapplets and used them in mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented performance tuning logic on Sources, Targets, mappings, and sessions to provide maximum efficiency.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings and workflows and to keep track of the changes in the development, testing and production environments.
• Created Workflows with Worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Created logical and physical data models and maintained relationships between tables using Erwin.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Enhance performance by creating Aggregate tables, Indexes and managing Cache.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g/11g, Teradata, SQL, PL/SQL, UNIX, Flat files, XML, SQL Server 2008, Erwi n, OBIEE 10.1.3.4.1

Confidential, New York

Informatica developer

Responsibilities:

• Integration of various data sources like Oracle, SQL Server, Fixed Width, Delimited Flat Files, DB2, COBOL files & XML Files.
• Extracting the data from SFDC and loading into Oracle database.
• Used Informatica to pull the data from SAP and loading in to Oracle Database.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets and Parameter files in Mapping Designer using Informatica PowerCenter.
• Designed Mappings using B2B Data Transformation Studio.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Migration of code between the Environments and maintaining the code backups.
• Created the Test cases and Captured Unit test Results.
• Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented.
• Migrating mappings, workflows and parameter files from development to production.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Maintained the target database in the production and testing environments.
• Produced automated build scripts using Perl and shell programming.
• Implemented Logical /Physical design of database schemas and business processes though Erwin.
• Developing information systems through investigation, analysis, design, implementation and maintenance with SDLC.
• Implemented complex views, procedures, functions, packages and triggers in PL/SQL.
• Developed PL/SQL code at the database level for the new objects.

Environment: Informatica Power Centre 8.6.1, Oracle 10g/9i, SAP, ABAP, PL/SQL, Erwin, Flat files, XML, SQL Server, MS Access, Business Objects, UNIX.

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Interacted with Business Analysts to understand the requirements and the impact of the ETL on the business.
• Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin.
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Created reusable transformations and Mapplets and used them in mappings.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• 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 rules and transformations.
• Worked with BTEQ, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency
• Assessed functional issues by troubleshooting Informatica mappings, sessions, and workflows with UNIX shell scripts; Perl scripts; SQL queries in all stages of development and/or production.
• Developed a. Framework for extensible automated production support in PL/SQL.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, SQLServer2005, Teradata 13,PL/SQL, XML, MS Access, Java, Sybase, Netezza, Web services, UNIX, Perl, UDB DB2 8.1, Toad, Business Objects.