SUMMARY

• Over nine (9) years of experience in analysis, design, development and implementation of Client/Server and Data warehouse applications.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehouse/Decision Support Systems usingETLtools,InformaticaPower Center 8.x, 9.x, OLTP, OLAP.
• Good understanding of Ralph Kimball Dimensional Modeling using Star schema methodology and Bill Inman Snow Flake schema methodology.
• Experience in Repository Configuration, creating Transformations and Mappings usingInformatica Designer and processing tasks using Workflow Manager.
• Knowledge in designing Dimensional models for Data Mart and Staging Database.
• Experience in Installation, Configuration, and Administration ofInformaticaPower Center 7.x, 8.x, 9.1 Client/Server.
• Responsible for interacting with different Business Partners, Vendors & Customers to identify information needs and business requirements for reports.
• Experience in documenting Design specs, Unit test plan and deployment plan.
• Experience in Oracle as Pl/SQLDeveloper.
• Extensively involved in creating Stored Procedures, Functions, Packages, Triggers, and Indexes with Query optimizations as part of ETL Development process.
• Experience in data integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat - files, CSV files, COBOL and XML files.
• Experience in Performance tuning ofInformatica(sources, mappings, targets and sessions) and tuning the SQL queries.
• Working knowledge of a variety of Relational DBMS products, with experience in designing and programming for relational databases, including Oracle, SQL Server,DB2.
• Experience in design and implementation usingETLtools likeInformatica(Power Center) Designer, Repository Manager and Workflow / Server Manager.
• Experience in creating various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Normalizer, Sorter, Router, XML, Stored procedure inInformaticaPower Center.
• Extensive knowledge in handling Slowly Changing Dimensions (SCD) Type 1/2/3.
• Experience in UNIX shell scripting (file validations, file downloads, workflow executions)
• Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like Oracle, SQL Server 2008/2005, Flat files, XML etc.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts.
• Experience working with SDLC, SCRUM, Waterfall and Agile methodologies.
• Reliable, responsible, hardworking and good team player.

TECHNICAL SKILLS

• Informatica Power Center
• SSIS
• SSRS
• MS SQL Server 2005 & 2008 R2
• T-SQL
• MS VSS
• TFS
• SVN
• Hadoop Ecosystem (PIG
• HIVEQL)

PROFESSIONAL EXPERIENCE

Confidential, Chandler, AZ

ETL Developer

Responsibilities:

• Communicated with business customers to discuss the issues and requirements.
• Created scripts to fine tune the ETL flow.
• Develop ETL programs using Talend 6.2 to Hadoop (HIVE)
• Maintain ETL SSIS 2014 to implement the business requirements.
• Unit Test Plan preparation
• Worked Coding, Unit Testing using Test harness
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked on Onsite and Offshore work model.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.

Environment: Talend Open Studio 6.2,SSIS 2012, Cassandra Datastax, MS SQL Server2012, Visual Studio 2012

Confidential, Torrance, CA

ETL Developer

Responsibilities:

• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Contributed as a ETL tech Lead for the Data Warehousing Project that involved thedesign analysis ofEnhancements to the Data warehouse project.
• 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.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• 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.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.

Environment: Informatica Power Center 9.6.1, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 10g/9i, SQL Server 2005/2008 R2 / 2012

Confidential, San Diego, CA

ETL developer

Responsibilities:

• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Star Schema on Oracle 9i Instance.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Developed ETL mappings, transformations using Informatica Power center.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Created Informatica complex mappings with PL/SQL procedures/functions to build business rules to load data.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Performed complex defect fixes in various environments like UAT, SIT etc. to ensure the proper delivery of the developed jobs into the production environment.
• Attended daily stand up meeting with internal team and weekly calls with client and updated the status report.
• 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.

Environment: Informatica Power Center 9.6, Oracle 10g, MS SQL Server2008, PL/SQL, UNIX shell scripting

Confidential, Louisville, KY

LEAD /ETL developer

Responsibilities:

• Involved in massive data cleansing prior to data staging.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Designed Type1 and Type2 mappings
• Transformed data from one server to other servers using tools like SQL Server Integration Services (SSIS) (2005/2008).
• Extensively usedInformaticaclient tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, TransformationDeveloper,InformaticaRepository Manager andInformatica Workflow Manager.
• Design and Development ofETLroutines, usingInformaticaPower Center within theInformatica Mappings, usage of Lookups, Aggregator, Ranking, connected and unconnected Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data into Oracle database.

Environment: Informatica power Center 8.6.1, SSIS 2008, DTS, Oracle 10g, SQL Server 2008, T-SQL Flat files (fixed width/delimited), UNIX shell scripting.

Confidential

Developer

Responsibilities:

• Requirement gathering and understanding the trends that is to be shown in the reports.
• Used Visual SourceSafe (integrated with VS.NET 2008) for version management.
• Developed new web service to consume by other system to generate policy file.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Wherever required, ETL process was created, the reports, will be stored, refreshed and utilized in the report on daily basis.
• Developed parameterized SSRS reports which used grouping, summing within grouping, sub reports etc. Created and managed subscriptions on these reports for users.
• Unit Test Plan preparation

Environment: SQL Server 2008, T-SQL, SSIS, SSRS, Visual Studio.Net 2010 (C#.NET), Web service.

Confidential

Developer

Responsibilities:

• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Extracted data from DB2 Mainframes, Cobol Copy books, DL1, XML, Sequential files to Oracle Dataware house
• Created detailed Technical specifications for Data Warehouse andETLprocesses.
• Conducted a series of discussions with team members to convert Business rules intoInformatica mappings.
• Extracted Erwin physical models into repository manager
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
• Tuned performance ofInformaticasession for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Mapplets and used them in different Mappings.
• Developed stored procedure to check source data with warehouse data and if not present, write the records to spool table and used spool table as lookup in transformation.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting productionETLscripts.
• Leveraged workflow manager for session management, database connection management and scheduling of jobs.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation ofInformaticaPower center.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Implemented pipeline partitioning concepts like Hash-key, Round-Robin, Key-Range, Pass Through techniques in mapping transformations
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.

Environment: InformaticaPower Center 8.6.1, Oracle 10g, SQL Server 2008, DB2, Toad, Winscp, UNIX

Confidential

Developer

Responsibilities:

• Imported various Sources, Targets, and developed Transformations usingInformaticaPower Center Designer.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations.
• Created Mapplets using Mapplet Designer.
• Used Type2 mapping to update a slowly changing dimension table to keep full history.
• Captured source file/table definitions, target data, and data mart table definitions.
• Create and maintain metadata andETLdocumentation that support business roles and detailed source to target data mappings.
• Involved in designing and extracting the transformations containing the XML Source Qualifier.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Testing and validation of the developedInformaticamappings.
• Monitored sessions usingInformaticaServer Manager.
• Applied performance-tuning logic to optimize session performance.
• Wrote PL/SQL Packages, procedures, functions in oracle for business rules conformity.
• Utilized SQL loader, export/import utilities for data load and transformation.
• Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.
• Worked with different databases such as Oracle and Flat files and usedInformaticato extract data.
• Involved in Unit Testing, Integration, and User Acceptance Testing of Mappings.

Environment: InformaticaPower center 8.1/7.1, Toad, Oracle 9i/8i, SQL Plus, UNIX,SQL*Loader.

Confidential

Developer

Responsibilities:

• Used update strategy to effectively migrate data from source to target.
• Moved mappings from development environment to test environment.
• Interacted with the business community and database administrators to identify business requirements and data realities.
• Imported and created source definitions from Oracle, SQL Server, Sybase and flat files.
• Created design documentInformaticamappings bases on business requirement.
• CreatedInformaticamappings using various transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.
• Involved in designing of testing plan (Unit testing and System testing).
• Tested scripts by running workflows and assisted in debugging the failed sessions.
• Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
• Used persistent caches whenever data from workflows were to be retained.
• Used lookups whenever appropriate, along with the use of appropriate caches.
• Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
• Environment:InformaticaPower Center 8.1/7.1, Oracle 9i, PL/SQL, UNIX.