PROFESSIONAL SUMMARY:

• Overall 10+ years of IT experience in analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP client /server applications.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse and DSS using Informatica PowerCenter,Power Exchange, IDQ, Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Experience with Relational and Dimensional Modelling using Star and Snow flake models for Data warehousing application.
• Experience in Automation & scheduling of processes, and Informatica sessions using Informatica Scheduler.
• Proficiency in gathering business requirements, establishing functional specifications and translating them to design specifications.
• Experience with development and maintenance of Informatica mappings, workflows and other tasks, experience in creating reusable objects.
• Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information.
• Experience in integration mappings including dynamic cache lookup, shared, and persistent mappings for Type I, Type II, Type III slowly changing dimensions.
• Experience in implementing update strategies, incremental loads and Change Data Capture.
• Experience in using SQL, PL/SQL, TOAD and SQL Developer.
• Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
• Experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in different databases.
• Automation and scheduling of Informatica jobs using AutoSys.
• Experience in database development skills using Oracle PL/SQL to write stored procedures and functions.
• Other experiences include: Agile methodology development, process re - engineering, facilitated sessions, proposal development, functional testing and software metrics & other quality assurance techniques.
• Excellent verbal and communication skills, has clear understanding of business procedures and ability to work as an individual or as a part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10X/ 9.5/9.1/8.6/8.1 , Informatica Power Exchange, Informatica Data Quality and Data ProfilingReporting Tools: Business Objects, Oracle Business Intelligence, Crystal Reports

Data Modeling: Erwin 7.2/4.0/3.5

Databases: Oracle Exadata/12/11g/10g,Netezza

Languages: SQL, PL/SQLTools: SQL plus, TOAD, Autosys

Operating Systems: UNIX, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential, FL

Senior ETL Developer

Responsibilities:

• Development of ETL processes using Informatica Power Center 10.2, Power Exchange 10.2 and IDQ.
• Translate functional requirements into technical specifications for ETL development
• Perform data profiling and source to target mappings (while capturing ETL and business metadata) for populating Kimball style dimensional models.
• Write scripts for automated testing of data in the target tables.
• Capture audit information during all phases of the ETL process.
• Write and maintain documentation of the ETL processes via ETL detail design documents and flow diagrams.
• Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues.
• Be able to implement slowly changing dimensions as well as transaction, accumulating snapshot, and periodic snapshot fact tables.
• Collaborate with business users, other data services team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse.
• Creating an External Table from a file.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.

Environment: Informatica Power Center 10.2, Power Exchange, IDQ, Oracle Exadata , SQL, PLSQL

Confidential, FL

Senior ETL Developer

Responsibilities:

• Part of Scrum team where we were assigned multiple tickets (tasks) pertaining to ETL and ELT developments.
• Migrated big batch of legacy data to new the new Data Warehouse which was part of Big Data Project.
• Worked on Big Data project in Hadoop environment used to extract data from Hive into ETL.
• Built multiple queries and complex SQL's on Netezza environment.
• Creation of ETL and ELT code in Informatica to manage data integration tasks within the project team.
• Task included but not limited to, from simple file imports onto database to complex mapping involving integration of multiple systems within the company
• Created Autosys scripts to run ETL informatica and other shell jobs.
• Solutions need to be highly efficient and functional to deal with high volumes of data.
• Scheduling jobs using Autosys, jobs execute multiple environment tools like Infomatica and DB Scripts.
• Communicate with the DA's for new solutions in implementing robust ETL's and ELT platforms.
• Assist in the continuing evolution of solutions ensuring we are on the vanguard of technologies.

Environment: Netezza, Informatica 9.6.1. Autosys. Aginity. Archipelago testing tool.Hadoop, Hive

Confidential, Birmingham, AL

Senior ETL Developer

Responsibilities:

• Involved in gathering the business requirements and molding them in to the technical specifications required for the conversions team.
• Designed the target Data Warehouse using Star Schema, Involved in Extraction, Transformation and Loading (ETL) Process.
• Extensively worked over the online tracking system for work-requests, database change request issues, automated UNIX scripts modification issues and various scheduler jobs issues.
• Collection of requirements from business users and analyzed based on the requirements.
• Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Mappings involved transformations like Expression, Sequence Generator, Joiner, and Update Strategy.
• Created sessions by extensively using ETL methodology for complete processing of data extraction, transformations and loading using Informatica.
• Managed multi source data extraction using Informatica.
• Involved in necessary training and knowledge transfer to assigned project members.
• Implemented mapping for slowly changing dimensions (SCD) to maintain current data as well as historical data.
• Created sessions and batches for data movement using Workflow Manager.
• Created reusable Transformations and Mapplets and used them in mappings in case of reuse of the transformations in different mappings.
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.

Environment: Informatica Power Center 9.5, Oracle 11g, Oracle SQL* Plus, Flat Files, UNIX Shell Scripting, TOAD

Confidential, Indianapolis, IN

ETL Developer

Responsibilities:

• Analysis of requirements to develop design specification for Global Manufacturing Data Mart (GMDM).
• Preparation of high level and low level design documents.
• Working with client to gather requirement and interpreting the requirement in Design and helping team to understand and development as per requirement.
• Worked closely with Project Management, Data Modeling, and DBA teams to build data mart application.
• Design and develop Informatica Mappings / Mapplets / Sessions / Worklets / Workflows for migrating data to GMDM.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Router, Joiner, Aggregator, Update Strategy, Lookup, Stored Procedure, Sequence Generator, Transaction Control, Union Transformation, SQL Transformation XML Source qualifier, XML Generator and XML Parser.
• Used Informatica Debugger to test the data flow and fix the mappings.
• Creation of PL/SQL Packages, Procedures and Functions for data migration to GMDM.
• Involved in writing UNIX shell scripts, PL/SQL procedures, Pre-session and Post- Session Scripts.
• Setting up Business Objects Environment in DEV/QA/PRD.
• Suggesting solutions based on technical expertise and knowledge.
• Analysis and review of code and deliverables.
• Deployments to Dev / QA / Production environments.
• Software Testing including Unit, System and System Integration Testing, Test case/data preparation, execution and verification of the test results.
• Involvement in value add proposals for cost benefit and improvement in system performance
• Assistance in performance tuning, problem determination and resolution during the development lifecycle.

Environment: Informatica Power Center 9.1, Oracle 11g, SQL, PLSQL, Toad 11.0

Confidential

Informatica Developer

Responsibilities:

• Designed ETL mapping based on Existing ETL logic.
• Worked with various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Extensively used ETL to load data from flat files to Oracle.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Made adjustments in Data Model and SQL scripts to create and alter tables.
• Worked extensively on SQL, PL/SQLand UNIX shell scripting.
• Analyzed the source system of ETL Maps.
• Designed and developed the fact/dimension entities.
• Co-ordination with Client Business & Systems team for QA.
• Performed the tuning of ETL SQLs.
• Compared actual results to expected results and suggested changes to mappings owned by others
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production

Environment: Informatica power Center 8.1, Oracle 9i, Flat Files, UNIX Shell Scripting

Confidential

ETL Developer

Responsibilities:

• Analysis and Design of the system
• Created mappings to extract, transform & load data from different sources using various Transformations.
• Created and scheduled workflows thereby combining sessions for individual units.
• Created PL/SQL scripts for data transformation in line with program specifications.
• Creating temporary tables and indexes for loading and updating data.
• Designed and Developed Stored Procedures, Packages & Functions using PL/SQL and SQL scripts.
• Developed shell scripts for database replication processes.
• Tested all the modules.
• Involved in ETL documentation.

Environment: Oracle 7.X, SQL, JDBC, PL/SQL, SQL*Loader, Developer 2000, Informatica

Confidential

Junior Software Engineer

Responsibilities:

• Creation of Packages.
• Major and Minor enhancements to D2kkForms and Reports.
• Requirement Analysis and design of reports
• Writing PL/SQL stored procedures and Functions for data manipulation.
• Preparation of Detail Design.
• Configuration controller.
• Unit Testing
• Documenting the processes and sharing with team
• Customer interaction
• Handling change request from the clients.