SUMMARY

• 5+ years of experience in datawarehouse using Informatica power center 10.0/9.0/8.6.
• Experience in dealing with various Data sources like Oracle 12c/11g/10g/9i/8i, Oracle PL/SQL, SQL Server 2010/2008, Teradata, Ms - Access, MS - Excel and Flat files.
• Dimensional Data Modeling experience on Data modeling, ERwin 4.5/4.0, Dimensional Modeling, Ralph Kimball Approach, Star Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Experince in creatging Mappings and Mapplets using various connected and unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator and upated strategy transformations.
• Proficient in using Informatica Designer, workflow manager, workflow monitor to create, schedule and control workflows, tasks, and sessions
• Worked exclusively in implementing the types of slowly changing dimensions (SCDs) - Type I II in different mappings as per the requirements.
• Experience in preparing the ETL Design Documents like High Level and low level Design documents. Involved in the Unit testing, integration testing, System testing and UAT using Quality Center.
• Experience in integration of various data sources like Oracle, SQL server and MS access and non-relational sources like flat files into staging area.
• Experienced with agile development using Scrum/Kanban
• Experience with Git (Github, Bitbucket), Jira .
• Aptitude for analyzing, identifying problems and coming with out of the box solutions
• Ability to achieve organizational integration, assimilate job requirements, employ new ideas, concepts, methods, and technologies.
• Excellent communication, interpersonal and analytical skills.
• Self-motivated, quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS

ETL tools: Informatica Power center 10.0/9.5/8.6/8.1/8.0/7.1

Databases: Oracle 12c/11g/10g/9i/8i,Ms Sql server 2010/2008/2005 , Teradata 13.0, MySql Server 5.7/5.1, Toad12.8, DB2 8.0.

Languages: C#, C++, SQL, PL/SQL.

Operating systems: Windows 8/7/95/98/00/07/ NT/XP, UNIX (Sun-Solaris, HP/UX), Linux RedHat 6.5.

Scripting languages: Windows scripting, UNIX Scripting.

Scheduling Tool: Control-M 10/9.0, Autosys

Other Tool: Microsoft Office (FrontPage, Excel, Groove, Communicator, OneNote, FileMover2.0, LiveMeeting), BeyondCompare, SmallTalk, HP QualityCenter, Putty, Visual Studio 2017 15.9, Framework4.7.

OCR Tools: OpenText Captiva Capture 7.1/6.4, Image Trust( Global Image Capture(GIC 4.2 / 2.7)), Paradatec(OCR Prosar-Aida,ProKey)/

Versioning Tools: GIT 2.17(Bitbucket), Tortoise GIT, SVN, Jenkins, FRS, Confluence

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Requirement Gathering and Analysis of Business requirements
• Converted business requirements into ETL Informatica technical specifications
• Created Technical Design Documents(TDD) and Runbooks for the project which I have worked
• Extensively used various transformations like Union, Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Implemented slowly changing dimensions Type1 and Type 2.
• Defined functional and technical design for DW applications, maintained the technical documentation.
• Worked with Lookup transformation using both Connected and Unconnected options.
• Worked extensively with various lookup cache like Static Cache, Dynamic Cache
• Responsible for performance tuning of the ETL process at the mapping level, session level, source level, and target level
• Worked with session logs, and Informatica Debugger at the designer level before creating the workflow for error handling
• Worked with tracing levels for performance tuning of the mappings-Terse, Normal, Verbose Initialization, and Verbose Data.
• Created Tasks like Session and E-Mail in the workflow designer
• Worked with mapping variables, mapping parameters and parameter files for the implementation of change data capture
• Worked with scheduler Control M for scheduling Workflows, Tested scheduler in Lower Env before deploying to Prod.
• Responsible for the Promotion of Mappings, Workflows and other Informatica objects like sources, targets, and transformation between environments like DEV, INT, UAT and PRD-Development, Integration Testing, User Acceptance Testing, and Production.
• Worked with Unix Scripting and Shell Scripts renaming generated target files, and for moving the files into different archiving directories.
• Facilitated meetings with business and technical teams. Reviewed functional and technical design and code as appropriate. Mentored and assigned tasks to other developers
• Knowledge of CI/CD process in particular - GIT (Bitbucket), Jenkins, Jira, Confluence, SVN, FRS.
• Worked on with OCR tools like GIC and Paradatec

Environment: ETL Informatica Power Center 10, 9.6, Oracle 11g, Windows 7, Control M, Linux RedHat, Toad12.8, Visual studio 2017,Captiva Capture 6.4, GIC 4.2/ 2.7, Paradatec, GIT 2.17 .

Confidential

ETL Developer

Responsibilities:

• Analyzed and understood business and customer requirements by interacting with Business Analysts, Data Modelers and Subject Matter Experts.
• Extracted data from heterogeneous sources like oracle, xml, flat file and perform the data validation and cleansing in staging area then loaded in to data warehouse in oracle 10g.
• Developed Mappings, Mapplets, Sessions, Workflows and Shell Scripts to extract, validate, and transform data according to the business rules.
• Developed 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.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data consolidation, standardization, de-duplication, matching, merging using Informatica Data Quality tool.
• Involved in Database and ETL mappings Performance Tuning.
• Used Informatica Debugger to troubleshoot logical errors and runtime errors.
• Performed Unit, Systems and Regression Testing of the mappings.
• Extensively used UNIX shell scripts to create the parameter files dynamically.
• Used PMCMD command to automate the PowerCenter sessions and workflows through UNIX load data in to warehouse database on Business requirements.
• Scheduled the tasks using Autosys. used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Learned Informatica Data Validation Option (DVO) and successfully written dvml scripts with different environments for New tables and tested them in a timely manner.
• Learned and successfully worked on Beyond Compare application for testing Static / New tables.
• Developed Test cases for Unit Testing of the Mappings.
• Analyzed the existing database and involved in designing the universes using Cognos for generating reports.

Environment : DB2 9, Teradata, ETL Informatica PowerCenter 9.5, Informatica Data Quality, Informatica DVO 9.5, Cognos 10.2.1, Beyond Compare tool, SQL Server , Autosys .

Confidential

ETL Developer

Responsibilities:

• Work with business users directly in gathering requirement and implementing them and working close with offshore developers.
• Analyzed the requirements and framed the business logic for the ETL process.
• Extensively used ETL to load data using PowerCenter from source systems like XML Files, Flat Files, and Excel Files into staging tables and load the data into the target database (Oracle, SQL Server).
• Developed mappings to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, Joiner, Normalizer transformations.
• Developed Slowly changing dimension mappings (Type 1 and Type 2).
• Worked on populating the EDW / Data Marts, multiple fact and dimension tables with star methodology.
• Designed and developed reusable mapplets and used mapping variable and mapping parameters in the ETL mapping.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the different bottlenecks.
• Involved in documenting the deployment plan and the unit test plan and other UAT related documents.
• Did unit testing to identify what can be done to improve effectiveness and efficiency.
• Did the User Acceptance Testing (UAT) to see that the system under test meets the user’s needs.
• Used HP Quality center to create and for tracking of defects.
• Assisted the reporting team in Generating Business reports using Business Objects.

Environment: DB2 10, Teradata, ETL Informatica PowerCenter 9.5, Data studio 4.1, HP Quality Center, SAP Business Objects 4.0, Confidential Integration Bus V9 and MQ 7.5, Linux6.5.