SUMMARY

• 8+ years of IT Experience in Designing, Development, Administration, Implementation of Data Warehouse & Data marts with Informatica Products 9.x/8.x/7.x/6.x as an ETL tool.
• Expert in integration of various Operational Data Sources (ODS) with Multiple Relational Databases like Oracle, SQL Server, Teradata & Worked on integrating data from various flat files
• Expert in Informatica 9.x installation, configuration, debugging, tuning and administration including Systems implementation, operations and its optimization as Informatica admin
• Experienced in development, maintaining and implementation of EDW, Data Marts and Data warehouse with Star schema and snowflake schema.
• Expert in Data Extraction, Transformation, Loading from data sources like Teradata, Oracle, SQL Server, XML, Flat files, COBOL and VSAM files etc.
• Expert in Stored Procedures, Triggers, Packages for tools like TOAD, SSMS & PL/SQL Developer
• Expert in using Informatica Designer for developing mappings, mapplets/Transformations, workflows and performing complex mappings based on user specifications/requirements
• Expert in Operational and Dimensional Modeling, ETL (Extract, Transform and Load) processes, OLAP (On-line Analytical Processing), dashboard designs and various other technologies.
• Highly experienced in working and managing projects in Onsite-Offshore models. Proficient in handling and meeting client expectations/requirements
• Experience in Informatica Big Data Developer Edition and Autosys ..
• Through knowledge of Relational & Dimensional models (Star & Snow Flake), Facts and Dimension tables, Slowly Changing Dimensions (SCD)
• Extensively worked on Teradata queries and Utilities BTEQ, MLOAD, FLOAD, FEXPORT, TPUMP.
• Experience in Informatica Big Data Developer Edition and Autosys .
• Hands on experience in implementing Slowly Changing dimension types (I, II &III) methodologies
• Expert in migrating Informatica mappings/Workflows/sessions to Production Repository
• Proven ability to manage multiple project modules simultaneously.
• Expertise in Informatica power center setup, configuration, user security and administration
• A personality with strong business acumen, excellent inter-personal relationship, possessing strong leadership and team building capabilities.
• Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server highly preferred.
• Experienced with handling high volume of data, performance tuning, query optimization using Vertica
• Effectively develops complex Vertica SQL coding (use of temp/volatile tables, complex joins, etc.)
• Worked in Data Warehouse and Business Intelligence Projects along with the team of Informatica, Talend (ETL), Cognos 10, Impromptu and Powerplay.
• Expertise on Service Now incidents, IMR (Incident Management Record), CMR (Change Management Records) process and management.
• Designed and Prepared Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation rules.
• Expert in fine-tuning mapping & sessions by identifying bottlenecks to improve the performance
• Expert in typical Admin jobs like Migrations, FTP requests, Performance tuning, Installation of patches, hotfixes and upgrading different tools.
• Strong experience in Scheduling jobs using UNIX Shell Scripts and Unix Crontab
• Excellent analytical, problem solving & communication skills including leading & managing a team
• Experienced as an Informatica Admin on monitoring resource utilization & proactively identifying Informatica job performance & resource issues like network, disk usage, memory usage etc.
• Expertise in setup LDAP authentication security in Informatica
• Experience in Performance tuning in Vertica which includes creation of projection, partition, LAP, and segmentation

SKILLS:ETL - DW Tools: Informatica PowerCenter 9.x/8.x/7.x, Informatica PowerExchange 9.x/8.x,TOAD, SSMS, BODS

Reporting Tools: Business Objects XIR2/6.5 (Supervisor, Designer, Business Objects), Cognos,SSRS

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling,FACT and Dimensional Tables, Physical and Logical Data Modeling.

Programming Languages: C, C++, Shell Scripts, C Shell, K-Shell Scripts, VB Scripts and VI-editor.

Databases: Oracle, Oracle Apps, MS SQL Server, SAP R3, Flat Files, Teradata, PL/SQL,DB2, Sybase, Vertica, Hadoop

GUI: Visual Basic, FrontPage, Excel, Power Point.

Servers: Oracle 9iAS, Apache, Tomcat and MS Site Server, Web spherePROFESSIONAL EXPERIENCE:

Sr. ETL/Informatica Developer

Responsibilities:-

