SUMMARY

• Over 11+ years IT experience in analysis, design, development and implementing software solutions in Data Warehousing using tools - Informatica PowerCenter 10.1.1, Informatica Master Data Management(MDM) 9.5, Informatica Data Validation Option(DVO) 9.5.
• Extensive Database experience using Oracle Exadata/11g/10g/9i, Teradata, DB2, MS SQL Server 2010/ 2005, SQL, PL/SQL.
• Strong Data Warehousing/ETL experience using Informatica PowerCenter Client tools - Designer, Repository Manager, Workflow Manager, and Monitor.
• Experience in handling Informatica Power Center for ETL extraction, transformation and loading into target Data warehouse.
• Strong in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema methodologies, slowly changing Dimensions (Scd Type1/Type2).
• Extensive experience in creation of complex ETL mappings, mapplets and workflows using Informatica Power Center to move data from multiple sources into target area.
• Participated in varying experience levels in building and supporting ETL processes for systems.
• Experienced in estimation, planning, Risk Management, finalization of technical / functional specifications, communication management and quality management of the product and Sound knowledge in tuning Informatica mappings and identifying bottlenecks and resolving the issues to improve the performance of the data loads and extracts.
• Proven experience translating business problems into actionable data quality initiatives.
• Experience in data profiling & data quality rules development with business and IT end users.
• Experience with Informatica Analyst 9.6.1 to analyze the Source data quality issues by creating the Profiles and applying the data quality rules.
• Experience in implementing the Change Data Capture Process using Informatica Power Exchange.
• Expertise in implementing Customer, Product and Supplier Master Data Management domains.
• Experience in working with Informatica DVO tool and creating SQL Views, Lookup Views and Table pairs for the Automation Testing.
• Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces.
• Experience in developing stored procedures, functions, triggers, cursors and joins, SQL Queries with T-SQL, PL/SQL and working with TOAD, SQL Developer, SQL*PLUS.
• Extensive knowledge in Business Intelligence and Data Warehousing Concepts with emphasis on ETL and System Development Life Cycle (SDLC).
• Work experience in agile and scrum methodology.
• Improved the performance of mappings using various optimization techniques.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.1.1,9.5/9.0.1,Siperian/Informatica MDM 10.0/9.1,Informatica Power exchange 9.1,Informatica DVO 9.5,Informatica Big Data Edition 9.6.1.Informatica 8.6.1,MS SSIS 2008

Reporting Tools: COGNOS BI- Framework manager,SAP Business Objects v4.0

Programming Languages: SQL, PL/SQL, HTML, UNIX SHELL SCRIPTING

Database: Oracle 9i/10g/ 11g, Teradata, DB2 MainFrame, MS SQL Server 2010

Operating System: Windows 98/NT/2000/XP/7, UNIX

Programming Tools: SQL PLUS, SQL Loader, TOAD 10.0, Putty

Scheduling tools: Control M, Crontab, Tidal

Defect Management: HP Quality Centre, HP ALM, JIRA

PROFESSIONAL EXPERIENCE

Confidential

ETL Technical Developer

Environment: Informatica 10.1.1, 9.5, Oracle, XML, SQL Server 2008, Web services, DB2 Mainframe, Tidal(Scheduler), Cognos, Remedy (Ticketing tool), GitHub, HP QC(Testing tool)

Responsibilities:

