SUMMARY:

• Around Nine years of IT experience in developing, maintenance and enhancement projects in Data Integration, Data Migration and Data Warehouse technology solutions.
• Experience in Architecting, Designing and Building Enterprise Data Warehouses, Operational Data Stores and Data Marts.
• Involved in end to end Data Warehouse Life Cycle implementations. Worked on both Data Management and Reporting & Analytic initiatives
• Extensively worked on Data Warehouse environments with domain knowledge in Insurance, Banking and Tele - Communication.
• Informatica (Data Integration): 8 plus years of experience in Data Warehousing and Extraction, Transformation, Loading (ETL) of data from various sources into Data warehouse and Data Mart using Informatica Power Center 10.1.1/, 9.6/9.1/8.6/8.1/7.1.1.
• Extensively used Informatica PowerCenter and Informatica Data Quality (IDQ) 9.6/9.1 as ETL tool for extracting, transforming, loading and cleansing data from various source data inputs to various targets,
• Integrated Informatica data quality mappings with Informatica powercenter.
• Data Modeling: 3 years of Dimensional Data Modeling experience on Data modeling, Erwin 4.5/4.0, Dimensional Modeling, Ralph Kimball & Bill Inmon Approaches, Star/Snowflake Modeling, DataMarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions)
• Database(Oracle, DB2): Seven plus years of RelationalDatabase experience using Oracle 11g/10g/9i
• Experience in working with databases like MS SQL Server 2000/2005, DB2, SQL, PL/SQL, SQL*Plus, SQL*Loader. Well versed in using TOAD, PLSQL Developer 3.0 interfaces
• Expert in Tuning Oracle SQL, PL/SQL Database Objects.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 9.x.,8.x
• Worked E2E in DWH (From installation of Informatica to Reporting using OBIEE 11g)
• Expert in the development of stored Procedures, Functions, Packages and Triggers.
• Experience in development of database objects like tables, indexes, Materialized Views, Procedures and synonyms.
• Experience in Query Optimization, Debugging, Tuning and improvising performance of the database, using the Oracle tools like Oracle Hints and Explain Plan etc.
• Strong PL/SQL programming skills and expertise with SQL tuning, performance tuning and Bulk binding techniques.
• Programming: Well experienced in UNIX shell scripting, PL/SQL.
• Expertise in preparing Functional & Technical Specifications besides User Guides.
• Experienced in Coordinating and leading off shore Development team.
• Expertise in Off-shore/On-site work culture, leading and mentoring Data Warehouse teams.
• Worked extensively on agile projects - multiple projects with release timeliness defined.
• Provided 24 x 7 supports for the projects during go-live and post production support activities.
• Excellent interpersonal and communication skills, technically competent and result- oriented with problem solving skills and ability to work independently and use sound judgement.
• Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents
• Completed POC project successfully on HDFS framework using Hive, PIG, Spark.

TECHNICAL EXPERTISE:

ETL Tools: Informatica Power Center, Informatica Cloud OBIEE 11g

Databases/Applications: Oracle 11g/10g/9i, DB2, MY SQL,SQL Server 2000/2005,AWS Redshift,Salesforce(Veeva)

Languages: PL/SQL, Unix, Shell Scripting.Python,Hive

Utilities: Putty, HP Quality Center, TOAD, SQL Developer, Winscp, Confidential Remedy, Github

Operating Systems: Unix, Linux, Windows 7, XP, NT,2000 Server/Professional DollarU,Autosys

EXPERIENCE SUMMARY:

Confidential

Integration Lead/Architect

Responsibilities:

• Working with client SME to gather requirements and participating in design and architecting discussions.
• Working as Salesforce Integration lead using Informatica Power Center, Informatica Cloud for extract, transform and load (ETL) purposes from and to databases like Oracle and cloud data warehouse services like Amazon RedShift.
• Preparing technical design/specifications for data Extraction, Transformation and Loading for integrations with various down streams and up streams.
• Using Unix Shell Scripts to automate pre-session and post-session processes.
• Working on improving performance using AWS Redshift using Unload like utilities.
• Scheduling and Designing the best possible flow of jobs using Autosys
• Designing the replication and staging layers for Salesforce application objects in Oracle Database.
• Validating Data in different layers and reviewing on data reconciliation results.
• Working in Onshore-Offshore model.

Environment: /Tools: Informatica PowerCenter10.x, 9.x,, PL/SQL, Oracle, UNIX, Shell Scripting, HP Quality Center, SQL Workbench, Autosys,AWS Red shift, Salesforce(veeva).

Confidential

