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