SUMMARY

• 11+ years of total experience in Software Applications Analysis, Design and Development, Testing, Maintenance and Enhancement in Data Warehousing, Data Integration and Client - Server environment in Financial, Healthcare, Banking, Insurance, and Sales Systems.
• 8+years of strong Data Warehousing experience in Business Requirement Analysis, Design, Development, Testing, Implementations, Loading, Maintenance and Enhancements of Data warehouse and ODS systems using Informatica, Oracle, DB2, SQL Server, Teradata, Netezza and well versed wif Data Warehousing Architecture, Technology, Operational Data Store and Dimensional Data Modeling. Has exposure to PeopleSoft, Salesforce, Siebel and SAP.
• Experienced and good knowledge in Project Management and Planning, Engineering Management Planning, Service Operation and Management.
• Experience in conducting Change review meetings for teh production change and Problem management and Incident Management.
• 7+ years of experience as a Data Analyst & Data Mapper.
• 5+ years of experience as a Lead managing offshore Team
• 2+ years of experience wif Informatica Administration, proactive monitoring
• Extensive knowledge wif Dimensional Data modeling, Star Schema/Snowflakes Schema, Fact and Dimension tables.
• Experienced in working on AWS migration’s project like data migration’s from on premise DB’s to AWS RDS, worked on migrating teh on premise ETL Informatica application to AWS hosted Informatica application.
• Heavily interacted wif teh Source System owners and business users to gather requirements, design tables, standardize interfaces for receiving data from multiple operational sources, coming up wif load strategies of loading staging area and data warehouse.
• Experienced in Software Development Life Cycle (SDLC) wif good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Performed data analysis and data profiling using complex SQL on various sources systems.
• Excellent knowledge in preparing required project documentation and tracking and reporting regularly on teh status of projects to all project stakeholders.
• Conducted GAP analysis to analyze teh variance between teh system capabilities and business requirements.
• Worked extensively wif different source & target systems like XML, flat file, relational tables and message queues.
• Implemented Change Data Capture (CDC) Techniques and slowly changing dimensions (Type1, Type2 and Type3).
• Maintaining and updating teh Unix Shell Scripting used to create teh Audit, Balance and Control files for data extracts from multiple in-house and third party vendor databases.
• Experience in developing Test Strategies, Test Plans, Test Cases, Test Scripts and provided 24x7 production support.
• Knowledge in Hyperion Modules FCCS and PBCS
• Possess excellent interaction, communication and problem solving abilities.
• Strong experience in offshore and onsite coordination and Team Based Development Environment.
• Project Resource planning and allocation.

TECHNICAL SKILLS

ETL Tools: IICS Cloud Data Integration,Informatica Power Center 10.x/9.x/8.x, Informatica Power Exchange, Informatica Data Quality/Informatica Developer.

Data Modeling: Erwin, Star Schema Modelling, Snow Flake Modelling.

Databases: Oracle 8i/9i/10g/11g/12g, DB2, SQL Server, Teradata.

OLAP Tools: Business Objects, Cognos, Actuate.

CRM Tools: Salesforce(SFDC), PeopleSoft, Siebel.

Miscellaneous: Toad, SQL* Loader, Control-M scheduler, Windows, Unix, Linux, MS Office, Visio. Amazon RDS, S3, EC2, Lambda, GitHub, Bit Bucket,ALM,SharePoint

PROFESSIONAL EXPERIENCE

Confidential, Kenilworth, NJ

Senior ETL Informatica Consultant / Data Engineer

Environment: Oracle, Snowflake, Amazon RDS,S3,Informatica Intelligent Cloud Services(IICS),SharePoint,ALM,Remedy

Responsibilities:

• Worked wif Business Analysts to translate business requirements into design documents and source-to-target mapping documents that served as teh blueprint for ETL work.
• Involved wif data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked on POC to integrate Amazon S3 wif Informatica Intelligent Cloud Services(IICS) for processing multiple Parquet files, csv files to Snowflake
• Involved in creating Functional Requirements,Integration Design Documents, Development Test Plans,UAT Test Cases, Release and Validation Plans adhering to healthcare standards.
• Designed ETL process flows for entire applications and developed data mapping spreadsheets to define transformation rules for each stage of ETL process.
• Worked on IICS Data Integration between SharePoint,SalesForce and Snowflake using Data Synchronization,Mapping Tasks and Taskflows.
• Involved in performance optimization of IICS jobs.
• Written various unix scripts to handle pre and post data load tasks
• Converting source files from excel to csv,csv to Parquet files for large data volumes using Intelligent Structure Model transformation
• Creating SOP documents for Prod support teams.

