ETL Developer Resume

SUMMARY

Over 13 years of IT experience with extensive experience in Data warehousing, ETL, Reporting, Database Development, Maintenance, Testing and Documentation.
Extensive Data Warehouse experience using Informatica Power Center / Power Mart (Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Designer) as ETL tool on Oracle Database.
Expertise in Dimensional data modeling, Star schema modeling, Snowflake modeling, Data Normalization. Experience in working with Erwin and PL/SQL.
Experience in Customized Microsoft Dynamics CRM 3.0, extensively used JavaScript, SSIS, SSRS
Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions. Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers
Self - motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.1/8.6 (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Worklets), SSIS 2005

Data Modeling: Erwin 4.0

Report: OBIEE 10.0, SSRS 2005

Databases: Oracle 10g, SQL SERVER 2000/2005/2008 , GreenPlum

Programming: JavaScript 4.0, SQL, PL/SQL, PowerBuilder 9.0/11.5

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential

Responsibilities:

Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
Designed and developed the Mappings using various transformations to suit the business user requirements and business rules
Uniform and standard data source. Base data is collected from Oracle ERP, CRM and other business project. BI Database is Greenplum. Assisted Develop BI Portal and reports using OBIEE.
Responsible for scheduling workflows, error checking, production support, maintenance and testing ofETLprocedures using Informatica session logs.
Performance tuning on sources, targets mappings and SQL (Optimization) tuning.

Software Engineer

Confidential

Responsibilities:

Customize Microsoft CRM using JavaScript. This case was elected the one of four successful Cases of CRM solution by Microsoft.
Process and uniform data source with SSIS
Maintenance and develop Business Application using PowerBuilder, Database is Microsoft SQL Server 2000/2005/2008 .

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship