SUMMARY

• Having 7+ years of IT experience in the field of Data Warehousing, BI Architecting, Design and development for various Data warehousing project using Informatica Power center 9.5/8.6/7.1, Cognos, databases as DB2, Oracle, and Teradata.
• Experience in (ETL) INFORMATICA (Power Center 9.5/8.x/7.x, Power Exchange).
• Extensively worked on ETL mappings, analysis and documentation ofOLAP reports requirements.
• Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Excellent understanding of software Development Life Cycle (SDLC) requirement analysis, design document, implementation, review specification, testing and maintenance of applications
• Designed develop and organized complex Informatica mappings, sessions and workflows.
• Developed technical design documents and mapping specifications to build Informatica mappings to load data into target tables adhering to the business rules.
• Experience on SQL, PL/SQL in creating Views, functions, Triggers and Stored Procedures in Data Warehouse environments that employ Relational databases like Oracle, DB2 and SQL server and Teradata.
• Experience in integration of various data sources with Relational Databases like Oracle, SQL Server, XML Files and Worked on integrating data from flat files like fixed width and delimited.
• Extensive Experience in loading the data from Flat file, XML, Oracle, DB2 to SQL Server, Oracle as the Target with Informatica.
• Proficient in Data Modeling using Erwin tool for creating physical and logical data models. Managed ODBC connections in almost all the projects.
• Experience in working with UNIX, Business Intelligence tools such as Cognos and Micro strategy, SSRS, SSAS.
• Monitoring jobs in Mainframes CA7 scheduler.
• Expertise in writing/debugging/enhancing UNIX Shell Scripts.
• Good work experience in Informatica Data Integration Tools - Such as Repository Manager, Designer, Workflow Manager, Workflow Monitor and Scheduled workflows using Workflow Manager.
• Proficient in using Agile Scrum methodologies, performed roles of Scrum Team Member following sprint/standup sessions and analyzed the Iteration Burn Down charts.
• Proficient with Tools/Utilities such as TOAD, Microsoft SQL server, Oracle PL/SQL server.
• Familiar with usage of tools like QC and JIRA for defect tracking.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x, Informatica Power Analyzer/ Powermart 6.2, Crystal Reports.

Databases: Oracle11g/10g, MS SQL Server 2008, SSIS, DB2, Teradata

DB Tools: SQL Plus, TOAD, Oracle SQL *Plus

Reporting Tools: Cognos, SAP BO, SSRS, SSAS, CA7

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, Erwin.

Business Intelligence: Business Objects (BO Designer - Thick client/WEBI, Supervisor, Broadcast Agent)

Operating Systems: MS Windows2008/2007/NT/XP, Solaris, Unix, Linux, IBM Mainframes.

Languages: SQL, PL/SQL, XML, Unix Shell Scripting, COBOL.

Programming Skills: HTML, CSS, JavaScript, Jquery.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

ETL/Informatica Developer

Responsibilities:

• Analyzed business documents and created system requirement specification.
• Extensively used Informatica power Center 9.5 for ETL (Extraction, Transformation and Loading), data from relational tables and flat files.
• Extensively worked oncomplex mappings, mapplets and workflowto meet the business needs and ensured they are reusable transformation to avoid duplications.
• Designed and developed star schema, snowflake schema and created fact tables and dimension tables for the warehouse and data marts using ERwin.
• Implemented Join, Expressions, Aggregator, Rank, Lookup, and Update Strategy, Filter and Router transformations in mappings.
• Used Repository manager to create folders, which is used to organize and store all metadata in the repository.
• Responsible for developing, support and maintenance for theETL(Extract, Transform and Load) processes usingInformaticaPower Center 9.5.1.
• Migrating frominformatica9.1.1 mappings intoinformatica9.5.1, which consists of grid technology.
• Understanding the domain and nodes as well as by using theinformaticaintegration service to run the workflows in 9.5.1.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets to data into data warehouse.
• Developedshell scriptsfor Daily and weekly Loads and scheduled usingUnix Maestroutility.
• Involved in writingSQL scripts, stored procedures and functionsand debugging.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Responsible for providing comments for user stories within an AGILE software development SCRUM environment.
• Monitoring jobs in Mainframes CA7 scheduler.
• Created sessions and batches and tuned performance of Informatica sessions for large data files by increasing the block size, data cache size and target based commit interval.
• Used debugger to test mapping at designer level.
• Developed email routines to indicate failure or successful completion of workflows.
• Wrote stored procedures to check source data with warehouse data if it is not present wrote those records to spool table.
• Created configured and scheduled the sessions and Batches for different mappings using workflow manager and using UNIX scripts.
• Extensively used PL/SQL programming in backend and front-end functions, procedures to implement business rules.
• Involved in upgrading from Informatica Power Center 8.6 to 9.5.1.

Environment: Informatica Power Center 9.5/8.6, Power Mart, Oracle Oracle11g/10g, PL/SQL, CA7 Cognos, SAP BO, SSRS, Windows, UNIX, ERwin, TOAD, Control-M, mercury Quality center, Business objects, Windows XP, IBM Mainframes.

Confidential, San Francisco, CA

ETL/Informatica Developer

Responsibilities:

• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested the mappings.
• Coordinate and develop all documents related to ETL design and development.
• Involved in designing the Data Mart models with ERwin using Star schema methodology.
• Used repository manager to create repository, users groups and managed users by setting up privileges and profile...
• Used debugger to debug the mapping and correct them.
• Performed Database tasks such as creating database objects (tables, views, procedures, functions).
• Responsible for debugging and performance tuning of targets, sources, mappings and sessions.
• Optimized the mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
• Used Informatica workflow manager for creating, running the Batches and Sessions and scheduling them to run at specified time.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and set up email delivery after execution.
• Preparing Functional Specifications, System Architecture/Design, Implementation Strategy, Test Plan & Test Cases.
• Implemented and documented all the best practices used for the data warehouse.
• Improving the performance of the ETL by indexing and caching.
• Created Workflows, tasks, database connections, FTP connections using workflow manager.
• Responsible for identifying bugs in existing mappings by analyzing data flow, evaluating transformations and fixing bugs.
• Code walks through with team members.
• Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.
• Created UNIX shell scripting for automation of ETL processes.

