SUMMARY

• Around 6+ years of work experience in designing and developing Data warehouse applications with special emphasis on Design and Development of Data Warehousing Concepts.
• Expert in all phases of Software development life cycle(SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Data Integration from Confidential, Databases like Oracle,DB2, SQL Server, Postgres etc.
• Defined development standards focusing on different types of data load strategies, performance, reusability, parameters, self-healing capability, balancing & controls, reasonability checks, error-handling with proper data lineage and thresholds, and housekeeping.
• Experienced in DB packages, procedures, triggers, views, indexes, and partitions.
• Written PL/SQL test cases and performed functional and non-functional testing.
• Extensively worked in ETL process consisting of data transformation, data sourcing, mapping, conversion, and loading.
• Strong experience with Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Workflow Manager/Monitor and Server tools - Informatic Server, Repository Server manager.
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access. Strong knowledge of writing simple and Complex Queries in various databases like Oracle, Teradata, My SQL, DB2 and SQL Server.
• Proficient in creating UNIX Shell Scripts.Excellent communication skills and co-ordination with project managers, business analysts, architects, DBA’s and Developers and also experience with SFTP and SCP for SSH file transfers.
• Good knowledge in several facets of MDM implementations, including data profiling, data migration, data validation, real time and batch data Integration, pre-landing processing and custom data publishes.
• Strong background in MDM hub configuration in creating and modifying base objects, staging tables, mappings, cleanse functions, trust, validation rule setup, match & merge configuration, message triggers, hierarchies etc.
• Good experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in Different databases.
• Extensive experience in data profiling, data migration from various legacy sources and relational systems to OLAP and decision support target systems.
• Good knowledge on Informatica Power Exchange. Proficient inRelational Database Management System(RDBMS).
• Strong experience working in data migration and conversion projects. Expertise inData Quality (IDQ) tool and Standardization, Address Validation and Deduplication.
• Having Good knowledge on Informatica IICS which helps teh cloud can drive innovation, uncover efficiencies, and help redefine business processes.
• Having Good Knowledge on Big Data Management (BDM) and worked with upstream Data Lake team for ingesting teh data into teh pods.
• Having good knowledge on Integration Cloud (IICS) which provides teh ability to move and migrate existing enterprise business applications to public and private cloud solutions as well as allowing for continued co-existence with on-premises applications and systems.
• Having knowledge on business objects in Data Integrationconcepts in large scale implementation environments.Proficiency in developing complex mappings using Informatica and Change data capture (CDC), Data Cleansing, slowly changing dimensions (SCD) types 1&2.
• Database experience using DB2,Oracle 12g/11g/10g/9i, MS SQL Server 2000 and MS Access.
• Good knowledge of Data warehouse concepts, Data modelling principals - Star Schema, Snowflake, Normalization/De-normalization. Knowledge on Phyton Scripting
• Expertise in usingglobal variables,expressions,andfunctionsfor teh reports with immense experience in handling sub reports inSSRS.
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, DB2, flat files into teh staging area and Design ETL processes that span multiple projects.
• Experience in working in a Multi-Dimensional Warehouse projects. Experience in reading and loading high-volume Type 2 dimensions by implementing SCD (Slowly Changing Dimensions).
• Expertise in OLTP/OLAP System Study, Understanding E-R modelling andDimensional Models using Star schema and Snowflake schema techniques.
• Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges, and folders.

TECHNICAL SKILLS

ETL Tools: Informatica Power Centre 10.1/9.6/9.5/9.1, Informatica Power Exchange 9.1/8.6, IICS, IDQ 10.1.1/9.5.1, MDM (10.x/9.x).

Databases: Oracle 12g/11g/10g/9i, DB2, MS SQL Server (2012, 2008, 2005)

Other Tools: Winsql, TOAD, MLOAD, Erwin 4.x/3.x, SQL, XMLPad, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer

Languages: SQL, PL/SQL, Linux, UNIX Shell Scripting, Unix Commands.

Scheduling tools: Autosys, Control-M,ESP

Operating Systems: Windows Server 2008/2003, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Informatica Developer and Production Support

Responsibilities:

• Understood teh Business point of view to implement coding using Informatica power center designer. Used InformaticaPower Center 10.2 for retrieving data from Oracle Databases.
• Involved in development of ETL loads and Business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems.
• Debugging invalid mappings using breakpoints, testing of stored procedures and functions, testing of Informatica sessions, batches, and teh target Data.
• Created Mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Designed and developed teh logic for handling Slowly Changing Dimension tables load by flagging teh record using update strategy for populating teh desired.
• Developed reusable mappletsand transformations for reusable business calculations.
• Used exception handling logic in all mappings to handle teh null values or rejected rows.
• Tuned teh ETL components to gain teh performance and to avoid business continuity.
• Worked with Persistent Caches for Conformed Dimensions for teh better performance and faster data load to teh data warehouse.
• Involved in performance tuning and optimization of Informatica Mappings and Sessions using partitions and data/index cache to manage very large volume of data.
• Performed query overrides in Lookup Transformation as and when required to improve teh performance of teh Mappings.
• Identified sources, targets, mappings, and sessions and tuned them to improve performance. Created and scheduled Sessions, Jobs based on demand, run on time, and run only once using Workflow Manager.
• Developed SQL and PL/SQL scripts to validate and load data int interface tables using SQL Loader. Performed strategies for incremental data extraction as well data migration to load data into Teradata.
• Developed ETL programs using Informatica to implement teh business requirements. Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.

Environment: PL/SQL,Informatica Power Centre 10.2, TFS, MS SQL SERVER 2000, SQL,UNIX Shell Script, Tidal,Gitlab, Informatica Workflow Manager, Power Centre Designer, Oracle 12g.

Confidential, Dearborn, MI

Informatica Developer and Production Support

Responsibilities:

• Understood teh Business point of view of teh dataflow in all teh regions and supported teh flow.
• Monitoring different applications Scheduled Jobs and their run cycles and their batch processing in teh production environment.
• Analysing different Job failures and long running issues and working on teh resolution steps by restarting teh failed session in informatica.
• Identified sources, targets, mappings, and sessions and tuned them to improve performance. Created and scheduled Sessions, Jobs based on demand, run on time, and run only once using Workflow Manager.
• Performance tuning using Informatica partitioning. Involved in Data Base Tuning. Written UNIX Shell Scripts for various purposes in teh project.
• Developed SQL and PL/SQL scripts to validate and load data int interface tables using SQL Loader.

Environment: PL/SQL,Informatica Power Centre 9.8, MS SQL SERVER 2000, SQL,UNIX Shell Script, Tidal, Informatica Workflow Manager, Power Centre Designer, Oracle 12g.

Confidential, Bloomfield, CT

Informatica Developer and Production Support

Responsibilities:

• Understood teh Business point of view of teh dataflow in all teh regions and analysed teh flow.
• Monitoring different applications Scheduled Jobs and their run cycles and their batch processing in teh production environment.
• Analysing different Job failures and long running issues and working on teh resolution steps by restarting teh failed session in informatica.
• Extract data from Hadoop layer using Hadoop tools such as Hive, Impala and generate reports.
• Analysing different incident tickets coming from different teams and giving them appropriate results or steps to resolve teh incident.
• Used Linux servers to check teh data which is coming as flat flies and raw files.
• Involved in production releases/outages and worked on holding and resuming teh jobs for teh deployment part in production.
• Generated Different production reports using SQLs andDB2 database, which will help in analysing teh data flow in different source and target regions.
• Generated reports using Phyton Scripts.
• Involved delivery team when and where there is a code fix or improper data flow.
• Used GitLab to analyse teh YAML configurations for each table that needs to be published in teh target and they are generated as Kafka topics as Avro files.
• Used Cloudera Manager and Linux Open shift to monitor and to check teh logs, Kafka topics and Pods.
• Used Splunk enterprise to monitor teh Logs in different regions.
• Involved in automating some reports which will reduce further analyse.
• Involved DBA to kill teh sessions which are long running SQLs and worked on workaround steps to resolve teh issues.

Environment: PL/SQL,Informatica Power Centre 10.1, SQL, UNIX Shell Script,DB2, Main frames, Informatica Workflow Manager, Power Centre Monitor, ESP, Hive, Impala, Cloudera manager, Open Shift, Gitlab.

Confidential, Windsor, CT

PL/SQL, Informatica Developer

Responsibilities:

• Developed data mappings between source systems and target system using Mapping Designerand Stored Procedures for teh business requirements.
• Developed shared folder architecture with reusable Mapplets and Transformations.
• Created batch jobs for Fast Export.
• Defined and executed manual test cases which test all aspects of teh component under development.
• Increased use of automating testing, developing automated tests for components of an application
• Ensures accuracy and integrity of data and applications through analysis, coding, profiling, and problem resolution.
• Extracted teh raw data from Microsoft Dynamics CRM to staging tables using Informatica Cloud.
• Developed Cloud mappings to extract teh data for different regions (Asia and America).
• Refreshing teh mappings for any changes/additions to CRM source attributes.
• Developed teh audit activity for all teh cloud mappings.
• Automated/Scheduled teh cloud jobs to run daily with email notifications for any failures.
• Generated automated stats with teh staging loads comparing with teh present day counts to teh previous day counts.
• Extracted teh raw data from Microsoft Dynamics CRM to staging tables using Informatica Cloud (IICS).
• Developed Cloud mappings to extract teh data for different regions
• Worked with QA team for testing after integration.
• Created Business Objects as per teh requirement using informatica.
• Created ESP jobs to setup teh dependency between Cloud and PowerCenter jobs.
• Identified problems and seeks assistance with solution implementation.
• Provided technical knowledge and subject matter expertise as required. Adheres to detailed deployment plans, schedules, timelines, and milestones.
• Extensively used ETL Tool Informaticato load data from Flat Files, Oracle,DB2, SQL Server and mainframes etc.
• Prepared Conceptual Solutions and Approach documents.
• Worked with XML, Flat file connectors.
• Created profile, rules and mappings with InformaticaDeveloper and Analyst Tool.
• Strong in implementation of data profiling, creating score cards, creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
• Worked with Informatica Data Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities using IDQ 9.6.1.
• Performed teh data profiling and analysis making use of Informatica Data Quality (IDQ).
• Worked on different transformations like case converter, standardizer, labeler etc for cleansing and standardize teh data.
• Created Profiles using IDQ rules and filters. Applying cleansing rules using IDQ.
• Prepared Business Requirement Documents, Software Requirement Analysis and Design Documents (SRD) and Requirement Traceability Matrix for each project workflow based on teh information gathered from Solution Business Proposal document.
• Data modelling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables also used Phyton Scripting.
• Created SSIS ETL packages to get data from different sources like Flat files, MS Excel, MS Access.
• Involved in Migration projects to migrate data from data warehouses on Oracle/DB2.
• Responsible for optimization of SQL queriesand SSIS Packages.

Environment: PL/SQL,Informatica Power Centre 10.1,IDQ 9.6.1, MS SQL SERVER 2000,SQL,DB2 mainframes, UNIX Shell Script, ESP,Gitlab, Informatica Workflow Manager, Power Centre Designer, IICS, Oracle 12g.

Confidential, SFO, CA

Informatica Developer

Responsibilities:

• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and to successfully implement business logic.
• Understood teh Business point of view to implement coding using Informatica power center designer. Used InformaticaPower Center 10.1 for retrieving data from Mainframe system.
• Involved in development of ETL loads and Business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems.
• Debugging invalid mappings using breakpoints, testing of stored procedures and functions, testing of Informatica sessions, batches, and teh target Data.
• Identified sources, targets, mappings, and sessions and tuned them to improve performance. Created and scheduled Sessions, Jobs based on demand, run on time, and run only once using Workflow Manager.
• Developed SQL and PL/SQL scripts to validate and load data int interface tables using SQL Loader. Performed strategies for incremental data extraction as well data migration to load data into Teradata.
• Developed ETL programs using Informatica to implement teh business requirements. Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensionsand Fact tables.
• Implemented different Mappings with teh collection of all Sources, Targets, and Transformations using Designer.
• Converted specifications to programs and data mapping in an ETL Informatica Cloud environment.
• Worked on complex T-SQL Query and Stored Procedure to identify items that could be converted to Informatica Cloud ISD.
• Used Cloud Services to highly scalable parallel data integration architecture, that streamlines and automates parallel loading into Amazon Redshift cluster optimizing with both ETL and ELT (pushdown optimization).
• Used Informatica Intelligent Cloud Services to work on Cloud Based service that enables visual design, development and deployment of data integration mappings
• Implemented Conceptual, Normalized/Denormalized Logical and Physical data models to design OTLP and Data warehouse environments.
• Assists in design, development and implementation of end-to-end complex MDM system using Informatica tools.
• Plan and contribute to MDM development efforts for team utilizing informatica tools.
• Produce written deliverables for technical design, system testing and implementation activities.
• Installation of MDM on databases Oracle, SQL Server and on Application server.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 12g RDBMS in accordance with requirements and specifications.
• Designed and developed mapplets and re-usable transformations and used them in different mappings.
• Experience developing and supporting complex DW transformations. Creating Reusable Transformations and Mapplets in a mapping.
• Good experience working on SFTP and SCP for SSH file transfers.
• Developed Conceptual, normalized Logical and Physical data models to design OTLP and Data warehouse environments.
• Used ETL process to load data from multiple sources to staging area (Oracle12g) using InformaticaPower Center 10.1Created Mapplets and used them in different Mappings.
• Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads, and process flow of teh mappings.
• Performance tuning using Informatica partitioning. Involved in Data Base Tuning. Written UNIX Shell Scripts for various purposes in teh project.

Environment: Informatica Power Center 10.1, Oracle 10g, MS SQL SERVER 2000, Teradata, Control M, SQL, PL/SQL, SQL*Loader, UNIX Shell Script,Informatica Workflow Manager, Power Center Designer, IICS, Oracle 12g.

Confidential, Merrimack, NH

Informatica Developer

Responsibilities:

• Responsible for Internal Delivery of ETL code from Development/Testing and Implementation phases.
• Extensively developed various mappings incorporated business logic, which performed Extraction, Transformation and Loading of source data into OLAP schema.
• Created Several Informatica Mappings to populate teh data into dimensions and fact tables. Worked on DataHub configurations - Data modeling & Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director (IDD).
• Involved in teh development of Informaticamappings and Mapplets and tuned them for optimum performance, Dependencies and Batch Design.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Understand teh business rules completely based on High Level document specifications and implements teh data transformation methodologies.
• Involved in implementing teh Land Process of loading teh customer data set into informatica from various source system.
• Knowledge of Identifying Facts and Dimensions tables. Involved in understanding of Business Processes, identification of dimensions and measures for OLAP applications.
• Experience in writing, testing and implementation of teh PL/SQL triggers, stored procedures, functions and packages.
• Extensively worked on developing and debugging Informatica mappings, Mapplets, sessions and workflows.Experienced with creating Unit Test Cases for mapping and code reviews.
• Loading data from different sources like relational Tables and Flat Files to Target Data warehouse.Used Slowly Changing Dimensions (SCD 1 and SCD 2) techniques to load teh conformed dimensions.
• Worked with various Informatica client tools like Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, InformaticaRepository Manager and Workflow Manager.

Environment: InformaticaPower Centre 9.5/9.5, ETL, Oracle 11g, Teradata, XML, SSRS, MS SQL Server, Flat Files, ETL, PL/SQL, Oracle, Control M Excel source files, XML files, Unix Shell Scripts.

Confidential

SQL Developer

Responsibilities:

• Created/ modified SQL Queries better performance tuning on analyzed existing code for better outcome.
• Performed End-to-End Testing, troubleshooting, debugging, integration testing and performance testing and analyzed teh results to justify teh validation.
• Works with business analysts to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses.
• Designs and develops database applications using SQL Server Integration Services, TSQL and Stored Procedures. Developed User Defined Functions and created Views.
• Created Triggers to maintain teh Referential Integrity. Implemented Exceptional Handling. Worked on client requirement and wrote Complex SQL and PL/SQL Queries to generate Reports.
• Collaborates with business analysts, source system experts, and other team members to determine data extraction and transformation requirements.
• Involved in performing database Backup and Recovery. Collaborate with IT operations for support in problem resolution and root cause analysis.
• Supports IT staff and business users in teh development, usage and troubleshooting of database-driven applications. Participates in special projects as needed and performs other duties as assigned.

Environment: Oracle 9i, Reports 6i, Forms 6i, SQL* loader, Oracle SQL Developer PL/SQL, SQL*Plus.