Confidential - Portland, ME

Senior ETL Informatica Consultant / Data Engineer

Environment: Oracle, SQL Server, Amazon RDSInformatica Power Center 10.2, XML, SFDC, JIRA, Control-M, WinSCP, Amazon RDS, S3, EC2, Lambda, GitHub.

Responsibilities:

• Worked wif Business Analysts to translate business requirements into design documents and source-to-target mapping documents that served as teh blueprint for ETL work.
• Involved wif data profiling for multiple sources and answered complex business questions by providing data to business users.
• Prepared High Level Technical Design specification and Low-level specifications based on business requirements.
• Designed ETL process flows for entire applications and developed data mapping spreadsheets to define transformation rules for each stage of ETL process.
• Involved in teh full development lifecycle from Requirement gathering through Design, Build, QA, Deployment and Support using Informatica Power Center.
• Designed and developed teh Data integration framework and code base to integrate data from IFCS application to Business Connect (SFDC) application for EMEA and Chevron APAC clients.
• Worked on implementing hierarchy solution in SFDC BC applications Account object and other objects like Invoice, Account Receivables, Contacts, Security, Program and Dishonor.
• Fine-tuned teh SFDC BC ETL jobs and implemented teh Bulk load methodology in SFDC to ingest enormous amount of transactions into SFDC objects.
• Worked wif DBA for partitioning and creating indexes on tables used in source qualifier queries and tuning SQL to improve performance.
• Worked on generating Custom EDI files based on teh companion guide for different customers.
• Worked on migrating teh ETL Informatica code base from 9.6 on premise application to 10.2 AWS hosted application and configuring teh root /Cache/file/log/Parameter file directories accordingly.
• 24x7 production support for jobs running in teh production environment. Involved in debugging teh failed mappings identify teh root cause and developing error-handling methods.
• Work wif a team of architects and engineers to develop proof-of-concept components.
• Worked wif several heterogeneous sources and targets from various channels including JMS Message Queue, Oracle, XML files and flat files.
• Implemented various Performance Tuning techniques such as Pushdown Optimization and Partitioning. For reusability, Mapplets and reusable transformations has been created.
• Facilitated code reviews as a Lead consultant to ensure code quality worked and afted QA testers in testing teh ETL output.
• Extensively worked on XML Mappings to facilitate teh requirements and business case.
• Created mappings & Mapplets for data cleansing in IDQ/Informatica developer and used in Power Center.
• Worked on Informatica transformations including but not limited to SQL, XML, SFDC objects and Stored Procedure to facilitate teh business requirements.
• Created labels, deployment groups and worked on migrating teh code between different environments using deployment groups.
• Used team-based versioning to check all versions of teh objects used in creating teh mappings, workflows and to track teh changes in teh development and QA environments.
• Worked wif Change Management deployment team to migrate Informatica objects such as workflows, sharable sources & targets, parameter files from DEV environment to higher environments such as SIT, UAT and PROD.
• Worked wif Production Support team to schedule Informatica jobs using Control-M scheduler.
• Involved in unit testing of teh end-to-end flow and documented teh unit test case scenarios.
• Worked wif various off shore teams based out across Europe, New Zealand, Australia and India to deliver teh various project deliverables wif teh designated business clients.
• Manage all backup, restore and disaster recovery processes and procedures. This includes understanding how to execute all procedures and meet all related SLA’s
• Provide security administration support wif respect to users and privileges wifin all informatica domains

Confidential - Phoenix, AZ

ETL Informatica Consultant / Data Engineer

Environment: Oracle, DB2, SQL Server, Informatica Power Center 9.6, IDQ, Power Exchange, XML, Microsoft SQL Server Management Studio, Control-M, WinSCP.

Responsibilities:

• Worked wif Business Analysts to translate business requirements into design documents and source-to-target mapping documents that served as teh blueprint for ETL work.
• Involved wif data profiling for multiple sources and answered complex business questions by providing data to business users.
• Extensively worked on Power Center Client tools such as Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Implemented Slowly Changing Dimensions to store history according to business requirements.
• Implemented various Performance Tuning techniques such as Pushdown Optimization, Pass-Through Partitioning, Key range and Database partitioning.
• Responsible for four types of performance tuning Mapping Level, Session Level, Source Level, and Target level.
• Worked wif several heterogeneous sources and targets from various channels including Oracle, DB2 and flat files.
• Extensively worked on developing Real-time CDC Mappings to process teh Message queue data using transformations such as XML Parser, Router, Lookup, Update strategy and XML Generator.
• Work wif a team of architects and engineers to develop proof-of-concept components.
• Design/Develop teh ETL process framework to process Initial and Incremental load.
• Created labels, deployment groups and worked on migrating teh code between different environments using deployment groups.
• Created mappings, Mapplets for data cleansing in Informatica developer and used in Power Center.
• Used team-based versioning to check all versions of teh objects used in creating teh mappings, workflows and to track teh changes in teh development and QA environments.
• Worked wif Change Management deployment team to migrate Informatica objects such as workflows, sharable sources & targets, parameter files from DEV environment to higher environments such as SIT, UAT and PROD.
• Worked wif Production Support team to schedule Informatica jobs using Control-M scheduler.
• Involved in through unit testing of teh end-to-end and documented teh unit test case scenarios.
• Technical guidance and troubleshooting for teh team. Involved in Peer reviews.

Confidential - Portland, ME

ETL Informatica Consultant / Data Engineer

Environment: Oracle, DB2, SQL Server, Teradata, Informatica Power Center 9.6, IDQ, Power Exchange, XML, JMS, Control-M, WinSCP.

Responsibilities:

• Worked wif Business Analysts to translate business requirements into design documents and source-to-target mapping documents that served as teh blueprint for ETL work.
• Involved wif data profiling for multiple sources and answered complex business questions by providing data to business users.
• Performed data mining on Claims data using very complex SQL queries.
• Worked wif DBA for partitioning and creating indexes on tables used in source qualifier queries and tuning SQL to improve performance.
• Worked on Informatica transformations including but not limited to SQL, XML, SFDC objects and Stored Procedure to facilitate teh business requirements.
• Worked wif several heterogeneous sources and targets from various channels including JMS Message Queue, Oracle, DB2 and flat files.
• Worked on extracting teh Member data required for enrollments. Provider data for Billing, rendering, servicing providers, Claims data, Authorizations, Premiums.
• Extensively worked on developing Real-time CDC Mappings to process teh JMS Messages data using transformations such as XML Parser, Router, Lookup, Update strategy and XML Generator.
• Work wif a team of architects and engineers to develop proof-of-concept components.
• Design/Develop teh ETL process framework to process Initial and Incremental loads.
• Implemented various Performance Tuning techniques such as Pushdown Optimization and Partitioning. For reusability, Mapplets and reusable transformations has been developed.
• Worked wif different source & target systems like XML, flat file, relational tables and message queues (JMS).
• Implemented Slowly Changing Dimensions to store history according to business requirements.
• Used team-based versioning to check all versions of teh objects used in creating teh mappings, workflows and to track teh changes in teh development and QA environments.
• Worked wif Change Management deployment team to migrate Informatica objects such as workflows, sharable sources & targets, parameter files from DEV environment to higher environments such as SIT, UAT and PROD.
• Implemented Aggregate, Sorter, Router, Normalizer, Filter, Joiner, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Worked wif Production Support team to schedule Informatica jobs using Control-M scheduler.
• Involved in through unit testing of teh end-to-end flow and documented teh unit test case scenarios.
• Technical guidance and troubleshooting for teh team. Involved in Peer reviews.

Confidential - Phoenix, AZ

ETL Informatica Consultant / Data Engineer

Environment: Oracle, Informatica Power Center 8.6, Power Exchange, XML, Control-M, WinSCP.

Responsibilities:

• Extracted data from different data sources and loaded them into Oracle using Informatica Power Center.
• Created source and target definitions, mappings, transformations (re-usable).
• Used various transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router.
• Implemented SCD methodology including Type 1 and Type 2 changes.
• Developed several Workflows, Tasks, Sessions in Workflow Manager and scheduled them to run according to Load order.
• Created shortcuts, copies of Mappings, Workflows, various objects as per requirements and made use of shared folder objects.
• Involved in ETL processes from development to testing to production environments.
• Created Source-Target field mapping documents.
• Developed stored procedures to run as part of pre/post load process.
• Responsible for scheduling jobs and preparing technical documentation.
• Created Dimension tables, Fact tables, Aggregation tables.
• Used teh Repository Manager and Administrator Console to create users, folders and groups and providing teh required privileges.
• Responsible for verifying teh Source to Target data load.
• Responsible for implementing change requests and fixing defects, issues and failures.