We provide IT Staff Augmentation Services!

Etl Talend Developer Resume

Southfield Michigan, MI

SUMMARY

  • Over 7+ years of experience in information technology industry in the areas of data warehousing and business intelligence: focusing on Talend, Informatica Power Center ETL development, testing and bug fixing
  • Over 3+ Years of experience with Talend Open Studio & Talend Enterprise Edition.
  • Experience in the areas of Retail, Financial, Health Care and Insurance domains.
  • Extensively used ETL Methodology for supporting Data Extraction, transformation and loading processing using Talend & Informatica
  • Experience in Data Modeling, Star Schema, Snow Flake Schema, Dimensions and Fact tables.
  • Expertise knowledge on Talend Components.
  • Proficient knowledge on all Transformations of Informatica.
  • Experience in full cycle of Software Development including project planning, requirement analysis, design, development, testing, implementation, integration and deployment.
  • Experience in developing back end programs on various databases including Oracle, DB2, Sybase and MS SQL Server.
  • Expertise in writing, testing and implementation of the triggers, stored procedures, functions and packages at database level using PL/SQL.
  • Understanding knowledge on Master Data Management (MDM), and BigQuery.
  • Hands on experience to manage Error Handling, Performance Tuning, Error Logging, clustering and High Availability in Talend
  • Hands on experience with all phases of Software Development Life Cycle (SDLC) and also have Exposure to Agile process and methodologies
  • Hands on experience in generating source to target mapping, validation, transformations, and business rules.
  • Hands on experience in using multi format files like XML, .CSV, .TXT and loading data from these files in to relational tables.
  • Strong work experience on Windows, UNIX, and Linux platforms.
  • Implementation of ETL engine using Java to handle Incremental Loads
  • Expertise in enhancements/bug fixes, performance tuning, troubleshooting, impact analysis, Unit testing, Integration Testing, UAT and research skills.
  • Good exposure in projects with the Onsite - Offshore model.
  • Tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date and worked on 50+ Complex jobs in recent times
  • Ability to articulate complex data problems and solutions.
  • Flexible to work in Agile SCRUM environment.
  • Team Player as well able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

ETL Tools: Talend Enterprise Edition for Big Data 6.2.1/5.6.2 , Informatica Power center 8.6/8.1/7.6

DW Tools: Erwin, ER/Studio, MS Visio

RDBMS: Oracle 10G/9i/8.x, MySQL, 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

Reporting Tools: Jasper Soft BI

PROFESSIONAL EXPERIENCE

Confidential, Southfield Michigan, MI

ETL Talend Developer

Responsibilities:

  • Effectively working on Business Requirement documents to Map client data fields with Database columns and prepare the Technical document to build Talend Job.
  • Building and maintaining Talend Job/SQL Programs for member & claims data.
  • Good understanding on HIPAA and PHI consent Rules for healthcare domain.
  • Creating Talend Components such as tMSSqlInput, trowGenereator, tHashOutput, t-Map, tJava and pulled all data fields from SQL database tables.
  • Designing Talend component within Job along with Joblet, setting up Database configuration and Project level configuration Contexts, Talend Artifact Repository for Talend Jobs.
  • Creating Multiple Reports through Talend such as Pipe delimitated file (.txt), Excel (.xlsx), formats and tables of BigQuery data transfer to Talend.
  • Publishing Talend job snapshot version each time to keep all Environments (Development, Staging, Prod/UAT, and Production) in Sink.
  • Creating Test Scripts and Test cases for QA team to load Nexus snapshot version into Talend Administration Center to get test Report output to End User.
  • Deploying Talend Jobs to Sonatype Nexus Repository manager and working with QA to run the Job process in Talend Administration Center.
  • Working with QA to drop report output files from Prod/UAT environment into client sFTP server and support any data related issues, File Format issues and solve them before moving into Production Environment.
  • Processing Inbound/Triage file from End users and pulling from client/End user sFTP server and loading into Talend Repository.
  • Migrating existing reports from SQL Server data warehouse to the new data warehouse using Talend 6 for Data Integrity on JAVA Platform.
  • Working on Agile Methodology and Sprint Planning for software development and JIRA system dashboard for issue tracking, Bug tracking and project management principles.
  • Supporting business users for any productions issues through Incident Tickets from Project Account Manager and End users.

