SUMMARY:

• Around 11 years of experience in the field of IT including 9 years of experience in Informatica Power Center.
• Proficient in development of mapping using Informatica Power Center 6.x, 8.x, 9.x.
• Proficient in all phases of the system development life cycle including Requirement Gathering, Design, Development, Testing and Production Support.
• Excellent knowledge in data warehouse development life cycle and dimensional modeling, implementation of Star, Snowflake Schemas and Slowly Changing Dimensions.
• Actively involved in Performance Tuning to identify Bottlenecks.
• Good knowledge in Big - data which includes Hadoop (Architecture, Hadoop distributed file system, Map-Reduce).
• Expertise knowledge of Informaticastandards and best practices, Slowly Changing Dimensions (SCD1, SCD2, SCD3).
• Experience in testing coordination, writing test cases and executing test scripts, and logged defects in Quality Center (QC).
• Got good knowledge on Big data components like Hadoop (Hadoop distributed File system and Map Reduce).
• Worked on different transformations like Join, Lookup, Expression, Aggregator, Update, and Filter.
• Worked on application support for different clients.
• Worked on Teradata load utilities like (Fast Export, Fast Load, Multi load and TPump) which were mainly used to refresh Stage/test Environment from Production.
• Expert in fulfillment of data warehouse project tasks such as Planning, Requirement gathering, Identifying sources, allocation of resources and execution of projects including planning of implementation activities.

TECHNICAL SKILLS:

ETL Tool: Informatica 9.5/9.1/8.6/8.1

Big Data & Big Data Ecosystem: MapReduce, HDFS, Hive

Database: DB2, Teradata, Oracle

Operating System: LInux 9.x, AIX, Windows XP/Vista/7,Unix

Testing Tools: HP Quality Center

Scheduling Tools: Autosys

PROFESSIONAL EXPERIENCE:

Confidential, LA, CA

Lead Business Associate

Responsibilities:

• Performed business analysis, requirements gathering and converted them into technical specifications
• Mentoring the 4 offshore developer and 2 onsite resources on daily activities.
• Provide heads up to Senior Management team on daily/weekly basis.
• Provide effort estimations and make sure team logs their weekly time entries into Clarity (UB internal time reporting tool)
• Functional requirement gathering from the client and preparing the technical ETL specifications
• Coordinating on the ETL development
• Optimized the performance of theInformaticamappings by analyzing the session logs and understanding various bottlenecks (source/target/transformations)
• UsedInformaticadebugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading
• Software Testing including Unit and System Integration Testing, Test case/data preparation, execution and verification of the test results
• Performing walkthroughs & inspections as per standards.
• SIT support and UAT support.
• Production Implementation.
• Prompt in responding to business user queries and changes on demand.

Environment: Informatica 9.1, Oracle 10g, UNIX, Autosys, HPSM

Confidential

Lead Business Associate

Responsibilities:

• Installed and configured Big data Hadoop distributions of various vendors namely Horton Works, Cloudera, MapR.
• Installed and configured different cluster monitoring tools like Ganglia and Nagios.
• Got familiar with management consoles for different distributions for monitoring the cluster health and metrics.
• Involved in generating test data using Random Text Writer and TeraGen.

Environment: Hadoop, MapReduce, HDFS, Hive, Java (jdk1.6), Hadoop distribution of Horton Works, Cloudera, MapR

Confidential

Sr ETL Consultant

Responsibilities:

• Responsible for business analysis and requirements collection.
• Analyzing source data for potential data quality issues and addressing these issues in ETL procedures.
• Responsible for coding and modifications to enforce business rules and to improve performance of the system.
• Design, peer code review and mentoring team members for any work related issues.
• Provide status to the client team lead on a daily basis and client manager on bi-monthly basis regarding the progress like resolved tickets, pending tickets and on-going activities.
• Created source definitions, short cuts to objects using Power Connect for Legacy systems.
• Used ETL transformations like Sorter Transformation, Aggregator Transformation, Normalizer Transformation, Source Qualifier Transformation, Joiner Transformation, Expression Transformation, Lookup (Cache and Persistent) and Sequence Generator.
• Used the command line program pmcmd to communicate with the Informatica Server.
• Ensure that the developed code promotes reusability, scalable performance.
• Created mapping documents to outline the dataflow from Source to targets.
• Unit testing and documentation for all the developed mappings.

Environment: Informatica 9.1, Oracle 10g, UNIX

Confidential

ETL Consultant

Responsibilities:

• Support for ETL jobs on shift basis (in 24x7 roasters).
• Monitoring the PROD and SAT
• Created sessions & workflows for all mappings.
• Performance tuning of the Informatica mappings.
• Used the transformations such as Normalizer, Lookup, Router, Sorter, Aggregator, Expression, Union, Joiner and Filter in Informatica mappings
• Application, technology, product and/or domain specific specializations for a set of applications/product to ensure availability for business use as per agreed SLAs or requirements
• Giving KT to new joiners in SAT.
• Create production support manuals for future .

Environment: Informatica 8.6, UNIX, TNG

Confidential, NY

ETL Consultant

Responsibilities:

• Design, development and enhancements of the ETL jobs.
• Used UNIX commands during support and enhancement work.
• Unit testing and documentation.
• Control-M job creation

Environment: Informatica 8.6, Control-M scheduler, UNIX

Confidential, WI

ETL Consultant

Responsibilities:

• Support for ETL jobs on shift basis (in 24x7 roaster).
• Closing the remedy ticket assigned to production support.
• Provide application, technology, product and/or domain specific specializations for a set of applications/product to ensure availability for business use as per agreed SLAs or requirements.
• Design, development and enhancements of the ETL mappings/mapplets.
• Used the transformations such as Normalizer, Lookup, Router, Sorter, Aggregator, Expression, Joiner, Sequence Generator and Filter in Informatica mappings
• Created sessions & workflows for all mappings.
• Performance tuning of the Informatica mappings.
• Unit testing and documentation.

Environment: Informatica 8.1, DB2, UNIX, Informatica Job Scheduler Zena, Remedy User

Confidential

ETL Developer

Responsibilities:

• The responsibilities include as Team member for Claims subject area
• Preparing TSD documents for Pre-Stage to staging area data load.
• Development of Informatica mappings for the mainframe files to Pre-Staging area
• Preparing TSD and ETL specification documents for staging to EDW load.
• Preparing Unit test cased for the scripts.
• Testing the scripts with test data.
• CreatedPowerExchangeRegistration for CDC on DB2 mainframe tables, created DataMap to extract data from file on mainframe.

Environment: Informatica PowerCenter 8.1,Informatica Power Exchange 8.1,Unix, Teradata

Confidential

Business Associate

Responsibilities:

• The responsibilities include as Developer
• Involved in performing data cleansing
• Interacting with onsite folks as well as clients regarding the status update.

Environment: Informatica 8.1, Oracle 9i,Windows XP

Confidential

Jr. Software Engg

Responsibilities:

• The responsibilities include as Team member for Claims subject area
• Preparing TSD documents for Pre-Stage to staging area data load.
• Development of Informatica mappings for the mainframe files to Pre-Staging area
• Preparing TSD and ETL specification documents for staging to EDW load.

Environment: Informatica Power Center 6.0, Oracle, Windows XP