PROFESSIONAL SUMMARY:

• Having around 9+ years of experience in conceptualizing and delivering Data warehouse projects and having experience in full life cycle of Software Development (SDLC) including Business Requirement Gathering & Analysis, System study, Application Design, Development, testing, Implementation, System Maintenance, Support and Documentation.
• Enterprise Data Warehousing and Data mart: Experience and Expertise in ETL process (Informatica Power Center 10.x/9.x/8.x/7.x), Experience in using Informatica Quality 10.1/9.6.1, Informatica Developer 10.1/9.6.1.
• Experience and Expertise in ETL process (Informatica PowerCenter) Mappings, Mapplets, Transformations, Workflow Manager and Workflow Monitor. Also, Experience in Extraction / Transformation / Loading of legacy data to Data Warehouse using Informatica Developer 10.1.
• Expertise in creating the plans with components by IDQ8.6, mappings with transformations by Informatica Developer 10.x/9.x.
• Expertise in implementing the HTTP, XML, Web Services and HTML Transformations along with SFDC Sales force methodology.
• Worked on Informatica Cloud Services, Salesforce.com, and Salesforce transformations.
• Experience in Informatica Administration.
• Expertise in Data Warehousing Concepts with Ralph and Kimball methodologies, ODS and Staging data.
• Experience in designing the Batch mechanism, Audit Balancing and Counting frame works, partitioning the jobs at ETL level.
• Expertise in identifying the Source and Target bottle necks and implementing the Performance tuning techniques at mapping, session and database level.
• Proficiency in using Informatica Power Center tool to design Data Integration, Data Conversions, Data Migration from Multiple Source systems.
• Extensively worked on Databases like Oracle 11g/10g/9i/8i, Netezza, Teradata, DB2 SQL Scripting and also worked on large database systems.
• Extremely proficient in writing the PL/SQL Scripts like Procedures, Packages and Functions.
• Having good knowledge on writing Shell Scripts and UNIX commands.
• Testing skills include performing Unit, Regression, Integration, and Volume testing Confidential well Confidential Development, Execution, and Maintenance of Test plans, Test specifications and Test scenarios.
• Experience in providing Application support engagements and On Call (24*7) Support for Production Problem Resolution (Resolve Production issues and problems in an expedited manner).
• Excellent cross - functional communicator, working Confidential interface between business/clients with an ability to see the end to end project functions while staying on top of the details

TECHNICAL SKILLS:

O/S: Windows NT/XP/98/2000, Unix, Linux

ETL & Data Quality Tools: Informatica PowerCenter 10.1/9.6/9.0.1/8.6/7.1.1, Informatica Data Quality 10.1/9.6.1, Informatica Developer 10.1/9.6.1, Informatica Analyst 10.1/9.6.1, Informatica Power Exchange 8.6, Informatica Cloud, ICRT, Secure Agent, Power center Web Services, Informatica 9.6.1/9.0.1 Administration

Cloud Platforms: Informatica Cloud Secure Agent, Salesforce.com, Web Services

Database, Languages & Tools: Oracle 11g,10g/9i/8i, Sql, Pl/Sql, SQL Server R2/2008/2012, MS-Access, Netezza, DB2, Teradata, Java, C++

Tools: and Utilities: IBM Data Studio, Sql Server, Toad, Sql Developer, Putty, PVCS, Clear case HP Quality Center11

Methodologies: Star Schema, Snowflake Schema

Reporting Tools: Business Objects XIR2, MicroStrategy, WebFocus

PROFESSIONAL EXPERIENCE:

Confidential, ATLANTA, GA

Senior ETL Developer / Data profiling Analyst

Responsibilities:

