Professional Summary

• Over 7 years of experience in IT, with proficiency as ETL developer and expert in writing SQL queries and stored procedures, worked extensively on ETL tools such as Talend and Informatica.
• Very strong in SQL joins, Nested Queries, Unions, Multi-table joins.
• Experience in scheduling the batch jobs using workflow monitor, Tivoli TWS , Autosys and FTP methods.
• Developed Batch jobs using UNIX shells scripts PMCMD commands, sftp commands to automate the process of loading, pushing and pulling data from different servers.
• Good experience in performing supporting Unit testing, System Integration Testing SIT , UAT and production support for issues raised by application users.
• Well versed with all stages of Software Development Life Cycle SDLC i.e. Requirement s gathering analyzing, Design/redesign, Implementation and Testing.
• Good knowledge on Agile Methodology and the scrum process.
• Excellent knowledge on datawarehouse concepts using Ralph Kimball and Bill Inmon methodologies. Involved in data modelling using Erwin Data modeller using both these methodologies.
• Excellent in Fast learning, Analytical thinking, decision making and problem solving skills.
• Have experience in working with both 3NF and dimensional models for data warehouse and good understanding of OLAP/OLTP systems.
• Proficient in preparing high/low level documents like design and functional specifications.
• Extensively involved in ETL Datawarehousing using Informatica PowerCenter 7.x/8.x/9 Designer tools like Source Analyzer, Target Designer, Mapping Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Worked with Dimensional Data warehouse in Star and Snowflake Schemas, created slowly changing SCD Type I/II/III dimension mappings.
• Expertise in using SQL Loader to load Data from external files to Oracle Database.
• Experience in optimizing the performance of SQL scripts and Oracle database/application tuning.
• Excellent experience with Informatica Power center and Talend Open studio and Talend Integration Suite.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Excellent experience with Informatica Power center and Talend Open studio and Talend Integration Suite.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like Sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse.
• Experience in coding using SQL, SQL Plus, PL/SQL, Procedures/Functions, Triggers and Packages.

TECHNICAL SKILLS

• Operating Systems: MS DOS, UNIX, Windows NT/ 2000/ XP and Linux
• Languages: SQL, PL/SQL, Shell scripting
• RDBMS: Oracle 8i/ 9i/10g/11g, MS SQL Server, Netezza
• ETL Tools: Informatica 8x, 9x, Talend Open Studio, Talend Integration Suite
• Testing Tools: QTP, Quality Center, Rational Suite Requisite Pro, Rose, Robot, Test Manager, Clear Quest, Clear Case , Selenium, HP quick Test Pro.
• Tools: Aginity, Putty, Toad

Confidential

Sr. ETL Developer

Responsibilities

• Participated in meetings with Users, Business analysts in understanding the business requirements and analyzed use cases to develop detailed Test Plan
• Agile team interaction.
• Worked on Talend ETL and used features such as Context variables, Database components like tMSSQLInput, tOracleOutput, file components, ELT components etc.
• Extracted data from flat files and SQL server and loaded to Oracle database using Talend.
• Involved in Complete Software Development Lifecycle Experience SDLC from Business Analysis to Development, Testing, Deployment and Documentation.
• Constructed Korn shell driver routines write, test and implement UNIX scripts
• Wrote views based on user and/or reporting requirements.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Involved in performance and tuning of the ETL processes.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Worked on Talend ETL to load data from various sources to Oracle DB. Used tmap, treplicate, tfilerrow, tWaitforFile and various other features in Talend
• Worked on extracting data from DB2 and Mainframes and load it to Oracle using Informatica ETL tool.
• Involved in Complete Software Development Lifecycle Experience SDLC from Business Analysis to Development, Testing, Deployment and Documentation.
• Written custom Java code to achieve few complex functionality in Talend.
• Wrote Oracle PL SQL stored procedures to handle complex business logics.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Gathered system design requirements, design and write system specifications.
• Worked in Agile methodology.
• Involved in system testing of overall Processes provided production support.
• Worked on data warehouses with sizes from 10-20 Terabytes.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements

Environment

Oracle 11g, Informatica 9x, DB2, Mainframes, SVN, Outlook, Putty

Confidential

ETL Developer

Responsibilities

• Participated in meetings with Users, Business analysts in understanding the business requirements and analyzed use cases to develop detailed Test Plan
• Agile team interaction.
• Worked on Talend ETL and used features such as Context variables, Database components like tMSSQLInput, tOracleOutput, file components, ELT components etc.
• Extracted data from flat files and SQL server and loaded to Oracle database using Talend.
• Involved in Complete Software Development Lifecycle Experience SDLC from Business Analysis to Development, Testing, Deployment and Documentation.
• Constructed Korn shell driver routines write, test and implement UNIX scripts
• Wrote views based on user and/or reporting requirements.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Involved in performance and tuning of the ETL processes.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Performance tuned and optimized various complex SQL queries.
• Wrote many UNIX scripts.
• Gathered system design requirements, design and write system specifications.
• Worked on data warehouses with sizes from 20-40 Terabytes.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements
• Extensively used Toad and wrote complex SQL Queries using joins, sub queries and correlated sub queries

Environment

Talend, Informatica 8x, power exchange, Oracle, Netezza, Aginity, SQL, SVN, Outlook, Putty

Confidential

Informatica Developer

Responsibilities

• Analyzed Business Requirements Document and Functional Specification document to develop detailed Test Plan and Test Cases.
• Involved in Complete Software Development Lifecycle Experience SDLC from Business Analysis to Development, Testing, Deployment and Documentation.
• Worked on Oracle PL SQL to create stored procedures, packages and various functions.
• Constructed Korn shell driver routines write, test and implement UNIX scripts
• Wrote views based on user and/or reporting requirements.
• Performance tuned and optimized various complex SQL queries.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Done caching optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Extensively worked on Autosys to schedule the jobs for loading data into the tables and also for spooling the data to various down streams.
• Performance tuning to ensure optimal session performance.
• Extensively used Informatica debugger to validate Mappings and to gain troubleshooting information about data and error conditions.
• Used Erwin for data modeling and Dimensional Data Modeling.
• Wrote many UNIX scripts.
• Gathered system design requirements, design and write system specifications.
• Agile team interaction.

Environment

Informatica 8x, power exchange, Oracle, Netezza, Aginity, SQL, SVN, Outlook, Putty

Confidential

Informatica Developer

Responsibilities

• Coordinate with the front end team working on Oracle Forms to provide with the necessary stored procedures and packages and the necessary insight into the data.
• Extensively involved in creating PL/SQL objects i.e. Procedures, Functions, and Packages.
• Analyzed Business Requirements Document and Functional Specification document to develop detailed Test Plan and Test Cases.
• Involved in Complete Software Development Lifecycle Experience SDLC from Business Analysis to Development, Testing, Deployment and Documentation.
• Worked on Oracle PL SQL to create stored procedures, packages and various functions.
• Created Materialized views and presented to BI teams.
• Created Ref cursors, Bulk processing, collections, nested tables.
• Performed bug verification, release testing and provided support for Oracle based applications.
• Involved in performance tuning the existing objects.
• Used External tables to manipulate data obtained daily before loading them into the tables.
• Extracting thousands of data from the database for data analysis.
• Extracting and moving data from UNIX.
• Documentation of all modules for user level and system level maintenance.
• Worked in a CMMI level 5 coding standards.

Environment

Oracle 8i, UNIX, SQL, PL/SQL, SQL Developer and TOAD, SQL Loader, Putty