We provide IT Staff Augmentation Services!

Talend Developer Resume

2.00/5 (Submit Your Rating)

Dallas, TX

SUMMARY

  • 8+ years of extensive experience in Information Technology wif special emphasis on Master Data Management(MDM), Data Warehousing and ETL process using Talend, Informatica Power Center9.x/8.x/7.x/6.x and Data stage
  • Expertise in Master Data Management concepts, Methodologies and ability to apply this noledge in building MDM solutions
  • Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor.
  • 3+ Years of experience on Talend Data Integration, Master Data Management & Data Quality
  • Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
  • Successfully managed in setting up teh data and configured teh components needed by Hierarchy Manager for MDM HUB implementation which included in implementing hierarchies, relationships types, packages and profiles by using hierarchies’ tool in model workbench.
  • Extensively used ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and loading using Talend/SSIS and designed data conversions from wide variety of source systems
  • Experience in designing and developing complex Talend/Data Stage jobs, routines.
  • Created complex mappings in Talend using components like tMap, tJoin, tReplicate, tParallelize etc., and have created various complex jobs.
  • Manage Error Handling, Performance Tuning, Error Logging, clustering and High Availability in Talend
  • Experience as working wif various Relational Databases (RDBMS): Oracle, MySQL, SQL Server, Complex Flat Files, Datasets, XML and Flat files.
  • Experience in creating Ab Initio (or Datastage, Informatica or Talend) projects and sandboxes in lower life cycle environments, experience in configuration and support of multiple test environments.
  • Strong Knowledge on Data Warehousing Basics and relational database management Systems and Dimensional modeling (Star schema and Snowflake schema).
  • Good understanding of Data warehouse concepts and principles, Kimball & Star & Snowflake Schema, Fact/Dimension tables, Normalization/De normalization
  • Excellent Experience on various Python integrated IDE's such as Sublime Text, Pycharm, Eclipse, NetBeans
  • Experience on Python scripts to parse XML documents and load teh data in database
  • Hands on experience in writing, testing and implementation of teh triggers, procedures, functions at Database level using PL/SQL.
  • Implemented Slowly Changing Dimension phenomenon while building Data Warehouses.
  • Implemented Error Logging, Error Recovery, and Performance Enhancement’s & created Audit Process (generic) for various Application teams.
  • Deep understanding of OLTP, OLAP and data warehousing environment and tuning both kind of systems for peak performance.
  • Knowledge in Using Amazon Elastic Beanstalk wif Amazon EC2 to deploy project into AWS
  • Worked in designing and developing teh Logical and physical model using Data modeling tool (ERWIN).
  • Experience wif various Data Stage packages that includes XML and Web Services.
  • Experience in working wif parallel extender for splitting bulk data into subsets to distribute teh data to all available processors to achieve best job performance.
  • Good noledge on utilizing various Teradata Tools
  • Extensively writing Teradata Coding wif multiple SQL statement scenarios in Dev and Prod Environment.
  • Written stored procedures to insert and clean data into teh data warehouse tables, fired triggers upon completion of load to obtain teh log of all teh tables loaded wif job name and load date.
  • Worked on UNIX shell scripts using Kshell for teh Scheduling sessions, automation of processes, pre - and post-session scripts.
  • Excellent work experience in AGILE methodology and development.
  • Committed to excellence, self-motivator, fast-learner, team-player, and a prudent developer wif strong problem-solving skills and communication skills
  • Ability to learn and use new systems and paradigms in considerably less time, Solid communicator wif exceptional team-building skills.

TECHNICAL SKILLS

Languages: C, JAVA, SQL, PL/SQL, UNIX Shell Programming,Python

Data Warehousing: Talend, Informatica, Data Stage. Power Exchange, ERWIN, Master Data Management (MDM)

Databases: ORACLE 8i/9i/10g/11g, Teradata, SQL SERVER 6.5/7.0, MYSQL, Sybase 11.1

Operating Systems: Windows, Linux, Unix

Scheduling Tools: Autosys, Control M, Job conductor (Talend)

Testing Tools: QTP, Quality Center.

