SUMMARY

• Over 6 years of experience in information technology industry in the areas of data warehousing and business intelligence: focusing on SSIS, Talend, Informatica PowerCenter ETL development, testing and bug fixing.
• Experienced in working with clients to implement requirements and in providing team leadership for development support teams comprising company as well as client and third - party contract staff.
• Excellent work ethics and analytical skills coupled with excellent communication, written and interpersonal skills describing a committed team player.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, T-SQL, Korn/Bash Shell Scripting, Microsoft PowerShellSed, Awk/Sed/Grep, Perl

ETL Tool: Informatica Power Center 10.x/9.x/8.x/7.x

Database: Oracle 11g/10g/9i/8i, MS-SQL Server 2000/2005/2008 , DB2, Postgre SQL, Salesforce.com, Teradata, MySQL, Netezza

Operating Systems: Windows 7/2003/2000/NT/XP/98/95, UNIX/Linux, MS-DOC

Data Modeling: Erwin, Oracle Data Modeler, ERstudio

Other Tools: TOAD, SQL*Plus, SQL Developer, Putty, WinSCP, SQL Server Management Studio, Teradata SQL Assistant, Notepad++, Aginity

PROFESSIONAL EXPERIENCE

ETL Design/Developer

Confidential, Chicago, IL

Responsibilities:

• Interact with the Data Analyst/Architect to gather requirements by walking through requirement document and business background knowledge.
• Discuss with Data Analyst to determine key terms on Extraction, Transformation and Loading (ETL) such as, source/target system, target data grain, update strategies and dependencies.
• Use Microsoft Excel Sheet, Visio Diagram and SQL to explain and study complicate business functions and rules.
• Perform the data profiling and import database table definition using SQL query tool such as SQL developer, and Informatica Power Designer.
• Analyze current ETL code and database to improve the requirement documents and design.
• Estimate the overall effort needed to develop a solution.
• Analyze system architecture, review project documents, and set up all the tools and access, such as Informatica PowerCenter, Oracle DB, ODBC connection and Development file system.
• Study and Implement code standard, naming conventions, code documentation and reusable objects.
• Communicate with development team to determine the ETL logic and algorithm, such as Changed Data Capture, Lookup and Target Load Strategy.
• Translate technical requirements into a detailed design for new and existing code
• Document the detailed design specifications and Participate in design reviews and provide input to the design recommendations
• In corporate coding standards and security requirements into design
• Use SQL, Informatica Transformation Language, Unix Shell Scripting to perform various calculations on different data types, such as number, string and date, based on requirements, with Informatica Power Designer.
• Use Unix ksh scripting, Regular Expressions and utilities like sed, grep, awk, to perform data and file manipulation.

Confidential, Los Angeles, CA

Sr. PL/SQL Developer

Responsibilities:

• Extensively used SQL Loader for loading data into staging tables from various data sources
• Used Bulk Collections for better performance.
• Developed mappings and workflows by reading the data from one database and loading the data to another database.
• Developed generic mappings and workflows for loading different types of client data by passing the parameters.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Scheduled copy over jobs and regularly checking the status of critical jobs by email alerts.
• Test case/data preparation, execution and verification of the test results.
• Worked with day-to-day issues that are submitted in the form of tickets.
• Involved in Data loading and Extracting functions using SQL*Loader.
• Responsible for development and testing of conversion programs for importing data into Oracle database utilizing PL/SQL, SQL*Loader and UNIX shell scripts, to load data from flat files to Oracle database.
• Worked mostly on the data conversion part to be uploaded into corporate reports using Oracle PL/SQL.
• Analyzed SQL statements reorganize database objects and design indexes to improve response of queries.
• Implemented PL/SQL scripts using Ref cursors in order to load data dynamically and implemented incremental loading of the data.

Environment: Oracle 11gR2, TOAD 10.0, Unix, SQL* Loader, PL/SQL Developer

ETL Data Stage Developer

Confidential, VA

Responsibilities:

• Understanding the business functionality & Analysis of business requirements
• Involved in the preparation of the Detailed Platform Application Design document
• Review of the documents and ensure its prompt delivery to the Business for approval.
• Worked on DataStage - DataStage Designer, DataStage Manager DataStage Director. Involved in the development of DataStage jobs.
• Developed parallel jobs with collection of all source stages, target stages and processing stages like Aggregator, Transformer, look-up, join etc.
• Created Job Sequencer for dependency jobs and to run the jobs by using parameters.
• Viewing Log for the jobs and cleaning up the resources using Director.
• Running and monitor the jobs in Director.
• Used most of the stages such as the Transformer, Datasets, Sequential File, Aggregator, Peek, Funnel, etc.
• Involved in Unit Testing and Test plan preparation to meet proper testing activity.
• Prepared the Deployment guide and release notes for the project. Which contains the entire configuration details and paths of project deliverables which will be useful for system testing to deploy the build?
• Having exposure to Connect: direct software which will transfer the data from one system environment to another environment.
• Having exposure to QC, where we can reassign the build for System testing people.

Environment: Ascential Datastage 7.5.2/7.5.1 PX (Enterprise Edition) Oracle 9i, UNIX IBM AIX 4.2.

Sr. Data stage Developer

Confidential

Responsibilities:

• Involved in analysis, Requirement collection and documentation of functional and technical specifications.
• Analyzed the specifications and identified the source data and needs to be moved to the data warehouse.
• Involved in Logical and Physical data model, Built the DDL and DML scripts from the Erwin tool
• Extensively used Informatica power center for extracting, transforming and loading databases from oracle and non-oracle databases.
• Implemented excellent Informatica development strategies and used Target Load Plan, Constraint based loading, partitioning, performance tuning the existing mappings. Used the Informatica debugger to resolve the errors in the mappings.
• Wrote SQL, PL/SQL, stored procedures, triggers and cursors for implementing business rules and transformations.
• Involved in performance tuningof Existing Jobs.
• Involved in the preparation of documentation for ETL, standards, procedures and naming conventions.
• Used UNIX shell scripts for running the jobs.
• Setting up Batches and sessions to schedule the loads at required frequency using Autosys. Generated completion messages and status reports using Workflow manager.
• Developed Unit Test Cases, Design Documents and Effective Test Data to ensure successful execution of the data loading process.
• Involved in production support for troubleshooting data issues and overnight batch support.

Environment: Informatica Power Center 8.6, oracle 10g, SQL Server, UNIX Shell Scripting, TOAD, SQL Developer Informatica Power Center 8.6, oracle 10g, SQL Server, UNIX Shell Scripting, TOAD, SQL Developer