SUMMARY:

• Over 9+ years of hands - on experience Software engineering
• Over 7+ years in development and design of ETL methodology for supporting data transformations & using Informatica Power Center
• Over 3+years of experience as Testing/QA Analyst/ETL Testing/System Analyst role
• Over 2+years of experience on giving Production Support.
• Over 3+ years of experience on Unix Shell scripting
• Over 2+years of experience on reporting tools like Tableau
• Experience in diversified fields in Data Warehousing.
• Worked on various projects involving Data warehousing using Informatica Power Center 8.6/8.0/7.1 (Workflow Manager, Workflow Monitor, Server Manager, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer & Transformation Developer)
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, Data Modeling, staging tables, Dimensions, Facts and Star/Snowflake Schema.
• Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export &
• Extensive experience Trouble shooting and Tuning performances in mappings, targets, sources and sessions.
• Expertise in using HP ALM Quality Center for creating testing cases
• Expertise in Manual Testing the code in various scenarios and opening defects if found any
• Expertise in scheduling jobs using JCA (Job Control Application)
• Experience in Oracle 11g/10g/9i/8i, Oracle SQL, PL/SQL Programming and TOAD.
• Experience in identifying root cause and implement resolution for production processing issues
• Experience in working with Unix shell scripting
• Highly analytic problem solver proficient in evaluating business and technical processes and issues, developed and implemented system enhancements to facilitate overall operations.
• Excellent analytical and communication skills
• Great learning skills to adapt the rapid changing technologies and implementing the same at work
• Good team player and also have ability to work independently in a time sensitive environment.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 6.0/7.0/8.0/8.6/9.5

Testing Tools: HP ALM Quality Center

Oracle Utilities/Tools: Oracle 11g/10g/9i/8i, SQL*Plus, Toad

Database: Oracle, Teradata, Sybase

Programming Languages: SQL and PL/SQL

Reporting Tools: Tableau, SAP BO

Cloud Computing: AWS, Informatica Cloud

Office Tools: MS PowerPoint, MS Word, MS Excel

Operating Systems: Windows NT/2000/XP, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

System Analyst

Responsibilities:

• Worked directly with business users for gathering reports that were generated every week
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Extensively used various transformations to meet the business requirements
• Involved in different stages of Testing and assisted QA Team to fix and find solutions for the production issues.
• Used Job Control Load (JCL) to run the jobs that are located in Unix server.
• Involved in writing Oracle and PLSQL queries and extensively used TOAD
• UNIX Shell scripting for backup and monitoring of databases.

Environment: ETL, Sybase, Oracle 11g, UNIX, Windows 7

Confidential

Software Engineer

Responsibilities:

• Extensively used Informatica Power Center 9.1 as ETL tool for developing project.
• Developed various procedures to Extract, Transform and Load (ETL) the data into the system.
• Created complex mappings using various transformations like SQL filter, sorter, aggregator, expression, union, joiner, router, SQL and Look up.
• Coding and unit testing of Informatica mappings for various stages of ETL
• Designed and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 11g.
• Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic.
• Understanding in Informatica ILM and Data Masking concepts
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shells, Unix shell Scripting
• Responsible for the development, implementation and support of the database of the server.

Environment: Informatica Power Center 9.1, SQL, PL/SQL, Toad 9.7.2, Windows 7, UNIX Shell Scripting.

Confidential, Morrisville, NC

Software Engineer

Responsibilities:

• Interacted with business users, source system owners and Designed, implemented, documented ETL processes and projects completely based on best data warehousing practices and standards.
• Designed and developed Informatica Mappings and implemented business rules and Involved in testing of Informatica workflows and also the target data.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager
• Created Sessions, reusable Worklets and workflows in Workflow Manager and Scheduled workflows
• Provided production support and involved with root cause analysis, bug fixing and promptly updating the business users on day-to-day production issues.
• Testing for the Data integrity and Consistency
• Prepared and maintained mapping specification documentation.

Environment: Informatica 9.1, Teradata, BTEQ, UNIX Shell Scripting, Windows 7

Confidential, Tampa, Florida

ETL Developer

Responsibilities:

• Extensively used Informatica Power Center 8.6.1 as ETL tool for developing project.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager, Workflow Manager and Workflow Monitor
• Worked on Star Schema modeling, Snowflake modeling to design Fact and Dimension tables.
• Data Loaded from different Flatfiles, Oracle and Sql Server with different Transformations.
• Worked in developing various reusable transformation mappings
• Designed various workflows by using event raise and event wait to specify the path to target tables
• Implemented Type-1,Type-2 and Type-3 mappings depending on the requriments to populate the slowly changing dimension tables.
• Created Sessions, reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Worked on Incremental Aggregation for Improving Performance in Mapping and Session level.
• Responsible for monitoring all the sessions that are scheduled, running, successful and failed.
• Involved in debugging the Mappings that failed.
• Moving the mappings and workflows to staging and then production environment and testing the process at every level.
• Redesigned some of the mappings in the system to meet new functionality
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse

Environment: Informatica 8.6.1, Oracle 11g/10g, SQL Navigator, PL/SQL, SQL*Plus,, UNIX Shell Scripting, windows XP

Confidential, Tampa, Florida

ETL Developer

Responsibilities:

• Created workflows and tasks in Workflow Manager and linked the database through server setup and various other connections. Created users in Informatica, assigned them various permissions.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
• Responsible in retrieving data by using data warehousing techniques like snowflake schema and star schema
• Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Developed Mappings using Designer to extract, transform data according to the requirements and loaded into database.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Analyzed the session and error logs for troubleshooting Data mappings and sessions.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Responsible for monitoring all the sessions and debugged the mapping of the failed session to check the progress of data load.
• Co-ordinated with the off-shore teams and mentored junior developers.

Environment: Informatica Power Center 7.1, TOAD, SQL Navigator, SQL*Plus, UNIX Shell Scripting, HTML, SQL Server 2000, windows XP