ETL Developer Resume

SUMMARY:

10+ years of IT experience in the Business Requirements Analysis, Design, Development, Implementation and Testing of Enterprise Data warehouse and Data mart applications.
Experience in implementation of Data Warehousing using Informatica Power center 9.x/8.x/7.x, Data Mart, OLAP, OLTP, Star Schema, and Snowflake Schema.
Experienced in Client interaction, Requirement analysis and conversion of the same to high - level & low-level technical design.
Strong experience in Star Schema/Snowflake modeling, Ralph Kimball methodology, designing Fact & Dimension tables
Extensive experience of gathering requirement, Proof of concept, gap analysis, design, development, and Implementation of the ETL/Data warehouse projects.
Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Mart.
Expertise in tuning mappings, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions
Strong exposure in Data Analysis, Data Modeling, Data Cleansing, and Transformation, Integration,
Strong Experience in ETL Design, Development and Production support.
Technical expertise in ETL methodologies, Informatica 9.x/8.x - Power Center, Power Mart, Client tools - Mapping Designer, Workflow Manager/Monitor and Repository Manager and Experience in INFORMATICA MDM Development with Using Informatica MDM 9.1,9.5.1
Experience in coding using BTEQ Scripts and utilities like MLOAD and FLOAD in Teradata.
Experience in integration of various data Sources like Oracle, MS SQL Server, Teradata and flat files into the Staging area.
Very good exposure to Oracle 10g, 9i, 8.x, Teradata databases, SQL Server Hands on experience in scheduling jobs through Control-M / Work Load Manager Jobs
Proficient in SDLC Process and hands on experience in Full Life cycle of the project.
Experience on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the automobile, telecom healthcare industries
Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.
Strong Leadership qualities & equally active Team member

SKILL:

ETL Tool: Informatica9.x/8.x/7.x, Informatica MDM

Operating System: Windows Family, UNIX MS-DOS

Languages: C, PL/SQL.

Database: Oracle, Teradata, SQL Server

Tools: Citrix, Erwin, WLM, Control M

IM Tools: Service Center, TSRM, Service Now

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

Experience in implementation of Data Warehousing using Informatica Power center 9.x/8.x/7.x, Data Mart, OLAP, OLTP, Star Schema, and Snowflake Schema.
Experienced in Client interaction, Requirement analysis and conversion of the same to high - level & low-level technical design.
Strong experience in Star Schema/Snowflake modeling, Ralph Kimball methodology, designing Fact & Dimension tables
Extensive experience of gathering requirement, Proof of concept, gap analysis, design, development, and Implementation of the ETL/Data warehouse projects.
Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Mart.
Expertise in tuning mappings, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions
Strong exposure in Data Analysis, Data Modeling, Data Cleansing, and Transformation, Integration,
Strong Experience in ETL Design, Development and Production support.
Technical expertise in ETL methodologies, Informatica 9.x/8.x - Power Center, Power Mart, Client tools - Mapping Designer, Workflow Manager/Monitor and Repository Manager and Experience in INFORMATICA MDM Development with Using Informatica MDM 9.1,9.5.1
Experience in coding using BTEQ Scripts and utilities like MLOAD and FLOAD in Teradata.
Experience in integration of various data Sources like Oracle, MS SQL Server, Teradata and flat files into the Staging area.
Very good exposure to Oracle 10g, 9i, 8.x, Teradata databases, SQL Server Hands on experience in scheduling jobs through Control-M / Work Load Manager Jobs
Proficient in SDLC Process and hands on experience in Full Life cycle of the project.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship