SUMMARY:

• Overall 7 years of experience in development of various projects using Data Warehousing tools like Informatica, Databases like Oracle, SqlServer, Teradata.
• Experience in data warehousing applications, Responsible for Extraction, Transformation and Loading of data from various sources into Data Warehouse. Experience in design, coding and testing of Data Warehousing implementations across Financial, Retail and Educational Industries.
• Experience in implementing complex Mappings/Mapplets, Reusable transformations and Partitioning Sessions and Experience in writing daily batch jobs using UNIX shell scripts.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database using PL/SQL.
• Strong experience in implementation of Informatica Power Center components like Source Analyzer, Target Designer, Mapping/Mapplet/ Transformation Designer, Workflow Manager/ Workflow Monitor.
• Good understanding and working experience in Logical and Physical data models that capture current/future state data elements and data flows using Erwin. Well versed in Normalization (1NF, 2NF and 3NF) and Denormalization techniques for optimum performance in relational and dimensional database environments.
• Experience in using data sources Oracle, Teradata, DB2, MS SQL server, flat files, and XML files. Experience in RDBMS such as ORACLE 12c/11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , Teradata V12, V14, V15, DB2, SQL and PL/SQL.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, SQL transformation, Data masking, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Transaction Control transformations. Implemented Performance Tuning Techniques and Error Handling at various levels such as sources, Target, mappings.
• Hands - on experience in business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing. Strong skills in creating reusable components like shared containers and local containers for multiple project use.
• Exposure in AWK Scripts and Worked on Control-M to schedule the jobs. Efficient in all the phases of System development life Cycle (SDLC) using different methodologies like Agile and Waterfall.
• Worked on ftp for file transmissions, monitoring system activity for resource contentions, system sanity checks, etc. Knowledge in Star Schema, Snow Flake Schema, Dimensions and Fact tables.
• Creation of folders and maintained Users, Groups, Roles, and Privileges. Have extensive experience with multiple client location also working in onsite-offshore model.
• Experience in Query Optimization and Performance Tuning of Stored Procedures, Functions. Extensively worked with Teradata utilities like BTEQ, Fast Load, Multi Load, TPUMP to export and load data to/from different source systems including flat files.
• Experience in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems and Having exposure in OLTP and OLAP Transactions.
• Administer projects, roles, user, and privileges across all three environments. Load balancing of the ETL services and Experience on Node, Grid and High availability configurations.
• The ability to adapt and learn new technologies and proficient in learning them quickly.

TECH NICAL SKILLS:

Data Warehousing Tools: Informatica Power Center 10.1,9.0.1,9.5,9.6,8.x,7.x, Informatica Data Quality

Databases/RDBMS/Others: SQL Server 2008/2005/2000 , Oracle 8i/9i/10g/11g, Teradata V12, V14, V15, XML, Flat files and Excel sheets.

Data Modeling: Erwin 4.x/3.x, MS Visio, Star Schema, Snow Flake Schema, Physical and Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables.

Languages: SQL, PL/SQL, MY-SQL, UNIX shell, HTML

Job Control and Other Tools: Informatica Scheduler, Control-M, Teradata SQL Assistant

Reporting Tools: Cognos, Tableau

PROFESSIONAL EXPERIENCE:

Confidential

Informatica/ETL Developer

Responsibilities:

• Designed and customized data models for Data warehouse supporting data from multiple sources.
• Involved in the full development lifecycle from requirements gathering through development and support using Informatica Power Center, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts. Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse. Used various transformations like Source Qualifier, Joiner, Lookup, Router, Filter, Expression and Update Strategy.
• Worked closely with Business Analyst and interacted with Report Users to understand and document requirements, translated them to Technical Specifications.
• Extensively worked with large Databases in Production environments. Migrate the Workflows to production using export and import. Performance tuning for Data Warehouse Database (Teradata) and Data Warehouse operations.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Created BTEQ scripts and stored procedures, functions and packages for moving the data from staging area to Target Staging areas in oracle database.
• Used Teradata utilities Fast load, Multi load to load data. Used Debugger to test the mappings and fixed the bugs.
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• 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. Involved in testing all forms, PL/SQL code for logic correction.
• Prepared migration document to move the mappings from development to testing and then to production repositories. Troubleshoot problems associated with the designed workflows and provide technical guidance on complex workflows.
• Created effective Test Cases and performed Unit Testing, Integration Testing to ensure the successful execution of data loading process. Used UNIX Commands and shell scripts to schedule the jobs.

Environment: Informatica Power Center 9.6 and 10.1, Teradata 14/15, SQL Server, Oracle11G, Control M Scheduler, UNIX, SQL, PL/SQL, HP ALM.

Confidential - Reston, VA

Informatica Developer/ETL Developer

Responsibilities:

• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Automating the ETL process through scheduling the exception-handing routines as well as source to target mapping development, support and maintenance.
• Migrate/upgrade Informatica version from 8.X and 9.X. Understanding of Meta Data and Data Quality needs on ETL and Data Warehouse processes.
• Responsible for configuring the workflow tasks like email task, Command task and make it reusable for other team members. Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• 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.
• Monitor production daily, monthly and quarterly loads and on call Production Support. Test connectivity with different sources like Oracle, SQL Server and all types of files.
• Written Test Cases for ETL to compare Source and Target database systems. Responsible for developing Mapplets to implement the reusable logic.
• Developed UNIX shell scripts to run batch jobs in production. Worked with BTEQ in UNIX environment and execute the script from UNIX platform.
• Developed PL/SQL Packages, Procedures and Functions accordance with the business requirements for loading data into database tables.
• Involved in creating, editing, scheduling and deleting of sessions using workflow manager in Informatica. Prepared the data flow of the entire Informatica objects created, to accomplish testing at various levels unit, performance testing.
• Developed SQL Loader Script to load staging area using data from flat file. Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator using Informatica in ETL to transform the data.
• Performed source data analysis and captured metadata, reviewed results with business. Corrected data anomalies as per business recommendation.
• Extracted data from different databases like Oracle and external source systems using ETL tool.

Environment: Informatica Power Center 9.6, SQL Server, Flat Files and Oracle, SQL and PL/SQL, UNIX, Tableau, HP Quality Center.

Confidential - Union, NJ

ETL Developer

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required Sources and Targets using SQL Server 2005 Integration Services.
• Extensively used Informatica for extracting, transforming, loading databases from Oracle, flat files and DB2.
• Analyzed business requirements to build a Data Mart for various business processes conformed to the business rules. Designed Technical specification document based on the FSD. Created Mapping Design document based on FSD.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Involved in Optimizing and Performance tuning on targets, sources, mappings, and sessions to increase the efficiency of session.
• Designed and developed various mappings in Mapping Designer, sessions & workflows in Workflow Manager to extract data from flat files, Oracle and DB2 sources and load to Oracle.
• As per requirements developed the reports in the form of Table, Matrix and Chart using SQL server 2005 Reporting Services.
• Created and modified UNIX scripts to process the Informatica jobs, file handling, executing SQL scripts.
• Knowledge and worked with administrator client for creating new user and assigning role. Participated in the review and approval of the technical transformation requirements document used to design and build the ETL modules in Informatica Designer.
• Configured, built, deployed different reports in PDF, Excel formats according to the business requirement using SQL Server Reporting Services.
• Data Participated in weekly end user meetings to discuss data quality, performance issues, ways to improve data accuracy and new requirements, etc.

Environment: MS SQL Server 2005/2008, ETL, Data Modeling, Informatica Power Center, Flat FilesOracle, UNIX, SQL

Confidential

ETL Developer

Responsibilities:

• Involved in Business meetings to understand the business requirement specifications and implemented the ETL jobs using Informatica.
• Analyzed the business requirement documents (BRD) and drafted Informatica mapping designs for the data extraction, business logic implementation & loading into targets. Implemented slowly changing dimensions on customers table using SCD stage in Informatica.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application. Worked extensively on exception handling for handling errors using system defined exceptions and user defined exceptions.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• On Informatica extensively used the Filter, Copy, Funnel, Join, Merge, Aggregator, Column Generator, Sort, SCD and Remove Duplicate stages for providing transformation logic for the field as per the requirement.
• Involved in analyzing SQL Server Storage Structure, Index and Security Architecture. Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files.
• Created tables, relationships, triggers and indexes for enforcing business rules.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations. Performed Performance testing with different sets of node configuration, different queue and different volumes.
• Created job sequencer to automate the job. Performed extraction, transformation and loading of data from various sources like flat files and oracle tables. Created PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Worked with Business Analysts, using work sessions, to translating business requirements into technical specifications, including data, process and specifications.

Environment: Informatica Power Center 9.1/9.0, Oracle, UNIX, Teradata V12R5, SQL.

Confidential

ETL Developer

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Gathering requirements and creating technical specifications based on client functional specifications. Experience with high volume datasets from various sources like Oracle, Text Files. Identified source systems, their connectivity, related tables and fields and ensured data suitability for mapping.
• Involved in understanding requirement, analyze new and current systems to quickly identify required sources and targets. Created and maintained various databases for production, development and testing using SQL Server.
• Used the HP ALM to upload the unit test cases and executed them. And to track any defects in the project during different phases of testing, debugging, investigating and worked towards closure of the defects.
• Import Data from MS-Access Database and XML to SQL Server Database. Wrote complex Stored Procedures to meet the business requirements.
• Created Users and Roles, and managed security and permission of database. Used design and development techniques that resulted in efficient, maintainable and high quality ETL processes.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• 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.
• Used JIRA as the tracking tool for storing the test plan, uploading the test cases and storing the defects. Import various formats of data into Oracle using Import and Export wizard.

Environment: Informatica Power Center 8.0/8.1, Oracle 10g, UNIX, Teradata V12R5, MS Access, MS SQL Server.