Environment: Talend Enterprise 6.2.1, Sonatype Nexus, TAC (Talend Administration Center), winscp, Microsoft SQL Server 2012/2008r2, JIRA, Service Now, SVN Repository

Confidential, Dallas, Texas

Responsibilities:

  • Involved in Extraction, Transformation and Loading of data Using Talend Enterprise Edition for Big Data 5.6.2
  • 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.
  • Used the Informatica debugger to resolve the errors in the mappings.
  • Implemented code in Talend (Java Backend) and used over 100+ components to design Jobs.
  • Scheduled Talend jobs using Talend Administration Center.
  • Created couple of Templates on Error handling, Error Logging in Talend.
  • 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.
  • Setup sessions to extract data through FTP from remote Oracle and SQL Server data source files and implemented Slowly Changing Dimensions (Type 1 and Type 2).
  • Wrote test case scenarios and unit tested the code developed in Informatica and later on Migrated the code to Talend
  • 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 UNIX Shell scripts to run Informatica and Talend jobs.
  • Used debugger and breakpoints to view transformations output and debug mappings.
  • 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.
  • Involved in Production support and served as Technical Lead for a Team of Three.

Environment: Talend Enterprise Edition for Big Data 5.6.2, Informatica Power Center 8.6/9, Oracle 10g, SQL Server, ER/Studio, Toad and Windows XP, Unix, TOAD, SQL Developer

Confidential, Pleasanton, CA

Responsibilities:

  • Involved in analysis, Requirement collection and documentation of functional and 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
  • Extensively 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, performance tuning the existing mappings. Used the Informatica debugger to resolve the errors in the mappings.
  • Wrote SQL, PL/SQL, stored procedures, triggers and cursors for implementing business rules and transformations.
  • 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, San Roman, CA

Responsibilities:

  • Extensively used Informatica for extracting, transforming, loading from and to many databases.
  • Developed mappings, Mapplets, transformations, Workflows, sessions using ETL tool Informatica Power Centre Designer to transform and populate Data Warehouse target tables from multiple sources and load them into Oracle, MS SQL Server target tables.
  • Worked with the business users to get the business rule modifications in development and testing phases and analyzed claims data through rigorous evaluation methodology.
  • Wrote PL/SQL, stored procedures & triggers for implementing business rules and transformations.
  • Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, 20+ Transformations, Informatica Repository Manager and Informatica Server Manager.
  • Used Perl scripts to execute the pre-session and post-session commands and to run the sessions.
  • Worked on Data Cleansing Processes.
  • Used UNIX shell scripts for running Informatica mappings.
  • Documented the Informatica Mappings and workflow process, error handling of ETL procedures
  • Drawn ER Model diagrams by using Erwin.
  • Extensively worked on Performance Tuning using various components like parameter files, variables and dynamic cache.
  • Interacted with Users for analyzing various Reports.
  • Verify the logs to confirm all the relevant jobs are completed successfully and timely and involved in production support to resolve the production issues.
  • Gained familiarity with IMS Health data, NDC data and other standard information sources.

Environment: Informatica Power center 8.1/8.6, Microsoft SQL Server 7, Microsoft DTS, SQL, Sybase, Oracle10g, Data Junction, Erwin 4.0 and UNIX.

Confidential

Responsibilities:

  • Worked with applications Wells, Land, Reservoir, Tax, and General Ledger
  • Worked with business analysts and clients in gathering the requirements for data warehouse and document business needs for decision support for data.
  • Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center.
  • Developed various Mappings with the collection of all Sources, Targets, and Transformations.
  • Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings.
  • Created reusable transformations and Mapplets using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer respectively.
  • The tables had to be populated for use in daily load for the initial load ‘inserts’ and then updated using incremental loads and update strategy transformation.
  • Extensive experience in developing logical and physical models & implementing them in Erwin.
  • Worked Extensively with Slowly Changing Dimensions i.e. Type1 & Type2.
  • Worked on Version Control in Informatica to maintain multiple versions of an object, control development on the object and track changes.
  • Worked on migrating of Databases from SQL Server to Oracle database.
  • Written SQL overrides in source qualifier according to the business requirements.
  • Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from the database.
  • Tuning of SQL queries for better performance.
  • Involved in Development, Testing and Production support.

Environment: Informatica Power Center 7.6, SQL Server 2005, DB2, Oracle 10g, Erwin4.0, TOAD, SQL Plus and Windows XP.

Hire Now