SUMMARY

• Confidential has 14 years of professional IT experience which involved end to end implementations of Data Warehousing projects using Informatica Power center, Ab Initio and Data Stage.
• Good understanding on SDLC process and involved end to end implementations of DWH projects using ETL tools Informatica Power Center, Ab Initio and Data Stage.
• Extensive Data Modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modeling.
• Gathered Business requirements by interacting wif teh business users.
• Performed gap analysis and feasibility study for teh given requirement.
• Involved in preparing Functional and Technical Design documents based on inputs from Business teams in understanding business requirements and developing and modeling.
• Good noledge and experience in ETL Performance Tuning and Code Review in Informatica power center/Ab Initio.
• Good noledge in ETL code migration projects like conversion from Informatica to Data Stage.
• Sound Experience in Designing ETL Processes wif Informatica Power Center, Ab Initio and Data Stage.
• In depth noledge on Data Mapping, Data Conversion, and Data Cleansing.
• Designing and developing teh Informatica mappings, sessions and workflows.
• Monitoring teh Daily ETL Loads in production.
• Strong noledge in Data warehousing concepts.
• Responsible for development of Test cases and executing Test Scenarios.
• Involved extensively in System Integration Testing and User Acceptance Testing.
• Excellent problem - solving skills wif good interpersonal skills, quick learner and excellent team player.
• Sound Experience in 24X7 Level II & III Production Support wif strict Service Level Agreements ensuring negligible loss in productivity (good experience on L1, L2, L3 incident, problem management and change management support in Service Now)

TECHNICAL SKILLS

Technologies: Data warehousing, ETL

ETL Tool: Ab Initio GDE 3.2.7.2/3.5.2/4.0.2.3 , Informatica Power Ceneter 7.x/8.x/9.x/10.x, IICS & Ascential Data Stage 7.5 EE, Data Stage 8.0.1

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

Scripting: UNIX Shell (Ksh /Csh)

Scheduler: Autosys, TWS (Tivoli work scheduler), Control-M

Operating Systems: Windows 98/NT/2000/XP, UNIX.

Others: MS Office (Excel, Word, PowerPoint, Outlook, Access), Putty, WinSCP

Packages: SQL* PLUS, Toad, SQL developer, Erwin, MS Visio.

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential, San Francisco, CA

Responsibilities:

• Participating project initiations and implementation, manager-scrum/weekly meetings.
• Analysis of requirements gathered by teh business analysts. Prepare white papers and converting teh requirements to design specifications.
• Analyzed application requirements and provided recommended design and studied teh current system to understand teh existing data structures.
• Extensively involved in Design phase of Low-level designs for each interface.
• Extensively involved in Data Extraction, Transformation and Loading
• Extensive usage of Multifile system where data is partitioned into four partitions for Parallel processing.
• Wide usage of Lookup Files while getting data from multiple sources and size of teh data is limited.
• Developed Generic graphs for data cleansing, data validation and data transformation.
• Responsible for cleansing teh data from source systems usingAb Initio componentssuch as Join, Dedup Sorted, Denormalize, Normalize, Reformat, Filter-by-Expression, Rollup
• Worked wif Departition Components like Concatenate, Gather, Interleave and Merge in order to departition and repartition data from Multifiles accordingly.
• Worked wif Partition Components like Partition-by-key, Partition-by-expression Partition-by-Round Robin to partition teh data from serial file.
• Used SQL developer to verify teh counts and results of teh graphs.
• Extensively involved in Unit testing, System Integration Testing.
• Extensively involved in UAT
• Crucible/Jira ticket for peer code review
• Review test cases and provide feed back
• Handover after development deploy/test competition.
• QA testing support and Test results review.
• Tuning of Ab Initio graphs for better performance.
• Process and Transform delta feeds of customer data, which comes in daily.
• Developed dynamic graphs to load data from data sources into tables and to parse records.
• L3 application walkthrough before production deployment.
• Supported teh migration of Informatica components from Development to environment to QA and Production.

Informatica ETL Developer

Confidential, Minneapolis, MN

Responsibilities:

