We provide IT Staff Augmentation Services!

Sr. Etl Informatica Developer Resume

0/5 (Submit Your Rating)

Parsippany, NJ

PROFESSIONAL SUMMARY:

  • Eight plus (8+) years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Healthcare, Insurance, Financial and Telecom Sectors.
  • Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, ERP, BI, Client/Server applications.
  • Strong Data Warehousing ETL experience of using Informatica 10.1.1/9.5/9.1/8.6.1/8.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
  • Extensively worked on Informatica Data Quality(IDQ) and Informatica Power center throughout complete Data Quality projects
  • Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
  • Used PowerExchange to import the JD Edwards EnterpriseOne source definitions to read the data.
  • Used Informatica BDM 10.1.1 (Big Data MAnagement): To inject the data from AWS S3 raw to S3 refine.
  • Have done Requirements gathering, Design, Development, Implementation, Migration, Testing for various ETL implementations using Informatica. Worked extensively and designed ETL solutions using sources like Oracle ERP R12, JD Edwards, Siebel ERP
  • Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
  • Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2012/2008/2005 , DB2 8.0/7.0 and Teradata. Have a clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
  • Loading data from various data sources and legacy systems into Teradata production warehouse using utilitiesBTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD.
  • Experience in writing, testing and implementation of thePL/SQL triggers, stored procedures, functions, packages.
  • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
  • Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
  • Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
  • Experience in using Automation Scheduling tools like Active Batch and Redwood.
  • Worked extensively with slowly changing dimensions.
  • Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
  • Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

Operating Systems: Windows 10, 8, 7, XP, UNIX.

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.5/8.1/7.1 , PowerExchange 9.6.1

Database Tools: SQL Server 2016/ 2012/2008/2005 , Teradata 13/12/V2R5, Oracle 11g, 10g, Oracle Exadata/11g/10g/9i, ERP,MS-Access, DB2 8.0/7.0, Sybase.

Data Modeling Tools: Erwin, MS Visio

OLAP Tools: Cognos 8.0/8.1/8.2/8.4/7.0/ , Business Objects XI r2/6.x/5.x, OBIEE 10.1.3.4/ 10.1.3.3

Languages: Java, C++, Visual Basic.Net, JavaScript, HTML, SQL, HTML5, Adobe Illustrator, InDesign, SharePoint.

Web/Apps Servers: IBM Web Sphere, Sun iPlanetServer, IIS, Tomcat

Methodologies Tools: Waterfall, Agile and Scrum methodologies

Testing Tools: JIRA, HP ALM 11.5, HP Quality Center 9.0/9.2/10.0

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany NJ

Sr. ETL Informatica Developer

Responsibilities:

  • Involved in gathering and analysis requirement and writing ADD (Application Design Document) and indentified the data sources and targets.
  • Used PowerExchange to import the Source tables from different sources like Adobe Campaign (Ms Sql), ECM(Oracle) and EDW.
  • Designed the template for STTM (Source to Target Mapping Documents) for CDC and IDL.
  • Designed the one threat of the Mapping which we used in the scope for audit columns for CDC and IDL.
  • Designed the mapping Template in the MAV(Mapping architect for Visio) by using Informatica Stencils.
  • Used the mapping template Wizard and generated multiple mappings at a time in PowerCenter for CDC and IDL.
  • Designed the STTM documents for AC, ECM, EDW for CDC and IDL
  • Extracted data from various source systems like Oracle, SQLServer and loaded into Landing Zone and then by using copy command loaded in the raw zone.
  • Data Integration: JD Edwards EnterpriseOne to read data from sources and writen data to targets
  • Hard code parameterized the sessions and Worklows and used output file as a command with timestamp.csv.
  • Unit Tested: AC, ECM, EDW and designed the UT document for further consideration.
  • Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
  • Imported Hive Source in Informatica BDM and Did Insert,Update and Delete Pocs.
  • Did POCs on Informtica 10.1.1 BMD for the source delta processing and for the cleansing the data from S3 Raw to S3 refine.
  • Did POCs Insert,Update,Delete and how to slices the large files and load into Redshift by using Informatica BDM
  • Configured a session for a JD Edwards World source in a mapping and In the Task Developer, created a new session and associated with the mapping and defined the JD Edwards World application connection before to run a workflow from the Workflow Manager.
  • Debugged and resolved load failures by verifying the log files. Supported QA Testing in fixing the bugs and also helped to resolve various data issues.
  • Maintained a very good interaction with analysts, Project Managers, architects and testers to have efficient and better results.
  • Used SQL tools like SSMS to run SQL queries against the AC and validated the data.
  • Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Warehouse.
  • Provided 24x7 production supports for business users and documented problems and solutions for running the workflows.

