We provide IT Staff Augmentation Services!

Sr. Etl Informatica Developer Resume

4.00/5 (Submit Your Rating)

New York, NY

PROFESSIONAL SUMMARY:

  • Over 9 + years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Application Development, Implementation and Testing of Applications in Data warehousing with business knowledge of Healthcare, Financial, Insurance domains.
  • Good working experience in SDLC (Software Development Life Cycle) methodologies like waterfall, Agile.
  • Experience in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center 9.x/8.6, Power Exchange and Informatic Data Transformation(B2B), Informatica MDM, IDQ
  • Experience in Installation and Configuration of Informatica Client and Repository.
  • Expertise in RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL
  • Extensively worked Different Database Oracle, SQLServer, SYBASE
  • Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
  • Experience in Interacting with Business Users to gather Business Requirement Specifications Document and Prepare System Requirement Specifications document.
  • Extensively worked on Data extraction, transformation, loading with Oracle, SQL Server 2012, Sybase using Informatica.
  • Having hands on Experience in B2B DataTranformtion for converting EDI (X12) to XML
  • Having hands on Experience in MDM Tool IBM Initiate inspector
  • Having good Experience on Scheduler Tool Dollar universe, Control - M, Tidal
  • Experienced with Data Extraction, Transformation and Loading(ETL) from disparate Data Source databases like Oracle, SQL Server, flat files, CSV files, EDI, XSD and XML files and loaded into target warehouse by using various transformations in Informatica.
  • Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the Session logs.
  • Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions and experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplet.
  • Good experience with Informatica Performance Tuning.
  • Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, Slowly Changing Dimensions.
  • Extensive experience in onshore/offshore work model, being on both fronts.
  • Having knowledge on Informatica IDQ
  • Having knowledge on Big Data.
  • Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
  • Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/9.1/8.6.1/ 8.1.1

Utilities: Power Exchange, Informatica Data Transformation(B2B), Informatica IDQ

Data Modeling: Dimensional Data Modeling, using Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Databases: Oracle 11g/10g, SQL Server

Scripting: Unix Shell scripting, SQL stored procedures

Scheduler Tools: Dollar Universe, Control -M, Tidel

MDM Tool: IBM Initiate inspector

DB tools: SQL / PL SQL, TOAD, Oracle Developer

Operating System: UNIX (AIX, Sun), Windows

Agile Tools: Version One, Trello

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. ETL Informatica Developer

Responsibilities:

  • Interaction with clients and SME’s for status updates on tasks and requirements gathering for new requirements on daily basis
  • Understanding the Business Requirements and Develop an ETL process to load data from source to target.
  • Extensively used Informatica power Centre loading the data from sources involving sources like Oracle, Sql server, Sybase
  • Created ETL mappings for various layer of data loads like Staging and Landing
  • Developed and scheduled Workflows using task developer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
  • Reviewed the mappings, mapplets, sessions and workflows and workletes for ETL standards.
  • Involved in review of detailed Design document, Data Element sheet, UTC & Unit Testing of Code.
  • Prepared Unit Test/ Assembly Test cases and executed unit test scripts successfully
  • Created the Sample Files for SIT and Tested in SIT Environment.
  • Involved in code Reviews as per ETL/Informatica standards and best practices.
  • Deployed the components from DEV to QA.
  • Created Turns for Code migration to QA.
  • Prepared One-shot scripts for abended jobs and deploy this code into production.
  • Maintained the Defect Tracking and fixed the Defects.
  • Assigned tasks to the offshore team.
  • Setting up and coordinating meeting with Offshore and business users. scheduled daily status and weekly status meetings with offshore and client.

Environment: Informatica power Center 9.6, Oracle11g, SqlServer, Sybase, UNIX (AIX), SQL.Oracle Developer, Rapid SQL.

Confidential, Louisville, Kentucky

Sr. ETL Informatica Developer

