SUMMARY:

• Over THIRTEEN Years of strong IT experience with Data Warehousing in various areas like Application Development, Enhancement, Maintenance & Support, Application Management and Implementation.
• Having good experience in Informatica cloud (IICS, ICRT) integration with Salesforce, AWS (Redshift, S3) and other third party applications. Configure Vendor Web services with services and processes through ICRT to SOAP and REST best solution.
• Strong data warehousing ETL experience using Informatica Cloud/10.2/9.x/8.x Power Center client tool . Worked with different data bases such as Oracle, SQL Server, Teradata, DB2, SAP, Flat files, HDFS etc. Having good experience in writing UNIX Shell scripting, AUTOSYS JILs.
• Experience in project estimation and onsite, offshore team management. Strong experience in the analysis, design, development, testing and implementation of Business Intelligence solutions using Data Warehouse. Experienced in performance tuning of the application.
• Involved in full life cycle development of Data Warehousing. Excellent understanding of Star Schema, Snowflake modeling. Fact, Lookup and Dimensions Tables. Excellent skills in understanding business needs and converting them into technical solutions.
• Exposure on Hadoop ecosystems like HDFS, HIVE, PIG, Impala, MR, SQOOP and RDBMS. Good exposure in project estimation, preparing BRD, FRD, Technical specs, project documentation. Strong domain experience in Banking Domain (AML, RISK, CCAR) applications, Healthcare.
• Good experience in handling AML/FRAUD applications like ACTIMIZE, Case Management tools, Good exposure in handling vendors in multiple projects with cross platform technologies like Informatica, MS.Net, OBIEE, UNIX, Mainframe - DB2 etc.
• Good experience in Job scheduling tools like CA7, Autosys, Tivoli. Good experience in ITIL Process. Good experience in change management, incident management and problem management methodologies and also part of CAB team defining the process as per ITIL methodologies.
• Good experience in defining the new process as per business requirement to support the applications.

TECHNICAL SKILLS:

DW Tools: Informatica CLOUD (IICS, ICRT), Power Centre 8x, 9x, 10.2, OBIEE.

Bigdata: Hadoop-HIVE, Impala, Sqoop, HUE, HDFS.

DataModeling Tools: Erwin, TOAD Data Modeler.

RDBMS: Oracle, DB2, SQL Server, MS-Access.

Programming Languages: C#.Net, UNIX Shell Script, Batch Script.

Scheduling Tools: CA7, AUTOSYS, TIVOLI.

Operating Systems: Windows NT/2000/XP, MS-DOS, UNIX.

Tools & Utilities: PUTTY, VSS, Service Center 6.2, SM9, HPSA, Service Now.

Web Related: ASP.Net, HTML, XML.

Server: WAS, IIS, MOSS.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

ETL Technical Lead

Responsibilities:

• Worked with Assignment step, create step, jump step and data decision step, Service call step, sub process in ICRT. Integrating AWS - Redshift data base with on-premise databases. Integrating AWS- S3 unstructured data with RDBS database.
• Created service connectors in ICRT to run the ICRT process through REST API. Worked with process objects to process multiple records in a Realtime process. Implemented salesforce Out Bounding Messaging concepts in both ICS and ICRT to process the data in real time.
• Created Custom Profiles, Public Groups and Roles to distribute user rights and functionality. Created and customized Record types, page layouts, list views managed Role hierarchies and Profiles. Developed UNIX scripts to handle source files.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different transformation of Informatica. Project estimation and project design as per business requirements. Managing the team and providing technical solution.
• Managing migration projects from lower informatica version to latest version. Worked with the Salesforce, People Soft, Service Now, flat files, xml files. Developed incremental load logic in Informactica Cloud based on CDC.
• Used most of the transformations such as Source Qualifier, Java Transformation, Trancation Commit, Filter, Joiner, Sequence Generator, Expression, Aggregator, Lookup, Rank, Router, and Update Strategy, SQL Transformation, etc.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well. Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues.
• Involved in unit testing to test the processed data and user acceptance testing. Experienced in troubleshooting and fix the different Development/Production environment issues. Involved in environment creation of metadata manager.
• Involved in Workflow, Mapping deployment by using deployment group from Dev to UAT and UAT to Quality and production Repositories.

