We provide IT Staff Augmentation Services!

Sr. Etl Informatica Consultant Resume

IL

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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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

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 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

Responsibilities:
  • 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

Hire Now