We provide IT Staff Augmentation Services!

Informatica Developer Resume

Richardson, TX

SUMMARY:

  • Over 7 years of IT experience with a strong background in SDLC, Data Integration tools including Informatica Power Center, Informatica Power Exchange.
  • Currently working with Accenture in a Contract position over more than 3 Years.
  • Expertise in Informatica Power Center 9.x/8.x extracting data from SQL Server and DB2 databases.
  • Extensive experience in Extraction, Transformation and Loading of data using Informatica and DB2 Utilities from heterogeneous sources.
  • Performed ETL activities with the help of DB2 Utilities and shell scripting by redesigning existing informatica Mappings and Workflows
  • Involved in Application Migration from SQL Server to DB2 including Data Archival and Database Migration
  • Involved in Database Migration from SQL Server to DB2 including Data Archival
  • Extensive experience with Insurance and Banking Domains.
  • Experience working in an Agile/Scrum environment.
  • Strong ability to analyze source systems and business requirements, identify and document business rules, design data architecture for cohesive decision support and prepare dimensional data models.
  • Good understanding of Dimensional data modeling like Star and Snowflake schemas
  • Organized Group sessions to discuss complex business requirements, design sessions, code reviews and troubleshooting issues.
  • Extensively worked in development of Informatica Mappings and Informatica Workflows.
  • Involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.
  • Performed Performance/ Query tuning and Generation/interpretation of explain plans and tuning SQL to improve performance.
  • Skilled in Linux Shell Scripting and experience on different UNIX platforms.
  • Experience in scheduling of ETL jobs using $Universe and Control - M.
  • Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
  • Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.
  • Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, maintenance and production support.
  • A highly motivated self-starter and a good team-player with excellent verbal and written communication skills.
  • Experienced in debugging, Error handling and performance tuning of sources, targets, mappings and sessions. Implemented parallelism in loads by partitioning.
  • Expertise in preparing the ETL Design Documents like low-level Design documents, Technical design documents and Source to Target Mappings.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x.

Other Tools: Toad, MS Visio, DB2 Connect, DB2 Data Joiner, Quest Tools, Power Designer, HP Service Manager, XML & XSD

Data Modeling/Tools: Visio, Star Schema, Snowflakes Modeling

Databases: MS SQL Server 2005/2008, Oracle 8i/9i /10g,IBM DB2

Scripting Languages: Korn Shell

Methodologies: Data Warehousing Design, Data Modeling, Logical and Physical Database Design.

Operating Systems: UNIX, Windows 7, LINUX and Mainframe

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Informatica Developer

Responsibilities:

  • Developed ETL programs using Informatica to implement the business requirements, Using Agile Scrum Model.
  • Communicated with business customers to discuss the issues and requirements.
  • Created shell scripts to fine tune the ETL flow of the Informatica workflows.
  • Redesigned Existing ETL flow with Linux Scripting.
  • Used Informatica file watch events to pole the FTP sites for the external mainframe files.
  • Production Support has been done as part of ELS period to resolve the ongoing issues and troubleshoot the deployment problems.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
  • Worked in Informatica version-based environment and used deployment groups to migrate the objects.
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
  • Effectively worked on Onsite and Offshore work model.
  • Pre and post session assignment variables were used to pass the variable values from one session to other.
  • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
  • Performed unit testing at various levels of the ETL and actively involved in team code reviews.
  • Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica Power Center 10.1/9.6,Web Services, DB2, SQL Server, Xml, Flat Files, WinSCP, UNIX / Windows MS VISIO, Control-M, Quality Center

Confidential, Bloomington, IL

Production Support Analyst

Responsibilities:

  • Identifying the load on server and performing load balancing to avoid SLA miss outs during regular job monitoring.
  • Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
  • Involved in development of Informatica Mappings, Mapplets and Workflows for complex Business rules
  • Deploy Informatica Objects in to TEST, UAT and Production Environments.
  • Having experience on Dimensional Data Modeling using Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
  • Performed various transformation logics by utilizing the Source Qualifier, expression, filter, joiner, lookup, router and Update Strategy.
  • Prepared required application design documents based on business functionality.
  • Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
  • Monitoring daily runs of jobs on $Universe (scheduling tool) and UNIX environment.
  • Batch job support (24x7) including Month End, Quarter End and Year-End Support.
  • Involving in migration and Testing of applications during software/hardware environment upgrades.
  • Developed and Scheduled Various Mappings and Sessions.
  • Automated various manual Processes through ETL logic.
  • Involved in code and application development & enhancements.
  • I was also involved in Solving Priority 1 Business Cases and Maintaining and supporting the production in a Full Cycle basis.
  • Responsible for maintenance of proper quality standards in deliverables, version control, defect tracker, error log etc and Major Business and Operations Support.
  • Involved in Critical and high priority time bound issues providing detailed Root Cause and resolution to business users.
  • Identified performance bottlenecks and implemented Performance tuning methods.

Environment: Informatica Power center 9.5/9.1, UNIX, Oracle 11g, SQL, Dolor Universe, Korn Shell, Quality Center 9.x, Power Exchange 9.2.1/8.6.1.

Confidential

ETL Tester

Responsibilities:

  • Performing data threshold validation check
  • Validating record count check, before and after the transformation logic applied
  • Data flow validation from the staging area to the intermediate tables
  • Identifying record count check from the intermediate table to the target system.
  • Ensure the key field data is not missing or Null.
  • Checking if the aggregate values and calculated measures are loaded in the fact tables.
  • Check modeling views based on the target tables.
  • Check the BI reports based on the loaded fact and dimension table and as per the expected results.
  • Identified the Test requirements based on business requirements.
  • Performed Manual Testing and maintained documentation on different types of Testing viz., Positive, Negative, System, User-acceptance, and Black Box.
  • Developed Test Objectives, Test Cases and Test Procedures after analyzing the applications.
  • Developed test scenarios and test procedures based on the test requirements.
  • Participated in preparing Test Plans.
  • Performed data driven testing and regression testing using Win Runner and interacted with developers to resolve the issues.
  • Documented errors and implemented their resolutions.
  • Wrote SQL queries to validate data.
  • Participated in regular meetings with the development team and management to improve the testing effort of the application.
  • Participated in user training and submitted weekly status reports.

Environment: Informatica Power Center 8.6/ 8.1, TOAD, PL/SQL, Oracle 10G, Test Director, QC.

Hire Now