PROFESSIONAL SUMMARY:

• 9+ years of professional experience as a Data warehouse /ETL developer in IT Industries with strong Data Warehousing, Data Marts, Data Analysis experience in RDBMS databases
• Database expertise including SQL, ETL, Reporting, and Tuning.
• Data Warehousing experience on Data Modeling using Star schema and Snowflake schema with Facts, Measures and Slowly Changing Dimensions (SCD) Type1, Type2, and Type3.
• Specialty expertise with Talend most used components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more)
• Strong Data Warehousing ETL experience of using Informatica 9.x/8.x/7.x PowerCenter Client tools - Repository Manager, Designer, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Involved in Customization & Implementation of DB2 and MySQL Applications.
• Strong in analysis, requirements gathering, design, development, implementation, and management of full life cycle data warehousing projects.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8i, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Team Player as well as able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

Operating Systems: Windows 2012/2008/2007/2005/ NT/XP, UNIX, LINUX

ETL Tools: Talend TIS/TOS 4.3 to 6.4, Informatica PowerCenter 9.x/8.x/7.x,, SSIS and IBM DataStage

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata.

Data Modeling tools: Erwin, ER/Studio, MS Visio

OLAP Tools: Business Objects XI r2/6.x/5.x, Tableau, SSRS

Languages: SQL, PL/SQL, UNIX Shell scripts

PROFESSIONAL EXPERIENCE:

ETL Developer (Talend)

Confidential, Reston, VA

Responsibilities:

• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design documents and STTMs
• Defined and documented the technical architecture of the Data Warehouse, including the physical database components and their functionality.
• Involved in the creation of Talend mappings to extracting data from oracle, Flat Files to load in to Stage area.
• Responsible for implementing the Talend jobs to Process the delta data load.
• Design and Implemented Talend ETL for data load from Source to target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.
• Designed ETL Jobs/Packages using Talend Integration Suite (TIS)
• Created many complex ETL jobs for data exchange from and to Database Server and various other systems including RDBMS, XML, CSV, and Flat file structures.
• Used Talend most used components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more)
• Developed mapping parameters and variables to support SQL override.
• Worked data mapping, data cleansing, program development for loads, and data verification of converted data from legacy data.
• Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Talend jobs, and the Target Data.
• Testing and debugging of all ETL and database objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• Created and managed Source to Target mapping (STTM) documents for all Facts and Dimension tables, ODS tables.
• Interacted with developers & other team members to discuss about ETL architecture and improvements.
• Coordinate among Data Management team, DBAs, Business Analysts, and Scrum master.

Environment: Talend Integration Services (6.4), DB2, SQL Server 2014/12, Unix AIX, SVN, UNIX Shell Scripting, Bigdata - Hive Impala

ETL Developer (Talend)

Confidential, McLean, VA

Responsibilities:

• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design documents.
• Defined and documented the technical architecture of the Data Warehouse, including the physical database components and their functionality.
• Involved in the creation of Talend mappings to extracting data from oracle, Flat Files to load in to Stage area.
• Responsible for implementing the Talend jobs to Process the delta data load.
• Design and Implemented Talend ETL for data load from Source to target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.
• Designed ETL Jobs/Packages using Talend Integration Suite (TIS)
• Created many complex ETL jobs for data exchange from and to Database Server and various other systems including RDBMS, XML, CSV, and Flat file structures.
• Used Talend most used components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more)
• Used various Informatica 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.
• Created mapplets to use them in different mappings.
• Extensively worked on flat files, CSV files and involved in creation of UNIX shell scripts using different shell scripts, loading multiple files and archiving the files after the completion of loads.
• Worked data mapping, data cleansing, program development for loads, and data verification of converted data from legacy data.
• Documented the existing mappings as per the design standards followed in the project.
• Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Talend jobs, and the Target Data.
• Testing and debugging of all ETL and database objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• Created and managed Source to Target mapping documents for all Facts and Dimension tables
• Interacted with developers & other team members to discuss about ETL architecture and improvements.
• Communicated with the Data Management Group Manager to discuss the status of areas I was in charge of, for maintaining data layer on a periodic basis.

Environment: Talend Integration Services (6.4), Oracle 11 DB, SQL Server 2014/12, Unix AIX, SVN, UNIX Shell Scripting, Informatica Power Center 9.6/9.5, PL/SQL, Tableau, Erwin, Autosys, Toad 9.0

ETL Developer

Confidential, McLean, VA

Responsibilities:

• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design documents.
• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model’s using Erwin with Architect teams, I assisted them with Data Analysis & profiling.
• Defined, and documented the technical architecture of the Data Warehouse, including the physical database components and their functionality.
• Responsible for implementing the ETL jobs with Confidential logic to Process the delta data load.
• Extensively worked on flat files, CSV files and involved in creation of UNIX shell scripts using different shell scripts, loading multiple files and archiving the files after the completion of loads.
• Involved in the creation of Talend mappings to extracting data from oracle, Flat Files to load in to Stage area.
• Worked data mapping, data cleansing, program development for loads, and data verification of converted data from legacy data.
• Designed and Created data cleansing, data conversion, validation and loading jobs with Talend.
• Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of ETL jobs, and the Target Data.
• Proposed enhancements for relational database design, stored procedures, functions, triggers and scalability analysis.
• Testing and debugging of all ETL and database objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, SQL, Router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• 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.
• Documented the existing mappings as per the design standards followed in the project.
• Attended project meetings and work with teams, Project managers, team members / associates, business analysts, statisticians, and internal customers/ end users, working with multiple tasks.

Environment: Talend open Studio 4.2, UNIX Shell Scripting, SQL Server 2008/2005

ETL Developer

Confidential, Agora Hills, CA