Environment: Informatica Power Center 8.6/7.1, Oracle Oracle10g, SQL, Teradata, Cognos, SAPBO, SSRS, UNIX Shell Scripting, ERwin, TOAD, Mercury Quality center, Windows XP, IBM Mainframes.

Confidential, New York, NY

ETL/Informatica Developer

Responsibilities:

• Worked closely with Business Analyst and the end users in writing the functional specifications based on the business requirement needs.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin 4.5 to design the business process, dimensions and measured facts.
• Involved in massive data cleansing prior to data staging.
• Created mapping using XML, COBOL sources.
• Worked on power exchange to access the data from different sources and to avoid manual coding.
• Innovative design for Change data capture of Suppliers and millions of Account every business day.
• Experience with high volume datasets from various sources like Oracle, Text Files, and Relational Tables and xml targets.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalize, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop theInformaticaserver and recover the sessions.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Implemented Type1 and Type2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informaticasessions, batches and the target Data.
• Tuning the complex mappings based on source target and mapping, session level.
• Involved in performance and tuning theETLprocesses.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Developed UNIX Shell Scripts for scheduling the sessions inInformatica.
• Used SQL tools like TOAD 9.5 to run SQL queries and validate the data in warehouse.

Environment: InformaticaPower Center 8.6/7.1, Oracle Oracle10g, SQL, Teradata, Cognos, SAPBO, SSRS, UNIX, ERwin, TOAD, OBIEE, XML, PL/SQL, SQL server 2008, Windows, UNIX.

Confidential, Tampa, FL

ETL/Informatica Developer

Responsibilities:

• Worked on Informatica - Repository Manager, Designer, and Workflow Manager & Workflow Monitor.
• Integrated data into CDW by sourcing it from different sources like SQL, Flat Files and Mainframes (DB2 and VSAM) using Power Exchange.
• Extensively worked on integrating data from Mainframes to Informatica Power Exchange.
• Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and Mapplets to load data from external flat files and RDBMS.
• Used output xml files, to remove empty delta files and to FTP the output xml files to different server.
• Used MDM to extract the file and for address standardization.
• Worked with the Business Analyst team during the functional design and technical design phases. Designed the mappings between sources (external files and databases) to operational staging targets.
• Created Audit tables, Control Tables, Chain of Trust to maintain the statistics of data.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, connected & unconnected lookups, Filters, Router, Expression, Rank Union, Normalizer, XML Transformations and Update Strategy & Sequence Generator.
• Used XML transformation to load the data XML file.
• Used XML Generator transformation accepts data from multiple ports and writes XML through a single output port.
• Integrated data in to EDW by sourcing it from different sources like Mainframes copy books (COBOL files), DB2 and Teradata tables.
• Used SQL, PL/SQL to validate the Data going in to the Data Ware House.
• Worked on Informatica Schedulers to schedule the workflows.
• Extensively worked with Target XSD’s in order to generate the output xml files.
• Used Message broker as translate messages between the interfaces.
• Created mappings to read parameterized data from tables to create parameter files.
• Good Experience Co-Coordinating with Offshore.

Environment: Informatica Power Center, Power Exchange, Windows, IBM DB2 8.x, Mainframes, COBOL, SQL Server 2008, Erwin, BTEQ, Enterprise Architect, Meta data Manager, ER studio.

Confidential, Los Angeles, CA

ETL/Informatica Developer

Responsibilities:

• Analyzed source and target systems for loading data into CDW and to create external data feeds.
• Involved all the phases of SDLC design and development.
• Involved in gap analysis and STM documentation to map flat file fields with relational table data in CDW.
• Developed mappings, mapplets, re-usable transformations to load external data into CDW.
• Extracted data from CDW to create delimited and fixed width flat file data feeds that go out to external sources.
• Analyzed Design documents and developed ETL requirement specs.
• Created re-usable objects and shortcuts for various commonly used flat file and relational sources.
• Developed a shell script in order to append Date and Time stamp for output xml files, to remove empty delta files and to FTP the output xml files to different servers.
• Validate Logical Data Models relationships and entities, Determine data linage by including all associated systems in data profile.
• Excellent Data Profiling experience used Data Polling validating data patterns and formats.
• Integrated data into CDW by sourcing it from different sources like Oracle, Flat Files and Mainframes (DB2 and VSAM) using Power Exchange.
• Technical Analysis writing & reviewing technical designs.
• Created UNIX scripts to deal with flat file data like merging delta files with whole files and to concatenate header, detailed and trailer parts of the files.
• Developed Mappings, which loads the data in to Teradata tables with SAP definitions as Sources.
• Created mappings to read parameterized data from tables to create parameter files.
• Used XML Source Qualifier is used only with an XML source definition. to represents the data elements that the Informatica Server reads when it executes a session with XMLDeveloped.
• Used XML Parser transformation lets you extract XML data from messaging systems.
• Used ODI to perform data integration to ELT processing. Data is extracted from multiple sources, sent through several transformation processes and loaded into a final destination target.
• Used SAS for data entry, Retrieval, Management report writing and Statistical analysis.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load (ETL) data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Used Message broker as translate messages between the interfaces.

Environment: Informatica Power Center, Power Exchange, Windows, Oracle, Toad for Oracle, BODS, UNIX, workflow scheduler, Perl.