SUMMARY

• Over 9+ years of success in architecture, design, development, implementation/support across leading - edge technologies for numerous Fortune 500 companies.
• Experience working in Software Applications, Analysis, Design, Development, Testing, Maintenance and Enhancements in Data Warehousing and Data Integration.
• Excellent in designing ETL procedures to extract data from different heterogeneous source systems like Oracle 11g/10g, SQL Server, DB2, Netezza, Flat files, XML.
• Worked exclusively in implementing the types of slowly changing dimensions (SCDs) - Type I and II in different mappings as per the requirements.
• Strong experience on understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and SDLC (Software Development Lifecycle), Quality analysis.
• Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers
• Enhancements ofData warehouseandODS systemsusingInformatica Power Center 10.x/ 9.x/8.x/7.x/6.x,Oracle, DB2, SQL, PL/SQLand well versed with Data Warehousing Architecture, Technology, OperationalData
• Used features likepre-session/post-session commands/SQL, fine-tuned databases,mappings, andsessionsto getoptimal performance.
• Implementedslowly changing dimensionsType1,Type2andType3, slowly growingtargets, and simple pass through mapping's using Power Center.
• Experience inUNIX Shell scripting.
• Extensive experience with relational databasesOracle 10g/11g, DB2,SQLServer,.
• Extensive experience in ERP systems and CRM systems
• Experience in developingTestStrategy,Test Plan,Testcases,UseCase,and Test Scripts.
• Working and worked in Agile methodology with sprints.
• Experience working with Health Industry standards HIPAA, HL7, ANSI-834/837, NCPDP.
• Possess excellentinteraction,communicationandproblemsolvingabilities.
• Strong experience inoffshoreandonsite coordination.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9.6.1/8.x/7.x, Informatica Power Exchange 9.6.1/8.x, IDE, IDQ, MDM, SSIS, DataStage, Pentaho, SAP Business Object Data Integrator (BODI), SSIS,SSRS, Oracle Data Integrator (ODI)

Data Modeling Tools: ERWIN, Microsoft Visio Professional, SQL Developer

Reporting Tools: OBIEE, Cognos, Business Objects XIR2/XIR3, Crystal reporting, Qlikview, Micro strategy

Databases/Languages: Oracle 12/11/10/9i/8i, Microsoft SQL Server, MySQL, UNIX shell scripting, SQL/PLSQL, Java, Python, Natezza, Teradata, Hadoop

Other Tools: VSTS, TFS, Jira, control M, Autosys, Toad, SCM.

PROFESSIONAL EXPERIENCE

Confidential, Farmington Hills, MI

Sr ETL Developer

Responsibilities:

• Worked with Business / Customers to get the Business Requirements and completed the Business Requirement (BRD) & Requirement Traceability Matrix (RTM) documents.
• Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations.
• Worked on Informatica 9.6.1 Power center tools- Designer, Repository Manager, Workflow Manager and workflow monitor. Subject Matter Expert forconversionanddatamapping to Netezza
• Used HRDataknowledge, heavily participated indataconversionto Oracle DataWarehouse
• Installed and configured Informatica Power Exchange CDC and for Oracle on UNIX platform.
• Designed and developed mapping using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
• Used IDE / IDQ tool to load the data from file to stage tables.
• Used Informatica partitions like the Database and Pass-through for performance tuning.
• Involved in Reviews & Unit Testing of Mappings and Workflows..
• Used UNIX shell scripts to FTP the source files from EDI servers using the config files.
• Performed unit testing and created documents with the test cases using SQL scripts.
• Used various transformations like the Source Qualifier, Joiner, Expression, Filter, Lookup, Sequence Generator and Router to develop complex mappings using Power Center Designer.
• Worked on various types of flat files i.e. fixed width and delimited.
• Creating Deployment Groups and Harvest Packages to move the code to production.

Environment: Informatica 9.6.1, Oracle, Teradata, Power Exchange, Flat Files, Passport, Harvest, Windows XP, UNIX and Control -M

Confidential, Southfield, MI

Sr. Informatica Developer

Responsibilities:

