Informatica ETL developer - Computer Software Programming Resume Searc
Informatica ETL developer - Computer Software Programming Resume Searc
My Spider Scam Awareness Contacting Us F. A. Q.
 
Job Seekers
Search Jobs
Browse Jobs
Post a Resume
Job Alerts
 
Employers
Search Resumes
Browse Resumes
Post a Job

Informatica/ETL developer Resume


Desired Industry: Computer Software/Programming SpiderID: 26172
Desired Job Location: charlotte, North Carolina Date Posted: 4/20/2009
Type of Position: Contractor Availability Date: 04/21/2009
Desired Wage:
U.S. Work Authorization: Yes
Job Level: Management (Manager, Director) Willing to Travel: Yes, Less Than 25%
Highest Degree Attained: Masters Willing to Relocate: No


Objective:
PROFESSIONAL SUMMARY

• Around 7 years of experience in the IT / Software Industry possessing strong knowledge in data warehousing technology with skill set of Informatica and Oracle
• Experience in all the phases of Data warehouse life cycle involving design, development & analysis and testing of Data warehouses using ETL
• Capable of analyzing the business requirements and creating functional design documents to design mapping, mapplet, workflow and sessions in Informatica 6.0/7.1
• Experience in creating mapping, reusable transformations and mapplet using Firstlogic and performing Firstlogic administration
• Developed scheduling jobs in Informatica and monitored the same using the workflow monitor
• Practical understanding of the Database schemas like Star Schema and Snow Flake Schema used in relational and dimensional modelling.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables and Slowly changing dimensions
• Six sigma certified (Green Belt Certification)
• Experience in writing Unix Shell scripts
• Handling of database management activities for new releases using Oracle
• Experience in writing database scripts such as SQL queries ,PL/SQL Stored Procedures, Indexes, Functions, Views, Materialized views and Triggers
• Strong knowledge in the Software Development Life Cycle working in CMM Level 5 Company.
• Efficiently handling the data fixes and other support work on time
• Quick learning, sound communication, interpersonal skills and client interaction abilities complement the technical abilities
• Excellent analytical/ communication skills and good team spirit
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review process


Experience:
PROFESSIONAL EXPERIENCE

GE Health Care - Milwaukee, WI Feb’06 – Oct’08
Informatica/ETL developer

Description: The Sales Work Bench project is the web based application used by GE health care for managing their business globally. The business deals with the real time selling of GE health care products which involves the following modules.
• Accounts and contacts
• Leads and opportunities
• Territory management
• Configure, price and quote
• Order management
• Forecasting
• Sales compensation for sales representative



Sales Representative logs the details of Existing/Potential Clients Interested in procuring Medical Equipments. The Work Flow for this application starts from the stage where a Sales Representative enters a requirement till the product is delivered. The data was transformed according to the business requirement for users to validate their transaction online and then stored in the data mart.

Responsibilities:
• Development of mappings, mapplet, reusable transformations, sessions and workflows in Informatica 6.0 and Informatica 7.1 Power Center.
• Development of address cleansing/standardisation Mapplet and mapping using Firstlogic plug-in.
• Worked extensively with Extraction, Transformation and Loading of data from Multiple Sources (oracle, fixed width and delimited flat files) to Oracle using Informatica.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator and joiner.
• Worked on Scheduling workflows and sessions using Informatica scheduler and have implemented decision task and email task for tracking the successful completion
• Performing Informatica and Firstlogic server administration.
• Worked with parameter and variables in various mappings and sessions
• Handled the creation of tables, views, triggers, stored procedures, functions, sequences) in the database using SQL and PL/SQL scripts.
• Actively involved in creation of entity relationship diagram using data modelling techniques by interacting with the code development team
• Good understanding of session logs and handled the rejected load with reject files.
• Have worked with Debugger tool of Informatica in the mapping when the desired result is not achieved( in case of errors in the output)
• Performing unit test, functional test and integration test depending upon the environments along with testing team.
• Handling of Support Central and SPR requests (Data fixes when change is reported).
• Performed the Database management activities for each new release.
• Preparing technical documents for the Informatica scheduled jobs and data mappings.

Environment: Informatica 6.0, Informatica 7.1, Toad, Guidepost, Firstlogic 4.20C, SQL& PL/SQL

GE Health Care - Milwaukee, WI Jun’04 – Jan’06
Informatica/ETL developer

Description: In the sales compensation project for every product of GEHC sold by the sales representative, the payment and compensation details are calculated on a monthly basis. The details of the order that the sales representative make in a month is received in a file and then based on the plan/condition the compensation details are calculated and stored in the sales comp data mart for analysis and report generation.

Responsibilities:
• Worked extensively with extraction, transformation and loading of data from different sources to the database
• Developed and tested all the Informatica mappings, mapplets involving transformation such as lookup, router, filter, update strategy, sequence generator, joiner, stored procedure.
• Worked on creation of tables, views, triggers, stored procedures, functions, sequences in the database using SQL and PL/SQL scripts.
• Created pre-session and post-session SQLs to drop/create indexes for fast loading of the data.
• Implemented the Snowflake Schema Methodology during our Data Modelling.
• Knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions.
• Knowledge of the session logs and handled the rejected load with reject files.
• Performing unit test, functional test and integration test depending upon the environments along with testing team.
• Involved in creation of Low Level Design (LLD) document for Informatica mappings.

Environment: Informatica 6.0, Informatica 7.1, Toad, SQL and PL/SQL

Federal Super Market - Laurel, MS Jun’02 – Feb’04
Informatica developer

Description: The Retail Business Analytical Process (RBAP) provides a basic view of how to analyze the Business and Requirements for Decision Making in a way to organize and analyze the business of retail sales. The term Data Warehousing mainly explains us the basic idea for storing and analyzing the transformed data. The project mainly deals with all the possible ways to perform the analytical calculation to cater for the needs of strategic business requirements mainly for sales, stock comparisons and strategic planning for decision support systems.

Responsibilities:
• Used Informatica designer to develop complex mappings.
• Used various transformations like Lookup, joiner, aggregator, filter, router, update strategy and rank to migrate better and consistent data.
• Created reusable transformation and mapplets to import in the common mappings to avoid complexity
• Scheduled and monitored the workflows using Workflow manager and monitor.
• Developed SQL and PL/SQL Scripts for creation of Data Objects
• Implemented Type 2 mapping for slowly changing dimensions to maintain current data as well as history.

Environment: Informatica 6.0, Toad, Oracle 8i, SQL and PL/SQL

Image Compression using Vector quantization, India Dec’01 - May’02

Description: The project deals with compressing image of any size using the method of Vector Quantization. Vector quantization (VQ) is a method where the whole picture is divided into small parts based on the size of the image. VQ is done with the principle of the codebook design developed with the help of the Linde-Buzo-Gray (LBG) algorithm

Environment: C, C++, Visual Basic


Education:
EDUCATION

Master of Science in Information Technology.



Skills:
TECHNICAL EXPERIENCE

Informatica Tools: Informatica 6.0 / 7.1 (Designer, Server Manager, Workflow Monitor, Repository Manager),
Other Tools: TOAD, First logic, Informatica Match Consolidate, Informatica ACE, Informatica IACE, Guide Post
Languages: C, C++, Java, Visual Basic, SQL/PL-SQL
Database: Oracle
Operating Systems: Windows, Unix


Candidate Contact Information:
JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.


    





© 2021 Job Spider
Privacy Policy | CC Marketing Sites | Site Map | Links