We provide IT Staff Augmentation Services!

Informatica/talend Developer Resume

St Louis, MO

SUMMARY

  • IT experience in Data Warehouse Design, Analysis, Development, Testing and Maintenance.
  • Expertise in entire life cycle of DWH - Analysis, requirements gathering, ETL Design, development, Unit testing and production support.
  • Strong ETL experience of using Informatica 10.2.0/10.1.1 /9.6.1/8.6 Power Center Client tools - Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer, Repository manager, Workflow Manager/Monitor.
  • Worked in Data Ingestion project to inject data into Data Lake using multiple sources systems using Talend Bigdata.
  • Experienced in scheduling Talend jobs using Talend Administration Console (TAC).
  • Developed complex mappings using Informatica Power Center Transformations - Lookup Unconnected, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Java, and Sequence Generator.
  • Having strong hands on experience in extraction of the data from various source systems like DB2, Oracle, Teradata, Flat Files, and XML.
  • Experience in both ETL Informatica & Database Sql Performance Tuning.
  • Experience in working with Teradata Utilities like TPT to improve the loading performance.
  • Experience in writing BTEQ scripts also tuning them for performance issues.
  • Experience in writing the SQL, PL/SQL stored procedures to meet the business requirements and the transformations.
  • Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Experience in developing Stored Procedures, Packages, Functions, Views and Triggers, Complex SQL queries.
  • Proficiency in data warehousing techniques for Change Data Capture, Data Cleansing, Slowly changing dimensions types (1 and 2).
  • Good experience in doing Unit testing & working with QA team for QA Testing also experience in working with ETL Admin team for informatica higher environment Testing, Migrations & Deployments.
  • Good experience with both Waterfall & Agile (Scrum Process) implementations.
  • Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.

TECHNICAL SKILLS

Tools: and Utilities: Informatica Power Center 10.2.0/10.1.1 /9.6.1/8.6 , Talend Studio 7.1.1

Databases: Oracle 11g/10g, Teradata 14, SQL Server, DB2

File System: Flat Files, XML

Scheduling Tools: Tidal

Languages: SQL, PL/SQL, Teradata SQL, UNIX Shell

Operating Systems: Windows, Unix, Linux

Others: WinScp, Putty, Sql Assistant

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Informatica/Talend Developer

Responsibilities:

  • Involved in Requirement analysis in support of Data Warehousing efforts along with Business Analyst.
  • Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
  • Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations.
  • Extensively worked with various Passive transformations like Expression, Lookup and Sequence Generator.
  • Involved in creating Mapplets using Java Transformations for Decrypting the Encrypted data.
  • Worked with source databases like Oracle, SQL Server, XML and Flat Files.
  • Extensively worked with Teradata utilities like BTEQ & TPT to load data in to ware house.
  • Extensively Involved in Tuning Teradata scripts along with Oracle and Other source Queries for extraction.
  • Created Stored Procedures to map, transform and migrate data based on business requirements .
  • Involved in extracting data from client operational databases, transform, cleanse data, load it into staging area and then from stage to data warehouse.
  • Created complex mappings using Unconnected and Connected lookup Transformations.
  • Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
  • Implemented Slowly changing dimension Type 1 and Type 2 for change data capture.
  • Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache.
  • Worked extensively with update strategy transformation for implementing inserts and updates.
  • Experience in writing DMR’s for Production issues.
  • Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre session commands.
  • Extensively used debugger to test the logic implemented in the mappings.
  • Performed error handing using session logs.
  • Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval.
  • Involved in production support when required.
  • Monitored workflows and session using Power Center workflows monitor.
  • Used Informatica Scheduler along with Tidal for scheduling the workflows.
  • Involved in creating the jobs in Tidal Scheduler tool.
  • Extensively used Talend Administrator Console (TAC) for running the jobs on different servers by passing various context parameters.
  • Have the knowledge on scheduling jobs on TAC.

Environment: Informatica Power Center 10.2.0/10.1.1 , Talend 7.1 Oracle, Sql server, My Sql, PL/SQL, Flat Files, Teradata 15/14, Tidal, SQL Assistant, Unix, Windows.

Confidential

ETL Developer

Responsibilities:

  • Involved in Project Analysis and documenting the development requirements.
  • Worked with ETL Architects, Data Modelers & Business Analysts.
  • Designed and developed database views and stored procedures, Packages and Functions.
  • Used SQL to extract the data from the database and also using views on the tables.
  • Worked with Development Life Cycle in performing the Data Movement.
  • Wrote stored procedures, functions &Packages.
  • Involved in the creation of Mapping for various requirements using Informatica 9.6.1 and used Informatica Workflow Manager for configuring mappings also validated schedule run and monitor jobs using Workflow Monitor.
  • Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.
  • Developed SQL Applications for extracting the data from the Oracle tables.
  • Created detailed system design specifications to serve as a guide for system and the program development.

Environment: Informatica Power Center 9.6.1, Oracle, SQL, UNIX, Windows.

Confidential

Jr.ETL Developer

Responsibilities:

  • Involved in Project Analysis and documenting the dev requirements.
  • Worked with Data Modelers & Business Analysts.
  • Designed and developed database views and stored procedures, Packages and Functions.
  • Used SQL to extract the data from the database and also using views on the tables.
  • Worked with Development Life Cycle in performing the Data Movement.
  • Wrote stored procedures, functions &Packages.
  • Involved in the creation of Mapping for various requirements using Informatica 8.6 and used Informatica Workflow Manager for configuring mappings also validated schedule run and monitor jobs using Workflow Monitor.
  • Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.
  • Developed SQL Applications for extracting the data from the Oracle tables.
  • Created detailed system design specifications to serve as a guide for system and the program development.

Environment: Informatica Power Center 8.6, Oracle, SQL, PL/SQL, UNIX.

Hire Now