We provide IT Staff Augmentation Services!

Informatica Developer Resume

SUMMARY:

  • To apply and improve upon the knowledge obtained in the academic and professional career, to the practical demands of the organization.
  • A dedicated ETL Informatica developer with 4.5+ Years of experience in BI & Manufacturing domain in Confidential .
  • Technologist with a focus on ETL with tool Informatica 8.1 and 9.1 and their implementation in Business Intelligence problems.
  • A results - oriented and diligent professional currently serving Business Intelligence Unit of Confidential with passion for resolving complex problems or business challenges through innovation.
  • Possess an analytical mind-set, fast-learning ability, independent problem-solving skills, troubleshooting expertise and versatility to resolve multifaceted issues despite the challenges of changing priorities.
  • Recognized for utilizing excellent communication and interpersonal skills at all hierarchies of the organization.

TECHNICAL SKILLS:

Primary Skill category: Informatica 8.1X9.x, Oracle SQL,Teradata

Project Acquired skills: Unix, Oracle SQL,PL-SQL

Trained Skills: RDBMS, SQL,PL-SQL, DW Concepts, Teradata

Linguistic Skills: English

Platforms Worked: Windows XP/Vista, UNIX

Database: Oracle 10g, Teradata

WORK EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

  • Gain in-depth understanding and extensively work on ETL Mappings and Logic developing using InformaticaTool.
  • Automate existing manual processes through informatica.
  • Handled production and developments issues, provided solutions for new and complex informatica requirements
  • Schedule the daily meetings with the Clients and onsite Coordinators contacting them and having interactions.
  • Continued thrust on maintaining the zero defect quality on client deliveries.
  • Smartly facilitate superior communication between the onsite and offshore team members.
  • Successfully conducting the Learning and Development activity across the Team on various Technical topics.

Confidential

ETL Developer

Responsibilities:

  • Involved in gathering information for various scenario for Change Data Capture.
  • Closely worked with DBA to set up the DEV and QA environment and various users and roles
  • Designed and developed mappings using various transformations in Designer to load data from Flat Files, Oracle 10g into the target Data warehouse.
  • Developed parameter file templates and used parameters, variables to make mappings more flexible, also developed shell scripts to automate the process.
  • Automated Unix Script to download files from URL based storage to our UNIX box.
  • Prepared the release notes, Impact Analysis, Cut-Over Plan, Development & Production move checklist and code review reports for support central team for detailed code migrations.
  • Closely worked with the production support team and data team to recover from issues and various defects that encounter while running the jobs and analysing the data. Always been a primary call on support to handle the unexpected failures occur at run time

Confidential

ETL Developer

Responsibilities:

  • Allow non-FSE persons to report engine change in FDM.
  • Have a single point of data entry for as-maintained asset/configuration management
  • Have a standard process for data acquisition, processing, reporting
  • Control plan for continuous data quality needs to be in place.
  • Define master data and provide ability to link data between FDM and DO.
  • Enable FDM processes to support system/process integrations.
  • Process/product needs to support Customer Connect vision i.e. non- Confidential person’s ability to use GE’s tools.
  • Gathering User Requirements and analysis of the specifications provided by the clients
  • Updating Technical Architecture Document (TAD), Technical Design Document (TDD).
  • Creation of Informatica Mapping Design Document
  • Development and creation of ETL mappings to load data from various sources(Oracle, Flat files, XML files etc.) to IFS application tables applying Business Rules as per the Business Scenarios
  • Unit testing of mappings.
  • Integration Testing.
  • Migration of ETL Codes across environments (Development, QA, Production) and Go Live of the Informatica Folder.
  • Development of ETL script for performing the SCD type II and load tables into Teradata.
  • Worked as an analyst on providing the time and effort analysis on replacing the base Tables with Master Tables for Master Data Management.
  • Worked extensively on Teradata Utilities.
  • Development of SFTP, SSH scripts.
  • Worked on Message Queues in Informatica for loading IFS tables through MQ.
  • Provided solution for performance increase of long running sessions.
  • Development of UNIX scripts to combine all the XML files into one and converting them into SOAP-XML format which is a must requirement to load data into IFS application.
  • Development of UNIX script through CURL to download files from Confidential Library web URL to our Informatica UNIX source file Directory and further processing the files for Table Load.
  • Responsible for fixing defects during development, unit testing, UAT, post production
  • Create and maintain a project plan and update it on a weekly review with the IM and onsite coordinator of the Project.

Confidential

ETL Developer

Responsibilities:

  • Gathering User Requirements and analysis of the specifications provided by the clients
  • Creation of Requirements Harmonization Document, Technical Architecture Document (TAD), Technical Design Document (TDD).
  • Creation of Informatica Mapping Design Document
  • Development and creation of ETL mappings to load data by applying Business Rules as per the Business Scenarios
  • Unit Testing of mappings
  • Integration Testing
  • Development of mappings to pull Net Days payable XML file (from Confidential Capital), Supplier ERM flat file (from Business owner), Country sovereign risk (from Confidential Treasury) on a monthly basis from Confidential Library and load it to Teradata warehouse according to the business requirement.
  • Development of UNIX script through CURL to download files from Confidential Library web URL to our Informatica UNIX source file Directory and further processing the files for Table Load.
  • Development of script to Format the XML files.
  • Provide weekly status report and vendor project / leadership to team attend status meeting with Confidential Project Management Team during the project execution.
  • Identify reuse opportunities at all project stages and create reusable artifacts such as common components.
  • Provide project documentation for the project tasks and deliverables.
  • Migration of ETL Codes across environments (Development, QA, Production)
  • Development of Unix scripts to meet some functional requirements and scheduling the scripts through informatica
  • Responsible for fixing defects during development, unit testing, UAT, post production
  • Create and maintain a project plan and update it on a weekly review with the IM and onsite coordinator of the Project.

Confidential

OBIEE Report Analyst and ETL Developer

Responsibilities:

  • Analysis of the OBIEE reports and verifying the correctness of the same.
  • Detailed analysis of the Data loaded into the Data Mart.
  • Unit and Regression Testing of the OBIEE reports.
  • Preparing Test Cases for the OBIEE Reports.
  • Documented and stored the SQL queries used for the Testing purpose so as to benefit the following users.
  • Development of Mappings to load CDW Golden stamp tables.
  • Solving out the defects in the ETL process if the report is fetching incorrect data from tables.
  • Analysis of the existing Mappings to improve the data quality to provide less overhead on the reporting side.
  • Raised defects in MQC for each of the issues encountered in the reports and ensured resolution of the same.

Confidential

Team Member

Responsibilities:

  • Understand, analyze and obtain clarification on the requirements
  • Close any open items in the requirement
  • Complete changes to Informatica design documentation
  • Requesting and obtaining the access to the source and target databases, systems
  • Complete building additional/changed Informatica code as per new requirements
  • QA & UAT for the new/changed Informatica code
  • Execute the Informatica loads to facilitate Integration testing
  • Go-live and post-production support
  • Contributed on the Performance Tuning of the module.
  • Documentation for production migration

Hire Now