SUMMARY:

• Around 5 years of work experience in Information Technology including Requirements Analysis, Design, Development, and Production Support of Business Applications using Data Warehousing tools of Business Intelligence (BI).
• Experience in client requirement analysis, physical, logical design development, resource planning, coding, debugging, testing, deployment, support and maintenance of business intelligence applications.
• Experience in developing ETL mappings using Informatica Power Center, Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor.
• Experience in creating various transformations and mappings using Informatica Designer and tasks using workflow manager to apply business logics and move to data from multiple sources into targets.
• Experience in Database using Oracle, SQL, PL/SQL, and Toad.
• Experience in preparing Technical Design Document, Mapping Documents and Detail Design Document for the Source/Target mapping. .
• Excellent experience in designing, modeling, performance tuning and analysis, implementing processes using ETL tool Informatica Power Center for Data Extraction, Transformation and Loading processes.
• Designing and developing complex Mappings using transformations like Source Qualifier, Aggregator, Expression, Connected &Unconnected Lookup, Filter, Joiner, Sequence generator, Sorter, Router, Normalizer and Update Strategy.
• Used Teradata utilities FastLoad, MultiLoad, TPump to load data.
• Worked with snowflake schema to eliminate the data redundancy for smaller data warehouses.
• Written several complex SQL queries to validate the Data Transformation Rules for ETL testing.
• Have used BTEQ, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Developed Workflows using task developer, Work let designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Experience with high volume datasets from various sources like Oracle, Flat Files, SQL Server and XML.
• Performed data loading and transforming by using ETL & ELT pipelines.
• Experience in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
• Working with an Agile, Scrum Methodology to ensure delivery of high quality of work.
• Executed several projects using agile methodology.
• Design and implementation of Informatica (IDQ v9.6), Data Quality applications for the business and technology users across the entire full development life - cycle.
• Experience in UNIX environment, file transfers and job scheduling.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Designed and coded application components in an agile environment utilizing a test driven development approach.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 9.6/ Informatica PowerCenter 9.5.1, Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Informatica IDQ 9.6.

Databases: Oracle 11g, 10g, Teradata, SQL Server 2008,MySQL, IBM DB2, Mongo DB.

Data Modeling: Kimball & Inmon Methodologies.

Methodologies: Star Schema, Snowflake Schema, Galaxy Schema.

Reporting Tools: OBIEE - Oracle Business Intelligence 10.1.3.X, Oracle BI Publisher, MS Word.

GUI: Visual Basic 6.0

Languages: SQL, PL/SQL, C, C#.NET, VB.NET, JAVA, C++.

DB Tools: Toad, Sql Developer, SQL* plus, SQL* Loader, Import, Export

Scripting: HTML, XML, JavaScript, VBScript, ASP, UNIX Shell Scripting, Python.

OS: Windows 7/Vista/XP/2003/2000/NT/98/95, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica ETL Developer

Responsibilities:

• Understanding the requirements and developed ETL design document to develop mappings.
• Worked with Informatica Data Quality 9.6 (IDQ) toolkit, Analysis, data cleansing, data matching,data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.6.
• Identified and eliminated duplicates in datasets thorough IDQ 9.6 Algorithms of Edit Distance,Jaro Distance, Hammer Distance and Mixed Field matcher, it enables the creation of a singleview of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Developed IDQ mappings using various transformations like Labeler, Standardization, CaseConverter, Match and Address Validation Transformation.
• Developed mapping using Key Generator Transformation with Match Transformation.
• Efficient in creating source, target databases and developing strategies for Extraction, transformation and loading (ETL) mechanism using Informatica PowerCenter Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Experience with all components of Informatica PowerCenter such as Source Analyzer, Target designer, Transformation, Mappings Designer, Mapplets.
• Experience with complex mappings using different transformations such as Source Qualifier, Expression, Filter, Joiner, Router, Update Strategy, Union, Rank, Normalizer, Unconnected / Connected Lookup, JAVA, Sorter, Sequence Generator and Aggregator.
• Focused on fixed and de-limited flat files, also worked with direct and indirect flat files.
• Used dimensional modeling techniques to design the data warehouse.
• Used Meta data management to store data mapping and transformations from source systems to the data warehouse.
• Experience in various Heterogeneous Database Systems like Oracle, DB2, Teradata, MS SQL Server flat files, and XML document, and Excel, CSV and Legacy systems.
• Proficient in dimensional modeling using Star and Snowflake schema, identifying Facts and Dimensions tables, data profiling, data cleansing and Data Staging of operational sources using ETL processes.
• Understanding Relational Database Management Systems (RDBMS) concepts.
• Worked extensively on SQL, PL/SQL and UNIX shell scripting.
• Knowledge in OLTP, OLAP Systems, Kimball and Inmon methodologies.
• Using Kimball methodology designed and builds DW/BI system architecture based on your business requirements, data volumes, and IT systems environment.
• Used Informatica power center to load data from different sources like flat files and Oracle, Teradata into the Oracle Data Warehouse.
• Knowledge in design and implementation of SCD - slowly changing dimensions types (1, 2 and 3).
• Performed root cause analysis on failures and resolving the performance tuning related issues and queries.
• Wrote complex SQL Queries involving multiple tables with joins. Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Creation of indexes for enhancing performance for data access.
• Performed Unit testing on the developed Mappings and was also involves in the documentation of Test Plans and testing with the Users (UAT).
• Worked with an agile, Scrum methodology to ensure delivery of high quality work.
• Experience with Autosys, Control-M scheduling team in Scheduling tools.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Involved in writing procedures, functions in PL/SQL.

