SUMMARY:

• 8+ plus years of experience in the IT industry with Domain knowledge on Insurance, Health Care, Retail and Telecom Projects.
• Demonstrated an analytical ability to understand the business requirements, convert the business specification to technical document, develop and integrate solutions to meet the requirement.
• Created Business Requirements Documents (BRD), Source - to-Target or Lineage document for data warehousing applications.
• Worked on projects using Informatica which are related to migration, development and Integration of various systems using various versions of Informatica (10x/9x/8x).
• Proficient in Informatica Designer components such as Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer (Re-usable transformations), Workflow Manager, Workflow Monitor.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Developed complex mappings in Informatica using different transformations such as Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union and Stored Procedure etc.
• Hands on experience in using Business Intelligence tools such as Microstrategy and Cognos.
• Worked on various relational databases like Oracle, SQL Server, DB2 in creation of SQL Queries required by the project.
• Aware of concepts related to PL/SQL programming and some other scripting languages such as UNIX.
• Extracted data from various sources like Oracle, DB2, Flat files, MS SQL SERVER, XML files and other open source databases such as Cassandra.
• Worked closely with Data Modellers in coming up with scalable relational and dimensional data models. Good understanding of Star Schema, Snowflake Schema and 3NF data models.
• Proficiency in Data Warehousing techniques for Data Cleaning, Slowly Changing Dimension (SCD) phenomenon, Surrogate Key assignment and Change Data Capture (CDC).
• Worked extensively with Slowly Changing Dimensions Type1, Type2 and Type3.
• Understand the business rules completely based on High Level document specifications and implement the data transformation methodologies.
• Experience in Performance tuning of Informatica sources, mappings, targets and sessions and SQL queries. Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Developed unit test cases for testing the ETL logic.
• Experience in setting up batch jobs using Autosys and Control-M job schedulers.
• Strong knowledge on Agile SCRUM methodology, Waterfall model and Test Driven Development.
• Hands on experience in Production Support and Maintenance.

TECHNICAL SKILLS:

ETL Tools: Informatica 10.1/9.6/9.5.1/9.1.0/8.6, ODI

Reporting Tools: Microstrategy, Tableau, Cognos, OBIEE

Databases: Oracle 8i/9i/10g/11g/12c, IBM DB2, SQL Server, Netezza, MS-Access.

Operating systems: Windows 95/2000/NT/XP/Vista, UNIX.

Data Modeling Tool: Erwin 8x

Utilities: Oracle SQL Developer, TOAD, SQL*LOADER, SQL Navigator

Job Scheduling Tools: Informatica Scheduler, Control- M, Autosys.

Production Support Tools: JIRA, Remedy, HP QualityCenter, Bugzilla

Office Application: MS Excel, MS Outlook, MS Word, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Burlington, MA

Sr. ETL Developer

Responsibilities:

• Worked with Business Analysts to understand the requirements and convert them to technical specfications.
• Created multiple mappings that involved implementation of Business Logic to load data into staging area.
• Extracted data from mainframe source systems and applied the business logic to load data into target systems.
• Implemented the ETL logic based on the mapping document to load the data from various source systems to target systems.
• Developed mapping parameters and variables to support SQL overrides and create global parameter files for loading various source and target tables.
• Used existing ETL standards to develop mappings.
• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregator, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Developed workflows with multiple sessions and instances for same subject area.
• Worked on Partitioning of the Sessions and Performance Tuning of Informatica.
• Implemented Indexing, Partitioning and Parallelismstrategies to facilitate huge volume data loads.
• Scheduled workflows using Autosys Scheduler and configured them with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
• Loaded data into fact and dimension tables in that handled slowly changing dimensions of Type II to populate current and historical data to Dimensions tables in the data warehouse
• For some strategies implemented the SCD TypeI.
• Removed bottlenecks at source level, transformation level and target level for the optimum usage of sources, transformations and target loads.
• Performed Unit testing of Informatica ETL process to ensure ETL logic.
• Once successfully unit tested ETL mappings, workflows and worklets were successfully moved to QA environment.
• After thorough User Acceptance Testing code was migrated to production and I provided 24x7 production support.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Participated in test results document preparation for the project.

Environment: Informatica Power Center 9.6(Power Center Designer, workflow manager, workflow monitor), Oracle Data Integrator, Business Objects XI 4.1, PowerExchange, UNIX, SQL Developer, Erwin, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g, Agile.

Confidential, NY

Sr. ETL Developer

Responsibilities:

• Interacted with Business Analysts to understand and analyze the requirements.
• Translated requirements into business rules & made recommendations for innovative IT solution.
• Worked closely with user decision makers to develop the transformation logic to be used in Informatica Power Center.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Used Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for different types of studies for Daily, Monthly and Yearly Loading of Data.
• Removed bottlenecks at source level, transformation level and target level for the optimum usage of sources, transformations and target loads.
• Captured data error records corrected and loaded into target system.
• Tuned Source System and Target System based on performance details, when source and target were optimized, sessions were run again to determine the impact of changes.
• Experienced in troubleshooting and fix the different Development/Production environment issues.
• Responsible for regression testing ETL jobs before test to production migration.
• Performed Database/ETL migrations from Dev. environment to Test/Training/UAT/Staging and PROD environments.
• Worked on Business Objects functionalities like Queries, Slice and Dice, Drill Down, Custom sorts, Cross Tab, Master Detail and Formulae.
• Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues.
• Providing 24x7 production support.
• Worked on daily production incidents and triaging the defects.

Environment: Informatica Power Center 9.5.1(Power Center Designer, workflow manager, workflow monitor), Business Objects XI 3.3, WinSQL, UNIX, SQL Developer, Erwin, Putty, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g,SAP Power Connect, VersionOne, Mingle, Sharepoint, Agile.

Confidential, Bentonville, AR

ETL Developer

Responsibilities:

• Analyzing the source data coming from different sources and working with business users and developers to develop the Data Model.
• Create functional specifications and work with application technical teams to create the high level and low level design documents.
• Working closely with user decision makers to develop the transformation logic to be used in Informatica Power Center.
• Developing mappings, workflows as per the requirement.
• Created flat file targets and XML file targets extensively.
• Worked with UNIX environment for maintaining parameter files.
• Prepare the implementation plan to deploy ETL jobs and batches in Dev, Test and Production environments.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design and development changes.
• Resolving tickets opened by users for BO Production issues as well as access related issues.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Implemented efficient and effective performance tuning procedures.
• Handling High priority and criticality incidents.
• Handling work requests and project requests.
• Provided backup liaison with business and IT.
• Understanding the functionality of the application from the business prospective.
• Monitoring and maintaining the scheduled jobs.
• Providing 24x7 production support.
• Responsible for maintaining the Quality standards in all the phases.

Environment: Informatica Power Center 9.6.1/9.1(Power Center Designer, workflow manager, workflow monitor), WinSQL, UNIX, Business Objects, Erwin, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g,SAP Power Connect.

Confidential, Fremont, CA

ETL Developer

Responsibilities:

• Designed the ETL Mapping Documents for development team members for their implementations.
• Worked on Informatica Power Center components- Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
• Promoted Informatica mappings from development to test to production environment.
• Used Informatica to extract, transform and load data from different input sources like flat files and XML files into Oracle 10g database.
• Created Informatica Power Center Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
• Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Migration between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and System testing at ETL level in my mappings.
• Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• Follow-up on tickets and fixing the issues.

Environment: Informatica 8.1.2, Oracle 10g, SQL, PLSQL, Microsoft Excel, MS-Word, COBOL.

Confidential, Deerfield, IL

ETL Developer

Responsibilities:

• Gathered the Project Requirement and Worked on System Requirement Design
• Worked on ETL Specification and Logical & Physical Design documents
• Understanding the existing DATA MODEL and gathered and analyzed the business requirements to develop a data warehouse model and evaluated for the ETL purpose
• Coordination with the ETL & Reporting Development team with Design/Development approach to create a DW and Data Marts.
• Improved the existing process towards more automated, reduce failure risks, improve data quality and increased resource utilization.
• Extensively used Informatica Power Center as an ETL tool to integrate various sources and loaded the data into Datawarehouse.
• Writing data extracts (equities, market data etc) to Excel files so that Business-users can analyze the data extracts in spreadsheets. These data extracts are also used for high-level Business users reporting purposes.
• Develop complex transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, XML transformations.
• Creating/ Building and Running / scheduling Batches and Sessions/workflow using the Server Manager/Workflow Manager and automation of ETL process using Autosys.
• Worked on daily loads that include delta and change data capture logic and also worked with global and local variables at the workflow and the mapping levels.
• Involved in creating the procedures and functions to support the ETL logic as required.
• Worked on Unix Platform with respect to Informatica file transfers, generating logs etc.
• Worked on UNIX shell scripts for scheduling sessions, pre and post session scripts for data transfer needs, GFT mechanism etc.

Environment: Informatica Power Center 8.6, Informatica PowerExchange, Oracle 10g,Siebel 8,TOAD, MS Visio, UNIX Scripting (Ksh)