SUMMARY

• 7 years of total IT experience in Data Warehousing and Business Intelligence working in various BIDW projects (Healthcare, Insurance domain).
• Worked in all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing.
• With strong skillset in ETL development, testing and production support in Data Warehousing.
• Strong knowledge in implementing Change Data Capture (CDC) and Slowly Changing Dimensions (SCD’s) 1, 2, and 3.
• Good exposure to SDLC process viz. Requirements Analysis, Design, Development, Change Management and testing.
• Strong Experience in Informatica Power center versions 10.x,9.x (Designer, Workflow manager, Workflow monitor and Repository manager)
• Expertise in data warehouse ETL strategies, design and development for staging, fact / dimension and summary tables load including integration with various source/targets like Oracle, Teradata and Flat Files
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica PowerCenter.
• Strong skills in coding and debugging Teradata utilities like Fast Load, MultiLoad and Fast Export for Teradata ETL processing huge volumes of data throughput.
• Expert in Change Data Capture (CDC) Methodology using Informatica PowerCenter 10.x/9. x
• Expertise in UNIX shell scripting and UNIX environment using standard commands
• Experience of working with Teradata and its utilities (Fast export, mload) used in Informatica
• Have experience in working with ORACLE 11g/10g, SQL Server 2012/2014, Teradata 16/14 databases.
• Created Mappings and Transformation logic for data loads into EDW/dimensional models.
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files. Written number of shell scripts to run various batch jobs.
• Worked extensively in design and analysis of Requirements, Development, testing and deployment.
• Prepared various types of documents like ETL specification, Data Mapping, Test cases, Test Results etc.
• Worked closely with Testing team to assist in Integration, System and User
• Acceptance Test (UAT) scenarios.
• Hands on experience in performance tuning and extensive experience in debugging and identifying the issues.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x / 9.x, Informatica IICS

Data Warehouse: Dimensional model - STAR Schema, Fact/Dimension tables, SCD 1,2,3

Databases: Oracle 19c, Teradata 16, SQL Server

Operating Systems: Windows, Unix, Linux

DB and other Tools: SQL Developer, Teradata SQL Assistant, Toad

Programing: C/C++, SQL, PL-SQL Unix scripting

Scheduling: Control-m, Informatica Scheduler

Others: Quest, TOAD, SQL*PLUS, SQL*Loader, WinSCP, Putty, Jira

PROFESSIONAL EXPERIENCE

SR ETL DEVELOPER

Confidential, Dunmore, PA

Responsibilities:

• Analyzed the business requirement and functional specifications.
• Created mappings to implement technical enhancements for data warehouse by extracting data from sources like oracle and delimited flat files.
• Development of ETL using Informatica 8.6.
• Applied slowly changing dimensions like Type1 effectively to handle delta loads.
• Prepared various mappings to load the data into different target tables.
• Used various transformations like SQ, Aggregator, Joiner, Filter, Lookup, and Update Strategy for designing and optimizing the mapping.
• Created sessions and workflows using the workflow manager.
• Used fastload and fastexport utilities in Teradata at different stages in the project.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Prepared SQL queries to validate the data both in source and target database.
• Created and executed unit test cases for the mappings developed.
• Closely worked with reporting team to ensure correct data is presented in the reports

ETL DEVELOPER

Confidential, Hartford, CT

Responsibilities:

• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Documented Data Mappings/ Transformations as per the business requirement.
• Prepared Technical Design documents and Test cases.
• Creating and maintaining source-target mapping documents for ETL development team.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• 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.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse tables.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
• Created summarized tables, control tables, staging tables to improve the system performance and as a source for immediate recovery of database
• Migrated Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Wrote hundreds of SQL query for data analysis to validate the input data against business rules.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Improved performance testing in Mapping and the session level.
• Worked with UNIX shell scripts for job execution and automation.
• Coordinated with Autosys team to run Informatica jobs for loading historical data in production.

ETL DEVELOPER

Confidential, Irving TX

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.