SUMMARY

• Over 8 years of experience of IT experience in Software Analysis, Design, Implementation, coding, Development, Testing, and Maintenance for various software applications in the client - server environment in providing Business Intelligence Solutions in Data Warehouse.
• Application Using ETL tools like Talend 6.3 and IBM InfoSphere DataStage 9.1.
• Experience with Talend Open Studio & Talend Integration Suite.
• 3+ years’ experience using Talend Integration Suite (6.x/5.x)/ Talend Open Studio (6.x/5.x) and 2+years of experience with Talend Admin Console (TAC).
• Excellent Experience working on Talend ETL and used features such as Context variables, Database components like tMSSQLInput, tOracleOutput, tmap, tFileCopy, tFileCompare, tFileExist file component, tlterateToFlow, tFlow Tolterate, tHasoutput, tHashInput, tRunjob, tJava, tNormalize etc.
• Create mappings using Lookup, Aggregator, Joiner, Expression, Filter, Normalizer and De-Normalizer, Rank, Sorter, Union, Update Strategy, Router, Source Qualifier, and Maps Transformations. Developed reusable Transformation and joblets.
• Familiar with data architecture including data ingestion, pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing and experience optimizing ETL workflows.
• Experienced in working with Horton works distribution of Hadoop, HDFS, MapReduce, Hive, Sqoop, Flume, Pig, Hbase, and MongoDB.
• Involved in TAC (Talend Administrator Console) activities such as Job Scheduling, AutoSys, Server Monitoring, Job Conductor, Task Creation, Job Deployment, Control M& Job Conductor (Talend Admin Console) and using UNIX (Korn & Bourn Shell) etc.
• Demonstrated expertise utilizing ETL tools: Talend Data Integration, SQL Server Integration Services (SSIS), Development slowly changing dimension (SCD) mapping using Type-I, Type-II, and Type-III methods.
• Experience in the implementation of the full life cycle in Data warehouse, ODS and Datamarts with Dimensional modeling techniques, Stat Schema and Snowflake Schema.
• Created test plans, test data for extraction and transformation processes and resolved data issues followed the data standards.
• Data Warehouse and Data Marts using DataStage version 9.1, 8.7, 8.1.
• Designed jobs in DataStage 9.1, 8.7 using stages like Transformer, sequential, Aggregation, Dataset, File Set, Remove Duplicates, Sort, Join, Merge, Lookup, Funnel, Copy, Modify, Filter, Change Data Capture, Surrogate Key, External Source, Eternal Target, Compare and Schedule jobs through UNIX shell scripts.
• Strong hands-on experience using Teradata utilities like SQL Assistant, B-TEQ, FastLoad, MultiLoad, Fast Export, and TRUMP. Experience in, performance tuning of Informatica mappings.
• Experience in accepting and working tickets submitted by clients to a ticketing system.
• Unique ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem-solving skills.
• Experts in all areas of SQL Server development including tables, user functions, view, indexes, Stored procedures, functions, triggers, clustering, T-SQL, relational database model, data dictionaries, and data integrity, Data warehousing concepts, OLPT & OLA.
• Hands-on experience in MS SQL Server database with tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Optimal Performance.
• Great Expertise in creating and managing Event Handlers, Package Configuration, Logging, system and User-defined Variables for SSIS Packages.

TECHNICAL SKILLS

ETL/Middleware Tools: Talend 5.5/5.6, Informatica Power Center 9.5.1/9.1.1/8.6.1/7.1.1

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Fact and Dimension tables, Physical and Logical Data Modeling.

Business Intelligence Tools: Business Objects 6.0, Cognos 8BI/7.0.s, Sybase, OBIEE 11g/10.1.3.x

RDBMS: Oracle 10g/9i, Netezza, Teradata, MS SQL Server, DB2, MySQL, MS Access.

Programming Skills: SQL, Oracle PL/SQL, Unix Shell Scripting, HTML, DHTML, XML, Java, .Net

Modeling Tool: Erwin 4.1/5.0, MS Visio.

Tools: TOAD, SQL Plus, SQL*Loader, Quality Assurance, Soap UI, Fish eye, Subversion, Share Point, IP switch user, Teradata SQL Assistant.

Operating Systems: Windows 8/7/XP/NT/2x, Unix-AIX, Sun Solaris 8.0/9.0.

Scheduling Tool: Zena, Maestro, Control M, Informatica Scheduling.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Talend Developer

Responsibilities:

• Administration, configuration, analysis, design, development, maintenance and support of Talend.
• Technology assessments and recommendation.
• Design and development of ETL jobs (Extraction, Transform and Load).
• Performing other tasks as assigned by Project Manager. working with the following tool for data integration needs: Talend Enterprise 6.2.1 (Big data edition)
• Creating detail design specifications for the extraction, transformation and load processes coded for audit and maintainability purposes.
• Write efficient ETL code within established timelines to successfully deliver projects on schedule.
• Write the shell script for cleanup activity, the run job from the background.
• Thoroughly unit test ETL code to ensure free of errors. Document the results of testing prior to hand off tested ETL code to the Quality Assurance department.
• Participating in regular technical review sessions to identify non-adherence to standards, design and performance issues/improvements in ETL code.
• Accountable for assigned Data Integration Development Deliverables.
• Best practices to find opportunities for improvements in developmental processes and make recommendations for implementation.
• Leverage skills and experience to contribute to overall architecture for IM systems, in developing the end-to-end system design for specific data warehouse application.