Environment: Informatica-Cloud (IICS/ICRT), Powercenter -10.2, salesforce, AWS (Redshift, S3), Hadoop - Hive, OFSAAI, UNIX, CA-7, NDM, Oracle, OFSAAI.

Confidential, McLean, VA

ETL Tech Lead

Responsibilities:

• Involved in analysis, LLD, HLD and documentation of mapping specs as per business rules. Creating inforamatica mappings as per business requirements. Developing SCD type 2, type 1 mappings using informatica. Loading DB2 Dimension data into ParAccel Database as per BRS.
• Prepare test strategy and Test Directories. Developed UNIX scripts to handle source files. Developed AUTOSYS JIL scripts to manage informatica workflow jobs. Performed UNIT Testing on developed mappings. Extensively used CDC on real time data.
• Extensively used SQL server Database from source and target. Participate in review of test document for the end-to-end testing. Prepare project status reports for the work carried out. Collect and reporting metrics on end-to-end testing.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different transformation of Informatica. Experienced in ETL auditing process.
• Used most of the transformations such as Source Qualifier, Filter, Joiner, Sequence Generator, Expression, Aggregator, Connected & Dynamic Lookup, Rank, Router, and Update Strategy, SQL Transformation, etc.
• Scheduled the Informatica Workflows as per user requirement by using AUTOSYS scheduling tool. Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues. Involved in unit testing to test the processed data and user acceptance testing. Experienced in troubleshooting and fix the different Development/Production environment issues.
• Involved in environment creation of metadata manager. Involved in recycle Repository, integration services and creation of automated scripts for deployment using pmrep command.
• Involved in Workflow, Mapping deployment by using deployment group from Dev to UAT and UAT to Quality and production Repositories. Experienced in writing Uniting Test Cases with multiple scenarios.

Environment: Informatica-9.6, UNIX, AUTOSY, ORACLE, SQL SERVER-2008, FlatFiles, DB2, ParAccel.

Confidential

ETL Technical Lead

Responsibilities:

• Involved in analysis, LLD, HLD and documentation of mapping specs as per business rules. Involve in understanding test requirements. Prepare test strategy and Test Directories. Participate in test case development and execution. Participate in test results document preparation for the project.
• Participate in bug reporting and tracking for the project. Performed ETL data loading into OBIEE Environment. Loading the data into HIVE. Extensively used CDC on real time data. Extensively used SQL server Database from source and target.
• Participate in review of test document for the end-to-end testing. Prepare project status reports for the work carried out. Collect and reporting metrics on end-to-end testing.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different transformation of Informatica. Developed AUTOSYS JIL scripts to manage informatica workflow jobs. Experienced in ETL auditing process.
• Used most of the transformations such as Source Qualifier, Filter, Joiner, Sequence Generator, Expression, Aggregator, Connected & Dynamic Lookup, Rank, Router, and Update Strategy, SQL Transformation, etc.
• Scheduled the Informatica Workflows as per user requirement by using AUTOSYS scheduling tool. Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues. Involved in unit testing to test the processed data and user acceptance testing. Experienced in troubleshooting and fix the different Development/Production environment issues.
• Involved in environment creation of metadata manager. Involved in recycle Repository, integration services and creation of automated scripts for deployment using pmrep command.
• Involved in Workflow, Mapping deployment by using deployment group from Dev to UAT and UAT to Quality and production Repositories. Experienced in writing Uniting Test Cases with multiple scenarios.

Environment: Informatica-9.6, OBIEE, Oracle11g, Erwin, TOAD Data Modeler, UNIX, Mainframe-DB2, MS.Net, WAS, HIVE, SQOOP, HDFS, Autosys.

Confidential

Sr. Analyst

Responsibilities:

