SUMMARY

• 15+ years of comprehensive and versatile exposure of IT experience on Data Warehouse and Business Intelligence with proven ability of implementation Software Development Life cycle (SDLC) encapsulating the process like Business Requirements Analysis, Application Design, Development, Performance Tuning, Testing, Implementation and maintenance of Data Warehouse and Data Mart systems in the Telecom, Insurance, Health Care and Banking Domains.
• Experienced in development and design of ETL methodology for supporting data transformations and processing in a corporate wide ETL Solution using Informatica Power Center 9.6.1/9.1.0/8.6.1/7.1.1 (Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer)
• Knowledge of RDBMS concepts, with hands on experience in the development of relational database environment using SQL, PL/SQL, Stored Procedures, Packages and UNIX shell scripting.
• Well versed in using the Scheduling tools across the projects like MAESTRO (TWS), Informatica Scheduling, Autosys and ESP
• Knowledge in designing and developing Data marts, Data warehouse using multi - dimensional models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems. Experience in FACT & Dimensions tables, Physical & logical data modeling.
• Good experience in technical, functional and leadership roles by applying development methodologies.
• 11 Years of database experience using DB2, Oracle, MS SQL Server 2000, SQL and PL/SQL
• 8 years of in UNIX shell scripting to address different needs of projects.
• Team player, motivated and dynamic with excellent oral and written communication skills.
• Quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Center v 10.2.0/9.x/8.x/7.x, Diyotta

Languages: SQL, PL/SQL, C, C++, Java

Scripting: UNIX shell scripting

Databases: DB2, Oracle, SQL Server, Sybase.

Scheduling Tools: Tivoli Workload Scheduler, Autosys, ESP

Platforms: MS Windows, Windows NT, UNIX, Hadoop (HDFS)

Utilities: Squirrel, DBeaver, Toad, Embarcadero Rapid SQL 7.0.1

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked with different stakeholders to get the requirements, functional specifications.
• Based on the needs create BRD, functional specification document and technical design documents
• Develop informatica mappings, work on performance tuning of existing mappings.
• Create Source to Target Mappings
• Worked on Informatica upgrade from 9.6.1 to 10.2.0 in development and testing environments
• Work on end user tickets and provide root cause analysis and if needed, provide resolution and fix the issue
• Delivered projects MRR, MPT, MRR Confidential -X campaigns, DDA, CACS, TU

Environment: Informatica Power Center 10.2.0, DB2 v9.7, Tivoli Workload Scheduler and UNIX.

Confidential

Data Engineer/Data Analyst

Responsibilities:

• Worked with different stakeholders to get the requirements
• Analyze incoming source data and create a gap analysis document comparing existing DB2 tables.
• Convert Informatica mappings into Source to Target Mappings
• Perform root cause analysis on data issues
• Create scripts to move history data from DB2 tables to Hive tables.
• Provide support to development and testing team related to any queries
• Work on development of Hive scripts
• Delivered projects RESL, mHUB, Scotia Insurance, Rewards, Digital Payments

Environment: Hadoop, DB2, Shell scripting, Hive Scripts

Confidential

Sr. Informatica Developer/Onshore lead

Responsibilities:

• Worked with Stakeholders regarding business requirements, functional specifications and enhancements, based on the business needs created technical design and functional specification documents.
• Active participation in discussions with solution architect and data modeling teams to understand and work on any new requirements.
• Provide design documents and source to target mappings.
• Identifying and extracting data from varied sources, applying business rules and loading them to target Data Marts using Informatica Power Center 9.1 ETL solution environment.
• Identify performance improvements/defects/issues/process improvements and implement in production.

Environment: Informatica Power Center 9.1/9.6.1, DB2 v9.7, SQL Server 2005, Tivoli Workload Scheduler and UNIX.

Confidential

Sr. Informatica Developer

Responsibilities:

• Perform the requirement analysis for developing the Customer Interaction Repository (CIR).
• Design the Data Model and review with both offshore and onshore.
• Design the solution for CIR and review with offshore and onshore.
• Develop the code in Informatica and perform testing.
• Provide the necessary functional support by organizing design reviews with Reporting team and on ad-hoc basis.

Environment: Informatica Power Center 8.6, SQL Server 2008, Oracle, Autosys and UNIX.

Confidential

Informatica TechLead

Responsibilities:

• Work on ADHOC, Inquiry and Issue requests assigned.
• Actively participate in the Conference call with onsite and communicate daily status
• Work on the Development/Test environment based on the ticket assigned.
• Support the CO-Promote, One World and CIR interfaces. Whenever their is a failure, preform the root cause analysis and fix the failure.
• Work on Process improvements to prevent the failures and implement in production.

Environment: Informatica Power Center 8.6, Teradata, Oracle, Autosys and UNIX.

Confidential

Sr. Software Engineer

Responsibilities:

• Design the architectural flow of diagrams, asses the flow of code to be implemented Confidential Informatica ETL level in a faster way to minimize the bottlenecks.
• Extensively used all transformations for implementing the business logic including Source Qualifier, Filter, Sorter, Aggregator, Joiner, Lookup, Router, Sequence Generator, Normalizer, Sql Transformation, Union, XML and Update Strategy
• Performed data validation, data filtration as required and data masking for confidentiality.
• Involve in the preparation of Technical Design Document and walkthrough the flow of the code impacting the stage/final target tables.
• Work on the critical End user tickets which TEMPhas financial impact on the business.
• Creating/Building and scheduling the workflows and sessions using the workflow manager.
• Creating Unix Scripts for getting the flat files from the Source and transferring the files to the destination.
• Supporting projects during implementation and post implementation phases.
• Performed analysis, design and fix of Defects that are logged during Application Product Test and Production Defects.

Environment: Informatica Power Center 8.6, DB2, Oracle, Business Objects, ESP Scheduler and UNIX.

Confidential

Software Engineer

Responsibilities:

• Designed, Developed and defined the ETL processes using Informatica tool to load data from Sybase, Oracle and Flat Files into the target which may be file or relational.
• Extensively used all transformations for implementing the business logic including Source Qualifier, Filter, Sorter, Aggregator, Joiner, Lookup, Router, Sequence Generator, Normalizer, Union, XML and Update Strategy
• Creating/Building and scheduling the workflows and sessions using the workflow manager.
• Creating Unix Scripts for getting the flat files from the Source and transferring the files to the destination.
• Perform Sessions operations, Monitor the session progress and fixing the errors encountered during the loading process.

Environment: Informatica Power Center 7.1, Sybase, Oracle, Microstrategy and UNIX.