Environment: MS SQL Server, Talend Enterprise for Big Data 6.2.1, Oracle, RedShift, Linux, JIRA, TAC, SVN, GitHub.

Confidential, Harrisburg, PA

Talend Developer

Responsibilities:

• Involved in analysis, requirement collection & documentation of functional & technical specifications.
• Analyzed the specifications and identified the source data and needs to be moved to the data warehouse.
• Involved in Logical and Physical data model, Built the DDL and DML scripts from the Erwin tool
• Used Informatica power center for extracting, transforming and loading databases from Oracle and non-oracle databases.
• Implemented excellent Informatica development strategies and used Target Load Plan, Constraint-based loading, partitioning, and performance tuning the existing mappings. Used the Informatica debugger to resolve the errors in the mappings.
• Wrote SQL, PL/SQL, stored procedures, triggers & cursors to implement business rules and transformation; involved in performance tuning of Existing Jobs.
• Involved in the preparation of documentation for ETL, standards, procedures and naming conventions.
• Used UNIX shell scripts for running the jobs.
• Setting up Batches and sessions to schedule the loads at required frequency using Autosys. Generated completion messages and status reports using Workflow manager.
• Developed Unit Test Cases, Design Documents, and Effective Test Data to ensure successful execution of the data loading process.
• Involved in production support for troubleshooting data issues and overnight batch support.

Environment: Informatica Power Center 8.6, oracle10g, SQL Server, UNIX Shell Scripting, TOAD, SQL Developer.

Confidential, Newark, NJ

Talend Developer

Responsibilities:

• Interacting with Business Analyst and solution architects to gather the requirements and update the solutions.
• Schedule the Talen jobs with Talend Admin Console, setting up best practices and migration strategy.
• Implemented FTP operations using Talend Studio to transfer files in between network folders as well as too.
• Experienced in using debug mode of Talend to debug a job to fix errors.
• Created complex mappings using tHashOutput, tHashInput, tNormalize, tDenormalize, tMap, tUniqueRow. tPivotToColumnsDelimited, etc.
• Used tRunJob component to run child job from a parent job and to pass parameters from parent to child job.
• Created Context Variables and Groups to run Talend jobs against different environments.
• Design and developed end-to-end ETL process from various source systems to the Staging area, from staging to Data Marts.
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats into a Database table to record job history.
• Integrated java code inside Talend studio by using components like tJavaRow, tJava, tJavaFlex and Routines.
• Conducted JAD sessions with business users and SME's for better understanding of the reporting requirements.
• Developed Talend jobs to populate the claims data to data warehouse - star schema.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Involved in writing SQL Queries and used Joins to access data from Oracle, and MySQL.
• Broad design, development and testing experience with Talend Integration Suite and knowledge in Performance Tuning of mappings.
• Developed jobs in Talend Enterprise edition from stage to source, intermediate, conversion, and target.
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats.
• Solid experience in implementing complex business rules by creating re-usable transformations and robust mappings using Talend transformations like tConvertType, tSortRow, tReplace, tAggregateRow, tUniteetc.
• Used tParalleize component and multi-thread execution option to run sub jobs in parallel which increases the performance of a job.
• Troubleshooting, debugging & fixing Talend specific issues while maintaining the health and performance of the ETL environment.

Environment: Talend 5.5/5.0, Oracle 11g, Teradata V 13.0, Fast load, Multi-load, Teradata SQL Assistant, MS SQL Server 2012/2008, PL/SQL, Agile Methodology, T-SQL, SSIS, TOAD, Erwin, AIX, Shell Scripts, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Gathered the business requirements from Business Analyst. Worked on analyzing Source to Target mapping Excel document.
• Extensively worked on Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Worked on various tasks like Session, E-Mail task and Command task.
• Worked on Informatica Scheduler for scheduling the delta loads and master loads.
• Written the scripts needed for the business specifications.
• Facilitated performance tuning of the process at mapping level, session level, source level and Target level.
• Used Mapplets for use in mappings thereby saving valuable design time and effort.
• Worked on various Lookup Caches like Static, Dynamic, Persistent and Shared Caches.
• Worked on UNIX to Import parameter files into workflow manager.
• Worked on session logs, Informatica Debugger and Performance logs for error handling when we had workflows and session fails.
• Functionality, Back-end, and Regression testing during the various phases of application and data integrity/back-end testing by executing SQL statements.

Environment: Informatica Power Center 9.0/8.6, Oracle 10g, UNIX, Toad.

Confidential

Informatica Developer

Responsibilities:

• Played a key role as part of the creative team and contributed ideas to build the DMIP product and won innovation award for the same.
• Played a key role in Data Modeling, ETL development, a Quality process in developing the product.
• As part of WS1, interacted with business analyst to understand the business requirements and develop the physical data models for the product using Erwin tool.
• As part of WS2, developed end to end mappings from the source system to target system.
• As part of WS3, developed quality check mappings in developer tool for the entire insurance business rules repository.
• As part of WS4, used Informatica Analyst tool to develop profiles for profile specifications.
• Explored IDQ and added value to the product development team.
• Played the role of a trainer to train the juniors in the project in ETL transformations and also IDQ services.
• Also worked for the Data Quality team to develop data quality rules in Informatica developer and Analyst tools. These rules are specific to maintain qualitative data across the stages of warehousing.

Environment: Informatica 8.6.1, Oracle 10g, Toad, Erwin