Operating Systems: UNIX, Linux, Windows

Defect Tracking Tools: Jira

Domain Knowledge: Financial, Banking and Healthcare

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Talend Developer

Responsibilities:

  • Involved in Reviewing teh project scope, requirements, architecture diagram, proof of concept (POC) design and development guidelines onTalend.
  • Reviewed/Prepared teh technical design documents (TDD) and source to target mappings are created as per requirements meet
  • Wrote Python scripts to parse JSON documents and load teh data in database.
  • Used Python and Django to interface wif teh jQuery UI and manage teh storage and deletion of content.
  • Developed and tested many features for dashboard using Python, Java, Bootstrap, CSS, JavaScript and JQuery.
  • Designed and Implemented ETL for data load from heterogeneous Sources to SQL Server and Oracle as target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2 to capture teh changes
  • Developed Mapping to pull data from Source, apply transformations, and load data into target database.
  • Involved in various projects such as Data Migration, Data warehousing & Automation Projects.
  • Involved in data extraction from various sources like relational database & Flat Files and Load them in EDW.
  • Extensively Used tMap component which does lookup & Joiner Functions, tjava, tOracle, txml, tdelimtedfiles, tlogrow, tlogback components etc. in many of my Jobs Created and worked on over 100+ components to use in my jobs.
  • Worked Extensively onTalendAdminConsole & Schedule Jobs in Job Conductor, this option is not available inTalendOpen Studio.
  • Mainly Involved in Performance Tuning ofTalendJobs.
  • Hands on Experience on many components which are there in teh palette to design Jobs & used Context Variables to ParameterizeTalendJobs.
  • Hands on Experience in creating Generic schemas, Context Groups and Variables to run jobs against different environments like Dev, Test and Prod.
  • DesignedTalendJobs and Created Jobs for Audit Process, Exception Handling framework.
  • Worked wif Microsoft SQL Server management Studio/TOAD while Implementing Unit Testing.
  • Worked wif Parallel connectors for Parallel Processing to improve job performance while working wif bulk data sources inTalend.
  • Scheduling teh ETL Jobs on daily, weekly, monthly and yearly basis.
  • Experience in Agile methodology.

Environment: TalendEnterprise for Big Data (V6.0.1, 5.6.2/5.6.1 ), UNIX, Microsoft SQL Server management Studio.

Confidential, San Francisco, CA

Talend Developer

Responsibilities:

  • Reviewed/Prepared teh technical design documents (TDD) and source to target mappings are created as per requirements meet
  • Designed and Developed ETL process using Talend Open Studio (Data Integration) & Even Worked on Enterprise Latest Version’s
  • Design and Implement ETL to data load from Source to target databases and for Fact and Slowly Changing Dimensions (SCD) Type1, Type 2 to capture teh changes
  • Designed and Developed ETL process using Talend Platform for Big data & Even Worked on Developed ETL mappings for Staging, Dimensions, Facts and Data marts load
  • Involved in Data Extraction for various Databases & Files using Talend Open Studio & Big Data Edition
  • Worked on Talend wif Java as Backend Language.
  • Extensively Used tmap component which does lookup & Joiner Functions
  • Worked on Joblets which is used for reusable code.
  • Wrote backup and recovery shell scripts to provide failover capabilities
  • Worked Extensively on Talend Admin Console & Schedule Jobs in Job Conductors, this option is not available in Talend Open Studio.
  • Mainly Involved in Performance Tuning of Existing Jobs and created Audit Process & Error Capturing methodology for various app teams.
  • Hands of Experience on many components which are there in teh palette to design Jobs & used Context Variables/Groups to Parameterize Talend Jobs.
  • Implemented Error Logging, Error Recovery, and Performance Enhancement’s & created Audit Process (generic) for various Application teams.
  • Worked Extensively on Talend Admin Console & Schedule Jobs in Job Conductors, this option is not available in Talend Open Studio.
  • Developed teh Pig UDF'S to pre-process teh data for analysis.
  • Worked wif Microsoft SQL Server management Studio/TOAD while Implementing Unit Testing.
  • Experience in using Repository Manager for Migration of Source code from Lower to higher environments.
  • Created Projects in TAC and Assign appropriate roles to Developers and integrated SVN (Subversion)
  • Worked on Custom Component Design and used to have embedded in Talend Studio
  • Used to be on call Support if teh Project is deployed to further Phases
  • Used Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis (Cron Trigger)