• Worked with business team to help understand functional requirements and convert to technical specifications.
• Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Involved in create Source - Target mapping documents.
• Extensively used Informatica Client Tools - Informatica Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Involved in development of mappings. Sophisticated transformation rules are implementing using Informatica features like Aggregator, Filter, Expression, Sequence Generator, Lookup, UPS and Source Qualifier.
• Created test plans, test data for extraction and transformation processes and resolved data issues following the data standards.
• Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
• Experience in developing Transformations, Mapplets and Mappings using Informatica Designer to implement business logic.
• Applied the rules and profiled the source and target table's data using IDQ.
• Developed the mappings, applied rules and transformation logics Confidential per the source and target system requirements.
• Provided support during the system test, Product Integration Testing and UAT.
• Designed and developed Informatica ETL Interfaces to load data incrementally from Oracle databases and flat files into staging schema.
• Automated the ETL process through Control-M scheduling.
• Created and monitored sessions using Informatica Workflow manager and workflow monitor.
• Responsible for Unit and Regression testing of the Informatica Mappings created according to the business requirements.
• Developed a Plan for Informatica auto regression test case suite for the project.
• Performing the unit testing and preparing test cases.
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.
• Coordinate with Configuration management team in code deployments.
• In case of a job failure on the Informatica side, notify the user groups and work with them to rerun the job and ensure the completion of the load.
• Coordinate with different administrative services like DBAs for the DB issues.
• Resolved the issues remedy tickets on priority basis.

Environment: Informatica Power Center 10.1.1/9.6.1, Data Profiling, IDQ 10.1, Oracle, MS SQL Server, Unix, Control-M, IBM DB2, GitHub, MS access.

Confidential, San Ramon, CA

Senior ETL Developer / Operations support

Responsibilities:

• Worked with business team to help understand functional requirements and convert to technical specifications.
• Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Involved in create Source - Target mapping documents.
• Extensively used Informatica Client Tools - Informatica Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Involved in development of mappings. Sophisticated transformation rules are implementing using Informatica features like Aggregator, Filter, Expression, Sequence Generator, Lookup, UPS and Source Qualifier.
• Involved in UNIX scripting while downloading the files from multiple source systems via ESFT.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Prepared low level technical design document and participated in build/review of the BTEQ Scripts, Fast Exports, Multiloads and Fast Load scripts, Reviewed Unit Test Plans & System Test cases.
• Have used BTEQ, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL. Efficiently used Oracle utilities like SQL Loader, Export/Import in UNIX environment.
• Provided support during the system test, Product Integration Testing and UAT.
• Designed and developed Informatica ETL Interfaces to load data incrementally from SFDC, Oracle databases and flat files into staging schema.
• Automated the ETL process through UC4 scheduling.
• Created and monitored sessions using Informatica Workflow manager and workflow monitor.
• Responsible for Unit and Regression testing of the Informatica Mappings created according to the business requirements.
• Developed a Plan for Informatica Data Validation Option opportunities for the project.
• Developed solutions with the use of different functionalities of DVO.
• Performing the unit testing and preparing test cases.
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.
• Coordinate with Configuration management team in code deployments.
• In case of a job failure on the Informatica side, notify the user groups and work with them to rerun the job and ensure the completion of the load.
• Coordinate with different administrative services like DBAs for the DB issues.
• Resolved the issues remedy tickets on priority basis.

Environment: Informatica Power Center 10.1.1/9.6.1, Informatica Cloud, DVO, Salesforce, Oracle, MS SQL Server, PL/SQL, Teradata 14.0, Unix, UC4, Clear case, PVCS.

Confidential, San Ramon, CA

Senior ETL Developer / Operations support

Responsibilities:

