SUMMARY:

• Over 11+ Years of IT experience in Administration, Designing, Development and Implementation of Data Warehouses & Data marts with Informatica PowerCenter 9.x/8.x/7.x/6.x as an ETL tool.
• Extensive experience in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation, and Production.
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review process.
• As an Informatica Administrator, responsible for the installations, upgrades, hot fixes, configuration, and support of 15 environments.
• Installed and configured Power Center 9.6.1 on Red Hat Linux platform and configured High Availability and grid. creating new repositories from scratch, backup and restore
• Code migration and monitoring data activities and handling production job failure/long running.
• Implementing security, creating roles and Privileges, taking Backup restoration if needed
• Work with product manager to ensure the architecture design meets the product requirements .
• Work with QA manager to develop test specifications
• Worked extensively with complex mappings using Expression, Joiner, Router, Lookup and Update strategy, Source Qualifier, Aggregator to develop and load data in to different target types.
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and sessions using Informatica Power Center.
• Experience in programming with PL/SQL (Stored Procedures, Stored Functions, Cursors, and Database Triggers).
• Worked extensively with debugger and tuning of ETL processes to improve the overall performance.
• Experience in integration of various data sources like Teradata, Oracle, SQL Server, DB2 into staging area.
• Experience in writing Unit test plans and Unit testing.
• Experience in writing shell and Perl scripts.
• Automated few of the tasks using shell and Perl scripts.
• Implemented GPG encryption and Decryption.
• Developed Auto code review tool which reduced time spent on code review activity.
• Possess excellent communication and interpersonal skills with ability to work independently and as part of a team.
• Experienced in leading the team from Onsite and Offshore as Informatica Lead
• Experienced in developing universe for Business Objects.
• Designing dashboards, reports in Business objects.
• Excellent analytical, problem solving, communication, technical, multi - tasking, and a motivated team player/lead with excellent inter-personal skills
• Strong leadership skill and able to build and maintain good personal relationship with Client.

TECHNICAL SKILLS:

ETL Informatica: Power Center 9.x/8.x/7.x/6.x, Data stage, Talend

RDBMS: DB2, Oracle 10g/9i/8i, Teradata

Reporting Tools: Business Objects

Languages: Perl, C, Shell Scripting

OS Sun Solaris: UNIX, Linux, Windows NT/2000.

Utilities/Tools: Toad, SQL* Loader, PL/SQL, Core FTP

Big Data Ecosystems: HDFS, HBase, Hive, Pig, Sqoop, Oozie

DevOps Tools: Jenkins, Chef, Ruby, BASH, GIT, Subversion

Cloud: AWS

PROFESSIONAL EXPERIENCE:

Confidential

ETL Consultant/Lead Developer

Responsibilities:

• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained always.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document and ETL specifications.
• Analyzing the system and customer requirements.
• Solely responsible for initial implementation of Informatica Production and Disaster Recovery environments within the organization
• Involved in Tidal Enterprise Scheduler integration & Tidal Agent setup for brand new environments.
• Configured OS profiles and LDAP/LDAPS Authentication in Active directory.
• Installed and configured Power Center 9.6.1 on Red Hat Linux platform and configured High Availability and grid. creating new repositories from scratch, backup and restore
• Code migration and monitoring data activities and handling production job failure/long running.
• Implementing security, creating roles and Privileges, taking Backup restoration if needed

Environment: Informatica Power Center 9.6, Oracle 11g, Tidal

Confidential, Seattle

ETL Consultant/Lead

Responsibilities:

• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained always.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document and ETL specifications.
• Analyzing the system and customer requirements.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center 9.6, Workflow Manager, Repository Manager, and Designer.
• Created Mapplets for reusable business rules.
• Having a good hold on L3 production support as well.

Environment: Informatica Power Center 9.6, Oracle 11g, Teradata, UNIX, Control-M

Confidential

ETL Consultant/Lead

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document and ETL specifications.
• Analyzing the system and customer requirements.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center 9.5, Workflow Manager, Repository Manager, and Designer.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• Created shell script to Decrypt the files.
• Created the shell Script to Encrypt the files using public key of the downstream system.

Environment: Informatica Power Center 9.1.0, Oracle 11g, UNIX, MS SQL Server, Varicent, TIDAL, Accurev & HP Quality Center

Confidential

ETL Consultant

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document and ETL specifications.
• Analyzing the system and customer requirements
• Prepared the estimation & schedule for different phases of project life cycle.
• Involved in client requirement’s session with Business people.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center 9.5, Workflow Manager, Repository Manager and Designer.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• Created UNIX shell script to transport flat files from different source systems to the ETL server.
• Worked on performance tuning of mappings, sessions, Target and Source.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Involved in creating and running Sessions & Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor.
• Created Shortcuts, reusable transformations and Mapplets to use in multiple mappings.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures.
• Created conversion scripts
• Created profiles and Scorecard in IDQ
• Created Logical Data Objects in Informatica IDQ.
• Created unit & System Test Plan and Test Cases in different testing phases.
• Participate in daily & weekly Calls with management and from the client side as well to discuss the development status & ways to improve the productivity.
• Review the code and update the review documents to make sure the code is with in Development Standards

Environment: Informatica - PowerCenter 9.5, Informatica IDQ, Oracle 11g, PL/SQL, Unix,Toad,Teradata

Confidential

