SUMMARY

• Having 8 years of vast experience in IT industry with wide range of skill sets, roles and industry verticals.
• Expertise in Design, Development and Implementation of Data Warehouses with ETL Tools using Informatica Power Center, Oracle10g/9i/8i and various other databases.
• Having 5+ years of work experience in Informatica using Informatica Power Center and experienced major roles as Senior Developer and Tech Lead.
• Experienced in developing data profiling and quality assessment processes.
• Experienced in developing data filtering, transformation and loading requirements.
• Ability to analyze source systems and business requirements, identify and document business rules, design data architecture
• Extensive Knowledge in Dimensional Data modeling, Star Schema modeling, Snow - Flake modeling, Fact and Dimension tables, Physical and logical data modeling.
• Experience in Performance Tuning of Informatica PowerCenter ETL jobs, Oracle SQL Queries
• Expertise in using Informatica Web services, HTTP and XML transformations
• Strong Experience in writing complex SQL Queries, PL/SQL stored procedures, triggers, creating tables, Indexes, Views and Materialized Views
• Experienced in determining appropriate translations between source data and target databases
• Experienced in design and implement appropriate error handling procedures
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, XML, DB2, Oracle, SQL Server, and also from ERP Oracle EBS, PeopleSoft and various legacy systems.
• Extensively worked on Informatica power center tools - Designer, Workflow Manager, Workflow Monitor & Repository Manager
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplets and Mapping Designer
• Extensive experience in error handling and problem fixing in Informatica
• Extensive experience in preparation of Technical Design document, Test cases, Unit testing, System testing, and Integration testing
• Experience in leading teams. Roles included Project Lead, System Analyst, Onsite Coordinator and Developer.
• Extensive knowledge on ETL Datastage.
• Extensive experience in full lifecycle project.
• Experienced in Capturing Incremental data (CDC) from source systems
• Worked Extensively with Slowly Changing Dimensions i.e. Type1 & Type2
• Excellent problem solving skills with a strong technical background and good interpersonal skills
• Excellent team player, quick learner, ability to work and deliver under tight deadlines

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6.1/8.5/8.1/7. x/6.x, Source AnalyzerMapping Designer, Workflow Monitor, Workflow ManagerData Quality, Repository, Metadata, Data Mart, OLAP, OLTP, Web servicesIntermediate skill level in ETL Ascential DataStage (Administrator, Designer, Director, Parallel, Extender, Quality Stage)

Programming Languages: SQL, PL/SQL, Shell Script

Operating Systems: Unix, Windows 95/98/2000/8.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server, MySQL, DB2

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Sr. ETL Informatica Developer

Responsibilities:

• Work closely with Business analysts and Business users to understand the requirements and to build the technical specifications.
• Prepared Technical Specification Documents and worked to design, develop and build Informatica jobs.
• UsedInformatica Power Center Workflow managerto create sessions, batches to run with the logic embedded in the mappings.
• Involved in Performance tuning of complex queries.
• Responsible to create Source to Target mappings.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Responsible for internal reviews of the deliverables by the team members and with Tech Leads.
• Extracted data from different sources likeOracle,flat files,XML,DB2andSQL Serverloaded into Data Ware House (DWH).
• Extracted data from Excel sheets, fixed width and delimited files.
• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.

Environment: Informatica 8.6, Oracle 9i,Unix

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
• Extensively Worked on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Participated in discussions with Team leader, Group Members and Technical Manager regarding any technical and Business Requirement issues.
• Involved in strategy making in order to extract relevant data from heterogeneous sources.
• Involved in creating Documentation like preparing high level design and ETL Specifications.
• Validation & Exception reporting on data.
• Assisted in implementing business rules, aggregations and lookups.
• Assisted in developing complex mapping by using unconnected lookups, transformation variables and terminating duplicate records and directing data to multiple targets.
• Tuned the existing stored procedures by changing the logic.
• Involved in performance tuning at transformation level like Joiner, filter, aggregator etc.

Environment: Informatica 8.6, Oracle, SQL server, Windows, Unix

Confidential, Washington DC

ETL Informatica Developer

Responsibilities:

• Interacted with the business users and collected the requirements
• Evaluated the feasibility of the requirements by analysing the source systems
• Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements
• Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system.
• Worked on physical Data Modelling
• Prepared program specifications for PL/SQL Procedures and Functions.
• Run batch jobs for loading database tables from flat files using SQL• Loader.
• Created Unix Shell scripts for automating the execution process
• Performed the data migration using SQL• loader.
• Developed new reports and customized existing according to the requirements.

Environment: Oracle 9i, SQL, SQL Developer, SQL• Plus.

Confidential, Redwood City, CA

Oracle Developer

Responsibilities:

• Study of manual operations for the proposed system.
• Created tables, views, synonyms and sequences
• Developed Graphical Screens &Reports using Visual Basic 6.0
• Written PL/SQL Stored Procedures, Triggers and Functions.
• Used SQL Loader for data loading.
• Modified existing forms, reports, and graphs as per the enhancement.
• Tested all the new and modified program units.

Environment: Windows 98, MS-Access, SQL*Forms 3.0, SQL*Plus, SQL*Loader, Oracle 8.0.