We provide IT Staff Augmentation Services!

Sr. Talend Developer Resume

Burien, WA

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.
  • 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.

WORK EXPERIENCE:

Sr. Talend Developer

Confidential - Burien, WA

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

Talend Developer

Confidential - Seattle, WA

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.

Talend Developer

Confidential - Newark, NJ

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.

Informatica Developer

Confidential - Chicago, IL

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.

Informatica Developer

Confidential - Richardson, TX

Responsibilities:

  • Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.
  • Extensively used Informatica Client tools like Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
  • Used Teradata utilities FASTLOAD, MULTILOAD, TPUMP to load data.
  • Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
  • As a Teradata developer, responsible for maintaining all DBA functions (development, test, production) in operation 24×7.
  • Created Sources, Targets in shared folder and developed re-usable transformations, applets and user defined function (UDF) to re-use these objects in mappings to save the development time.
  • Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
  • Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems.
  • Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
  • Experience with high volume datasets from various sources like Oracle, Text Files and Teradata Tables and XML targets.
  • Used debugger extensively to identify the bottlenecks in the mappings.
  • Modified PL/SQL stored procedures for Informatica mappings.
  • Created Sessions and Workflows to load data from the SQL server, flat file and Oracle sources that exist on servers located at various locations all over the country.
  • Configured the session properties i.e. high value for commit intervals to increase the performance.
  • Involved in unit testing, Integration testing and User acceptance testing of the mappings.
  • Involved in Migrating the Informatica objects using Unix SVN from Dev to QA Repository.
  • Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables.
  • Responsible for scheduling workflows, error checking, production support, maintenanceand testing of ETL procedures using Informatica session logs.
  • Performance tuning on sources, targets mappings and SQL (Optimization) tuning.

Environment: Informatica Power Center 9.1.1, Flat Files, Oracle 11g, Teradata 12/13, SQL, PL/SQL, TOAD, SQL Assistant, Windows XP, Unix, Perl, Maestro.

Hire Now