SUMMARY

• Over 7 years of IT experience as specialist in performing Analysis, Design, Development, Testing, Deployment, and Maintenance for various software applications.
• Extensive knowledge on the SDLC development life cycle. Involved in different phases starting from Requirement Gathering to Production Deployments.
• Extensive experience in ETL design, development and maintenance using SQL, PL/SQL, Informatica Power Center 9.x/8.x/7.x on UNIX and Windows platforms.
• Expertise in Data Warehousing, Data Migration, Data Integration using Business Intelligence (BI) tools such as Informatica Power Center, Power Exchange CDC, B2B Data Transformation, Informatica Data Quality, Informatica Data Explorer, MDM, SSIS, OBIEE, Cognos, etc.
• Worked with various source systems such as Relational Sources, Flat files, XML, Mainframe COBOL and VSAM files, SAP Sources/Targets and Web Services etc.
• Extensive knowledge of various Performance Tuning Techniques on Sources, Targets, Informatica Mappings, Sessions, and Data Base Tuning.
• Experience in writing BTEQ scripts and loading data into Teradata using FASTLOAD, MLOAD and TPUMP utilities.
• Expertise on integration mappings of Type I, Type II, and Type III Slowly Changing Dimensions and implementing update strategies, incremental loads, and change data capture.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes
• Expertise in defining and documenting ETL Process Flow, Job Execution Sequence, Job Scheduling and Alerting Mechanisms using command line utilities.
• Expertise in complete Software Development Life Cycle (SDLC) from Requirements gathering, Analysis, Data Modeling, Design, Testing, Debugging, Deployment, and Post Implementation Support and Maintenance
• Extensive experience in implementing Error Handling, Auditing and Reconciliation and Balancing Mechanisms in ETL process.
• Knowledge of various Data Modeling techniques such as E - R modeling, and Dimensional modeling (Star/Snowflake Schema).
• Strong Expertise in Database Design, development of SQL Scripts, Stored Procedures, Functions, Packages, Triggers using Oracle PL/SQL, T-SQL, Teradata SQL, DB2 SQL PL, etc.
• Knowledge of Informatica Administration, complete installation and upgrade of Informatica 8x.
• Worked on creating reports using OBIEE, Oracle Analytic functions, Business Objects and Cognos.
• Experience in UNIX Shell Scripting for applying data fixes and automation of ETL jobs.
• Ability to work on multiple projects and as well as a team member.

TECHNICAL SKILLS

Operating Systems: Windows 2003/XP//Vista/7, Windows Server 2003, UNIX.

ETL Tools: Informatica Power Center 9.5/9.1/8.x/7.x., Power Exchange, and Metadata Manager

Data Modeling: ERwin, E-R Studio, UML

Databases: Oracle 11g/10g//9i, SQL Server 2005/2008, Teradata, DB2, Sybase, Netezza etc.

Languages: C, C++, Java, SQL, PL/SQL, T-SQL, HTML, XML, UNIX Shell Scripting

DB Tools: SQL*Plus, SQL*Loader, Toad, Fast Load, MLoad, TPUMP

Reporting Tools: OBIEE 10g, Business Objects, Cognos, and SSRS etc.

Other Tools: HP Quality Center, Tivoli, Tidal, Autosys, Control-M.

PROFESSIONAL EXPERIENCE

Confidential, Freeport, NY

Sr.ETL Developer

Responsibilities:

• Involved in Dimensional Modeling (Star Schema) of the Data Warehouse and used ERwin to design the business process, grain, dimensions and measured facts.
• Involved in Analysis phase of the business requirement and design technical documents for developing Informatica mappings
• Member of the team to implement Confidential North and South America’s Datamarts project
• Responsible for reviewing and validating the functional specifications provided by the data architect and advising on improvements and changes
• Ensured proper relational integrity between the various fact and dimensional tables
• Involved in design and development of complex ETL mappings
• Fine-tuned existing mappings for performance optimization
• Performed unit testing to identify defects
• Prepared test cases and test plans, assisted the testers in system and integration testing
• Responsible for loading XML files into database, which is used for shipment tracking purposes by Confidential associates around the country
• Changed existing XML schema files to suit business needs.
• Developed Unix scripts to segregate various kinds of files, clean the files of unwanted data and to archive the files after the data load
• Responsible for scheduling, monitoring, reporting on load statuses and troubleshooting when required
• Troubleshooting the loading failure cases, including database problems.
• Extensively transformed the existing PL/SQL scripts into stored procedures to be used by Informatica Mappings with the help of Stored Procedure Transformations.
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target table.
• Written Unix scripts for moving files from Unix to windows environment.

Environment: Informatica Power Center 9.5.1,Oracle 11g, SQL Navigator 6.5, UNIX Scripting, Flat Files, XML files, Autosys.

Confidential, CT

Sr. Informatica Developer

Responsibilities:

• Performed business analysis and requirements per high end users and managers and performed requirement gathering.
• Responsible for passing the requirements to offshore team and co-ordinate with them in completing the tasks and then presenting them to the client.
• Developed a standard ETL framework to enable the reusability of similar logic across the board.
• Extracted source data from Oracle, Flat files, XML files using Informatica, and loaded into target Database.
• Extracted data from Mainframe using Power Exchange and COBOL files and created Recon processes to test the feed from main frames with the feed generated at the Distributed end.
• Engaged in designing and developing test cases, error control routines, data validation, audit and log controls using Informatica inbuilt error logging techniques and PL/SQL.
• Extensively transformed the existing PL/SQL scripts into stored procedures to be used by Informatica Mappings with the help of Stored Procedure Transformations.
• Involved in extensive Performance Tuning by determining bottlenecks in sources, mappings and sessions.
• Validated the data in warehouse and data marts after loading process balancing with source data.
• Worked closely with the business analyst’s team in order to solve the Problem Tickets, Service Requests. Helped the 24/7 Production Support team
• Worked with Teradata loaders within Workflow manager to configure Fast load and Multi load sessions.
• Experience with Teradata as the target for the datamarts, worked with BTEQ, Fast Load and Multi Load.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, MS SQL Server, Windows, Unix, Micro Strategy 9.1, ERWin 3.5, Mainframe, TOAD.

Confidential, Boston, MA

Sr. ETL Developer

Responsibilities:

• Participated in the Data Model design and designed it according to the Business Requirements.
• Responsible for converting Functional Requirements into Technical Specifications
• Responsible for passing the requirement to offshore team and coordinate with them in completing the tasks and then presenting them to client.
• Created Design Specification Documents including source to target mappings for Mainframe/Operational Source/financial systems to Stage, Stage to ODS and form ODS to Data warehouse tables.
• Extracted data from Mainframe using Power Exchange and loaded into SQL Server Database tables.
• Extensively worked with many source systems like Cobol Files, MQ series using Power Exchange.
• Implemented Real time Chang Data Capture (CDC) using Informatica Power Exchange.
• Worked on IDQ tool for data profiling, data enrichment and standardization.
• Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of daily loading into the Warehouse.
• Created different SCD-II mappings using changed data capture (CDC) processes.
• Created and scheduled jobs using Tidal Enterprise Scheduler.
• Provided Operational support for Production issues, and for business users and documented issues and resolutions.
• Worked with Teradata loaders within Workflow manager to configure Fast load and Multiload sessions.
• Experience with Teradata as the target for the datamarts, worked with BTEQ, Fast Load and Multi Load.

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL, PL/SQL, TOAD, UNIX Shell Scripting, Windows XP, UNIX.

Confidential, Denver

Informatica Developer

Responsibilities:

• Worked in an Agile Development environment using Scrum/Kanban methodologies. Participated in sprint planning sessions/backlog building, and daily standup meetings.
• Utilized FACT tables and granular dimensions in designing and data modeling of data warehouse and data marts in star schema methodology.
• Interacted with the business community and database administrators to identify the Business requirements and data realties.
• Worked on IDQ tool Used to identify data duplication, understand the quality of data and report generation and Data Analysis for Data migration.
• Created design documents for Informatica mappings based on business requirements.
• Involved in the performance improvement project.
• Created stored procedures, functions, triggers, tables, views, synonyms, and test data in SQL Server.
• Involved in designing of testing plan (Unit Testing and system testing). Tested scripts by running workflows and assisted in debugging the failed sessions.
• Used persistent caches whenever data from workflows were to be retained.
• Perform Maintenance, including managing Space, Remove Bad Files, Remove Cache Files and monitoring services.
• Also involved in leading the team meetings and providing status report to project manager.

Environment: Informatica Power Center 7.1, SQL Server 2008, PL/SQL, Windows, ERWIN, and PL/SQL

Confidential, Sandiego, CA

ETL Developer

Responsibilities:

• Analyzed the functional specs provided by the data architect and created Technical System Design Documents and Source to Target mapping documents.
• Involved in designing Staging and Data mart environments and built DDL scripts to reverse engineer the logical/physical data model using ERwin.
• Converted the data mart from Logical design to Physical design
• Designed Audit table for ETL and developed Error Handling Processes for Bureau Submission.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Managed Change Control Implementation and coordinating daily, monthly releases and reruns.
• Responsible for Code Migration, Code Review, Test Plans, Test Scenarios, Test Cases as part of Unit/Integrations testing, UAT testing.

Environment: Informatica Power Center 8, Power Exchange, SAP, Oracle 10g, PL/SQL, TOAD, SQL SERVER 2005/2008, XML, UNIX, Windows XP, OBIEE

Confidential

Oracle Developer

Responsibilities:

• Requirements Gathering and Business Analysis.
• Created tables, indexes, users, roles, DB triggers and stored procedures.
• Coordinate with DBAs for administrative tasks like creating/rebuilding indexes, adding partitions, analyzing tables, etc.
• Involved in creating and maintaining Partitioned Tables and Indexes.
• Prepared and executed unit/ integration test plans.
• Wrote SQL statements to access data from the Oracle database.
• Generated necessary reports periodically using Reports.
• Used SQL * Loader to load the data from the text files.

Environment: Oracle 8i, PL/SQL, SQL*PULS, SQLLOADER, PL/SQL Developer/2000 (Forms & Reports)