SUMMARY

• Around 11 years of experience in data warehousing and data integration projects using tools like Informatica Power center and Data Quality.
• Strong knowledge of data warehouse architecture and designing star schema, snow flake schema, fact and dimensional tables, physical and logical data modeling using Erwin.
• Hands on experience in designing data load strategy for slowly changing dimensions and various granular levels of fact tables.
• Having knowledge of implementing data validation rules and exception handling mechanism while loading dimension and facts.
• Proficiency in data warehousing techniques for data cleansing using IDQ (Informatica Data Quality).
• Good experience in working with Informatica MDM.
• Worked on Ab Initio integration with Hadoop Eco System for staging, integration and semantic layers.
• Experience in working with different source like Oracle, Teradata, Salesforce, SAP, Hadoop Echo System, ASCII and EPCDIC files.
• Worked on QlikView dashboards using Chart Box, List, Input Field and Table Box.
• Have experience in using Teradata Utilities like MLOAD, FLOAD and TPUMP.
• Hands on experience through complete Software Development Life Cycle (SDLC).
• Worked on Power exchange connectors to extract data from different sources.
• Experience in UNIX shell scripting for scheduling, file copying and archival.
• Expertise in designing the job dependency schedules using scheduler tools like CTRL - M and Autosys.
• Good working knowledge in Unit testing, Functional, System, Performance, User Acceptance Testing.
• Excellent communication, presentation skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/8.6.1/7.1.2 , Ab Initio 3.2

Data Cleansing: Informatica Data Quality 8.x,9.x

OLAP Tools: QlikView, Cognos, OBIEE

Databases: Teradata, Oracle, DB2, MySQL

Languages: Java, SQL, PL/SQL, Shell Scripting.

Tools: /Utilities: TOAD, SQL Navigator.

Operating Systems: Windows, Unix, Linux

Source Systems: Hadoop, Salesforce, SAP and Mainframe

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Developer

Responsibilities:

• Interacted with business users for requirement analysis and to define business and functional specifications.
• Prepared software requirement specifications, business rules interacting with business units and designed star and snow flake schema, logical and physical database design.
• Developed complex mappings using Informatica for different layers like Staging, Integration and Semantic layers to load data into Data warehouse (ICDW).
• Worked on extracting the data from various source systems like Oracle, Teradata. Hadoop, Salesforce, ASCII and EPCDIC files.
• Used Java transformation to convert the data from one row into multiple rows based on the # separator values in an attribute.
• Worked on Ab Initio integration with Hadoop Ecosystem using custom components like CAIP READ and CAIP WRITE.
• Populate or refresh Teradata tables using FLOAD, MLOAD utilities for user acceptance testing.
• Prepared POC for migrating data from one table to another table in Oracle using generic mapping.
• Transformed the data via standardization, cleansing, data repair, matching, and deduping.
• Creating Informatica labels and ITSM tickets for migrating code from Development to UAT to Prod environments.
• Worked on Data analysis and profiling using IDQ.
• Developed IDQ Mappings and Mappelts by using transformations like standardizer, Case converter, Merge etc.
• Worked on IDQ Data Cleansing, Standardization, Key Generation, Match, Association and consolidation transformations.
• Export and import of IDQ components and integration with Informatica power center.
• Creating UNIX and Informatica workflow jobs in Ctrl-M for scheduling.
• Removed duplicate rows from tables through the process of deduping. .
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Designed error handling method to capture the errors based on the business logic on source data.

Environment: Informatica Power Center, Data Quality, Ab Initio, Hadoop Eco System, Salesfoce, Teradata, Oracle, Unix, Ctrl-M.

Confidential

Senior ETL Developer

Responsibilities:

