SUMMARY

• 8+ years of IT experience in Development, Test, administration & analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverable within committed deadlines.
• Having experience in interacting with the client in requirement gathering.
• Having sound knowledge on OLTP, ODS and EDW data modeling (logical and physical design, and schema generation) using Erwin, ER/Studio and other tools for Teradata, Oracle, DB2/UDB and MS SQL Server models & repositories.
• Extensive experience in loading high volume data, requirements gathering, analysis, design, development, test and implementation.
• Strong Data Warehousing ETL experience of using Informatica … PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Proficient in analysis of user requirements and functional specifications.
• Exclusive experience in ETL process and ETL development.
• Strong Emphasis in reviewing End-to-End test requirements, assigning appropriate resources, and initiate the End-to-End planning process.
• Good understanding of the Software Development Life Cycle (SDLC).
• Excellent in interacting with developers at various levels and understanding technical specifications, documentation of the application to be tested.
• Involved in development of Informatica mappings with required transformations like Aggregator, Filter, Lookup, Sorter, Normalizer, Update strategy etc.
• Strong Knowledge on Power center Designer, Workflow Manager, Workflow Monitor.
• Creating sessions and Workflows using Informatica Workflow Manager.
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while Developing Mapplets and Mappings using Informatica Designer Tool.
• Involved in Performance Tuning at mapping level and session level.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Expertise in working with relational databases such as Oracle … SQL Server … DB2 8.0/7.0, UDB, MS Access and Teradata.
• Having good knowledge in Autosys, ALM/QC and Clear Quest.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning.
• Expertise in writing large/complex queries using SQL.
• Strong knowledge on Ab Initio GDE … Co>Op …
• Good Knowledge in Dimensional Data modeling, Star/Snowflake schema design, Fact and Dimensional tables, Physical and Logical data modeling.
• Experience with business intelligence reporting tools using Business Objects, Cognos and Hyperion.
• Experience in supporting large databases, troubleshooting the problems.
• Experience in all phases of SDLC like system analysis, application design, development, testing and implementation of data warehouse and non-data warehouse projects.
• Excellent ability with competitive spirit in finding various approaches for problem solving and highly skillful, creative and innovative in developing efficient logic/code.
• Proficiency in prioritizing and multi-tasking to ensure that tasks are completed on time
• Good Communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica … Stage, OBIA,Talend, … Co-op • … SSIS

DB Tools: SQL*Plus, SQL Loader, TOAD,SQL Assistant,, BO

Databases: Teradata … Oracle 10g, DB2, MS-SQL Server … MS-Access, Oracle,Mainframe, Netezza

Scheduling Tools: Autosys

Version Control Tools: Clear Case

Programming Languages: C, C++, Java, J2EE, Visual Basic, SQL, PL/SQL,SiebelCOBAL, Python and UNIX Shell Scripting.

Data Modelling /Methodologies: Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Cycle. ERWIN 4.0

BI: Microstrategy, SAS, Cognos.

Operating Systems: Sun Solaris … Windows, UNIX

Big Data Technologies: Hadoop, Hive, Pig, Hbase.

PROFESSIONAL EXPERIENCE

Sr Informatica Developer

Confidential, TX

RESPONSIBILITIES:

• Understand the Requirements and Functionality of the application from specifications.
• Worked closely with Business users, ETL developers, Database architects, and the QA teams.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Created Mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, Joiner, etc.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Used Informatica Power Center tool for extraction, transformation and load (ETL) of data in the data warehouse.
• Using Informatica PowerCenter created mappings to transform the data according to the business rules.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Created different KPI using calculated key figures and parameters.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Involved in test data set up and data quality testing and Unit testing and Integration Testing.

Sr Informatica Developer

Confidential, CA

Responsibilities:

• Created Mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, Joiner, etc.
• Analyzed the business requirements and functional specifications.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Used Informatica Power Center tool for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Using Informatica PowerCenter created mappings to transform the data according to the business rules.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager
• Understanding of Requirements Specification and analysis of source systems.
• Involved in Unit, Integration, System, and Performance testing levels.
• Responsible for running Autosys jobs.
• Helping to the team members in fixing the issues, developing the jobs and analyzing the code.
• Analyzing the data loads, identifying the dependency and changing the load sequence in busy schedules.
• Monitoring the daily, weekly and monthly data loads and fixing the load failures.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in test data set up and data quality testing and Unit testing and Integration Testing.

Environment: Informatica Power Center, Teradata, SQL Server, SAS, Windows, Oracle, PL/SQLTOAD, Autosys, Cognos, Netezza.

