PROFILE SUMMARY:

• About 7 years of Software/IT experience in Design, Development, Testing, Implementation and support of Data Warehousing applications.
• Expertise in Data Warehousing, Data Migration, Data Integration using Business Intelligence (BI) tools such as Informatica Power Center, Power Exchange (Power Connect), Metadata Manager, Informatica Data Quality, Informatica Data Explorer, Data Transformation, MDM etc.
• Experience in designing , de velopment and implementing Extraction, Transformation, and Loading (ETL) techniques on multiple database pla tforms and operating system environments using Informatica Power Center 10.x/9.x/8.x, Power Exchange, SSIS, SQL, PL/SQL, External Loaders, and Shell/batch Scripting etc.
• Experience in major sectors such as Health care, Telecommunications, Banking and Insurance .
• Proficient in interacting with Business Analysts, Users and Business executives to understand the requirements and come up with innovative and efficient solutions by working with the data modelers and Architects.
• Proficient in all phases of the Software development lifecycl e (SDLC) using Agile, Waterfall and RUP methodologies .
• Extensive Experience with databases such as Oracle, Sales force, DB2 UDB, Microsoft SQL Server, Sybase, Teradata and database clients such as SQL server Management Studio and SQL Developer, SQL navigator, Toad etc.
• Proficient in Data Modeling, E - R diagrams, Logical, Physical design, Star/Snow flake Schemas using Erwin.
• Experience with using XML sources, targets, Informatica Web Services (Web service Consumer and Provider)
• Developed business intelligence dashboards to provide visualization techniques for the business units
• Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, and Mapping, Session, Database and System level in ETL processes.
• Strong Database experience and back-end procedure development in Oracle 11g/10g/9i, MS SQL Server 2005/2008, Sybase, Teradata, DB2, Netezza, etc.
• Expertise in the development of integration mappings such as Type I, Type II, and Type III Slowly Changing Dimensions and implementing incremental loads, and change data capture .
• Proficient in scheduling and Automation of ETL processes with scheduling tools such as Control-M, Autosys and Tidal .
• Working knowledge of other integration tools such as SSIS, Data stage, Abinitio , etc.
• Expertise in OLAP and Reporting tools like Qlik view, SSRS, OBIEE, Micro Strategy , and Cognos , etc.
• Hard working individual and a quick learner with strong analytical and communication skills. Experienced in Client interaction and understanding Business applications.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, Power Exchange 10.2,9.x, Metadata Manager, Informatica Data Quality, Informatica Data Explorer, SSIS, Data stage, Abinitio etc.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005/2000 , MS Access, IBM DB2, Tera Data V12, Siebel CRM, PeopleSoft, Teradata, Sybase, Netezza, DB2, etc.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling.

Environments: UNIX, Windows 2000/XP/7, Windows server 2000/2003, HP-Unix, Linux

Languages: C, C++, Java, SQL, PL/SQL, T-SQL, HTML, DHTML, XML, UNIX, Shell Scripting, Visual basic, ASP, JSP, XML, Macromedia Software, JCL.

Tools: Toad, Visio, SQL developer, ERWIN, MS Office Suite

Design Skills: Object Oriented Analysis Design using UML.

Scripting Languages: Java Script, VB Script and UNIX Shell Scripting, Batch scripting.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

• Designing and creating all related extraction, transformation and loading of data functions.
• Reading, analyzing and digesting what business wants to accomplish with its data and designing the best possible ETL processes around these goals.
• Working with Business Analysts to understand the existing logic, data flow and creation of Business Requirement Documents on the business logic.
• Implementing higher performance ETL design plans for generating fees (flat file to table, table to flat files).
• Providing strategies to approaching and resolving defects in applications.
• Implementing jobs to load data from XML files to database.
• Code migration, code review, test plans, test scenarios, and test cases as apart of Unit/Integrations testing and UAT testing to ensure systems run smoothly.
• Taking big-picture view of company’s data situation and scheduling job sin Tidal based on the provided user requirements.
• Presenting technical work products and associated test results for review and approval and testing SMEs.
• Implementation documentation, unit test documentation, and CAB documentation;
• Monitoring production issues and providing efficient resolutions.

Environment: Informatica Power Center 10.2/9.6.1/9.5/9.1 , Power Exchange, Tidal, Oracle 11g, MS SQL Server 2008/2012, Windows 10, Windows 7

