SUMMARY

• Having 7 years of IT experience in Analysis, Design and Development as a Software Engineer in developing strategies for ETL mechanism using SQL,PL/SQL and Informatica ETL Tools in complex, high volume Data Warehousing projects.
• Thorough knowledge in all phases of Data warehouse Life Cycle.
• Strong knowledge of Data warehousing fundamentals and dimensional modeling.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, reusable transformations.
• Clear and thorough understanding of business processes and the designing part of the ETL Development.
• Implemented SCD mechanisms like TYPE 2(Current flag & Effective Date Range) Expertise in Performance tuning and well versed on optimizing mapping level bottlenecks.
• Extensive hands on Unit Testing.
• Used Mapping Parameters and session parameters in various projects in the development.
• Managed and created Unit Test Case Document to determine whether the output is meeting exactly to the user requirements.
• Prepared Source to Target mapping and Support documents.
• Effectively reviewed mappings in the ETL development and resolved the bugs in the process and updated the test case document.
• Excellent quantitative and analytical skills and Exceptional analytical and problem solving skills.
• Experience in dealing with 50 - 80 TB of data in data warehousing.
• Managed offshore ETL Team.

TECHNICAL SKILLS

Languages: SQL,PL/SQL

ETL Tool: Informatica Power Center 8.6,9.1

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

Operating Systems: Windows server 2003, Windows XP, UNIX

Other Tools & Utilities: Toad, Control M, Autosys, Mercury Quality Center, Erwin, Visio

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles

Informatica Senior Developer

Responsibilities:

• Extensively used ETL tool Informatica to load data from different systems in to Data Warehouse.
• Participated in end to end Development activities.
• Developed the validation logic.
• Created Informatica mappings to build business rules to load data.
• Created sessions to run the mappings and took necessary measures to improve the load performance.
• Created mapplets to re-use transformation Logic.
• Implemented error handling and validation rules.
• Resolving if any issues in transformations and mappings during the development.
• Extracted information from flat files with related information such as, Customer, Location and transactions.
• Extracted metadata from different internal systems.
• Documenting the unit test results and working with QA team to resolve any issues.
• Scheduling the Jobs in control-M

Confidential, Ohio

Informatica Senior Developer

Responsibilities:

• Involved in Extraction, transformation, Loading and Implementation
• Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, oracle and then loading to SQL Server target database
• Extensively used various types of transformations such as source qualifier, Expression, Joiner, Update strategy, Aggregator, Lookup to load the data.
• Extracted information from flat files with related information such as, Customer, Location and transactions.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Performed Mapping Optimizations to ensure maximum Efficiency
• Created sessions to run the mappings and set the session parameters to improve the load performance.
• Design and development of mapping and Database management.
• Unit testing
• Prepared Low Level design document.
• Design the Error handling and Auditing Process.
• Scheduled all the Jobs in production using Autosys.

Confidential

Informatica Developer

Responsibilities:

• Developed ETL for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 8.6.0
• Informatica Power Center is used to extract the base tables in the data warehouse and the source databases include Oracle, Flat files and SQL Server.
• Setup the batches, configured the sessions and scheduled the loads as per requirement using UNIX scripts
• Extensively worked in fixing poorly designed mappings and developed schedules to automate the Informatica workflows
• Developed oracle PL/SQL, DDLs, and Stored Procedures and worked on performance and fine Tuning of SQL & PL/SQL stored procedures
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files
• Extracting data from several source systems like Oracle, XML files, etc. and loading data into DDM (Enterprise Data ware house).
• Prepared the documentation for the mappings and workflows
• Created test plans and did unit testing for the Informatica mappings and stored procedures
• Involved in Unit testing, Integration testing, UAT by creating test cases, test plans and helping Informatica administrator in deployment of code across Dev, Test and Prod Repositories.

Confidential

Informatica Developer

Responsibilities:

• Developed the mappings using Informatica’s data integration technology to extract, transform, and load data from the oracle and flat files.
• Converted the stored procedures in Oracle SQL,PL/SQL into Informatica mappings.
• Prepared the detailed unit test cases for ETL mapping.
• Tested for the business rule and prepared the test cases.
• Tuned the mapping for its better performance.
• Validating the reports by writing the test cases and SQL scripts
• Deployed the code to production using Autosys/Unix scripts.
• Post production support