• Involved in gathering and analyzing requirements, prepared Technical Design document and Source - Target Mapping docs and presented to BU team to finalize and get sign off. Worked on project plan to define the efforts and estimations tasks.
• Designed and Developed the Batch and Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Worked as a Senior ETL Lead for onsite/offshore model and leading a team.
• Participate in test results document preparation for the project. Participate in bug reporting and tracking for the project. Technical consultant for the team to provide optimal solutions, design reviews, code reviews and for any issues.
• Provided inputs to Project Stakeholders and Data Architects to accomplish the design of the project. Conducted design and review meetings to get design approval from different stake holders in the project. Involved in planning, effort tracking and estimations for the project.
• Extensively used SQL server Database from source and target. Participate in review of test document for the end-to-end testing. Prepare project status reports for the work carried out. Collect and reporting metrics on end-to-end testing.
• Scheduled the Informatica Workflows using CA7 scheduler tool. Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues.

Environment: Informatica-9.1, Hadoop-hiave, sqoop, Oracle11g, UNIX, DB2, OBIEE 11g, Erwin.

Confidential

Responsibilities:

• Requirement gathering for enhancements. Review HLD & LLD documents based on business requirements. Supported AML investigation requirements. Conducted monitoring of AML exception reports. Developing mappings, workflows as per the requirement.
• 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 Support. Resolving the issues within the SLA time to avoid business loss. Managing critical recovery call.

Environment: Informatica8.6, OBIEE, MS.Net, DB2, Oracle10g, UNIX, Detica Front end.

Confidential

Informatica - Team Member

Responsibilities:

• Understanding the Business rules completely and implemented data transformation methodologies, Involved in designing the E.T.L mapping documents. Involved in the mapping with a slowly changing dimension Type2 to keep track of historical data.
• Involved in developing Mapplets, Mappings and Transformations as per the requirements. Extracting data from different relational databases, Flat files using Informatica Power Center. Analyzing the issues and resolve with the scheduled time to avoid SLC.
• Creating Various Transformations like Interpreter, Preparer, Expression, Aggregator, Rank, Joiner, Sequence Generator, Lookup, and Update Strategy etc.

Environment: Informatica Power Center 8.6, SAP-ABAP, SQL, Oracle9i, UNIX, TOAD, PUTTY, EDIT PLUS, HPSD 4.5.

Confidential

Informatica-Developer

Responsibilities:

• Understanding the Business rules completely and implementing data transformation methodologies Involved in designing the E.T.L mapping documents. Involved developing Mapplets, Mappings and Extracting data from different relational databases, Flat files using Informatica Power Center.
• Creating Various Transformations like Expression, Aggregator, Rank, Joiner, Sequence Generator, Lookup, and Update Strategy, etc.

Environment: Informatica Power center 8.1, SQL Server 2005, UNIX, Putty, Service Center 6.5.

Confidential

Team Member

Responsibilities:

• Analyzed the existing OLTP system. Transforming existing data from Source database to Target database (Oracle). Performed data cleansing and transformation using Informatica. Developed Mapplets, Mappings and Transformations.
• Scheduled sessions to update the target data using Informatica Workflow Manager.

Environment: Informatica Power Center 8.1, Oracle 8i, UNIX, Putty, TOAD.

Confidential

Team Member

Responsibilities:

• Involved in developing the business logic layer and design the presentation layer. Involved in Application maintenance and enhancement. Involved in preparing the test cases and test scripts. Testing - unit testing. Representing Weekly & Monthly Client meetings from Offshore.

Environment: ASP.Net, C#.Net, Server-2000, Tools: SQL Profiler; O/s: Windows-2000.

Confidential

Team Member

Responsibilities:

• Involved in developing the business logic layer and design the presentation layer. Involved in Application maintenance and enhancement. Involved in preparing the test cases and test scripts. Testing - unit testing. Representing Weekly & Monthly Client meetings from Offshore.

Environment: ASP.Net, C#.Net, Server-2000, Tools: SQL Profiler; O/s: Windows-2000.