SUMMARY

• 8+ years of total experience in Information Technology including Data Warehouse/Data Mart development using Talend and Informatica Power Center.
• Have good hands on various tools like, Netezza, Aqua Data, Oracle Sql Developer and Tidal.
• Worked extensively on EDW warehouses.
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
• 3 years of experience in using Talend Data Integration tool as applied to BI data analytics, reporting and dashboard projects.
• Good Experience in Talend DI Administration, Talend Data Quality and Talend Data Mapping.
• Experience in Talend Big Data Integration for business demands to work towards Hadoop and NoSQL databases.
• Optimization and performance tuning of Hive QL, formatting table column using Hive functions.
• Troubleshoot SOA composite applications by performing corrective actions such as fault recovery.
• Have been involved in designing & creating hive tables to upload data in Hadoop and process like merging, sorting and creating, joining tables
• Created complex mappings in Talend using components like tMap, tJoin, tReplicate, tParallelize, tAggregateRow, tDie, tUnique, tFlowToIterate, tSort, tFilterRow etc. And have created various complex mappings.
• Experience in using Talend Big Data components to create connections to various third - party tools used for transferring, storing or analyzing big data, such as Sqoop, MongoDB and BigQuery to quickly load, extract, transform and process large and diverse data sets.
• Good understanding of Big Data Ecosystem in ingestion, storage, querying, processing and analysis of big data Experience in Hadoop, MapReduce, HDFS.
• Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, SQL, Stored Procedure, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.

TECHNICAL SKILLS

ETL Tools: Informatica Power center V8.X, V7.X, Talend 5.X

DW Tools: Erwin, ER/Studio, MS Visio, Teradata studio, Teradata SQL Assistant

RDBMS: Oracle 10G/9i/8.x,MS SQL Server, MS Access

Languages: SQL, PL/SQL, C, C++, VB, Shell Scripting, Java and XML.

Operating Systems: Microsoft Windows, MS-DOS, UNIX and Linux

Development Tools: TOAD, SQL Plus, SQL Developer, MS Visual Studio, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr. ETL Developer

Responsibilities:

• Dealt mainly with IDOC’s using various components like tSapinput, tFileInputXML, tFileOutputXML, tAdvancedFileoutputxml, tXMLMap, tEtractXMLField.
• Dealt with tXSLT, it requires an arranged java query which acts as the structural element for the creation of the new IDOC.
• Push data as delimited files into HDFS using Talend Big data studio.
• Usage of different Talend Hadoop Component like Hive, Pig, Spark. Loading data into parquet files by applying transformation using Impala and Implemented and tested analytical solutions in Hadoop
• Executing parameterized Pig, Hive, impala, and UNIX batches in Production.
• Created HIVE/PIG scripts for ETL purpose.
• IntegrateSOAwith Oracle EBusiness Suite and various technologies, such as: OTM, WMS, Ecommerce, OM, Finance, CRM, RMS, MQ, FTP, AOPS, AS400, Mainframe, Teradata, SQL Server, DB2 and Oracle database.
• Worked in migrating queries from Netezza to Teradata by comparing the data models.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functionsandpackagesfor moving the data from staging area to data mart.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Used Netezz SQL to maintain ETL frameworks and methodologies in use by the company.
• Collaborated with software architects to ensure alignment of the Netezza environment.
• Conducted ETL development in the Netezza environment using standard design methodologies.
• Monitored progress and documented compliance with ETL best practices standards.
• Assessed the Netezza environment for implementation of the ETL solutions. Ensured all deadlines were met and analyzed stability.
• Extensively worked with both Connected and Un-Connected Lookups.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.

Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, IDE, IDQ), SQL Server, Oracle 10g, Toad, UNIX Shell Scripting, Flat Files, SQL Developer, Oracle EBS 11i.

Confidential, Warren, NJ

Sr. ETL Developer

Responsibilities:

• Involved in Extraction, Transformation and Loading of data from 10 Source Systems into our data warehouse.
• Work with the offshore team for the day to day work and review the tasks done by them get the status updates in the daily meetings.
• Created Jobs for Matching and Merging to cleanse the data coming from Source system.
• Implemented code in Talend where Survivorship rules are required.
• Scheduled Talend jobs using Talend Administration Center.
• Worked with different Sources such as Oracle, SQL Server and Flat files
• Developed Informatica mappings, sessions and workflows as per the business rules and loading requirements.
• Wrote test case scenarios and unit tested the code developed in Talend and Informatica
• Worked on the project documentation and also prepared the Source Target mapping specs with the business logic and also involved in data modeling
• Worked on migrating data warehouses from existing SQL Server to Oracle database.
• Optimized and Tuned SQL queries used in the source qualifier of certain mappings to eliminate Full Table scans.
• Used Command line Shell to run the Informatics and Talend jobs.
• Used debugger and breakpoints to view transformations output and debug mappings.
• Implemented Performance tuning in Mappings/Jobs by identifying the bottlenecks and Implemented effective transformation Logic.
• Verify the logs to confirm all the relevant jobs are completed successfully and timely and involved in production support to resolve the production issues.
• Wrote SQL, PL/SQL, stored procedures, triggers and cursors for implementing business rules.
• Migrated the code and release documents from DEV to QA (UAT) and to Production.
• Created data model using E/R studio from existing database using Reverse Engineering.