Environment: Informatica Power Center 9.6, Informatica Data Quality 9.6.1, Oracle 11g,Teradata,Business Objects xi, TOAD,PL/SQL, SQL server, SSIS(2008),SSRS(2008),Windows,UNIX.

Informatica ETL Developer

Responsibilities:

• Responsible for information gathering, analysis and worked with Business Analysts in understanding the requirements.
• Worked with an agile, Scrum methodology to ensure delivery of high quality work
• Experience on loading data from different sources like Oracle, DB2, ASCII delimited flat files, CSV files to Teradata warehouse.
• Extensively used various active and passive transformations like Filter, Router, Expression, Source Qualifier, Joiner, Lookup, Update Strategy, Sequence Generator, Rank, XML and Aggregator.
• Experience in using mapping variables, workflow variables.
• Tuning of SQL queries in SQL overrides for better performance.
• Performed Tuning of the developed Informatica Mappings and Sessions by identifying and eliminating the bottlenecks for improving the performance.
• Created workflows and sessions to execute mappings using workflow manager.
• Created all reusable sessions for all the mappings developed.
• Ability to work on different utilities of Teradata like FastExport, FastLoad, MultiLoad, TPump.
• Experience on Type1 and Type2 Slowly Changing Dimensions (SCD).
• Experience on Oracle database tool like Toad.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources.
• Performance tuning of the Informatica mappings using various options available in Informatica.
• Worked on tuning of sessions and mappings for better performance.
• Running the SQL scripts from TOAD and creating Oracle objects like tables, views, Indexes, sequences & synonyms.
• Worked with offshore team by helping them to understand the requirements and co-ordinate with them to meet the deadlines.

Environment: Informatica PowerCenter 9.6,Windows, Oracle 11g, DB2 SQL, PL/SQL, TOAD, Delimited Flat Files, UNIX Shell Scripting.

Informatica ETL Developer

Responsibilities:

• Business Analysis and Requirements gathering.
• Developed a number of Informatica Mappings, Mapplets and transformations to load data from relational and flat file sources into the Target.
• Comfortable Working on SQL queries.
• Created PL/SQL procedures.
• Implemented SCD (Slowly changing dimension).
• Designed reusable tasks at mapping level and at workflow level.
• Used various Transformations like Source Qualifier, Lookup, expression, Update Strategy, Router, Filter, Sequence Generator and Joiner on the extracted source data according to the business rules and technical specifications.
• Usage of Aggregator, SQL overrides usage in source filter and lookups and data flow management into multiple targets using Routers.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Worked with Oracle, PL/SQL Stored Procedures, Functions Cursors, Indexes and Triggers and involved in Query Optimization.
• Created various Reusable Components in Informatica for reusability purposes.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Design/implement queries to extract specific data from legacy system to new data warehouse.
• Worked on the Performance tuning of the programs, ETL Procedures and processes.

Environment: Informatica Power Center 9.5.1, Oracle 11g, Windows, Teradata utilities.