• Instrumental in Analysis, Requirements Gathering and documentation of Functional and Technical specifications.
• Involved in Dimensional modeling to Design and develop STAR Schemas using ERwin to identify Fact and Dimension Tables.
• Work extensively on Informatica client tools such as Designer, Workflow manager, Workflow Monitor.
• Use ETL to load data from sources such as Flat Files, Oracle to Oracle, Teradata Target Database. Based on the business requirements Reusable transformations are created in transformation developer and Mapplets in the Mapplet designer.
• Involved extensively on Linux scripting to calls a job in informatica.
• Develop complex mappings to transform the data using Rank, Sorter, Stored Procedure, Joiner, Aggregator,
• Used B2B data transformation for getting the data from unstructured sources (XML).
• Integration of applications for EDI, order management and warehouse management.
• Extensively used ETL for new development by applying business rules and loading data in to Teradata and Oracle based operational data store sourcing from many feeds (XML, flat files, EDI). Trickle feed to Teradata using TPT.
• Used ETL for new implementation and loading data into Teradata from multiple feeds (EDI, XML, flat files).
• Use workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and

Environment: Informatica PowerCenter 9.6.1/8.6, Data Exchange (B2B),Oracle 10g, DB2, AutoSys, SQL Server 2008, PL/SQL, Teradata, Toad, ERwin 3.5, Unix

Confidential, Jacksonville, Florida

Sr. Informatica Developer

Responsibilities:

• Imported DT service in Informatica Powercenter which parsed incoming XML files.
• Worked in Agile environment to convey the assignment in view of scrum cycle.
• Utilized Jira to assign and manage task under the supervision of scrum master.
• Implemented Technical and logical specifications for ETL solution.
• Contributed in the design phase of logical and physical data model using Erwin 4.0.
• Designed, developed and documented the ETL (Extract, Transformation and Load) strategy to populate the Data Mart from the various source systems.
• Implemented partitioning and bulk loads for loading large volume of data.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Based on the requirements, used various transformations like Source Qualifier, Normalize, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, unstructured data transformation and Sequence Generator in the mappings.
• Developed Mapplets, Worklets, Sessions and Transformations for reusability.
• Identified performance bottlenecks and Involved in performance tuning of sources, targets, Mappings, transformations and sessions to optimize session performance.
• Played a key role in all the testing phases and responsible for the Unit testing from the development perspective.
• Optimized mappings, sessions/tasks, source and target databases as part of the performance tuning.
• Deployed the code to the higher environments using dynamic deployment groups.
• Scheduled jobs for both inbound and outbound using tidal control resources

Confidential, Orlando, FL

Informatica Developer

Responsibilities:

• Designed and developed ETL process using Informatica tool.
• Worked with various Active transformations in InformaticaPowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Worked with various Passive transformations in InformaticaPowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager. Responsible for extracting data from Oracle and Flat files. Responsible for Performance Tuning in Informatica PowerCenter.
• Worked with both Connected and Un-Connected Lookups.
• Made use of sorted input option for the performance tuning of aggregator transformation.
• Used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation.
• Prepared Technical Design documents and Test cases. Implemented various Performance Tuning techniques.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team Peer reviews.

Environment: InformaticaPowerCenter 9.5.1(Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 10g, DB2, SQL, PL/SQL, Flat Files, Star Team

Confidential, New York, NY

ETL Developer

Responsibilities:

• Used InformaticaPowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment
• Troubleshot issues in Test and Prod. Did impact analysis and fixed the issues..
• Wrote shell scripts for file transfers, file renaming and several other database scripts to be executed from Unix.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

Environment: InformaticaPowerCenter 8.6.1/7.x, Informatica Power Exchange 8.1, Stored procedures, Pl/SQL, Informatica Data Quality, Unix (Solaris), HP Quality Center

Confidential

Programmer Analyst

Responsibilities:

• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time.
• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.
• Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Designed and developed data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL, SQL.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
• Created and used reusable Mapplets and transformations using InformaticaPowerCenter.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, testing of Informatica Sessions, and the Target Data.

Environment: InformaticaPowerCenter 7.1.3, MS-SQL Server 2005, PL/SQL, Stored Procedures, Informatica Data Quality, Unix (Solaris), HP Quality Center