Responsibilities:

  • Interaction with client for status updates on tasks and requirements gathering for new requirements
  • Understanding the Business Requirements and Develop an ETL process to load data from source to target.
  • Extensively used Informatica power Centre loading the data from sources involving sources like Oracle, Sql server, flat files, XML and loaded into DWH.
  • Created ETL mappings for various layer of data loads like Staging, DWH.
  • Developed and scheduled Workflows using task developer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
  • Monitoring ETL loads using Dollar universe
  • Reviewed the mappings, mapplets, sessions and workflows for ETL standards.
  • Involved in review of detailed Design document, RDT, Data Element sheet, UTC & Unit Testing of Code.
  • Prepared Unit Test/ Assembly Test cases and executed unit test scripts successfully
  • Created the Sample Files for SIT and Tested in SIT Environment.
  • Supported during QA/UAT/PROD deployments and bug fixes.
  • Involved in code Reviews as per ETL/Informatica standards and best practices.
  • Created Turns for Code migration to QA and Prod.
  • Resolved process abends, change orders, Incidents.
  • Prepared One-shot scripts for abended jobs and deploy this code into production.
  • Maintained the Defect Tracking and fixed the Defects.
  • Assigned tasks to the offshore team.
  • Setting up and coordinating meeting with Offshore and business users.
  • Provide end to end Knowledge Transfer to Offshore team. scheduled daily status and weekly status meetings with offshore and client.

Environment: Informatica power Center 9.5, Flat files, XML, UNIX (AIX), SQL, PL/SQL, Mainframe, Oracle 11g, Toad, Dollar universe, Informatica MDM

Confidential, Cedar rapids, Iowa

Sr. ETL Informatica Developer

Responsibilities:

  • Proficient in understanding business processes/requirements and translating them into technical requirements
  • Understanding the Business Requirements and Develop an ETL process to load data from source to target.
  • Created the Source and Target XSD based on requirements.
  • Created ETL mappings using Informatica Power Center to move Data from sources like XSD, XML, loaded into XML, Oracle, SqlServer.
  • Created ETL mappings and mapplets for various layer of data loads like Staging, DWH, DataMart.
  • Reviewed the mappings, mapplets, sessions and workflows for ETL standards.
  • Involved in review of detailed Design document, RDT, UTC & Unit Testing of Code.
  • Prepared Unit Test/ Assembly Test cases and executed unit test scripts successfully
  • Created the XML Files for SIT and Tested in SIT Environment.
  • Supported during QA/UAT/PROD deployments and bug fixes.
  • Involved in code Reviews as per ETL/Informatica standards.
  • Monitoring ETL loads using Control-M
  • Used PMCMD, and UNIX shell scripts for workflow automation.
  • Parameterized the mappings and increased the re-usability
  • Created and defined DDL’s for the tables at staging area.
  • Used code debugging at mapping level and did enhancements.
  • Created label, Queries and Deployment groups for Migration to QA.
  • Created Turns for Code migration to QA.
  • Maintained the Defect Tracking and fixed the Defects.
  • Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
  • Setting up and coordinating meeting with Offshore and business users.
  • Provide end to end Knowledge Transfer to Offshore team. scheduled daily status and weekly status meetings with offshore and client.
  • Provide end to end Knowledge Transfer to Offshore team.

Environment: Informatica Power Center 9.5, Oracle 11g, Sql Server, UNIX (AIX), Windows XP, TOAD, Unix Shell script, Business objects. Flat files, XSD, XML, Informatica MDM

Confidential, Louisville, Kentucky

Sr. ETL Informatica Developer

Responsibilities:

  • Interaction with client for status updates on tasks and requirements gathering for new enhancements
  • Understanding the Business Requirements and Develop an ETL process to load data from source to target.
  • Created the Source and Target XSD based on requirements.
  • Created ETL mappings using Informatica Power Center to move Data from sources like XSD, XML, loaded into XML.
  • Reviewed the mappings, sessions and workflows for ETL standards.
  • Identify the bugs in existing mapping by analyzing the data flow.
  • Responsible for writing unit test cases and performing unit testing.
  • Created the XML Files for SIT and Tested in SIT Environment.
  • Created the UProcs, Session, Task in $Universe Scheduler Tool.
  • Scheduled the Informatica jobs by using $Universe in DEV and QA.
  • Migration between Development, Test and Production Repositories
  • Maintained the Defect Tracking and fixed the Defects.
  • Monitored the workflows.