• Worked with business team to help understand functional requirements and convert to technical specifications.
• Involved in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Involved in creating Source - Target mapping documents.
• Extensively used Informatica Client Tools - Informatica Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Worked on creating Informatica mappings with different transformations like lookup, SQL, Normalizer, Web Services, XML, HTML, Aggregator, SQ, Joiner, Expression, Router…etc.
• Designed and developed Informatica ETL Interfaces to load data incrementally from SFDC, Oracle databases and Flat files into staging schema.
• Created complex workflows with multiple sessions, worklets with consecutive or concurrent sessions.
• Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Responsible for Unit and Regression testing of the Informatica mappings created Confidential per business requirements.
• Worked on Oracle tool, SQL Developer and Toad to run the sql queries and validate data.
• Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL. Efficiently used Oracle utilities like SQL Loader, Export/Import in UNIX environment.
• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.
• Coordinate with Configuration management team in code deployments.
• Provided support during the system test, Product Integration Testing and UAT.
• Monitor the production jobs at regular intervals to ensure smooth running and proper completion of the jobs.
• In case of a job failure on the Informatica side, notify the user groups and work with them to rerun the job and ensure the completion of the load.

Environment: Informatica Power Center 9.6.1, Informatica Cloud, DVO, Salesforce, Oracle, MS SQL Server, PL/SQL, Teradata 14.0, Linux RHEL 6.2, UC4, Clear case, PVCS, SMC.

Confidential, Phoenix, AZ

Senior ETL Developer

Responsibilities:

• Participated in Business requirements.
• Coordinated cross-functional team efforts in meeting and exceeding goals.
• Played a project lead role in the requirement gatherings.
• Worked on creating Informatica mappings with different transformations like lookup, SQL, Normalizer, Web Services, XML, HTML, Aggregator, SQ, Joiner, Expression, Router…etc.
• Worked on data quality transformations to perform profiling, pattern check, matching algorithms.
• Worked on Informatica Data Quality Address doctor component to perform address checks across vendor feeds for trust systems.
• Worked on Informatica Web Services to perform request and response operations with different SOAP actions.
• Built ETL packages by setting up Task operations, target connections, data filters, field mapping under Data synchronization through Informatica Cloud Secure Agent.
• Worked on creating the mapplets with mapplet input and outputs by using Power center designer.
• Worked on creating the workflows and sessions with pre/post session commands.
• Worked on UNIX shell scripts and called them into ETL workflows by passing the input arguments.
• Worked on creating the generic batch mechanism process and audit controls.
• Extensively worked on performance tuning techniques and also on identifying the source, target bottlenecks.
• Created profiles on source tables/files, and generated score cards based on rules.
• Validated Informatica Analyst rules Confidential mapplets and called into power center designer.
• Worked on pl/sql procedures and oracle statements to capture the data and testing.
• Implemented Trust concept and assigned Trust score for domain columns.
• Prepare unit and integration test plans, code review, testing, debugging (using Debugger) and deployment of Informatica jobs into production environment.

Environment: Informatica Power Center 9.6, Informatica Developer 9.6, PowerCenter Web Services, XML, XSD, WSDL, Salesforce.com, Unix, Oracle 11g, SQL Developer, Pl/Sql, Control-M.

Confidential, Brighton, UK

Senior ETL Developer

Responsibilities:

• Participated in requirements gatherings.
• Coordinated cross-functional team efforts in meeting and exceeding goals.
• Played a lead role in the requirement gathering, preparation of Engineering Requirement Specification document.
• Worked on creating Informatica mappings with different transformations like lookup, SQL, Normalizer, Web Services, XML, HTML, Aggregator, SQ, Joiner, Expression, Router…etc.
• Worked on creating the mapplets with mapplet input and outputs by using Power center designer.
• Worked on creating the workflows and sessions with pre/post session commands.
• Worked on UNIX shell scripts and called them into ETL workflows by passing the input arguments.
• Worked on creating the generic batch mechanism process and audit controls.
• Extensively worked on performance tuning techniques and also on identifying the source, target bottlenecks.
• Worked on SFTP, FTP file transfer scripts, Control-M job scheduling scripts.
• Created Informatica mappings with transformations by using Informatica Developer.
• Created profiles on source tables/files, and generated score cards based on rules.
• Validated Informatica Analyst rules Confidential mapplets and called into power center designer.
• Worked on Address Doctor/Dictionaries to validate source data addresses and zip codes.
• Worked on IDQ transformations like Standardizer, Distance, Weighted Average, Consolidation, Matching, Labeler, and Parser …etc.
• Done single table structure profiling, cross table structure profiling by using Informatica Analyst.
• Worked on Informatica analyst to identify Patterns, Frequency, Null’s on source data.
• Worked on pl/sql procedures and oracle statements to capture the data and testing.
• Implemented Trust concept and assigned Trust score for domain columns.
• Created Exact, Fuzzy match & Enables Auto merge mechanism to cleanse the data.
• Implemented dashboards in Informatica Data Director and created score cards.
• Prepare unit and integration test plans, code review, testing, debugging (using Debugger) and deployment of Informatica jobs into production environment.