Sr Informatica Developer

Confidential, CA

Responsibilities:

• Worked with various Business users to gather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.
• Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Developed complex Mappings, Mapplets and Reusable Transformations to facilitate daily loading of Data into Oracle.
• Responsible for running Autosys jobs.
• Helping to the team members in fixing the issues, developing the jobs and analyzing the code.
• Analyzing the data loads, identifying the dependency and changing the load sequence in busy schedules.
• Monitoring the daily, weekly and monthly data loads and fixing the load failures.
• Responsible for coordinating with the upstream teams to get the data into system.
• Responsible for validating the ETL transformation logic.
• Analyzing and troubleshooting the issues that were found.
• Responsible for running Autosys jobs.

Environment: Autosys, Netezza, Informatica, Business Objects XI R3, ALM/Quality Center, Clear Quest, Clear Case, Oracle 9i/10g, Toad and Windows.

Sr Informatica Developer

Confidential, California

Responsibilities:

• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.
• Loading data from different system to Vertica database.
• Backing up, restore and recovery into Vertica database.
• Troubleshooting performance issues and optimize query performance.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Developed complex Mappings, Mapplets and Reusable Transformations to facilitate daily loading of Data into Oracle.
• Performed Unit testing of the mappings developed.
• Created transformations and used Aggregator, Expression, Sequence Generator, Joiner, Filter, Router, Look up and Update Strategy transformations to model various standardized business processes.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Modified existing mappings for enhancements of new business requirements.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.Responsible for coordinating with the upstream teams to get the data into system.
• Loaded data into test databases by executing Autosys box and validated the data.
• Created new Informatica mappings, sessions, Worklets and Workflows to in corporate the enhancements requirement.
• Giving KT to the new joiners and fresher in the team about project architecture, Loads and data issues.
• Responsible for validating the ETL transformation logic.
• Responsible for running Autosys jobs.
• Helping to the team members in fixing the issues, developing the jobs and analyzing the code.
• Analyzing the data loads, identifying the dependency and changing the load sequence in busy schedules.
• Monitoring the daily, weekly and monthly data loads and fixing the load failures.
• Automated the jobs through scheduling using Built in informatica scheduler.
• Performance tuned and optimized various complex SQL queries.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Teradata SQL Assistant, Windows NT, Autosys, UNIX, Putty.

Sr Informatica Developer

Confidential, San Francisco

Responsibilities:

• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Created Mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, Joiner, etc.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Loading data from different system to Vertica database.
• Backing up, restore and recovery into Vertica database.
• Troubleshooting performance issues and optimize query performance.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Involved in test data set up and data quality testing and Unit testing and Integration Testing.
• Providing suggestions for best join plans while visualizing SQL queries with Visual Explain and Explain while recommending best Join Indexes such as Single table or multi table join indexes.
• Supporting jobs running in production for failure resolution with tracking failure reasons and providing best resolution in timely manner.
• Interaction with different teams for finding failure of jobs running in production systems and providing solution, restarting the jobs and making sure jobs complete in the specified time window.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica PowerCenter Designer 8.6/8.1, Informatica Repository Manager, Vertica, Teradata, shell scripting, SQL Assistant, Cognos, Windows Vista, Erwin, Autosys.

Informatica Developer

Confidential

Responsibilities:

• Worked with various Business users to gather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.
• Understanding of Business Requirement Documents, Data models & Architecture of project.
• Created Tasks, Workflows, and Sessions to move the data at specific intervals on demand using Workflow Manager.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Developed complex Mappings, Mapplets and Reusable Transformations to • facilitate daily loading of Data into Oracle.
• Performed Unit testing of the mappings developed.
• Created transformations and used Aggregator, Expression, Sequence Generator, Joiner, Filter, Router, Look up and Update Strategy transformations to model various standardized business processes.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Modified existing mappings for enhancements of new business requirements.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica, Business Objects, Autosys, Oracle, Shell Scripts, OBIEE, HP Unix, Windows XP, Erwin.

Informatica Developer

Confidential

Responsibilities:

• Involved in understanding the Requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
• Configured the source and target database connections using .dbc files
• Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Developed reusable Mapplets and Transformations.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• 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.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Created proper Teradata Primary Indexes taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Involved in performance tuning for Teradata SQL statements using Teradata Explain command.
• Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes.
• Prepared the testcase documents and other technical specification documents.

Environment: Informatica Power Center, Informatica Repository Manager, Teradata, Teradata SQL Assistant, Fast Load, BTEQ, MLOAD, Business Objects, Shell Scripts, HP unix, Windows XP.