SUMMARY:

• 9 Years of experience in analysis, design, development, testing and implementation of data warehousing applications such as banking and insurance
• Good knowledge of software development life cycle and software testing life cycle
• Knowledge on Physical and Logical data models and knowledge on Erwin.
• Experience in integration of various data sources like flat files, DB2 and Oracle using Informatica
• Strong knowledge on Data warehousing concepts, dimensional, Star and Snowflakes schema methodologies
• Expertise in designing and developing Informatica mappings in Power Center 9.6.1
• Developed complex mappings using various transformations like Aggregator, Union, Joiner, Router, Connected/Unconnected lookups, Stored procedure, Expression, Filter, Sorter and Update strategy
• Implemented complex business rules in Informatica by creating re - usable transformations and Mapplets
• Created and modified Informatica workflow and worklets
• Experience in Data migration, Data extraction, Data cleansing, Data profiling and Data quality
• Expertise Designing and Developing Dimension and Fact tables
• Experience in Power Exchange 9.6.1 and creating data maps for Mainframe datasets
• Good Knowledge in Mainframe environment, Knowledge on TSO commands and JCL
• Knowledge on Control-M scheduling tool and scheduling and monitoring the jobs
• Experience in working Unix scripts and complex SQL queries
• Supporting daily/weekly/Monthly flows in production for the developed processes
• Developed the production logs with new errors to help other team members
• Strong knowledge in developing database queries
• Worked on tools like IBM Data Studio, Toad and WinSQL to run the SQL Statements
• Knowledge on HP Service manager tool to open/close tickets and change records
• Expert in troubleshooting/Debugging and improving performance of Informatica mappings
• Enthusiastic and goal-oriented team player processing good communication and interpersonal skills

TECHNICAL SKILLS:

ETL Tools: Informatica Power center 9.6.1, Informatica Power exchange 9.6.1

Languages: SQL, PL/SQL, JCL, Unix Schell scripting, SAS

Databases: DB2, Oracle

Operating systems: Unix/Linux, MVS, Windows

Other tools: IBM Data Studio, Toad, WinSQL, File-Aid, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, IL

Sr. ETL Informatica Consultant

• Coordinated with host team to understand the current functionality to migrate
• Assisted in preparing the high level and low level technical design
• Created the source to target mappings based on the low-level designs.
• Coded the new Informatica mappings according to the requirements
• Worked with DBAs to tune the SQL used in the Informatica mappings
• Developed Shell scripts to run the Informatica jobs
• Performed the Unit testing and Documented the test results
• Worked with auto flow and scheduling team to implement the changes in test environment
• Deployed the code to system testing environment
• Assisted the system testing team during system testing
• Fixed the defects identified in system testing and implemented in test environment
• Conducted user acceptance testing with business partners
• Implemented various performance tuning techniques to improve the performance
• Implemented the code in production and supported post production
• Monitor the production flows
• Fix if Informatica/Unix job fails with in time to continue the flow
• Correct if any valid data in the source files
• Document the production log if any new errors for their sources

Environment: Informatica Power center 9.6.1, Power Exchange 9.6.1, DB2, UNIX Shell Scripting, IBM Data studio, IBM Mainframe

Confidential

Sr. ETL Informatica Consultant

Responsibilities:

• Involved in business requirements gatherings
• Used the source data from flat files and DB2 tables
• Used various transformations like Joiner, Aggregator, Expression, Connected/Un-connected lookup, Filter, Router, Union, Stored procedure and Update Strategy
• Declared and used mapping parameters and variables with in the mappings
• Coordinated with DBAs to create the test objects in various test environments and in production during final implementation
• Performed debugging to identify the issues and resolved all the issues
• Developed shell scripts to run Informatica workflows
• Worked with auto flow and Scheduling team to schedule the jobs in Test and Production
• Implemented the code in system testing environment and assisted the test team while testing
• Documented the test results in project phases in Lotus notes
• Implemented the code and auto flows in production

Environment: Informatica Power center 9.5.1, DB2, UNIX Shell Scripting, IBM Data studio

Confidential,Richmond,VA

Informatica Consultant

• Interacted with business partners and gathered the requirements
• Assisted in designing logical and physical data models
• Developed Informatica mapping to extract the data from Flat files and DB2 tables lookups, Stored procedures, Aggregator, Joiner, Router and Update strategy
• Created SCD (slowly changing dimension) type 2 mappings and Facts
• Created Informatica Mapplets to reuse the same functionality in multiple mappings
• Created workflows and modified worklets to run the modified sessions
• Developed Korn Shell scripts to run the Informatica workflows
• Worked with DBAs to review the changed/new SQLs and made code changes as per the DBA Recommendations
• Performed Unit testing and Validated the data according to source to target mapping
• Documented test results and shares to project for review
• Identified the bottlenecks and tuned the performance of the session
• Deployed the code in system testing environment and assisted the test team during their testing
• Resolved the defects identified during system testing and closed all defects in time
• Shared the test results with business partners and assisted in user acceptance testing
• Worked with change management team on implementation plans to production
• Implemented the code in production and supported the process till transitioning

Environment: Informatica power center 9.1, DB2, UNIX shell scripting, IBM Data studio, Control-M, IBM Mainframe

Confidential, TX

Informatica Developer

• Interacted with business partners on the requirements
• Extracted data from flat files and DB2 tables
• Used various transformations like Joiner, Aggregator, Expression, Connected/Un-connected lookup, Filter, Router, Union, Stored procedure and Update Strategy
• Declared and used mapping parameters and variables with in the mappings
• Worked with DBAs to tune the SQLs coded in the SQL overrides
• Performed debugging to identify the issues and resolved all the issues
• Developed shell scripts to run Informatica workflows
• Implemented the code in system testing environment and assisted the test team while testing
• Performed User acceptance testing
• Documented the test results in project phases in Lotus notes
• Implemented the code in production
• Transitioned to service team after 2-week post production

Environment: Informatica Power center 8.6, DB2, UNIX Shell scripting, WinSQL, Toad

Confidential,Denver,CO

Informatica Developer

• Understanding business requirements
• Interacting with business analysts and end users
• Creating high level and low-level design documents
• Assisted in creating logical and physical data modeling
• Developed the Informatica mappings and workflows
• Developed shell scripts to start Informatica workflows
• Perform Unit testing and prepare unit test cases/results
• Involved in SQL queries tuning and improved the performance of Informatica session
• Created Informatica workflows and added the tasks like e-mail and Command
• Worked with Unix deployment team to issue the code to test and production
• Fixed all defects and assisted the test team
• Prepared transition documents and transitioned the work to service team

Environment: Informatica Power center, DB2, UNIX Shell scripting, WinSQL, Toad

Confidential, PA

Informatica Developer

• Interacted with business partners and gathered the requirements
• Assisted in designing logical and physical data modeling
• Developed Informatica mappings to extract the data from flat files and DB2 tables
• Created complex mappings using different transformations like Filter, Connected/Un-connected lookups, stored procedures, aggregator, joiner, router and update strategy
• Created SCD (Slowly Changing Dimension) type 1 and 2 mappings
• Created Informatica Mapplets to reuse the same functionality in multiple mappings
• Created workflows and modified worklets to run the new/modified sessions
• Developed shell scripts to run the Informatica workflows
• Worked with DBAs to review the changed/new SQLs and made code changes as per their recommendations
• Performed unit testing and validated the data according to source to target mappings
• Documented the test results and shared to project for reviews
• Identified the bottlenecks and tuned the performance
• Implemented the code to production and supported for one month

Environment: Informatica Power Center, DB2, Unix Shell Scripting, WinSQL