SUMMARY:

• Having 9 years of experience in Informatica with a strong background in Design, Development, Implementation and Support of ETL processes for Data Marts and large scale Data Warehouses using Informatica PowerCenter 9.X/8.5.x
• Proficient in Informatica Designer Components Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Experience in Developing Mappings, Mapplets and Transformations like Router, Normalizer, Joiner, Update Strategy, etc. between Source and Target using Informatica PowerCenter Designer.
• Worked on Slowly Changing Dimensions (Type 1, 2, 3) and its implementation to keep track of historical data.
• Efficient in troubleshooting and problem solving applications and Validating,Testing & Debugging Errors with in ETL Transformations with Informatica Debugger.
• Expertise in different types of loading like Normal and Bulk loading challenges. Involved in Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Efficient in trouble shooting, performance tuning, and optimization of ETL and reporting analysis.
• Involved in massive Data Cleansing prior to Data Staging.
• Experience with Data Extraction, Transformation and loading from different data sources into a common analytical data model using informatica.
• Proficient in the integration of various data sources with multiple relational databases like Oracle10g/9i, MS SQL Server, Teradata, COBOL files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Demonstrated ability to adapt to ever changing technologies and methodologies. Conformed to different technologies and domains very quickly.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Worklets and Workflows for data loads. proficiency in working with Teradata utilities like (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD).
• Excellent interpersonal skills, ability to effectively multitask, quick learner and a good team player.

TECHNICAL SKILLS / ABILITIES:

Databases: Teradata 14.X,Oracle 11g/10g/9i/8i, SQL Server 2005/2008

ETL Tools: Informatica PowerCenter 9.x/8.x.

Languages: PL/SQL, C, SQL

Other Tools: Teradata SQL Assistant, TOAD, SQL Developer

Methodology: Agile Methodologies

Operating Systems: Windows 2000/2003/NT/XP/7, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Beaverton, OR

ETL Informatica Developer

Responsibilities:

• Gather and analyze information on existing business processes in order to make recommendations that seek to improve business systems and processes.
• Analyze and document user requirements for enhancements to business processes and reporting. May involve investigation of third party vendors, procedures or systems.
• Analyses and identifies trends in ETL performance metrics. Designs, monitors and analyses performance metrics programs for ETL performance and tuning and monitoring initiatives.
• Keeps current with industry best practices and trends in ETL practices, tools and techniques. Creates training program to educate others. Mentors junior developers.
• Identifies, documents and tracks all ETL related performance problems and taking a leadership role in their resolution where appropriate.
• Documenting the processes, Test results along with unit testing and supporting business users throughout their testing.
• Suggesting innovative ideas to improve the performance of the code where in required.
• Involves in Coding, Implementation and UAT support to make sure that the delivery is within agreed time levs (SLA)
• Mentoring the junior developers in the team & provide KT on the project grey areas including technical along with the Application knowledge.
• Responsible from Understanding the business requirements, providing technical responses, Build and Deployment of the code till production.
• Create the Mappings, sessions, worklets & workflows to load the data in ODS.
• Working on Service Requests (SR’s) & Change Requests (CR’s).
• Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations.
• Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Involved in all phases of SDLC from requirements gathering, design, development and testing of ETL process using Informatica and Teradata.
• Gathered, analyzed business requirements and created mapping documents for the integration process.
• Designed, developed and tuned Informatica source, targets, transformations, mappings, mapplets, sessions and workflows for integrating data from various sources.
• Used Source, Filter, Expression, Lookup, union, Router, Sequence Generator, Sorter and Update strategy and, joiner transformations to ETL source data from Oracle and flat files and loaded data into targets.
• Wrote sql queries against the target database to validate the load results based on Business requirements.
• Developed the code using Teradata utilities like Fastload, Multi load, Tpump, BTEQ scripts.
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings ensured that the results are accurate before moving to QA.
• Verified ETL workflows performance during source to target loads.

Environment: Informatica Power center 9x, Oracle 11g, SQL, Teradata, PL/SQL, Toad, SQL*Loader, Quality Center, ETL testing, Maestro, Windows NT, PVCS, XML, Unix Shell Scripting, Business Objects.

Confidential, MI

ETL Developer

Responsibilities:

• Understanding the mapping specification and analyzed data according to the business requirements.
• Interfaced with analysts to understand high - level requirements and expectations.
• Extraction, Transformation and loading data from source to target.
• Used volatile, global temporary tables and parameters in code.
• Used the Fast Export utility of Teradata to run the Extracts (Extracting the data from tables and writing to flat files).
• Tested the SQL queries using Teradata SQL Assistant as part of the ETL process.
• Transformed CDC data from AS/400 using Power Exchange.
• Prepared unit test cases and verified the results like successful job runs, count check, duplicates and requirements validation to make sure results are accurate before moving code to QA.
• Verified the job performance during the data loads by checking the log files.
• Involved in required test data creation for different test scenarios

Environment: Informatica Power center 8.6/9x, Oracle 10g/11g, SQL, IBM, AS/400,Teradata, PL/SQL, Toad, SQL*Loader, Quality Center, ETL testing, Autosys, Windows NT, AIX 5.1,XML, Unix Shell Scripting, Business Objects.

Confidential, KY

ETL Developer

Responsibilities:

• Involved in detailed analysis of requirements and creation of requirement specifications and functional specifications.
• Analyzed business requirements and worked closely with various application teams and business
• To develop ETL procedures that is consistent across all application and systems.
• Involved in Creating Fact and Dimension tables using Star schema
• Built Repositories using Informatica PowerCenter Repository Manager to store Source, Target, Transformations, Mapplets and Mappings Meta Data Information.
• Worked on Informatica tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed various Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica Power Center Designer.
• Extracting and loading of data from flat file, Oracle sources to oracle database (target warehouse) using transformations in the mappings.
• Created Informatica mappings with SQL, PL/SQL procedures and Functions to build business rules to load data.
• Wrote shell scripts and control files to load data into staging tables and then into Oracle base tables using SQL*Loader.
• Performed tuning of sessions in Target, Source, Mappings and Session areas.
• The result of sessions has been track through log files using session manager.

Environment: Informatica Power Center8.6, HP Quality Center, Unix, WinSCP, Putty, OBIEE, ETL, XML, MS Excel, Oracle 10g, PL/SQL, SQL Server, Flat files, Windows NT 4.0.

Confidential

Informatica Developer

Responsibilities:

• Participated in the entire requirements engineering process right from requirements elicitation phase (where we gather the requirements from the retail business owners and marketing people) to the phase involving documenting of the requirements.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Used Task developer in the Workflow manager to define sessions
• Assisted retailers in understanding consumer buying patterns and in creating consumer sets for marketing campaigns
• Involved in quality assurance of data, automation of processes.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle into the Oracle target database.
• Involved in the creation of oracle Tables, Table Partitions, and Indexes.
• Implemented various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• Involved in the development and testing of individual data marts, Informatica mappings and update processes.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Created repository, users, groups and their privileges using Informatica Repository Manager
• Connection management and scheduling of jobs to be run in the batch process
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.

Environment: Informatica Power Center 8.6, Oracle 10g, Windows XP