SUMMARY

• Over 8+ years of experience in the field of Information Technology with proficiency in ETL design/development and Data Warehouse Implementation/development using IBM Infosphere DataStage, Informatica Power Center, UNIX, SQL and PL/SQL in various industries such as Banking, Finance, Health Care, Telecommunication, Brokerage, Retirement, and Insurance .
• Worked on Data Stage client tools DataStage Designer, DataStage Director, DataStage Manager, Data Stage quality designer and also generated reports, column analysis, table analysis, primary key analysis and foreign key analysis.
• Experience in Designing, Compiling, Testing, Scheduling and Running DataStage jobs.
• Expertise in creating entity relational & dimensional relational data models with Inmon & Kimball Methodology (Star schema & Snow flake schema architectures, Fact/dimension tables)
• Experience in integration of various Operational Data Source (ODS) s with Multiple Relational Databases like Oracle, SQL Server, Teradata and Worked on integrating data from flat files like fixed width and delimited.
• Designed and implemented various Stages using IBM WebSphere Data Stage components like ODBC Connector, Dataset Stage, File Set Stage, Join, Sort, Aggregator Stage, Lookup Stage & various other stages.
• Utilized Data Stage Import and Export Utilities to migrate the code from Development environment to QA and then to Production Environments.
• Participated in Full life cycle development of Data Warehouse systems such as Analysis, Design, Development, and Testing & Technical Documentation.
• Experience in writing, testing and implementation of the Stored Procedures, Cursors, Functions and Triggers using SQL, PL/SQL.
• Expertise in developing ETL mappings and scripts using Informatica Power Center(9.x/8.x) Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
• Expertise in designing / developing complex mappings, Mapplets, Sessions, Workflows and Worklets using various Transformations like Unconnected & Connected lookups, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Experience in UNIX shell scripting for ETL jobs schedule, FTP and audit purpose.
• Working experience in interacting with Business Analysts and developers to analyze the user requirements, functional specifications and system specifications
• Excellent problem solving skills with strong technical background and good inter - personal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS

ETL Tools: IBM Infosphere/Ascential Data stage 11.x/9.x/8.x, Informatica Power Center 9x/8x, (Designer, Repository Manager, Workflow Manager, Workflow Monitor)

Modeling Tools: Erwin, MS Visio

Scheduling Tools: Autosys, Control M

Programming Languages: C, HTML, XML, SQL, PL/SQL, XML, UNIX Shell Scripting.

RDBMS: Oracle 11g/10g/9i, Teradata, SQL Server 2012/2014

Operating System: Windows 10/8/7/XP, Linux

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. ETL Datastage Developer

Responsibilities:

• Interacted with Business Analysts to finalize AML requirements (Banking, Brokerage, Loans, Retirement, and Insurance) and documented the UDD, TDD for coding.
• Analyze and develop QualityStage process to standardize names and address information to enhance the matching process for Anti-Money Laundering data ware house project.
• Analyzing the existing ETL process and come up with an ETL design document that listed the jobs to load, the logic to load and the frequency of load of all the tables.
• Created Sequences, Written Shell Scripting to run the Interfaces through script.
• Used stages like Transformer, Aggregator, lookup, stored procedure stage, Join, merge, sort to design interfaces with various sources like Oracle, Flat files, XML files ad SQL server.
• Used key areas like Type II SCD to update and insert slowly changing dimensions.
• Migrated the code from 8.1 to 11.3. Reviewed in the code and compiled and triggered from 11.3 to load data.
• Initialize AML WLF, SAM, CDD daily screening process by loading Reference data from UDM CDS to Profile DB, entities and transactional data from UDM CDS to Profile DB.
• Designing Technical Design Document and Mapping documents according to the transformation rules.
• Defining and implementing JIL files to automate the data stage jobs by using AutoSys and monitoring them.
• Did unit testing on the interfaces against mapping rules, written unit test cases for client to validate the data in their database.
• Using Datastage Director to schedule, running the solution, testing and debugging its components & monitor the resulting executable versions.
• Involved in support, maintenance, troubleshooting, problem solving and ongoing enhancements to the Integration process.
• Moving all the Interfaces from QA Box to Preproduction and then to Production.
• Conducted Review sessions with Business users and SME’s for better understanding of the requirements.
• Interacted very closely with offshore to finish the task to reach Deadline.

Environment: IBM Infosphere Data Stage 11.3, Oracle 10g/11g, SQL Server 2012, UNIX, AutoSys, WinScp3, Windows XP 7

Data Stage Developer

Responsibilities:

