SUMMARY

• 6 years of total IT experience in the Business Requirements Analysis, Application Design, Data Modeling, Development, Implementations and Testing of Data warehouses and Database business systems for various Verticals like Banking/Financial Industry, Insurance and Telecommunications.
• Extensive experience in Informatica Power Center 10.2,9.X,8.X,Oracle Back - End Programming (PL-SQL) and OBIEE Implementation.
• Experienced in design, develop and maintaining Data Warehouses and Data Marts using INFORMATICA 10.2/9.6.1/8.6.1/8.1 , Oracle.
• Expertise in performance tuning and SQL Optimization.
• Expertise in different types of loading like Normal and Bulk loading challenges. Involved in Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Expertise in creation, modification and testing of Informatica Mappings, Mapplets, Workflows, Worklets and debugging and performance tuning of Informatica Mappings and Sessions.
• Experienced in Performance tuning of critical Informatica jobs and report queries.
• Involved in resolving Production job failures and Involved in fixing the production data Issues.
• Experience in slowly Changing Dimensions (Type 1, Type 2 and Type 3), OLTP, OLAP, Data Reports and Surrogate keys, Normalization/De normalization.
• Experience in UNIX Shell Scripting .
• Experience in job scheduling using autosys.
• Experience in Database Programming, SQL, PL/SQL (Stored Procedures, Functions and Triggers) for faster transformations and Development.
• Experienced in Creating Problem Tickets, Work Requests, Change Requests (CRs) and Work Orders.
• Involved in Code Reviews & suggested best practices and presented Informatica new features in USER Group meetings.
• Technical expertise in all aspects of the SDLC involving requirement analysis, system study, designing, coding, testing, documentation and implementation
• An effective communicator with honed interpersonal, leadership, planning, problem solving and motivational skills
• Expertise in complete software development life cycle using Agile methodologies, process optimization, quality engineering and customer satisfaction

TECHNICAL SKILLS

Programming Languages: C, C++, SQL, UNIX shell scripting

Databases: ORACLE, SQLServer

ETL tools: INFORMATICA POWER CENTER, POWER EXCHANGE

Operating Systems: UNIX and Windows

Other Tools: Toad, JIRA

IDE: Microsoft Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Validated the current production data, existing data and the programming logic involved
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override and Created mapplets to use them in different mappings.
• Worked onrequirements gathering, architecting the ETL lifecycle and creating designspecifications, ETL design documents.
• Converted Informatica mappings in to Teradata scripts using Teradata Utilities
• Involved in creation and modification of audit/validation scripts
• Scheduled jobs using Autosys job scheduler.
• Implemented Type II Slowly chasing Dimensions to maintain Historical data.
• Developed test Scripts, test data for Unit testing, A processing.
• Created sources and targets scripts based on the required columns.
• Assisted from Offshore during migration.

Environment: Informatica-Power Center 10.2 / 9.6.1,UNIX scripting, Exadata, Oracle 11g, Toad, Windows, AUTOSYS

Confidential

Informatica Developer

Responsibilities:

• Assessed requirements for completeness and accuracy and determined if requirements are actionable for ETL team
• Defined and implemented ETL development standards and procedures.
• Created, optimized, reviewed, and executed SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables
• Performed tuning and optimization of complex SQL queries Explain plan and also Responsible for Stats Collection on FACT tables
• Performance Tuning of physical database objects (tables, views, indexes, PPI, UPI, NUPI, and USI) to support normalized and dimensional models. Maintain the referential integrity of the database.
• Used JIRA tool to track requirements, development and defects.
• As an ETL Developer, involved in entire data warehousing life cycle design and development.
• Involved in Design & development of Informatica Power Center mappings, workflows.
• Involved in the development of Informatica mappings and also tuning of mappings for better performance.
• Developed informatica mappings in various transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy, SQL, UNION, and Joiner transformations etc.
• Extensively worked on Informatica Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.
• Involved in creation and modification of audit/validation scripts
• Scheduled jobs using Autosys job scheduler.
• Developed test Scripts, test data for Unit testing, A processing.
• Created sources and targets scripts based on the required columns.
• Worked on Cognos Frame Work Manager to create the Data Models which will be used to create Cognos Reports.
• Assisted from Offshore during migration.

Environment: Informatica-Power Center 9.6.1, UNIX, Oracle 11g, Toad, Windows, SAS Enterprise Guide, AUTOSYS, Crontab.