SUMMARY:

• 7+ years of experience in analysis, design, development and maintenance in IT industry.
• 6 years of extensive experience in Data Warehouse applications using Informatica, Oracle, DB2, MS SQL server on Windows, IBM and UNIX platforms.
• Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Strong in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema methodologies, slowly changing Dimensions (Scd Type1/Type2).
• Expertise in creation of match paths, match rules, match rule sets, system trust scores and trust score decay with Validation rules.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.x/8.x/7.x/6.x ETL tool.
• Expertise in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling using ERWIN 4.x/3. x.
• Experience in documenting High Level Design, Low level Design, and STM’s, Unit test plan, Unit test cases and Deployment documents.
• Extensive knowledge on the PowerCenter components as PowerCenter Designer, PowerCenter Repository Manager, Workflow Manager and Workflow Monitor.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 8.x/7.x/6. x.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experienced in writing Teradata SQL scripts for transforming business rules.
• Experienced in integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat - files, COBOL files, XML, etc.
• Experienced in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow Manager.
• Experience in Oracle and MS SQL Server environments using Triggers, functions, SQL, T-SQL and PL/SQL.
• Expertise in scheduling Informatica jobs using Informatica, Windows scheduler and with Unix.
• Expertise in creating UNIX shell scripts.
• Experienced in working for the post development cycle and applications in Production Support.
• Experience in data migration with data from different application into a single application.
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.

TECHNICAL SKILLS:

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

Reporting Tools: COGNOS BI- Framework managerSAP 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, NV

ETL Technical Developer

Responsibilities:

• Worked on 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
• Designed ETL high level work flows and documented technical design documentation (TDD) before the development of ETL components to load DB2 from Flat Files, Oracle, DB2 systems to build Type 2 EDW using Change data capture.
• 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.
• Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Router, Sorter, Expression, Normalizer, Sequence Generator and Update Strategy, data standardization, address validator etc.
• 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.
• Used Teradata utilitiesfastload, multiload, tpump to load data.
• 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.
• Provided performance tuning and physical and logical database design support in projects for Teradata systems.
• Collaborated with BI and BO teams to observe how reports are affected by a change to the corporate data model.
• Used HP QC to track defects
• Handled major Production GO-LIVE and User acceptance test activities.
• Defined escalation process metrics on any aborts and met SLA for production support ticket
• Handled Production issues and monitored Informatica workflows in production.

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

Confidential, TN

E TL Technical Developer

Responsibilities:

• Coordinating with source system owners, day-to- day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Widely used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Assisted in adding Physical conceptual data model using Erwin 4.0.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Excellent knowledge on ETL tools such as Informatica to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Involved in the process design documentation of the DW Dimensional Upgrades.

Environment: Informatica 10.1.1, 9.5 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, Teradata, TOAD, Erwin 4.0, PL/SQL, UNIX (Sun Solaris).

Confidential

ETL Developer/Designer

Responsibilities:

• Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of project
• Prepared Data Mapping Documents and Design the ETL jobs based with required Tables in the Dev Environment.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts & development team to gain a better understanding of the Business Process, Requirements & Design.
• Worked with data modelers to understand financial data model and provided suggestions to the logical and physical data model.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Worked with Data Profiling Team in analyzing the source systems data for duplicative and quality issues.
• Performed data profiling of reference data for large data sets using Informatica Data Analyst tool.
• Performed Match and Merge Rules as per business requirement on source data.
• Configured IDD application for Party master data model required for data governance used by the Data Services and analysis team.
• Created queries, procedures and packages in MDM Hub for displaying and updating the data.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 9.6/9.5, Informatica Developer 9.6/9.5, Oracle 11g, DB2,Business Objects, DB2,IDQ, SQL, Erwin 4.0, UNIX-AIX, XML, Web Services, UNIX shell programming.

Confidential

ETL Informatica Developer

Responsibilities:

• Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target Datawarehouse.
• Optimizing the mappings by changing the logic to reduce run time.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Analyze the client requirements and translate them into technical requirements.
• Gathered requirements from the end user and involved in developing logical model and implementing requirements in SQL server 2000 .
• Data migration ( import & export - BCP ) from text to SQL server.
• Responsible for creating reports based on the requirements using reporting services 2000.
• Identified the database tables for defining the queries for the reports.
• Worked on SQL server queries , stored procedures, triggers and joins .
• Defined report layouts for formatting the report design as per the need.
• Identified and defined the datasets for report generation.
• Formatted the reports using global variables and expressions.
• Deployed generated reports onto the report server to access it through browser.
• Maintained data integrity by performing validation checks.

Environment: Informatica Power Center 8.6, Oracle 9i, MS SQL 2000, Windows server 2000, SQL Query Analyzer and Enterprise Manager, MS Access 2000 & Windows NT platform.