Environment: Talend Platform for Big Data 5.6.2, TOS (Talend Open Studio) for Data Integration 5.6.2, Enterprise Platform for Data management (V5.5.1, 5.6.1/5.6.2 ), UNIX, Oracle, Microsoft SQL Server management Studio, WINDOWS

Confidential, Novi, MI

Informatica Developer

Responsibilities:

  • Understanding functional specifications and documenting technical design documents.
  • Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
  • Analyzed teh functional specs provided by teh data architect and created technical specs documents for all teh mappings.
  • Document or review documentation of steps in specification development, coding, testing and user acceptance for future reference and for internal control purposes.
  • Using teh Informatica and some Ab Initio development tool and SQL, support a large enterprise data warehouse used for statistical modeling.
  • Developed slowly changing dimension Type 2 mappings to maintain teh history of teh data.
  • Developing several mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables and Parameter files in Mapping Designer.
  • Created reusable transformations and mapplets and used them in mappings.
  • Used Informatica debugging techniques to debug teh mappings and used session log files and bad files to trace errors that occur while loading.
  • Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh mappings.
  • Implemented performance tuning logic on Sources, Targets, mappings, and sessions to provide maximum efficiency.
  • Develop test plan and/or test application in development status or debug application in production mode.
  • Used Informatica Version Control for checking in all versions of teh objects used in creating teh mappings and workflows and to keep track of teh changes in teh development, testing and production environments.
  • Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
  • Created Workflows wif worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
  • Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained teh batch processes using Unix Shell Scripts.

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL Server, Windows NT, Unix Shell Scripts.

Confidential

Data stage Developer

Responsibilities:

  • Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained teh batch processes using Unix Shell Scripts.
  • Used Python based GUI components for teh front-end functionality such as selection criteria
  • Cleaned data and processed third party spending data into maneuverable deliverables wifin specific formats wif Excel macros and python libraries.
  • Developed views and templates wif Python and Django's view controller and templating language to create a user-friendly website interface.
  • Involved in meetings to gather information and requirements from teh clients.
  • Used teh Data Stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
  • Involved in Designing teh ETL process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
  • Used teh Data Stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
  • Gathered information from different data warehouse systems and loaded into Database using Fast Load, Fast Export, Multi Load, Bteq and UNIX shell scripts.
  • Used teh Ascential Datastage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
  • Worked in teh areas of relational database logical design, physical design, and performance tuning of teh RDBMS.
  • Worked extensively on diverse types of stages like Sequential file, ODBC, Hashed File, Aggregator, Transformer, Merge, Join, Lookup and for developing jobs.
  • Create master controlling sequencer jobs using teh Datastage Job Sequencer.
  • Effectively used Datastage Manager to Import/Export projects from development server to production server.
  • Written K Shell Scripts for getting data from systems to Data Warehousing system.
  • Extensively used ETL to load data from Oracle 10g, XML files and Complex Flat files.
  • Responsible for trouble shooting, identifying and resolving data problems, worked wif analysts to determine data requirements and identify data sources, provide estimates for task duration.
  • Created Fast Load, Fast Export, Multi Load, Tpump, BTEQ scripts for Target Database.
  • Used teh Datastage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions (on an ad hoc or scheduled basis).
  • Scheduled jobs dependencies using Control-M Scheduler.
  • Implemented Unit, Functionality, and Performance on Mappings and created Testing Documents.
  • Involved in unit testing, systems testing, integrated testing and user acceptance testing.

Environment: Ascential Datastage 7.5.1 (Manager, Designer, Director), Teradata V2R6, Tools & Utilities (BTEQ, Fast Export, Multi Load, Fast load, TPUMP), PL/SQL, Oracle 10g, Windows 2000/NT, Unix, Control-M Scheduling.

We'd love your feedback!