Environment: Informatica Power Center 9.0.1, Informatica Data Explorer8.6, Unix, Oracle 10g, Business Objects, Toad, Pl/Sql, DB2, Informatica Developer9.0.1.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Involved in translating business requirements to integrate into existing data mart design.
• Coordinated cross-functional team efforts in meeting and exceeding goals.
• Played a lead role in the requirement gathering, preparation of Engineering Requirement Specification document.
• Involved in System analysis, Estimations and design for enhancements.
• Troubleshooting and fine tuning of mappings for maximum.
• Confidential part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions and done code migration from one environment to other.
• Worked on several transformations such Confidential Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, DT and Normalizer Transformation in Informatica.
• Also provided all Database Object scripts for DBA team to deploy stage and prod DB environments.
• Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
• Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage.
• Done Data cleansing, single and cross table structure profiling, analysis on data, and analyze the patterns with Informatica Data Explorer and generating reports and logs.
• Worked on Informatica Developer (Informatica Data Quality)9.0.1 and Informatica Analyst9.0.1 to cleanse and profile the data.
• Generated Scorecards based on profile results.
• Done single table structure profiling, cross table structure profiling.
• Created Data quality mappings(plans) and exporting those to power center Confidential mapplets.
• Worked on creating SSIS packages and scripts.
• Created Rules on profiled data and used the same to data quality mappings.
• Responsible for Unit & Integration test environments and for data accuracy with consistency throughout its lifecycle.

Environment: Informatica Power Center 9.0.1, Informatica Data Explorer8.6, Unix, Oracle 10g, BOXI R2, Toad, Pl/Sql, Informatica Dataquality8.6, Informatica Developer9.0.1.

Confidential, Phoenix, AZ

ETL Developer:

Responsibilities:

• Interacted with Business users to understand the Business requirements and created High Level Process flow, High level technical design, and Low Level technical design documents.
• Designed Informatica process and developed mappings/Sessions/Workflows to load data from Source to Staging and from staging to Warehouse.
• Involved in designing the data model and Prepare Process Flow Diagrams, Flow Charts, File layouts.
• Worked on Power Center Client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created mappings with various transformations, executed workflows with sessions through workflow manager.
• Responsible for Self and Peer Review of Programs and Test Records under Development Phase
• Prepare Unit, System, Integration and Load Test Plan’s, Test Specifications and Test Records under Test Planning Phase
• Perform Unit, System, Integration and Load Testing under Testing Phase and simultaneously reviewing and Recording the Test Results.
• Designed and developed transformation rules to generate consolidated data using Informatica ETL (Power Center) tool.
• Created Informatica mappings, batches and session and Scheduled jobs with UC4 scheduling tool.
• Worked extensively on Flat files Confidential the data from various legacy systems are Flat files.
• Used Partitioning techniques to improve session performance.
• Used Parameter Files defining variable values for mapping parameters and variables.
• Involved in data cleansing using Trillium data analytics, matching, standardization, and cleansing routines.

Environment: Informatica Power Center8.6, SQL Scripting, Oracle10g, VB script, Cognos, Control-M, SQL Developer, Flat files, Unix, Windows XP/2000.