• Interacted with the Business Analysts to understand the process flow and the business.
• Analyzed the present data warehouse data model and participated in investigation of data subject areas and document data flows.
• Used technical specifications document to design and develop the ETL jobs. Also modified the technical documents to accommodate the changes in specs.
• Designed, developed and tested the Data stage jobs using Designer and director based on business user requirements and business rules to load data from heterogeneous data sources like Sybase, Oracle 10g, text files and MS SQL Server.
• Used stages like Transformer, Aggregator, lookup, stored procedure stage, Join, merge, sort to design interfaces.
• Generation of Surrogate ID’s for the dimensions in the fact table for indexed and faster access of data.
• Extensively used SQL coding for overriding the generated SQL in Data Stage and also tested the data loading into the database.
• Extensively used DataStage built-in transforms and created user defined subroutines to implement some of the complex logic to meet the business requirements.
• Implemented overall best practices, tips and techniques in the design, development, testing and deployment of DataStage jobs to the target Oracle environments.
• Prepared documentation for addressing the referential integrity relations in between the tables at ETL level.
• Used DataStage manager to import table definitions from various databases, import and export the datastage jobs between development, testing and production environments.
• Used Data Stage director to validate, monitor, schedule and execute the jobs.
• Used DataStage version control to version the designed datastage jobs.
• Created DataStage sequencers using Job Activity, triggers, routine activity, execute command, notification activities to ensure the sequential run of all the designed jobs.
• Created stored procedures, functions, packages, views and triggers using PL/SQL.
• Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs and debugging them.
• Extensively used Oracle Exception handlers and created user defined exceptions to capture the errors in the designed PL/SQL functions and procedures.
• Involved in manual testing of the designed jobs, UAT, integration testing and production process.
• Developed UNIX shell scripts to automate file manipulation and data loading process.

Environment: IBM DataStage 8.5, SQL Server, Oracle 10g/11g, PL/SQL, UNIX, Windows

Confidential, Wilmington, DE

ETL Developer

Responsibilities:

• Interacted with the Business Analysts to understand the process flow and the business.
• Analyzing Source to Target mapping Excel document.
• Created web service jobs by configuring WSDL in designer and used Informatica Web Services Hub to start the Informatica tasks.
• Created Data Flow Mappings to extract data from source system and Loading to application DB.
• Developed the strategy for the incremental loads.
• Worked on various tasks like Session, E-Mail task and Command task.
• Converted the regular mappings to handle the Slowly Changing Dimension (SCD2).
• Developed UNIX scripts for scheduling the delta loads and master loads using ESP Scheduler.
• Implemented Master Data management (MDM) for reference and non-transactional data entities.
• Created and used various re-usable tasks, workflows, worklets, mapplets, and re-usable transformations.
• Used telnet and FTP to connect UNIX remote server and also developed shell scripts to rename and move the files to backup folders using Post and Pre session commands.
• Used Teradata utilities such as Multi Load, Fast Load and Teradata Pump, etc.
• Created BTEQ scripts.
• Used the Dynamic look up to implement the CDC.
• Developed ETL mappings which use, create and update the parameter files.
• Used Stored Procedure transformation to get the desired output from app DB.
• Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.
• Involved in Prod Support to research and resolve the daily load issues.
• Used CA Harvest tool to deploy the Informatica jobs among different environments (DEV, TEST,QA and PROD)
• Scheduled meetings with Senior Data Lead and analyzed the data.
• Prepared the documents for all the modules developed.

Environment: Informatica Power Center 9.1/9.0, Erwin, Oracle 11g, Teradata, PL/SQL, SQL Developer, UNIX, PL/SQL, Sybase, SQL Server 2005/2008, ESP Scheduler, ESP Scheduler, Agile scrum

Confidential

ETL developer

Responsibilities:

• Worked on the installation and configuration of Informatica Power Center 8.6.1
• Created and Documented ETL Test Plans, Test Cases, Test scripts, Expected results, Assumptions and Validations.
• Involved in Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Used most of the transformations such as the Source Qualifiers, Routers, SQL, Transaction control, Sequence Generators and Expressions as per the Business requirement.
• Developed complex mappings to load the data from various sources using different transformations.
• Used debugger to test the mapping and fixed the bugs.
• Used session partitions, dynamic cache and index cache to improve the performance.
• Designed & Developed workflows/sessions to extract, transform & load the data into Target.
• Wrote SQL, PL/SQL codes, stored procedures and packages.
• Monitored and improved the performance of Sessions, Load Manager Properties, Parameter files, Mappings and documented the rectified issues in detail.
• With a team of 10 developers created a test Data Warehouse.

Environment: Informatica Power Center 8.6.1, Oracle 9i, MS SQL Server, UNIX, Autosys.