ETL Developer Resume MI - Hire IT People

TECHNICAL SKILLS:

ETL Tool: Informatica Power center

Data Modeling: Erwin, Power Designer

BI Reporting Tools: Qlikview, Tableau, OBIEE, BO

Programming/Web: C, SQL, PL/SQL, HTML, CSS, JavaScript, PHP, C#, ASP.NET, UNIX, Shell

Querying/Supporting Tool: SQL Developer, SSH, Putty and Winscp

Database: Oracle, Microsoft SQL Server, MYSQL

SDLC: Iterative, Agile and waterfall methodologies

EXPERIENCE

Confidential - MI

ETL Developer

Responsibilities:

Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
Implemented complex mappings in Informatica and assisted the team in loading the data.
Consulted with project stakeholders and modified existing data models to increase efficiency

Confidential, Missouri

Research Assistant

Responsibilities:

Confidential

Senior Software Engineer

Responsibilities:

Extensively used Power Center to design multiple mappings (54) with embedded business logic.
Created events and tasks in the work flows using workflow manager.
Implemented Value Added Processes (VAP) to improve data transformation.
Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
24*7 support reconciliations of GE capital UK bank transactions which involve around 300 businesses. Both Inbound &Outbound type of interfaces were developed to prepare the chart of accounts for which daily multiple files and transactions will process through our end.
Developed a Reconciliations dashboard through Qlik View which automates the process and provide a unique platform for all businesses to track their statistics which driven to save a lot of time and human effort.

Confidential

Junior BI Developer

Responsibilities:

Created different transformations for loading the data: Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Expression, Aggregator, and Sequence Generator.
Developed database objects, including tables, views and materialized views using SQL.
Implemented SCD type2 effective date range.