PROFESSIONAL SUMMARY:

• 10+year of experience in Information Technology with a strong background in Informatica Power Center and SQL and have basic understanding of Data Warehousing and Data Modeling concepts.
• Extensively worked on Informatica Tools - Source Analyzer, Target Designer, Mapping Designer Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Expertise in designing and developing Informatica mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, stored procedure etc.
• Have performed various testing activities like unit testing, Integration-system Testing and user
• Acceptance testing and ensured that the code is ideal.
• Basic knowledge in UNIX Shell Scripting on UNIX & Linux platform. Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skill
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Having experience in working with both 3NF and dimensional models for data warehouse and good understanding of OLAP/OLTP systems.
• Ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries
• Strong analytical skills with ability to quickly understand business needs.
• Excellent Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product within deadlines

PROFESSIONAL EXPERIENCE:

Confidential, Springfield, IL

Informatica Developer

Responsibilities:

• Developed common routine mappings, Made use of mapping variables, mapping parameters and variable functions.
• Developed Informatica mappings, Reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier, and Joiner, designed complex mappings involving target load order and constraint based loading Create/build and run/schedule Workflows and Work lets using the Workflow Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Coded Database triggers, functions and Storedprocedures and written many SQL Queries. Helped coding shell scripts for various administration activities for daily backup.
• Involved in Physical schema implementation, objects like table-space, table rollback segments, created database structures, objects, and their modification as and when needed.
• Used versioning and shared folders for better control on Informatica jobs among the team and across different projects.
• Worked on slowly changing dimension Type2.
• Mapped the source and target databases by studying the specifications and analyzing the requirements.
• Involved in performance testing of jobs.
• Troubleshoot day to day database issues.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse

Environment: Power Center 9.x, Oracle 10g, IDQ, SQL, PL/SQL, UNIX (AXI), Erwin, Toad, Linux (Solaris).

Confidential

Informatica Developer

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Target Analyzer, Mapping & Mapplet Designer and Transformation Designer
• Extracted data from different sources to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center
• Performed the performance tuning at source, Target levels using Indexes, created instances and Partitioning in Informatica.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call Support
• Performed Unit testing and maintained test logs and test cases for all the mappings
• Maintained warehouse metadata, naming standards and warehouse standards for future applicatiodevelopment.
• Parsing high-level design specification to simple ETL coding along with mapping standards.

Confidential

Informatica Developer

Responsibilities:

• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using power center of Informatica.
• Created Informatica Workflows as per the business rules to load data into OLTP databases
• Parameterized the mappings and increased the re-usability.
• Created complex mappings in Power Center Designer using Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Worked on Teradata RDBMS using Fast load, Multiload, Tpump, Fastexport, Multiload Export, Teradata SQL And BTEQ Teradata utilities.
• Development and testing of mappings at Informatica level.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings. Developed error handling & data quality checks. in Informatica mappings.
• Extracted data from various source systems like Teradata, Tibco, Oracle, SQL Server and flat files as per the requirements.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments.
• Created and Monitor the sessions using workflow manager and workflow monitor.
• Migrated the code from DEV/SIT/UAT to production environments
• Created Test Plans and Test Scripts to support the testing team.
• Conducting unit testing

Environment: Teradata 13.x, Informatica Power Center 8.6, Oracle 10g, Windows XP, UNIX.