SUMMARY:

• 8+ years of IT experience in various phases of SDLC including Analysis, Design, Development, Testing and Implementation and support of various applications.
• Expertise in Informatica Power Center 9.x/8.x extracting data from Oracle, SQL Server and DB2 databases.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.
• Experience in Physical and logical data modeling using Erwin.
• Strong experience in SQL, PL/SQL and UNIX shell scripting.
• Extensive experience in Oracle back end objects like Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Extensive experience in Healthcare and Banking domains.
• Excellent knowledge of Software Development Life Cycle and Test methodologies.
• Experience in analyzing technical/business specifications and reviewing documentation.
• Experience in both Waterfall and Agile methodology.
• Managing Remedy tickets, scheduling and tracking it to closure.
• Strong knowledge in databases Oracle, SQL Server and DB2.
• Experience in scheduling of ETL jobs using Autosys, Control - M.
• Strong analytical and problem solving skills, ability to learn and adapt to new technologies quickly.
• Willingness to share knowledge with others in the team.
• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.
• Experience in implementing both Ralph Kimball and Bill Inmon’s Data Warehouse methodology.
• Possesses the ability to work in self-managed and team environments.
• Have excellent analytical and problem solving skills in large environments.
• Strong understanding of business processes & interface with IT.
• Excellent interpersonal and communication (written and verbal) skills

TECHNICAL SKILLS:

Tools: Toad, SQL Developer, Remedy, Informatica8.x/9.x, Metadata Manager,SSIS, Erwin, DBVisualizer, PPM, JIRA, Erwin, Oracle Data modeler, Business Objects, DVO,IDQ, Aqua Data Studio.

Markup languages: HTML,DHTML,XML

Programming/Scripting Languages: SQl, PL/SQL, UNIX Shell Scripting, Cobol, C, C++

Operating Systems: Windows 98/XP/Vista, UNIX, LINUX, MVS, Z/OS

Databases: Oracle 9i/10/11g, SQL Server 2005/2008,DB2

Defect Tracker: Test Director, Quality Centre

Version Control: Visual Source Safe

Job Schedulers: Autosys, ControlM

EXPERIENCE:

Confidential

Sr. ETL Lead developer

Environment: Informatica Power Center 9.1.0, SQL Server 2008Db2 8.x/9.x, Oracle11g, UNIX Shell scripting, Auqa data Studio, Visio,Tidal

Responsibilities:

• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Responsible for completing source to target mappings which is input for Development and testing teams.
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers.
• Created documents like ETL Architecture and QA assessment to fine tune the existing application.
• Developed technical specifications of the ETL process flow
• Worked on Data lineage / Data elements capturing in AML end to end process in very large Database.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in Oracle, SQLServer and DB2.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, DB2, Flat files).
• Supporting daily batch loads and work with business users to handle rejected data/data issues.
• Worked on Informatica checklist/Assessment to find out issues in existing mapping, session and workflow parameters.
• Assisting the team in development activities.
• Developed reusable mapplets and transformations.
• Worked on process improvements like creating development review checklist for peer review process.
• Worked on existing jobs performance tuning.
• Created reverse engineering documents on existing mappings using Mapping Analyst tool to document the business rules.
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.
• Worked on Slowly Changing Dimensions (SCD's) and its implementation to keeptrack of historical data.
• Writing SQL queries to verify and compare source and targets.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Developed PL/SQL Stored Procedures, Packages and Functions for implementing Business logic.
• Scheduled various daily and monthly ETL loads using Tidal.
• Involved in unit testing and documentation of the ETL process.
• Coordination of system/Integration/UAT testing with other teams involved in project and review of test strategy
• Written UNIX Korn shell scripts for file transfer/archiving.
• Involved in Production Support in resolving issues and bugs.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Involved in project post implementation verification process and status update.
• Monitor and trouble shoot nightly jobs and generate job status report on daily basis.

Confidential, NYC, NY

Sr. ETL/DWH Developer

Environment: Informatica Power Center 9.1.4, SQL Server 2008, Oracle11g, UNIX Shell scripting, TOAD, Business Objects, Visio, Autosys, DVO,IDQ,SVN

Responsibilities:

• Involved in project life cycle involving Requirement Analysis, Design, Coding, Testing and Implementation phases.
• Developed technical specifications of the ETL process flow
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQLServer and Oracle.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, SequenceGenerator and Normalizer.
• Created the dimensional logical model using Erwin.
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, andType 3) to keeptrack of historical data.
• Writing SQL queries to verify and compare source and targets.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Developed PL/SQL Stored Procedures, Packages and Functions for implementing Business logic.
• Involved in developing PL/SQL Procedures for Adhoc report generation.
• Writing and implementing PL/SQL scripts for summarizing data from the history table and loading into separate tables for analysis.
• Modified the existing large PL/SQL programs for best performance considering business logic.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Presenting Data Cleansing Results and IDQ plans results to Operations by generating score cards.
• Develop IDQ plans to identify possible data issues.
• Created single and table pair test runs in DVO to validate data.
• Generate DVO reports to maintain audit tails.
• Created List Reports and Cross Tab Reports and Drill Through reports, created standard and Ad hoc reports using Business Objects.
• Scheduled various daily and monthly ETL loads using Autosys.
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Involved in unit testing and documentation of the ETL process
• Involved in Production Support in resolving issues and bugs.
• Involved in Project implementation activities like submitting Remedy.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Involved in project post implementation verification process.
• Mange the time and cost of ERI (Enterprise Risk Integration) program through the PPM Tools activities.
• Creating, update and close tasks in JIRA.
• Writing shell scripts to archive data and log files with timestamp.
• Include email notification at session level and workflow level to track workflow status.
• Using pmcmd command to execute workflows from UNIX scripts.
• Monitor and trouble shoot nightly jobs and generate job status report on daily basis.
• Created documents like “Visio diagrams of different flows”, “Architecture Diagram” and “Project Overview document” for future use.
• Generate required artifacts and work on PQA audits to ensure required monitoring and control is in place.

