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 teh jobs
• Experience in working Unix scripts and complex SQL queries
• Supporting daily/weekly/Monthly flows in production for teh developed processes
• Developed teh 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 teh 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

Responsibilities:

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

Associate channel

Confidential

Responsibilities:

• Involved in business requirements gatherings
• Used teh 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 teh mappings
• Coordinated with DBAs to create teh test objects in various test environments and in production during final implementation
• Performed debugging to identify teh issues and resolved all teh issues
• Developed shell scripts to run Informatica workflows
• Worked with auto flow and Scheduling team to schedule teh jobs in Test and Production
• Implemented teh code in system testing environment and assisted teh test team while testing
• Documented teh test results in project phases in Lotus notes
• Implemented teh 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

Responsibilities:

• Interacted with business partners and gathered teh requirements
• Assisted in designing logical and physical data models
• Developed Informatica mapping to extract teh 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 teh same functionality in multiple mappings
• Created workflows and modified worklets to run teh modified sessions
• Developed Korn Shell scripts to run teh Informatica workflows
• Worked with DBAs to review teh changed/new SQLs and made code changes as per teh DBA Recommendations
• Performed Unit testing and Validated teh data according to source to target mapping
• Documented test results and shares to project for review
• Identified teh bottlenecks and tuned teh performance of teh session
• Deployed teh code in system testing environment and assisted teh test team during their testing
• Resolved teh defects identified during system testing and closed all defects in time
• Shared teh test results with business partners and assisted in user acceptance testing
• Worked with change management team on implementation plans to production
• Implemented teh code in production and supported teh process till transitioning

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

Confidential, TX

Informatica Developer

Responsibilities:

• Interacted with business partners on teh 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 teh mappings
• Worked with DBAs to tune teh SQLs coded in teh SQL overrides
• Performed debugging to identify teh issues and resolved all teh issues
• Developed shell scripts to run Informatica workflows
• Implemented teh code in system testing environment and assisted teh test team while testing
• Performed User acceptance testing
• Documented teh test results in project phases in Lotus notes
• Implemented teh 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

Responsibilities:

• 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 teh 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 teh performance of Informatica session
• Created Informatica workflows and added teh tasks like e-mail and Command
• Worked with Unix deployment team to issue teh code to test and production
• Fixed all defects and assisted teh test team
• Prepared transition documents and transitioned teh work to service team

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

Confidential, PA

Informatica Developer

Responsibilities:

• Interacted with business partners and gathered teh requirements
• Assisted in designing logical and physical data modeling
• Developed Informatica mappings to extract teh 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 teh same functionality in multiple mappings
• Created workflows and modified worklets to run teh new/modified sessions
• Developed shell scripts to run teh Informatica workflows
• Worked with DBAs to review teh changed/new SQLs and made code changes as per their recommendations
• Performed unit testing and validated teh data according to source to target mappings
• Documented teh test results and shared to project for reviews
• Identified teh bottlenecks and tuned teh performance
• Implemented teh code to production and supported for one month

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