Environment: Informatica power Center 9.1,Flat files, XML, UNIX, Version One, Unix Shell Script, Windows XP, IBM Initiate inspector

Confidential, Albany, NY

ETL Informatica Developer

Responsibilities:

  • Interacting with the onsite coordinators for getting business requirements on daily basis
  • Preparing Mapping spec based on Implementation Guide and Companion Guide
  • Used B2B Informatica DT for converting EDI x12 files to XML files.
  • Created ETL mappings using Informatica Power Center to move Data from multiple sources like EDI834, XSD, XML, Oracle loaded into Transactional Database
  • Used Unstructured Data Transformation in PWC to call B2B and generate EDI, XML files
  • Understanding existing Unix scripts and modified based on business requirements
  • Executing the Workflows and test the jobs.
  • Reviewing the mappings.
  • Identify the bugs in existing mapping by analyzing the data flow.
  • Defect tracking.
  • Responsible for unit test and assisted QA team.
  • Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables.
  • Preparing Minutes of Meeting with Client.

Environment: Informatica power Center 9.1, EDI, XML,Flat files, SQL, UNIX AIX, Informatica Data Transformation(B2B), Shell Script, FileZilla, Rational Team Connecter.

Confidential

ETL Informatica Developer

Responsibilities:

  • Understanding the Business Requirements and Develop an ETL process to load data from source to target.
  • Extensively used informatica power center for loading the data from sources involving flat files to target as relational table.
  • Mainly involved in ETL developing to Extract, Transform and Load the data into Target.
  • Creation of sessions for mapping and validate the session.
  • Created mappings in Data quality and imported in power center as a mapplet for Data quality.
  • Migration between Development, Test and Production Repositories.
  • Supported the Quality Assurance team in testing and validating the Informatica workflows.
  • Did unit testing and development testing at ETL level in my mappings.
  • Preparing Minutes of Meeting with Client.
  • Prepare the Design Document and review the documents.
  • Review the Test case documents and load to the QC

Environment: Informatica Power center 8.6, Informatica Data Quality, MQ series, Mainframe, Share point, UNIX, DB2

Confidential

Informatica Developer

Responsibilities:

  • Understanding the Business Requirements and Develop an ETL process to load data from source to target.
  • Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.
  • Imported various Application Sources, created Targets and Transformations using Informatica Power Center Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
  • Actively involved in gathering requirements from the end users
  • Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and sqlserver tables to target tables.
  • Worked with various transformations to solve the Slowly Changing Dimensional Problems using Informatica Power Center
  • Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
  • Did performance tuning at source, transformation, target, and workflow levels.
  • Parameterized the mappings and increased the re-usability
  • Used transformations such as the source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
  • Experience in using Debugger in Informatica Designer tool to test and fix errors in the mappings.

Environment: Informatica Power Center 8.1, UNIX, SQL Server, Oracle 10g, Toad, Putty, FileZilla.

Confidential

Informatica Developer

Responsibilities:

  • Designed and developed ETL mappings using various transformations.
  • Developed particular logic and transformation as per the requirement, created mappings and loaded the data into different targets.
  • Extracted the flat files data, Oracle Dimensional data using Informatica and loaded to the staging area.
  • Developed Informatica Mappings, lookups, reusable objects, Sessions as per the Business rules
  • Created Reusable Transformations and Mapplets, used them in Mappings to develop the business logic for transforming source data into target.
  • Created Workflows and Tasks to schedule the loads at required frequency using Workflow Manager.
  • Developed multiple Workflows using work flow manager for initial loading.
  • Optimized the performance of the mappings by optimizing sources, targets and transformations.
  • Involved in unit testing & preparing the unit test cases.
  • Assisted the team working on UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems, to schedule weekly and monthly loads/jobs

Environment: Informatica Power center 8.1, Mainframe, Share point UNIX, DB2, Oracle, SharePoint site, Windows XP.

We'd love your feedback!