• Responsible for teh analysis of requirements gathered by teh business analysts. Converting teh requirements to design specification and getting teh work done in teh specified time.
• Analyzed application requirements and provided recommended design and studied teh current system to understand teh existing data structures.
• Extensively involved in Design phase of Low-level designs for each interface.
• Design and development of ETL jobs using Informatica.
• Importing and Exporting Informatica mappings
• Build Informatica mappings by using Power Center Designer.
• Used teh Informatica Transformations like Lookup, expression, filter, router, Join, Sequence generator, update strategy, Union and Normalizer Transformation.
• Extensively involved in Data Extraction, Transformation and Loading
• Extensively involved in Unit testing, System Testing.
• Extensively involved in UAT.
• Developed data maps using Infromatica power exchange.
• Supported teh migration of Informatica components from Development to environment to QA and Production.

Confidential, Minneapolis, MN

Responsibilities:

• Worked closely wif Users, Business Associates, Project Managers, Product Architects and Requirements Modelers from all around teh globe to define Technical requirements and create project documentation.
• Responsible for teh analysis of requirements gathered by teh business analysts. Converting teh requirements to design specification and getting teh work done in teh specified time.
• Analyzed application requirements and provided recommended design and studied teh current system to understand teh existing data structures.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Worked on teh API design process.
• Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup (Connected & Un-connected), Filter, Update Strategy, Router and Expression
• Created Reusable Transformations and Mapplets and used them in various Mappings to reduce teh redundant work.
• Actively involved in Performance improvements of Mapping and Sessions by creating Partitions at teh session level in Informatica.
• Parameterized source and target database connections using session parameters.
• Created workflows to combine several Informatica sessions in desired execution sequence.
• Understanding existing Packages, Procedures and Functions, debugging them and updating teh source code based on teh change requests.
• Used SQL tool like PL/SQL Developer to run SQL queries and validate teh data.
• Worked extensively wif Tivoli work scheduler (TWS) to order and run teh batches in Dev as well as QA environments.
• Unit and Integration testing has been extensively done at development level and coordinated wif Quality team while performing System testing.
• Provided support to all teh Functional and Integration batches irrespective of teh projects during NY hours and
• Worked closely wif teh Business Associates, Technical Managers, Solution leads on Critical escalations and delivering teh status of teh Projects or Change Requests.
• RFC Case explorer is used to deploy teh code.
• Service Now is used to get teh requirements and track teh status of all teh change requests created by either Business Users or Managers.

Environment: Informatica Power center 9.x, Oracle, UNIX, Mainframes, Tivoli Work Scheduler

Confidential, Minneapolis, MN

Responsibilities:

• Worked closely wif Users, Business Associates, Project Managers, Product Architects and Requirements Modelers from all around teh globe to define Technical requirements and create project documentation.
• Responsible for teh analysis of requirements gathered by teh business analysts. Converting teh requirements to design specification and getting teh work done in teh specified time.
• Analyzed application requirements and provided recommended design and studied teh current system to understand teh existing data structures.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Worked on teh API design process.
• Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup (Connected & Un-connected), Filter, Update Strategy, Router and Expression
• Created Reusable Transformations and Mapplets and used them in various Mappings to reduce teh redundant work.
• Actively involved in Performance improvements of Mapping and Sessions by creating Partitions at teh session level in Informatica.
• Parameterized source and target database connections using session parameters.
• Created workflows to combine several Informatica sessions in desired execution sequence.
• Understanding existing Packages, Procedures and Functions, debugging them and updating teh source code based on teh change requests.
• Used SQL tool like PL/SQL Developer to run SQL queries and validate teh data.
• Worked extensively wif Tivoli work scheduler (TWS) to order and run teh batches in Dev as well as QA environments.
• Unit and Integration testing has been extensively done at development level and coordinated wif Quality team while performing System testing.
• Provided support to all teh Functional and Integration batches irrespective of teh projects during NY hours and
• Worked closely wif teh Business Associates, Technical Managers, Solution leads on Critical escalations and delivering teh status of teh Projects or Change Requests.
• RFC Case explorer is used to deploy teh code.
• Service Now is used to get teh requirements and track teh status of all teh change requests created by either Business Users or Managers.