Environment: Informatica BDM 10.1.1, Power Center 9.6.1, Informatica Power Exchange 9.6.1HF3, AWS,S3, Redshift, Oracle 11g, MS SQL Server, AC, ECM,EDW, Flat Files, JD Edwards, ERP,XML, UNIX Shell Scripting, Windows 7/10,AS-400, MAV, MS Office (Word, Excel, Powerpoint).

Confidential, Irving, TX

Sr. ETL Informatica Developer

Responsibilities:

  • Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
  • Created Design Specification Documents including source to target mappings.
  • Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target.
  • Extracted data from various source systems like Oracle, SQLServer, XML and flat files and loaded into relational data warehouse and flat files.
  • Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and more.
  • Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
  • Modified the existing worklets and workflows to accommodate for these new sessions and mappings. Created the break points in the designer and worked with debugger.
  • Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
  • Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
  • Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings

Environment: Informatica Power Center 9.5, Oracle 11g, MS SQL Server, TOAD, PL/SQL,SQL,Oracle Exadata, Flat Files, XML, UNIX Shell Scripting, Windows 7/8, MS Office (Word, Excel, Powerpoint).

Confidential, Bloomington, IL

Sr. ETL Informatica Developer

Responsibilities:

  • Interacted with business analysts and translate business requirements into technical specifications.
  • Using Informatica Designer, developed mappings, which populated the data into the target.
  • Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the mapping designer to map the sources to the targets.
  • Responsibilities included designing and developing complex informatica mappings including Type-II slowly changing dimensions.
  • Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks, shell scripts.
  • Developed complex mappings/sessions using Informatica Power Center for data loading.
  • Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval.
  • Extensively used aggregators, lookup, update strategy, router and joiner transformations.
  • Developed the control files to load various sales data into the system via SQL*Loader.
  • Extensively used TOAD to analyze data and fix errors and develop.
  • Involved in the design, development and testing of the PL/SQL Analyzed the requirements and framed the business logic for the ETL process.
  • Solid skills to configure Exadata to meet company internal security requirement.
  • Involved in the ETL design and its documentation.
  • Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using ER-STUDIO.
  • Followed Star Schema to design dimension and fact tables.
  • Experienced in handling slowly changing dimensions.
  • Collect and link metadata from diverse sources, including relational databases Oracle, XML and flat files.
  • Responsible for the development, implementation and support of the databases.
  • Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
  • Developed reusable Mapplets and Transformations.
  • Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes
  • Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
  • Scheduled the tasks using Autosys.
  • Loaded the flat files data using Informatica to the staging area.
  • Created SHELL SCRIPTS for generic use.
  • Created high level design documents, technical specifications, coding, unit testing and resolved the defects using Quality Center 10.
  • Developed unit/assembly test cases and UNIX shell scripts to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort.

Environment: InformaticaPowercenter 9.1, UNIX, Teradata V-14, Oracle 11g, SQL, PL/SQL, ER-win, Oracle Designer, MS VISIO, Oracle Exadata, Autosys, Korn Shell, Quality Center 10,Windows 7/8, MS Office (Word, Excel, Powerpoint).

Confidential, Houston, TX

Informatica Developer

Responsibilities:

  • Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
  • Using InformaticaPowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
  • Using InformaticaPowerCenter created mappings and mapplets to transform the data according to the business rules.
  • Involved in analyzing different modules offacetssystem andEDIinterfaces to understand the source system and source data.
  • Worked closely withFacets 4.48, 4.51and differentEDI transaction filelike837,834, 835, 270, 271 to understand the source structure and the source data pattern.
  • Used various transformations like Source Qualifier, Joiner, Lookup, sql,router, Filter, Expression and Update Strategy.
  • Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
  • Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
  • Documented Informatica mappings in Excel spread sheet.
  • Tuned the Informatica mappings for optimal load performance.
  • Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
  • Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
  • Have generated reports using OBIEE 10.1.3 for the future business utilities.
  • This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
  • Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
  • Constantly interacted with business users to discuss requirements.

Environment: Informatica PowerCenter Designer 8.6.1, Informatica Repository Manager, Oracle10g/9i,DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H,Unix- SunOS, PL/SQL,WindowsXP/7, MS Office (Word, Excel, Powerpoint).

Confidential

Informatica developer

Responsibilities:

  • Providing technical solutions to different problems of clients by taking help of different tools.
  • Experience in developing mapping in designer, workflow manager and monitor in Informatica 9.1.
  • Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
  • Ensure that the call comments are properly arranged and suitable information is provided to clients.
  • The standard of each call should be properly maintained in a comprehensive manner taking into view each aspect of attending the customer, listening to their problems and offer appropriate solutions to them.
  • Technical support and responsible for working with computer hardware and software for resolving the troubles that may arise within an organization.

Environment: Informatica 8.1, Oracle 10g, SQL Server 2005, Windows XP/7, MS Office (Word, Excel, Powerpoint).

We'd love your feedback!