• Developed high level technical design specification and low-level specifications based on business requirements.
• Developed Informatica ETL code using various mappings and transformations for transport of data from different sources to files.
• Involved in the full development lifecycle from requirement gathering through design, build, QA, deployment and support using power center.
• Used Informatica Data Quality tool to clean the address data for vendors.
• Developed Data mart for procurement business unit.
• Create a mapping with Java transformation to retrieve the procurement documents like PDF, JPEG from BLOB data type columns from oracle database.
• Developed robust Informatica mappings and fine-tuned them to process millions of input records with estimated throughput.
• Designed the workflows with trigger files to create dependencies between workflows to load data in one table after another.
• Used mapping variables and parameters in Informatica mappings to minimize the code changes and to reuse the code.
• Created UNIX scripts to run the Informatica commands thru command line.
• Designed Control table logic to implement incremental loads from source system.
• Created Slowly Changing Dimension to keep history data in target tables.
• Debugging invalid mappings using break points, testing of Informatica sessions, batches and the target Data.
• Involved in performance and tuning the ETL processes.
• Worked on estimating Informatica work, planned the development activities and delivered them on time.
• Worked with other teams like DBA, Informatica Admin to get the requirement tasks completed on time.

Environment: Informatica Power Center 9.1, Oracle, OBIEE, TOAD, UNIX

Confidential, TX

Responsibilities:

• Interacted with business users for requirement analysis and to define business and functional specifications.
• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule using RUP(Rational Unified process)
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Data marts, Enterprise Data warehouse (EDW).
• Prepared software requirement specifications, business rules interacting with business units and designed Star schema, logical and physical database design for Domains.
• Designed ER diagrams, logical model (relationship, cardinality, attributes and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Used FLOAD, MLOAD utilities to load data into Teradata tables to achieve better performance.
• Worked on extracting the data from difference sources like SAP, Mainframe and Travelocity.
• Removed duplicate rows from tables through the process of deduping.
• Developed data Mappings, Transformations between source systems and warehouse.
• Performed code reviews for the mappings developed by other team members.
• Managed the metadata associated with the ETL processes used to populate the data warehouse.
• Implemented mappings using Aggregator, Filter, Join, Expression, Lookup and update strategy transformations.
• Used Bteq’s and Teradata Utilities like multiload, fastload, tpump to achieve the good performance when working on huge volumes of data.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Generated various Error handling and failure recovery strategies.

Environment: Informatica Power Center 8.6, Teradata, MySQL, Cognos, UNIX

Confidential, New Jersey

ETL Developer

Responsibilities:

• Developed High Level Technical Design specification and Low-level specifications based on business requirements.
• Designed ETL process flows for entire CDD application and developed data mapping spreadsheets to define transformation rules for each stage of ETL process
• Developed Informatica ETL code using various mappings and transformations for transport of data from different sources to files.
• Involved in the full development lifecycle from requirement gathering through Design, Build, QA, Deployment and Support using Power Center.
• Resolved source system data issues by performing data profiling and providing workaround techniques.
• Worked closely with business analysts to gather functional specifications and turn them into technical specifications.
• Used Deployment groups to migrate the code from between different environments.
• Developed robust Informatica mappings and fine-tuned them to process millions of input records with estimated throughput.
• Responsible for monitoring scheduled, running completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Worked on CR’s to modify the existing Informatica ETL code as per the new business requirements.

Environment: Informatica 8.1/7.1.4, Business Object XI, Oracle, DB2

Confidential

Responsibilities:

• Developed standards and procedures for transformation of data as it moves from source systems to the data warehouse.
• Involved in technical design specification documents based on the functional design documents and the physical data model.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Powercenter 8.5.1/7.1.4.
• Migrating from Informatica 7.1.4 mappings into Informatica 8.5.1 which consists of grid technology.
• Tuning the complex mappings based on source, target and mapping, session level
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environments.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Extensively used Maestro tool for scheduling batch jobs.

Environment: Informatica Power Center 7.1.3/8.0, Oracle 10g, TOAD, Teradata, Shell Scripts.

Confidential

ETL Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting, reporting, and Identifying facts and dimensions.
• Prepared the required application design documents based on functionality required
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Oracle Data Warehouse database.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Designed and developed the logic for handling slowly changing dimension tables load by flagging the record using update strategy.
• Involved in cleansing and extraction of data and quality process for the warehouse.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.

Environment: Informatica Power Center 7.1/6.2, Business Objects, Oracle 9i, DB2, TOAD