DWH/Informatica Architect

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation and Loading
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Data modeling of 3 business event/process in the datawarehouse, data mart and staging layers (with delta detection), Oracle E-Business Suite Module Involved:
• Integration of the data sources Salesforce, oracle, SQL Server through ODBC (SQL Server) and flat files (external tables), OMB scripting, dimension modeling.
• Migration of the current environment, release management, repository data modeling against the databases (Oracle, SQL Server) and Excel Files using data federation, level-based measures and AGO functions, usage tracking installation and dashboard design.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process .
• Performed the roles of ETL Informatica and Data Quality (IDQ) Lead on a data warehouse initiative and am responsible for requirements gathering, preparing mapping document, architecting end to end ETL flow, building complex ETL procedures, developing strategy to move existing data feeds into the Data Warehouse (DW), perform data cleansing activities using various IDQ transformations.
• Design Changes at application level as Client is replacing GuideWire PC with legacy systems.

Environment: /Tools: Informatica PowerCenter10.x, 9.x, IDQ 9.x, PL/SQL, DB2, UNIX, Shell Scripting, HP Quality Center, Toad, Autosys,RDBMS like Oracle,SQL Server,DB2.

Confidential

Informatica Technical Lead

Responsibilities:

• Salesforce, iCatch are our sources. We pull the data from multiple sources and load into Staging tables for reporting
• Developed all the objects (entities) existing in Salesforce in MySQL DB
• Thorough Testing and Reviews have been made
• Lead for Production Support Team
• Successfully made production releases and deployments every month
• Batch job monitoring (24x7) including Month End, Quarter End and Year-End Support.
• Integrated & Imported data from various Sources transformed, loaded into Data Warehouse Targets using Informatica
• Participate in performance tuning of jobs, which have shown degradation in performance or have started to impact SLAs.
• Involved in testing Phase of UAT (User Acceptance testing)
• Ensuring the quality of the deliverables
• Preparing and reviewing various project documents and sharing the same with the customers.
• Worked as POC for development activities like documentation to describe program development, logic, coding, testing, changes and corrections. Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions
• Requirement Analysis, Impact analysis, Design and Development of Modules.
• Creating procedures, function, packages, ETL Mappings, Sessions, workflows and XML's.
• Performance Tuning for the queries which are taking lot of time to execute.
• Assign tasks to the offshore team, review the code.
• Creation of Test data and Testing.
• Coordinating with On-site counterparts.
• Responsible for all deliverables from offshore and onsite.
• DataMarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Extensively used database objects like tables, Index, views, Materialized Views triggers, Packages, functions and procedure.
• Expertise in preparing Functional & Technical Specifications besides User Guides.
• Experienced in Coordinating and leading off shore Development team.
• Expertise in Off-shore/On-site work culture, leading and mentoring Data Warehouse teams.

Environm ent: Informatica Cloud with SFDC, Windows 7, MY SQL

Confidential

ETL/ BI Reporting Developer

Responsibilities:

• Installation and Configuration of OBIEE 11g, Informatica 9.0.1 HF2, OBIA 7.9.6.3
• Taking regular rpd backups in OBIEE and repository backups in Informatica.
• Understanding the specification and analyze data according to client requirement.
• Gathering the requirements from several source components like CRM, BRM,DMS,Portal etc and designing the data Model to meet the customer required reports
• Developing SCD type 2 mappings for Dimensions
• Incremental load mappings for fact tables and summary tables
• Developing reports in analytics according to report requirements.
• Presenting reports to client and giving Knowledge Sharing sessions to Clients on adhoc reporting
• Provided the secure reporting to clients.
• Created and scheduled Sessions and Batches through the Informatica Server Manager.
• Worked with sessions and batches using Server Manager to load data into the target database.
• Testing for Data Integrity and Consistency
• Developed complex mappings in Informatica Power Center to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
• Created and scheduled Sessions and Batches through the Informatica Server Manager.
• Designed and documented validation rules, error handling and test strategy of ETL process

Environment: Informatica PowerCenter 9.1, OBIEE 11g, Oracle 11g,TOAD, HP AIX UNIX,OBIA 7.9.6.3

Confidential

ETL/ Developer- Admin

Responsibilities:

• Scheduled ETL’s through cronjobs in LINUX.
• Automating all the possible manual procedures related to job monitoring
• Worked in Production Support
• Worked on Pre-Prod Environment Configurations (like Unix, Informatica)
• Monthly Releases
• Batch job Monitoring
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Worked with XSD and XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used de bugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process

Environment: Informatica Power center 8.6.1, Oracle 10g, Unix, SQL, PL/SQL, Flat files, Confidential Remedy tool,Dollar U