ETL Consultant/Lead

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document and ETL specifications.
• Analyzing the system and customer requirements
• Prepared the estimation & schedule for different phases of project life cycle.
• Involved in client requirement’s session with Business people.
• Analyzed and Created Fact tables and Dimension Table for storing the historical data.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center 9.1, Workflow Manager, Repository Manager and Designer.
• Developed mappings between multiple sources such as flat files, oracle and multiple targets.
• Strong experience in using Expressions, Joiners, Routers, Lookups, Update strategy, Source qualifiers and Aggregators.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• Created UNIX shell script to transport flat files from different source systems to the ETL server.
• Worked on performance tuning of mappings, sessions, Target and Source.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Involved in creating and running Sessions & Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor.
• Created Shortcuts, reusable transformations and Mapplets to use in multiple mappings.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures.
• Created unit & System Test Plan and Test Cases in different testing phases. (Unit, Integration, System, Regression and End to End).
• Presented the Test Plan & Test Case of all testing phase to client
• Involved in different test execution - Unit, System test, Regression and End to End
• Reviewed the test cases & test results of Unit, System test and Regression test
• Develop & Review the code and update the review documents to make sure the code is with in Development Standards.
• Participate in daily & weekly Calls with management and from the client side as well to discuss the development status & ways to improve the productivity.
• Assign the tasks to the resources in the team & make sure that the delivery will be in the agreed deadlines.
• Organize KT to the new Team members & make them comfortable with the project understanding along with the application knowledge
• Explained the system requirements & solved all the technical & functional issues faced by team members
• Having a good hold on L3 production support as well.
• Migrated mappings, mapplets and workflows from Development to Testing and then testing to UAT.

Environment: Informatica - PowerCenter 9.1,Oracle 11g,PL/SQL,UNIX,TOAD and Windows NT/2000.

Confidential

ETL Consultant/Lead

Responsibilities:

• Participate in calls with business users to understand well about the requested change or new development for a particular functional area.
• Involved in designing of Informatica mappings by translating the business requirements.
• Keep the management updated about the development status daily and weekly & suggest new areas of development by using the technical expertise.
• Prepared the estimation & schedule for different phases of project life cycle.
• Participate in daily & weekly Calls with management and from the client side as well to discuss the development status & ways to improve the productivity.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center 9.1- Server, Workflow Manager, Repository Manager and Designer.
• Involved in developing the Perl script.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Created Unit&System Test Plans and Test cases in different Testing phase (Unit,Integration,System, Regression and End to End).
• Created Mapplets for reusable business rules.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Presented the Test Plan & Test Case of all testing phase to client
• Environment: Informatica - PowerCenter 9.1,Oracle 11g,PL/SQL,UNIX,TOAD and Windows NT/2000.

Confidential

ETL Consultant

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, Concept documents and ETL specifications.
• Analyzing the system and customer requirements.
• Prepared the estimation & schedule for different phases of project life cycle.
• Analyzed and Created Fact tables and Dimension Table for storing the historical data.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center Designer.
• Developed mappings between multiple sources such as flat files, oracle and multiple targets.
• Strong experience in using Expressions, Joiners, Routers, Lookup, Update strategy, Source qualifiers and Aggregators.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• Created UNIX shell script.
• Worked on performance tuning of mappings, sessions, Target and Source.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Involved in creating and running Sessions & Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor.
• Reviewed the test cases & test results of Unit, Int System and Regression test
• Develop & Review the code and update the review documents to make sure the code is with in Development Standards.
• Participate in daily & weekly Calls with management and from the client side as well to discuss the development status & ways to improve the productivity.
• Assign the tasks to the resources in the team & make sure that the delivery will be in the agreed deadlines.
• Organize KT to the new Team members & make them comfortable with the project understanding along with the application knowledge
• Explained the system requirements & solved all the technical & functional issues faced by team members
• Having a good hold on L3 production support as well

Environment: Informatica - PowerCenter 8.6, Oracle 11g, PL/SQL, UNIX, TOAD and Windows XP.

Confidential

Senior Developer

Responsibilities:

• Involved in the technical design document
• Involved in the developing workflows and Tasks in the workflow manager based on the business requirements.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center Designer
• Created Mapplets for reusable business rules
• Preparing and reviewing data flow mapping test cases.
• Created UNIX shell script for data loading
• Worked as configuration manager and performed reviewing and promotions to copy the workflows and mappings through Clear Quest Tool
• Participate in Daily & weekly Calls with client
• Involved in code review activity

Environment: Informatica - PowerCenter 7.1, Oracle 9i, PL/SQL, UNIX, TOAD and Windows XP.

Confidential

Software Engineer

Responsibilities:

• Design new package spec. and body with new procedure and functions with Transformation logic.
• Table creation with composite primary key constraints using Indexes and table spaces.
• Involved in Partitions creation.
• Involved in creating mapping and workflow.
• Involved in creating Autosys scripts which helps in scheduling the jobs.
• Tracing the queries by using Explain plan, Auto Trace.
• Involved in unit testing.
• Involved in the Implementation of data retention strategy for IRSR tables

Environment: Informatica - PowerCenter 7.1, Oracle 9i, PL/SQL, UNIX, TOAD and Windows XP.

Confidential

Software Engineer

Responsibilities:

• Design new package spec. and body with new procedure and functions with Transformation logic.
• Developed the mappings and workflows as per the Business logic using Informatica.
• Developed reusable Transformations.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Involved in creating Autosys scripts which helps in scheduling the jobs
• Involved in creating shell scripting
• Involved in unit testing.
• Participate in Daily & weekly Calls with client

Environment: Informatica - PowerCenter 6.1, Oracle 9i, PL/SQL, UNIX, TOAD and Windows XP.