Confidential

ETL Developer

Responsibilities:

• Worked with Data Architects and Business Analysts to understand the existing logic, Data flow and creation of Business Requirement Documents on the business logic.
• Responsible for implementing high performance ETL design plans for ODS to Staging, Staging to Data Mart, Data Mart to Submission (Flat file to table, Table to Table, table to Flat file).
• Responsible for code migration, Code review, test plans, test scenarios, test cases as part of Unit/Integrations testing, UAT testing.
• Performed multiple roles such as building extensible, robust, maintainable systems participating in all stages of Software development life cycle using Agile Scrum.
• Extensively migrated data from different source systems such as flat files, relational, and XML sources to ODS, Data marts and Data warehouse and worked on Data partitioning.
• Created workflows that consumed Soap/Rest based web services used prior to loading into Warehouse using Web Service Consumer and HTTP transformation and workflows with web Service Providers.
• Used Unstructured Data transformation to Cleanse the XML’s loading to Data marts and submitting to Web Service Providers.
• Engaged in designing and developing test cases, data validation, load processes.

Environment : Informatica Power Center 9.5/9.1, Power Exchange, Oracle 11g, MS SQL Server 2008/2012, Tidal, Windows 7

Confidential, Indianapolis, IN

ETL Developer

Responsibilities:

• Worked with Data Architects and Business Analysts to understand the data flow, existing logic and creation of Business Requirement Documents on the business logic involved in creation of feeds.
• Performed multiple roles such as building extensible, robust, maintainable systems participating in all stages of Software development life cycle using Agile Scrum/ Kanban .
• Created technical specification for the development of Informatica extraction, transformation and loading (ETL) mappings in order to load data into classified tables in DATA Marts and defined ETL standards.
• Used Informatica Data explorer (IDE), Developer & Analyst tools to implement Data rule taxonomy, repository, managing data rules to standardize and remove duplication of customer data and reporting on the execution of rules against data.
• Created data maps and mapping to extract data from VSAM files using Power Exchange Navigator for Main Frame to migrate legacy data into a SQL Server DB.
• Created workflows that consumed Soap/Rest based web services to Cleanse Member demographic data prior to loading into Warehouse using Web Service Consumer and HTTP transformation.
• Used Meta Data Manager to created lineage report for source/target objects and connected business terms with actual implementation and prepared a final report.
• Performance tuned the Mappings, Tasks, Sessions, SQL and Scripts to optimize Data-Load performance.
• Performed Configuration Management to Migrate Informatica mappings/sessions workflows from Development to Test and to production environment.
• Engaged in designing and developing test cases, error control routines, data validation, load processes, audit and log controls using PL/SQL , SQL.
• Designed, developed and implemented Microstrategy reports, report objects, dashboards and documents.

Environment : Informatica Power Center 9.5/9.1, Power Exchange, Oracle 11g, MS SQL Server 2008/2012, Tidal, Windows 7, Linux/UNIX, Micro Strategy 9.1, ERWin 3.5, Mainframe, TOAD.

Confidential, Cleveland, OH

ETL developer

Responsibilities:

• Interacted with Business Analysts to understand business and functional specifications.
• Involved in dimensional modeling ( Star Schema ) of the Data warehouse and used Erwin 3.5 to design the business process, grain, dimensions and measured facts.
• Participated in the Design Meetings, and prepared technical and mapping documentation.
• Extensively migrated data from different source systems such as flat files, relational, and XML sources to ODS, Data marts and Data warehouse and worked on Data partitioning.
• Used Type 1 and Type 2 SCD mappings to update slowly Changing Dimension Tables using Informatica changed data capture (CDC).
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Used Multiload, FastLoad and Tpump utilities to load to Teradata database.
• Read from SAP source using Power Exchange and also loaded data into SAP targets.
• Worked with Informatica Developer & Analyst tool to identify data duplication and understand the quality of data. Used IDE tool for profiling the data prior to Data migration.
• Created Financial, forecast reports for the top management/business users using Micro Strategy 8.1.
• Worked with testers and participated in Unit, Integration, system, and performance testing of ETL applications.

Environment: Informatica Power Center 9.1/8.6.1, Informatica Power Exchange(CDC), IDQ, Oracle 11g, SQL, MicroStrategy 8.1, SQL Server 2005, Teradata , Windows NT/2003, UNIX, Autosys.