Confidential, Philadelphia, PA

Informatica/Oracle Developer

Environment: Informatica Power Center 8.6.1, Metadata Manager,SQL, PL/SQL, Oracle11g, UNIX Shell scripting, TOAD, Visio, Autosys, SVN

Responsibilities:

• Develop and implement the coding of Informatica Mapping for the different stages of ETL.
• Experience inInformaticamapping specification documentation, tuning mappings to increase performance,
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Monitoring and tracking the applications as per the schedule run.
• Proficient in create and scheduling/Creating jobs with dependencies in Autosys.
• Strong skills in requirement gathering and study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures, Forms & Documentation, Effort Estimation,
• Extensively used ETL to load data from Flat files, DB2 and Oracle into Oracle.
• Designed Informatica mappings by translating the business requirements.
• Created mappings using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router and Update Strategy
• Worked with mapping variable, Mapping parameters and variable functions like Setvariable, Countvariable, Setminvariable and Setmaxvariable
• Widely used Informatica client tools - Power Center designer, Mapping designer, Work flow designer.
• Created events and tasks in the work flows using workflow manager
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, andType 3) to keeptrack of historical data.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Extracted data from legacy systems and uploaded into Oracle Datawarehouse
• Used Informatica Metadata Manager to maintain and document metadata.
• Design and development of UNIX Shell Scripts to handle pre and post session process.
• Writing complex PL/SQL scripts for data conversion and migration.
• Developed UNIX shell scripts to move source files to archive directory.
• Involved in Unit, Integration, system, and performance testing levels.
• Writing PL/SQL procedures, functions and packages.
• Developed and support the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems usingInformaticaand provide technical support and hands-on mentoring in the use ofInformatica
• Prepared a production monitoring and support handbook for ETL Process.
• Created reusable sessions and mapplet’s.
• Used mapplet’s and different transformations to meet the complex logic.
• Used XML generator and XML parser transformations to generate hierarchical XSD’s to target data consumers.
• Debug the sessions by utilizing the session/workflow logs.
• Performance tuning on Oracle database queries.

Confidential, Hartford, CT

ETL Developer

Environment: Informatica 8.6, Erwin, Control M, PL/SQL, Oracle 9i, DB2 8.2,SQL developer.

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Using Informatica Designer, developed mappings, which populated the data into the target.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the mapping designer to map the sources to the targets.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks, shell scripts.
• Created Stored Procedures for data transformation purpose.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Modified the existing large PL/SQL programs for best performance considering business logic.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Assisted the team of Developers in SQL statement tuning and use of ANALYZE command, Events trace to track the execution plan of statements.
• Involved in Code Reviews and preparing unit test cases
• Perform unit testing at various levels of the ETL.
• Responsible for writing the database programming to Store/Retrieve the information from the database.
• Experience with transactions involving Extraction, Transforming data, Bulk Loads and Data Transformation.
• Well-versed with different stages of Software Development Life Cycle (SDLC).

Confidential, Hartford, CT

ETL Developer

Environment: Informatica 8.6, Erwin 3.5, Control M, PL/SQL, Oracle 8i, SQL Server 2000,TOAD, Unix shell scripting.

Responsibilities:

• Involved in detailed analysis of requirements and creation of requirement specifications and functional specifications.
• Analyzed business requirements and worked closely with various application teams and business
• Develop logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Developed data conversion/quality/cleansing rules
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Created Mapplet and used them in different Mappings.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Involved in Creating Fact and Dimension tables using Star schema
• Built Repositories using Informatica Power Center Repository Manager to store Source, Target, Transformations, Mapplets and Mappings Meta Data Information.
• Developed various Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica Power Center Designer.
• Extracting and loading of data from flat file, Oracle sources to oracle database (target warehouse) using transformations in the mappings.
• Created Informatica mappings with SQL, PL/SQL procedures and Functions to build business rules to load data.
• Wrote shell scripts and control files to load data into staging tables and then into Oracle base tables using SQL*Loader.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Performed tuning of sessions in Target, Source, Mappings and Session areas.
• The result of sessions has been track through log files using session manager.
• Setting up batch jobs, scheduling and monitoring.

Confidential, Hartford, CT

ETL developer

Environment: Informatica 8.6, Erwin 3.5, Control M, PL/SQL, Oracle 8i, SQL Server 2000, DB2 8.2.

Responsibilities:

• Involved in design and development of data models using Erwin data modeler
• Designed the source to target mappings that contain the business rules for the server during the extract, transform and load process using Informatica ETL Tool.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Created Mappings in Informatica Designer to extract data from Heterogeneous data sources like Oracle, COBOL files, MS SQL Server, MS Access & Excel Sheets to load into the data warehouse with various types of transformations like Aggregator, Expression, Filter, Joiner, Lookup, External Procedure, Router & Update Strategy.
• Installed and Configured the Informatica Client tools.
• Worked on loading of data from several flat files to XML Targets.
• Exporting and importing data using Export/Import utilities.
• Involved in Analysis, Documentation and Testing of workflows.
• Tune ETL procedures and STAR schemas to optimize load and query Performance.
• Used mapplets and different transformations to meet the complex logic.
• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Created SOX documents for post-production fixes.
• Assuring quality in the deliverables and Follow the Quality procedures.