Responsibilities:

• Involved in business requirements, technical requirements, high-level design, and detailed design process.
• Worked on loading of data from several flat files sources to Staging using SSIS.
• Extracted data from the source Oracle & DB2 database using SSIS and linked server and generated ad-hoc reports.
• Worked on exporting data to flat files using SSIS File import, created SSIS Packages using Transformation, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Generated excel reports and power-point reports using VBA Macros.
• Worked with the users and testing teams to implement the business logic as expected.
• Written several source to target mappings to implement the business logic.
• Performance tuned ETL Batch jobs, Reporting and Ad-hoc SQL.
• Performed Data validation, Data integrity before delivering data to operations, Business, Financial analyst by using Oracle, SQL Server, MS Excel, MS Access.
• Developed SQL queries, Ad Hoc for Extracting data from production databases to build data structures, reports.
• Developed Ad hoc queries and scripts to meet the Business Analyst’s and the Operational Analyst’s requirements by using database, UNIX, Oracle, SQL.
• Created technical documentation for database, Function documentation/specification for report requirements
• Performed data extraction, data manipulation, data validations with help of database

Environment: SQL Server, SSIS, SSRS, IBM DB2 8.x, Oracle 10g

ETL Developer

Confidential, PA

Responsibilities:

• Used ETL methodologies and best practices to create Talend ETL jobs
• Extracted data from flat files/ databases applied business logic to load them in the staging database as well as flat files.
• Developed mappings /Transformation/Joblets in Talend 5.4.
• Designed ETL Jobs/Packages using Talend Integration Suite (TIS)
• Worked on different data sources such as Oracle, Netezza, MS SQL, Flat files etc.
• Created complex mappings in Talend 5.4 using tHash, tDenormalize, tMap, tUniqueRow. tPivotToColumnsDelimited As well as custom component such as tUnpivotRow
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats into a Database table to record job history
• Created Talend Mappings to populate the data into dimensions and fact tables
• Implemented new users, projects, tasks within multiple different environments of TAC (Dev,Test,Prod,DR)
• Worked with clients and created specific MRS documents to ensure mapping was to their specification.
• Worked with third party vendors on specific requirements needed for new feeds.
• Created and managed Source to Target mapping documents for required jobs.
• Ensured jobs, projects and MRS documents were up to date on the SVN within different environments.
• Was involved in the creation and fixing of jobs for four different teams. One of which was the release team for Sony.
• Worked on heterogeneous data sources and targets such as Oracle, DB2/AS400, SQL Server 2008
• Created physical database objects from data model to physical database like tables, indexes, views, and triggers. Also created DDL files to be deployed by production DBAs.
• Developed Talend Jobs for ETL to perform data cleansing, standardizing, and sourcing from DB2 database and load to target for initial load and for Change Data Capture ( Confidential ) data load including absentee processing.

Environment: Talend Integration Services (5.4), Netezza DB, MS SQL Server 2008,T-SQL, Unix, Linux, Wiki, SVN, Talend Administrative Console (TAC), Java, Oracle, AS400, DB2 9

ETL Developer April 2011 till Dec 2012

Confidential

Responsibilities:

• Worked for Confidential ’s Portfolio Management, Collateral Valuations, and Confidential to create central repository for integrated view of Property related Information such as: Sales data, Rental records, Foreclosure, Short Sale, and Third Party Sale etc.
• Worked with Pricing data, bulk deals, property pricing disputes, net proceeds etc.
• Conducted JAD sessions for Requirements gathering with Project sponsors including Senior Directors, Subject Matter Experts (SMEs) and Reporting Analysts, and produced Data Models, Data Dictionaries, Metadata Repositories, and Reporting System layouts.
• Designed and implemented ODS schema (data hub) for analytical usage.
• Design and create Logical and Physical data Models using ER/Studio.
• Lead the efforts for Standardization of data elements, Meta Data, Data Governance, naming standards, and Data Dictionary.
• Developed Talend & SSIS Jobs for ETL to perform data cleansing, standardizing, and sourcing from DB2 and Flat file data sources and load to target for initial load and for Change Data Capture ( Confidential ) data load including absentee processing.
• Created Talend jobs for Workflows, joblets, and normal data integration jobs.
• Create Database objects for MicroStrategy reporting layer.
• Performed Data Model walkthrough to MicroStrategy developers for Schema development.
• Build Reporting Platform consisting of SSRS and ASP.Net/C# based reports.
• Perform DBA activities like Backup & Restore, routine check of server logs, deployed physical objects including tables, views, stored procedures and Indexes to SQL Server 2008 and 2005.

Environment: ER/Studio 8, MS SQL Server 2008, SSIS/SSRS, Talend Integration Suite 3.2 & Talend Open Studio 4.2, MicroStrategy 9, ASP.Net/C#.

ETL Developer

Confidential

Responsibilities:

• Conducted JAD sessions for Requirements gathering with Client and Application team.
• Design and create Logical and Physical data Models using ER/Studio.
• Performed requirement gathering, Data Analysis using Data Profiling scripts, Data Quality (DQ) scripts, and unit testing.
• Design and Implement ETL jobs for bi-directional data load from ODS and Application database.
• Created Source to Target mappings, Data Conversion plan, ETL Architecture.
• Managing a team of DBAs (Size-4) and coordinating with Development team (Size 25) on daily basis to support development of CATS system.
• Perform DBA activities like Backup & Restore, routine check of server logs, Installation of SQL Server 2008, deployed physical objects including tables, views, stored procedures and Indexes to SQL Server 2008.

Environment: ER/Studio 8, MS SQL Server 2008, Talend Open Studio 3.2, Tortoise SVN Subversion 1.6.12