PROFESSIONAL SUMMARY:

• Over 7 years of experience in the IT industry in Design, Development and implementation as an ETL Informatica Developer.
• Experienced in analysis of different systems for system study and data warehouse implementations.
• Experienced in Data Analysis, Data modeling, ETL, Data Warehousing, Reporting, Development, Maintenance, Testing and Documentation.
• Experienced in OLTP/OLAP Systems, Analysis, and Data model Schemas like Star schema, Snowflake schema and multidimensional modeling.
• Well versed in Normalization (1NF, 2NF and 3NF) and Denormalization techniques for optimum performance in relational and dimensional database environments.
• Extensive experience in implementation of Informatica Power Center components like Source Analyzer, Target Designer, Mapping/Mapplet/ Transformation Designer, Workflow Manager/ Workflow Monitor.
• 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.
• 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, T - SQL and PL/SQL.
• Good understanding and working experience in Logical and Physical data models that capture current/future state data elements and data flows using Erwin
• Experience in writing complex SQL queries, stored procedures and functions using PL/SQL programming.
• Having extensive experience on load Utilities like FASTLOAD, TPUMP, MLOAD, FAST Export, TPT (Teradata Parallel Transporter) and PDO (Push down Optimization) and used BTEQ scripts.
• Experience in UNIX shell scripting and using PMCMD commands to run Informatica workflows.
• Experienced in handling SCDs (Slowly Changing Dimensions) and change data capture (CDC) using Informatica PowerCenter.
• Experience in Test Deployment of Informatica objects using Informatica deployment groups, and non Informatica objects using Eclipse and UNIX deployment process.
• Having Exposure in AWK Scripts and Worked on Autosys, Crontab and Control + M to schedule the jobs.
• Experience in understanding the requirements and preparing data mapping documents.
• Implemented type1/type2/type3/type4/type5/type6, Incremental and CDC logic according to the Business requirements.
• Experience in debugging mappings; Identified bugs in existing mappings by analyzing the data flow and evaluating transformations
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.

TECHNICAL EXPOSURE:

Data Warehousing Tools: Informatica Power Center 10.x,9.x,8.x,7.x, Informatica IDQ, SSIS

Databases/RDBMS/Others: MS SQL Server 2008/2005/2000 , Oracle 8i/9i/10g/11g/12c,DB2, Teradata V12, V14, V15, XML, Netezza, Siebel Data Base, Flat files and Excel files.

Data Modeling: ERWIN 4.x/3.x, MS Visio, Ralph-Kimball Methodology, Bill-Inman Methodology, Star Schema, Snow Flake Schema, Physical and Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables.

Programming Languages: java, SQL, PL/SQL, T-SQL, MY-SQL

Job Control and Other Tools: Informatica Scheduler, Putty, SQL*Plus, TOAD, PL/SQL Developer tool, Autosys, Crontab and Control + M

Reporting Tools: OBIEE, Cognos, MicroStrategy and Tableau, SAP BI/BW and SSRS.

PROFESSIONAL EXPERIENCE:

Confidential, CA

ETL Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Efficiently worked in all the phases of System development life Cycle (SDLC) using different methodologies like Agile and Waterfall .
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Performed requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Designing and building Informatica solution and PDO( Push down optimization ) where required Extensively worked with Informatica Power Center.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Analyzed source data files and gathered requirements from the business users.
• Design and build Teradata SQL,TPT, BTEQ and UNIX shell script
• Developed mappings to load into staging tables and then to Dimensions and Facts .
• 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 .
• Utilized Informatica Data Quality (IDQ) for data profiling and matching/removing duplicate data, fixing the bad data, fixing NULL values.
• 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.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• 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.
• Performed Performance testing with different sets of node configuration , different queue and different volumes.
• Prepared the DML' s for maintenance tables, review, and test and execute them.
• Used Github for version control tool for version controlling and movement of code to upper environments like SIT, UAT, Pre production and Production .

Environment: Informatica Power Center 10.1, Informatica IDQ 10.1, Teradata V14, Oracle 12c, SQL Developer, Teradata, Sql Assistant, UNIX Shell Scripting, Flat Files, XML Files, Agile Methodology..

Confidential, Boston, MA

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.
• 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.
• Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Automating the ETL process through scheduling the exception-handing routines as well as source to target mapping development, support and maintenance.
• Loading Data to the Interface tables from multiple data sources such as SQL server, Text files and Excel Spreadsheets using SQL Loader, Informatica and ODBC connections.
• Extracted data from different databases like Oracle and external source systems 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.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with the ETL processes.
• Developed PL/SQL programming that included writing Stored Procedures, Packages, Functions and Database Triggers.
• Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator using Informatica in ETL to transform the data.
• Preparation of test data for regression testing and Validating the target data with the source data.
• 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.

Environment: Informatica Power Center 9.6.1, Informatica IDQ 9.6.1, Oracle 11g, Sql Server, Toad.NetezzaFlat Files, Agile Methodology.

Confidential

Jr ETL Developer

Responsibilities:

• Involved to understand the Business requirements with Business Analysts and stakeholders.
• Involved to design the blue print and approach Documents for high level development and design of the ETL applications.
• Developed complex ETL mappings to load dimension and fact tables.
• Worked with type 1 and type 2 dimensional mappings to load data from source to target.
• Designed blueprint and approach documents for each story and take approvals from the business analysts to design the ETL mappings.
• Developed mappings, sessions, workflows and run the jobs.
• To develop the mappings used all transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
• Used reusable transformation from shared folder to implement the same logic in different mappings.
• Involved with testing team to resolve the issues while testing ETL applications.
• Resolved the testing issues and conducted meeting with testing team to understand the business requirements and how to test the applications based on business and technical prospective.
• Involved in moving the ETL jobs from development to test environment.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions level
• Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Experience in PL/SQL programming that included writing Stored Procedures, Packages, Functions

Environment: Informatica Power Centre 7.1, FTP, windows XP, Oracle 9i, DB2, PL/SQL, SQL Server,Flat files, UNIX, Shell Scripting, Waterfall Methodology.