ETL developer Resume

SUMMARY

Around 5 years of experience in ETL and PL/SQL development, Implementation of Data Warehouses, Data marts using Informatica Power Center 8.5/8.6/9.1/10 and Confidential database.
Good knowledge of DW Concepts, Dimensional Modeling using Star schema and Snowflake schema for faster, effective querying and Business Analysis Requirements.
Proficient in the development of ETL processes with a good understanding of source to target data mapping and Business rules.
Experience in scheduling, monitoring and reporting jobs using Autosys tool.
Have acquired a comprehensive grasp on various other technologies like UNIX, Cognos reporting tool. My technical knowledge is complemented with excellent problem solving and communication skills.

TECHNICAL SKILLS

Business Intelligence: Informatica 8.5, Informatica 8.6, Informatica 9.1, Informatica 10, Cognos 8.4 Report Studio and Query Studio.
Database: Confidential 9i, Confidential 10g and Confidential 11g
Scripting: UNIX
Version control tool: GitHub
Job scheduling tool: Autosys

PROFESSIONAL EXPERIENCE

ETL developer

Confidential

Responsibilities:

Involved in requirement gathering, analysis, effort estimation, implementation, testing and maintenance.
Developed PL/SQL packages, stored procedures, functions, views, triggers.
Developed ETL mappings and workflows to load the data from flat files to database.
Created Autosys jobs to schedule and monitor the jobs
Involved in continuous enhancement of existing Business applications and fixing production defects.
Unit testing - Created and execution of UTPLSQLs.
Involved in different team activities like technical discussion, code review, provide resolutions to achieve better performance and re-usable code

Confidential

Responsibilities:

Involved in requirement gathering, analysis and design: Understanding the requirements, specifications and Business logic, by interacting with end users.
Involved in estimation of tasks
Preparing data mapping document based on Business requirement
Developed ETL mappings using Informatica Power center designer to extract data from Confidential database/flat files, transform it according to Business logic and load it into Confidential database.
Prepared customized SQL queries for data extraction.
Created reports and worked on enhancement of existing reports using Cognos 8.4 Query Studio and Report Studio.
Prepare unit test cases for testing mappings.