SUMMARY

• Dynamic IT professional wif around 8+ years of total IT experience and Technical proficiency in the Data Warehousing teamed wif Business Requirements Analysis, Application Design and Data Modeling.
• Extensive experience in Informatica Power Center to implement data marts which involve creating, debugging and executing mappings, sessions, tasks, and workflows and testing SQL queries.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML, and Mainframe into Warehouse.
• Well versed in Data modeling concepts incorporating dimensional modeling (star and snowflake schema), logical and physical data modeling.
• Experience on Informatica designer tools - transformations, reusable transformations, mappings, and mapplets, DT Studio includes DT/Engine, DT/Designer and DT console.
• Experience working in Oracle8i/9i/10g/11g wif database objects like triggers, stored procedures, functions, packages, views, and indexes.
• Proficient in performance tuning of Informatica Mappings, Transformations, and Sessions experienced optimizing query performance.
• Worked extensively wif Informatica Workflow Manager (using tools such as Task Developer, Worklet and Workflow Designer, and Workflow Monitor) to build and run workflows.
• Experienced in using Informatica Data Quality (IDQ) tools for Data Analysis.
• Expert in using Informatica Power Exchange CDC (Change Data Capture) wif Oracle database including DC (Data conversion).
• Experience in creatingjobs, SQL Mail, Alertsandschedule SSIS PackagesusingSQL Server Agent.
• Experience using automation tools such as Autosys and Maestro for scheduling workflows.
• Identified and fixed bottlenecks, and tuned the complex Informatica mappings for better performance.
• Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling
• Excellent exposure on Software Development Life Cycle (SDLC) and Onshore/Offshore model.
• Extensively worked wifTeradatautilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Experience in building a very large data warehouse wif many complex transformations, wif many sources and targets.
• Extracted data from various sources like Oracle, DB2, flat files, SQL Server, Mainframes, Teradata and loaded into Teradata and Oracle databases.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x

Database & Related Tools: Oracle 11g, 10g/9i/8i, MS SQL Server 2005/2008, Teradata, Sybase, UDB(EEE), Netezza, Mainframes, File Aid 9.2, SQL*Plus, SQL Loader.

Data Modeling Tools: TOAD 9, Maestro, Erwin 4.0 (Dimensional Data Modeling, Star schema, Snowflake schema), Physical and Logical Data Modeling, Oracle Designer 2000.

BI & Reporting Tools: Cognos 8.0, Business Objects 6.5, Autosys, Control-M, Oracle Developer.

Languages: SQL, PL/SQL, T-SQL, C#.

Operating Systems: Window 95/98/2000/2003/ XP, Unix.

PROFESSIONAL EXPERIENCE

Confidential, Ontario, CA

Sr. ETL/ Informatica Developer

Responsibilities:

• Used Informatica Power Center to create data maps for mainframe files which involve creating debugging and executing mappings, sessions, tasks, and workflow.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Normalizer, Union, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Created and monitored sessions and batches using Server Manager to load data into the target database.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Testing of Informatica Sessions, Batches and the Target Data.
• Responsible for updating web application code and queries based on business to business (B2B) requirements.
• Importing the IDQ Mapplets to Informatica and using them in the Informatica mappings.
• Involved in migration of the Mapplet's from IDQ to power center.
• Create Oracle/Netezzaviews, tables as facts or dimensions based on requirement.
• Converting unstructured data into target database wifB2Btool of Informatica.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Cleansed the source data using Informatica Data Quality tool, extracted and transformed data wif business rules, built reusable mappings, non as ‘Mapplets’ using Informatica Designer.
• Involved in the development of Informatica mappings and used Informatica partitioning (parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities) for performance tuning theirby reducing the load time.
• Worked on Main frame files, created copy books, imported the source files and set up the respective connections.
• Created source to target mappings, data repository and data models for the Data Warehouse.
• Development of Data WarehouseModel and ETL Strategy
• Created and Maintained Oraclestored procedures (PL/SQL)
• Developed various PL/SQL packages, stored procedures and functions along wif various database objects like views, cursors, ref cursors, indexes and triggers as required.

Environment: Informatica Power Center, Oracle11g, Informatica B2B, IDQ, SQL,TOAD 9.5, UNIX, Teradata, Oracle eTRM 12.0.0,Metadata, Windows2000/XP/7, Autosys, Erwin 4.1, UC4.