• Using Informatica Power Center 9.6 to extract data from various sources, transform and load it into staging database and from staging database to Oracle Servers and files. Also included mappings which directly loaded tables from various sources to Oracle databases
• Responsible for Optimization of mappings, sessions, SQL queries using Informatica
• Working on Alternative approach Stream, which includes mapping creation for 60+ tables, Pre and Post Migration Stages of the project in Dev, Test, QA & Prod Environments
• To Develop UNIX shell scripts to run batch jobs & automate workflows
• To Extract XML data from different sources such as messaging system TIBCO, files & databases using XML Parser Transformation, also Used XML editor to create and validate personalized views
• Responsible to design Informatica Trigger Processes to initiate and monitor Informatica Events
• To use Informatica Design Quality (IDQ) tool for data profiling based on the given business rules and convert them into reusable Mapplets which can be plugged into power center tool
• Working with data modeler in designing Conceptual, Logical and Physical data models making use of ERwin for relational OLTP systems.
• Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
• Effectively develops complex Vertica SQL coding (use of temp/volatile tables, complex joins, etc.)
• Developed a ETL process to extract project date from Primavera P6 to IBM Cognos TM1Developed a ETL process to load project status information from Project Proposal System to Primavera P6
• Responsible for various Requirement Gathering, their Analysis and leading End user Meetings
• To perform and lead typical Admin jobs like Migrations, FTP requests, Performance tuning, Installation of patches, hotfixes and upgrading the tool etc
• To develop each test plan and test case based on the high-level and detail design.
• To Standardize the formats of irregular data coming from upstream systems into a more meaningful dataset for analysis using various transformations like Standardizer, Label, Match and Comparison transformations etc.
• Creating PL/SQL Stored Procedures, Functions, Triggers & Packages to implement business logics
• Implemented exception handling using autonomous transactions, Pragma, Locks, used save points, commits & rollbacks to maintain transactional consistency & database integrity.
• Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manage
• Migrated data from SQL Server, SeaQuest (HP internal Database) to HBase using Sqoop. 
• Configured various big data workflows to run on top of Hadoop and these workflows comprise of heterogeneous jobs like VSQL, Sqoop and MapReduce. 
• Tuning of the mappings to ensure data load was completed by SLA. Working with the Cognos developers to create customized BI reports to meet user requirements using Cognos Query Studio
• Responsible for converting Functional Requirements into Technical Specifications
• Involved in Unit Testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements
• Leading onshore and off shore teams to identify and resolve various issues relating to processes, Informatica, other databases etc.

Environment: Informatica PowerCenter 9.6/9.1, Informatica PowerExchange 9.6/9.1, Oracle 10.0.1, PL/SQL developer, TOAD, Teradata, SQL Server Management Studio, Putty, UNIX Shell Script, Cognos Query Studio

Confidential,Milwaukee, WI

Sr. ETL/Informatica Developer

Responsibilities:-

• Created ETL transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica v9 designer.
• Populated data from OLTP application database to data warehouse using Informatica.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Developed robust mappings using various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union in the Informatica Designer
• Worked with business users & RADAR reporting teams to gather detailed reporting requirements
• Prepared Functional Design Specifications and Technical Design Specifications for BO reports and Technical design specification for new Universe development
• Created Configuration files with XML documents to support the packages in various environments
• Modified existing mappings for enhancements of new business requirements and Created mapplets to use them in different mappings.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Developed Mappings for Type 1 and Type 2 Slowly Changing Dimensions.
• Exported the Universe to the Repository to make resources available to the users for ad- hoc report needs using BI/BO reporting tools.
• Develop the new Universe which holds tables from various functionalists like Rating, Quality, and Finance to satisfy the new business area which has entirely different functionality.
• Created complex reports stating Rating information Region wise per year using cascading and user objects like measure objects to create the summarized reports using Business Object
• Designed, developed & managed Universes in BOs Designer for generating Ageing, Corrective Action Report etc for QA users making use of Prompts, Customized LOV's, multiple data providers
• Coordinated with offshore and onshore teams for different exercise including report deliveries
• Tested Business Objects reports and validated values as per user requirements.

Environment: Informatica PowerCenter 9.5, Informatica PowerConnect / PowerExchange 9.5, Data Analyzer 8.1 Business Objects XI R2/R3/R4.1,TOAD, Teradata, Oracle 9i, PL/SQL

Confidential,Bloomfield, CT

ETL Developer

Responsibilities:-

• Developed and supported the Extraction, Transformation, and load process (ETL) for data migration.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL, TOAD
• My responsibilities included developing and maintaining efficient ETL Talend and reporting using Cognos 8 B
• Installed, Configured Cognos8.4/10 and Talend ETL on single and multi server environments
• Used Normalizer Transformation to split a single source row into multiple target rows by eliminating redundancy and inconsistent dependencies.
• Worked on Talend RTX ETL tool, devalop jobs and scheduled jobs in Talend integration suite. Extensively used the concepts of ETL to load data from AS400, flat files to Saleforce .
• Extracted XML data from different sources such as messaging system TIBCO, files & databases using XML Parser Transformation, also Used XML editor to create and validate personalized views
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Designed and developed Informatica packages, designed stored procedures, configuration files, tables, views, and functions.
• Configured match rule set property by enabling search using rules in MDM as per Business Rules
• Migrated Informatica mapping to the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2 and Flat Files.
• Worked on Dimension/Fact tables to implement the business rules and get required results. Developed Re-usable Transformations and Re-Usable Mapplets.
• Used various transformations like Lookup, Filter, Normalizer, Joiner, Aggregator, Expression, Update strategy, Sequence generator, XML Generator, router etc. in the mappings.
• Worked on XML Parser transformation to read the XSD file and build the source definition and accordingly to read the XML source file.
• Used Netezza SQL to maintain ETL frameworks and methodologies in use for the company and also accessed Netezza environment for implementation of ETL solutions
• Involved in loading the data into Netezza from legacy systems and flat files using scripting on UNIX. Used NZ SQL & NZ LOAD utilities of Netezza
• Responsible for Unit testing and Integration testing of mappings and workflows, also responsible for Performance Tuning at the Source, Target, Mapping and Session Level.
• Rational Clear case is used to Controlling versions of all files & Folders (Check-out, Check-in). Defect Tracking and reports are done by Rational Clear Quest.
• Provided excellent customer service to the internal functional team by pro-actively following up with the issues on hand (through detailed emails and by setting up short meetings).