Environment: Informatica Power center 9.x, Oracle, UNIX, Mainframes, Tivoli Work Scheduler

Informatica ETL Developer

Confidential, Norwalk, CT

Responsibilities:

• Extensively involved in Study Source System of various Interfaces.
• Extensively involved in Design phase of low-level designs for each interface.
• Design and development of ETL jobs using Informatica.
• Importing and Exporting Informatica mappings
• Build Informatica mappings by using Power Center Designer.
• Used teh Informatica Transformations like Lookup, expression, filter, router, Join, Sequence generator.
• Extensively involved in Data Extraction, Transformation and Loading
• Extensively involved in Unit testing, System Testing.
• Extensively involved in UAT.

Environment: Informatica Power center 9.x, Oracle, UNIX

Informatica ETL Developer/Production Support

Confidential, Norwalk, CT

Responsibilities:

• Worked as Senior Informatica developer and coordinating on teh SDLC activities and ensuring timely delivery of quality products
• Provided 24X7 Level II & III Production Support wif strict Service Level Agreements ensuring negligible loss in productivity
• Interacted wif Business teams and other stakeholders of various sub-businesses of Confidential Comfin like EFS, HFS, CRE and Capital Americas to understand cash/non-cash reconciliation and reporting enhancement requirements
• Re-engineered ETL (Informatica Power center) processes to integrate data loads into TLM from teh General Ledger source distributed across multiple databases.
• Designed, developed and supported around 100 ETL (Informatica Power center) data interfaces wif complex data transformation logic for over 30 sub ledger sources feeding data into TLM
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager to manage, develop ETL (Informatica Power center) components
• Designed data integration processes extracting data from various heterogeneous data sources like Relational databases, XML files, Fixed length flat files, Delimited files and legacy file systems
• Designed and developed Unix Shell scripts for extraction automation, data decryption, FTP and Cron Jobs
• Monitor all teh components dat provide financial activities related to high risk/cash accounts on a daily basis for reconciliation
• Kick-off Informatica Power center workflows to generate Sub-ledger entries from different sources and load it to teh downstream application daily/monthly/quarterly across all businesses once teh account reconciliation templates are created

Environment: Informatica Power center 9.x, Oracle, UNIX

Informatica ETL developer/Production support

Confidential

Responsibilities:

• Worked to transform requirements into technical design.
• Overall responsibility for requirements analysis, estimation, architecture, design and implementation of teh ETL processes include defining teh data quality.
• Designing and developing highly scalable and maintainable ETL. (high level, low level)
• Conversion of Business functionalities to Informatica flows.
• Guide and halp development team wif performance and other technology issues. Competency building, mentoring and providing training wifin teh team.
• Worked wif team on designing teh mappings, sessions, work lets and workflows in Informatica.
• Extensively involved in performance tuning of teh Informatica Mappings and workflows.
• Supported teh migration of Informatica components from Development to environment to QA and Production.
• Developed test plans to conduct teh Unit, QA, Integration, acceptance and load testing.
• Responsible for 24/7 Production support during loads. Addressed teh issues/failures wifin teh SLA. Join teh bridge line to work wif all teh impacted downstream applications/interfaces and make sure teh issues resolved and Problem Ticket has been closed properly and sign-offs from teh technical counter parts of impacted interfaces.
• Prepared teh Production support guideline document for teh team to follow teh process as per standards of Confidential energy.

Environment: Informatica Power center 9.x, Oracle, UNIX, Control-M

Informatica ETL Developer

Confidential, Norwalk, CT

Responsibilities:

• Gathering business requirements for various source systems
• Creating Design documents such as LLD, unit test plan etc.
• Design & Develop Informatica Power center mappings and creating teh workflows according to requirements.
• Coding, Unit Testing, Functional testing and Integration testing for all Informatica Power center mappings & workflows.
• Scheduling and monitoring of teh Informatica Power center jobs
• Migration of Informatica objects across different environments such as Dev and QA
• Giving Support to Production For data loading on a regular basis.
• Attending Customer calls on requirement basis.
• Involved in Detailed Design Documentation.

Environment: Informatica Power center 9.x, OracleInformatica ETL Developer/Production support