• Lead the analysis, design, development & implementation of logical data models, physical database objects, data conversation, integration and loading processes
• Worked on an onshore/offshore model working with development team in Bangalore
• Created stored procedures, views based on project needs
• Develop and coding the ‘real time’ and batch modes loads.
• Developed standard framework to handle restart ability, auditing, notification alerts during the ETL load process.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in performance tuning and optimization of mapping to manage very large volume of data
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Develop complex ETL mappings on Informatica 10.x platform as part of the Risk Data integration efforts.
• Implemented SCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.
• Implemented error handling for invalid and rejected rows by loading them into error tables.
• Implementing the Change Data Capture Process using Informatica Power Exchange.
• Extensively worked on batch frame work to run all Informatica job scheduling.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Worked with data modelers to understand financial data model and provided suggestions to the logical and physical data model.
• Designed presentations based on the test cases and obtained UAT signoffs
• Documented test scenarios as a part of Unit testing before requesting for migration to higher environment levels and handled production deployments
• Recorded defects as a part of Defect tracker during SIT and UAT
• Identified performance bottlenecks and suggested improvements.
• Performed Unit testing for jobs developed, to ensure that it meets the requirements
• Prepared/reviewed the technical design documentation (TDD) before the development of ETL and BOBj components
• Collaborated with BI and BO teams to observe how reports are affected by a change to the corporate data model.
• Scheduled the jobs using Tidal.
• Used HP QC to track defects
• Handled major Production GO-LIVE and User acceptance test activities.
• Created architecture diagrams for the project based on industry standards
• Defined escalation process metrics on any aborts and met SLA for production support ticket
• Handled Production issues and monitored Informatica workflows in production.

Confidential, NJ

ETL Technical Developer

Environment: Informatica 9.5, XML, Oracle 11g, SQL server 2008 R2, SQL, T-SQL, PL/SQL, Toad 10.6, SQL Loader

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.5.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with the ETL processes.

Confidential

ETL Developer

Environment: Informatica Power Center 9.1, Informatica MDM 9.1, XML, Oracle, PL/SQL, DB2, RALLY, HP Quality Control, Informatica Power Exchange 9.1, JIRA

Responsibilities:

• Performed requirement and analysis and prepared business rules
• Implemented IDD applications and created subject area groups, subject areas, subject area child, IDD display packages in hub.
• Document unit test cases and provide QA support to make testers understand the business rules and code implemented in Informatica.
• Responsible for investigation, characterization, and communication of build and release problems, implementing corrective and preventive actions.
• Resolved all the issues with JIRA tickets on priority basis.
• Analyzed Change request (CR) as per requests from team track/JIRA. Creating SR to Informatica Inc- related to any Power center product issues.
• Worked with XSD and XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Used Cleanse Functions to Cleanse and Standardize while data is loading into stage tables.
• Enabled delta detection to extract the Incremental Data.
• Defined the Systems, Trust Scores and Validation rules.
• Created the Match/Merge rule sets to get the right master records.
• Performed data steward operations by editing the records using data manager and merge manager.
• Import & Export of ORS using Metadata manager.
• Configured Address Doctor which can cleanse Customer Address Data.

Confidential

Senior ETL Developer

Environment: Informatica 8.1.6, Oracle, Neoview, SQL Server 2005, HP QC, Control M, JIRA

Responsibilities:

• Analysis and design of warehouse workflow from the existing Stored Procedures
• Preparing the mapping diagrams & Technical Specification required for ETL development
• Working on Informatica and Unix
• Perform AS-IS on the current Stored Procedure code HDFC
• Design the STTM
• Preparing the mapping diagrams
• Preparing Technical Specification required for ETL development
• Extensively developed the mappings, sessions, worklets, workflows using Informatica 8.6.1
• Consolidate the code and test at the onsite server
• Involved in performance tuning of stored
• Used ControlM scheduling jobs.
• Assisted QA/UAT cycle by resolving the defects quickly.
• Wrote Configuration files for Performance in production environment.
• Participated in weekly status meetings.

Confidential

ETL Developer

Environment: Microsoft SSIS 2008, Oracle 10g, Windows XP, Unix Shell Scripts, SQL, PL/SQL, Flat files, JIRA

Responsibilities:

• Created project specific rule set
• Co-ordination with front-end developers
• Build components Pipeline and task components in SSIS
• Helping in designing the GUI
• Testing the data quality from front end during the deliverables
• Preparing the mapping diagrams
• Preparing Technical Specification required for ETL development
• Building the Rules for Standardization for managing the rules for Insurance Data Quality Services
• Developed a data model to fit the Data Cleansing
• Scripting queries with SQL Server 2000
• Involved in creating Detail design documentation to describe program development
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.