Environment: Informatica PowerCenter 9.5/9.1, Informatica PowerExchange 9.5/9.1,TOAD,Teradata, SQL Server 2012/2008, Oracle 11g, Shell Scripts, UNIX, Quality Center, IDQ tool, Auto-sys scheduling tool, Rational clear Quest

Confidential,Rego Park, NY

ETL/Informatica Developer June 2010- Mar 2011

Responsibilities:-

• Worked with team to understand the business requirements and designed, transformed & loaded data into data warehouse using ETL tool Informatica
• Created new mappings & updated old according to changes in Business logic using Informatica
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document Profiled data using Informatica Data Explorer (IDE) & performed Proof of Concept for Informatica Design Quality (IDQ)
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts & loading process
• Developed complex mappings using Transformations like Lookup Joiner, Sorter, Rank, Source Qualifier, Router, Union, Aggregator, Filter, and Expression in the Power Center Designer.
• Performed troubleshooting in performance issues for mappings and Optimized performance by tuning the Informatica mappings as well as SQL
• Addressed performance issues on ETL jobs, views, stored procedures, Reporting & Ad-hoc SQL.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2 and Flat Files.
• Formulated the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Extensively worked with various re-usable components like tasks, workflows, Worklets, Mapplets and transformations
• Developed Informatica workflows & sessions associated with mappings using Workflow Manager
• Worked with session logs, Informatica Debugger, and Performance logs for error handling to fix workflows and session failures.
• Created UNIX Shell Scripts for batch scheduling and loading process.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, DB2, PL/SQL, Teradata, TOAD, SQL* Plus, SQL*Loader, SQL Server 2005, Autosys, and Windows Server 2003.

Confidential,New York, NY

Informatica Developer 

Responsibilities:-

• Designed and created mappings using tools like Source Analyzer, Warehouse, Mapping & Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Developed mappings to load Fact and Dimension tables, for Type 1 and Type 2 dimensions and Incremental loading and unit tested the mappings.
• Involved in various phases of the project from design to development, integration and acceptance
• Extensively used various transformations like Source Qualifier, Aggregator, Filter, Joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language like transformation expression, constants, system variables, data format strings etc.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions
• Involved in performance tuning of mappings to tune the data load & SQLs for better performance
• Debugged maps using Debugger and Transformation's verbose data.
• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document Profiled data using Informatica Data Explorer (IDE) & performed Proof of Concept for Informatica Design Quality (IDQ)
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created shared folders, local and global shortcuts to reuse metadata.
• Resolved performance issues for huge volume of data & increased the performance significantly
• Scheduled and monitored workflows by use of Workflow Manager and Workflow Monitor.
• Worked on Dimension/Fact tables to implement the business rules and get required results. Developed Re-usable Transformations and Re-Usable Mapplets.
• Defined parameters, variables and parameter files for flexible mappings/sessions.
• Prepared various kinds of documents like Test case document, mapping design document.
• Involved in the migration of code from development to QA environment and then to production.

Environment: Informatica Power Center 8.1 (Source Analyzer, Warehouse Designer, TransformationsDeveloper, Mapplet Designer, Mapping Designer, Workflow Manager) Worklets, SQL, MS SQL 2005, Windows NT, HP-UX. 

ConfidentialETL Developer 

Dublin, OH

Responsibilities:-

• Analyzed business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• My responsibilities included developing and maintaining efficient ETL Talend and reporting using Cognos BI.
• Installed, Configured Cognos and Talend ETL on single and multi server environments
• Worked on Talend RTX ETL tool, develop jobs and scheduled jobs in Talend integration suite. Extensively used the concepts of ETL to load data from AS400, flat files.
• Modified reports and Talend ETL jobs based on the feedback from QA testers and Users in development and staging environments.
• Helped to create detailed Technical specifications for Data Warehouse and ETL processes.
• Tuned Informatica mappings to improve the execution time by applying suitable Partitioning mechanisms and tuning individual transformations inside the mapping.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created various sessions, tasks like event raise and event wait.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and unconnected Lookups, Joiner, update strategy and stored procedure.
• Developed mappings to load Fact and Dimension tables, SCD Type I and SCD Type II dimensions and Incremental loading and unit tested the mappings.
• Creating new and enhancing the existing stored procedure SQL used for semantic views and load procedures for materialized views.
• Addressed performance issues on ETL jobs, views, stored procedures, Reporting & Ad-hoc SQL.
• Involved in creating different types of reports including OLAP, Drill Down and Summary in BO.
• Performed Performance Tuning of SQL, ETL & other processes to optimize session performance
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.

Environment: Oracle 9i, PL/SQL Developer, SQL*Plus, UNIX Shell Script