Environment: Informatica Power Center 8.6/9, Oracle 10g, SQL Server, ER/Studio, Toad, Talend 5.5.1 Enterprise MDM Edition, Windows XP, Unix, TOAD, SQL Developer.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Involved in Extraction, Transformation and Loading of data from 10 Source Systems into our data warehouse.
• Work with the offshore team for the day to day work and review the tasks done by them get the status updates in the daily meetings.
• Created Jobs for Matching and Merging to cleanse the data coming from Source system.
• Implemented code in Talend where Survivorship rules are required.
• Scheduled Talend jobs using Talend Administration Center.
• Worked with different Sources such as Oracle, SQL Server and Flat files
• Developed Informatica mappings, sessions and workflows as per the business rules and loading requirements.
• Wrote test case scenarios and unit tested the code developed in Talend and Informatica
• Worked on the project documentation and also prepared the Source Target mapping specs with the business logic and also involved in data modeling
• Worked on migrating data warehouses from existing SQL Server to Oracle database.
• Optimized and Tuned SQL queries used in the source qualifier of certain mappings to eliminate Full Table scans.
• Used Command line Shell to run the Informatics and Talend jobs.
• Created Workflows using various tasks like sessions, control, decision, e-mail, command, Mapplets/Joblets and assignment and worked on scheduling of the workflows.
• Migrated the code and release documents from DEV to QA (UAT) and to Production.
• Created data model using E/R studio from existing database using Reverse Engineering.

Environment: Informatica Power Center 8.6/9, Oracle 10g, SQL Server, ER/Studio, Toad, Talend 5.5.1 Enterprise MDM Edition, Windows XP, Unix, TOAD, SQL Developer

Confidential, Georgia, Atlanta

Sr. ETL Developer

Responsibilities:

• Leading efforts to implement Data Integration process with Talend Integration Suite (TIS) 5.0.1
• Designing, developing and deploying end-to-end Data Integration solution.
• Developing the ETL mappings for XML, .CSV, .TXT sources and also loading the data from these sources into relational tables with Talend ETL.
• Responsible for creating Fact, Lookup, Dimension, staging tables and other database objects like views, stored procedure, function, indexes, constraints.
• Implementing dimensional data modeling with the methodologies of Kimball and Bill Inmon.
• Developing complex ETL mappings for Staging, Operational Data Source (ODS), Data warehouse and Data marts load.
• Developing SQL and PL/SQL queries, functions and procedures.
• Developing and handling of complex ETL flows like slowly changing dimension (SCD) Type1, Type 2, Type 3 to capture the changes.
• Developing Talend jobs for Star and Snow-Flake schema models.
• Developing jobs for Fact, Dimension, Staging tables and multiple formats source files.
• Loading Fact, Staging, Lookup and dimension tables.
• Analyzing and tuning the ETL flow for better performance.
• Scheduling the ETL mappings on daily, weekly, monthly and yearly basis.

Environment: Talend 5.0.1 Integration Suite, Oracle 10g, SQL Server, Windows XP, UNIX, SQL Developer.

Confidential, Phoenix, Arizona

Sr. ETL Developer

Responsibilities:

• Worked on Informatica 8.6.1 client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Involved in design and development of complex ETL mappings.
• Based on the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
• Developed Mapplets, Worklets and Reusable Transformations for reusability.
• Developed Informatica SCD type-I, Type-II mappings
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL scripts to automate the process.
• Created UNIX Shell scripts and called as pre session and post session commands.

Environment: Informatica Power Center 8.6.1, Oracle 9i, SQL, SQL Server Management Studio, UNIX, and Windows XP.

Confidential, Charlotte, NC

ETL Developer

Responsibilities:

• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets and Transformations Developer.
• Interacted with Business Users and Managers in gathering business requirements
• Created mappings using Informatica Designer to build business rules to load data.
• Most of the transformations were used like the Source Qualifier, Aggregator, Lookup, Router, Filter, Sequence Generator, Expression, Joiner and Update Strategy.
• Developing and modifying changes in mappings according to the business logic.
• Creating Mapping variables, Mapping Parameters, Session parameters.
• Recovering Data from Failed sessions and Workflows.
• Creating Workflows, sessions using Workflow Manager.
• Coding & Debugging, Sorting out their time-to-time technical problems.
• Analyze the types of business tools and transformations to be applied.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval. Worked with short cuts for various Power Center objects like sources, targets and transformations.
• Implemented performance tuning logic on sources, mappings, sessions and targets in order to provide maximum efficiency and performance.
• Involved in writing the Unit Test Cases using SQL.

Environment: Informatica Power Center 8.6, Oracle 9i, SQL/PLSQL, TOAD, UNIX, and Windows XP

Confidential

ETL Developer

Responsibilities:

• Development of General Ledger, Transaction and Profit Margins processes.
• Development of staging for P/E, equities, Derivatives and Fixed income.
• Extensively used almost all types of transformations like filter, joiner, sorter, rank, update strategy, expression and aggregation.
• Involved in coding, testing in UAT.
• Created Workflow, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirements.
• Created reusable worklets and mapplets and transformations.
• Performance Tuning of sources, targets, mappings and SQL queries in transformations.
• Wrote Unix Shell Scripts to run mappings.
• Created Functions, Procedures and Triggers in PL/SQL.
• Refresh scripts for new close of business.

Environment: Informatica power center 5.1, Windows 2000, Unix-Solaris, Oracle 9i, Toad 6.3