Confidential, Foster City, California

Informatica Developer

Responsibilities:

• Designed and developed complex mappings in Informatica to load the data from various sources using different transformations such as SQL, Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Extensively worked wif database and Informatica Partitioning for performance tuning.
• Extensively designed and developed reusable transformations & aggregations and created target mappings dat contain business rules.
• Implemented Informatica Data qualityto do datacleansing, datamatching, reporting and monitoring the XML files
• Responsible for developing data ingestion routines, creating standards and reusable code and performing InformaticaData Transformation (B2B) development.
• Worked wif different sources like Oracle, flat files, XML files, DB2, MS SQL Server.
• Developed complex TeradataSQL code in BTEQ script using OLAP and Aggregate functions to name few.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Designed and Developed the NetezzaSQL Scripts as per the Customer requirements.
• Performance tuning of NetezzaSQL scripts.
• Used Power center Manager for managing repository, Imported and Exported items between different Informatica systems metadatawif other data warehousing tools.
• Build UNIXshell scripts to automate the ETL processes.
• Created and configured workflows, worklets, and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Created several packages to set up and share global variables, types and transforms which were extensively used for manyAb Initiographs.
• Fixed invalid mappings, tested stored procedures and functions, and performed unit testing of Informatica Sessions and Workflows.
• Implemented Slowly Changing Dimensions (SCD) to update the dimensional schema.

Environment: Informatica Power Center, Oracle11g, SQL, TOAD 9.5, UNIX, Autosys, Netezza, Metadata, Teradata, Erwin 4.1, Putty, OBIEE.

Confidential, Kansas City, MO

Informatica Developer

Responsibilities:

• ETL design and development using Informatica Power Center toolset.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Normalizer, Union, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Create Oracle/Netezzaviews, tables as facts or dimensions based on requirement.
• Technical documentationof test cases and results for all development activities.
• Job workflow definition and setup, Job monitoring and issue resolution.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Extensively worked wif database and Informatica Partitioning for performance tuning.
• Extensively designed and developed reusable transformations & aggregations and created target mappings dat contain business rules.
• Implemented Change Data Capture (CDC) to extract information and Partitioned sessions for concurrent loading of data into the target tables.
• Fixed invalid mappings, tested stored procedures and functions, and performed unit testing of Informatica Sessions and Workflows.
• Implemented Slowly Changing Dimensions (SCD) to update the dimensional schema.

Environment: Informatica Power Center/Power Exchange Development 9.1.0, Oracle 11g, SQL, TOAD 9.5, UNIX, Oracle eTRM 12.0.0,PL/SQL, Netezza, Windows2000/XP/7,Vermillion, Autosys, Erwin 4.1, Putty, OBIEE.

Confidential

Datawarehouse ETL Developer

Responsibilities:

• Gathering and analysis of Business requirements and converting them into specifications and worked as a team member for design and development of Data Mart and integrating it wif Global Data Warehouse.
• Used BTEQ utility to communicate wif Teradata RDBMS systems.
• Extracted data from DB2 mainframe by using Informatica Power Exchange and also used it for change data capture and to set up restart token file.
• Designed and developed a robust end to end ETL process for the efficient extraction, transformation and loading of Sequential flat files to the staging and tan to the data mart.
• Worked wif the data analyst to analyze Source system data and Designed data validation strategy.
• Created the database objects like tables, stored procedures, indexes, etc and partitioned the tables were the data volume is huge, to improve the reporting performance.
• Implemented complex ETL logic using SQL overrides in the source qualifier.
• Used Incremental Aggregation in the Aggregator transformation to make sure the measures for certain aggregate tables got calculated properly.
• Used stored procedure transformation to integrate the business logic implemented in Oracle stored procedures wif Informatica.
• Created shell scripts to handle File Management dat involved file transfer, external auditing and file archiving.
• Implemented complex logic in the transformations to cleanse the customer data periodically by creating reusable Mapplets.
• Created workflows, worklets and designed dependency among them using workflow manager.
• Worked wif tools like TOAD and SQL tools to write queries and generate the results.

Environment: Informatica Power Center 8.1, Oracle 9i, SQL Server 2005, SQL *Plus, Toad 8.6, Erwin 4.0, UNIX, Shell Scripts, Teradata, Mainframes, COBOL, Business Objects 6.5.