SUMMARY:

• 12+ years of IT experience in Software Development Life Cycle - Requirement gathering, Analysis, Design, Development, Implementation, Testing and Maintenance of Data Warehouse applications across Finance, Insurance domains.
• Very strong in ETL-Informatica PowerCenter, Informatica Data Quality, Informatica Power Exchange (PWX), Informatica Cloud,Data Validation Option (DVO) for PowerCenter, Database Design and Programming.
• Having knowledge on Hadoop, Spark, Hive, HBase, Sqoop, Apache Kafka, Scala.
• Good experience in developing Perl, UNIX scripts, Windows batch scripts.
• Experienced in SAP-Business Objects, Informatica MDM, Informatica B2B DT&DE, Data Migration and Data Warehousing.
• Have knowledge on Ab Initio ETL tool transform Components Aggregator, Match sorted, Join, Denormalize sorted, Reformat, Rollup and Scan Components.
• Strong base in Financial (Credit Risk, Recovery), Banking and Insurance domains.
• Experience in understanding the Business requirements and translating them into detailed design along with Technical specifications.
• Developed several complex custom mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping designer using the Informatica PowerCenter
• Experience in Informatica Metadata and Repository Management, was directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Having experience in Informatica IDQ 9.6.1 for Analysis, data cleansing, data matching, data conversion, exception handling, reporting and to complete initial data profiling, matching/removing duplicate data. Implemented Address doctor validation using IDQ.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Good experience in Oracle Golden Gate CDC (Change Data Capture).
• Experience in Virtual Source Safe (VSS), Clear Case and TFS for version controlling and promoting the code to higher region.
• Extensive experience in Production Support participating with disciplines of supporting the IT systems/applications which are currently being used by the end users. Involved in performance tuning.
• Involved in Informatica upgrade from 8.x to 9.x and 9.x to 10.x
• Strong experience working with different RDBMS like Oracle, SQL Server, DB2 and with different file systems like Flat Files, COBOL VSAM files and XML Files both as Source and as well target.
• Checking data for inconsistencies through Data Validation Option (DVO) which is a ETL Testing tool which comes along with Power Center and enables to test and validate data.
• Created the Unit Test Case document and performed various testing like Unit Testing (UT) and System Integration Testing (SIT).
• Created the Deployment Plan and made use of versioning tool ClearCase.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC), Agile Methodology.
• Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

ETL: Informatica PC 8x, 9x& 10x, Informatica Data Quality (IDQ), Informatica MDM, Informatica DVO, Power Exchange Express CDC

Databases: Oracle v8-10g/11g, MS SQL Server 2008; 2012 and 2014, Teradata, Netezza, DB2

Languages: PL/SQL, SQL, UNIX Shell Scripting, Batch Scripting, C, C++Microsoft.Net Framework 4.0, Ant, Nant scripts, Python 2.7 programming

Methodologies: SDLC, Agile

Big Data Technologies: Hadoop Framework (HDFS, Map Reduce implementation), YARNSpark, Apache Nifi, Scala, Kafka, Hive, HBase, Pig, Sqoop, Storm, ImpalaFlume, Python, AWS.

Tools: /Applications: SAP Power Designer, Erwin, ClearCase, Remedy, JIRA, Toad, Zena, Autosys, Tidal, Control-M, SQL*Loader, Dataflux, VersionOne, FileZilla

Reporting Tools: SAP Business Objects

Environment: Windows ’95/98/NT/2000/XP’, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Designer &Technical Lead

Responsibilities:

• Played the role of a Program Technical Lead/ETL Architect and was responsible for designing the ETL Strategy & Architecture of the Project.
• Was responsible in managing tasks and deadlines for the ETL teams both Onsite and Offshore.
• Was the point person on the ETL team for other teams such as Reporting, Testing, QA and Project Management for updates on Project Status and issues.
• To get the Functional Requirement Specifications from customer and understand the same.
• Understand the debtor recovery, legal placement, payments functionality.
• Break up the work into task list and estimate based on simple, medium and complex methodology
• Interaction with business users and requirement gathering.
• High level & low-level ETL flow design, worked on detailed technical design.
• Give functional KT to the QA team.
• Was involved in conducting the review of Informatica Code, Unit Test Cases & Results with the Developers.
• Organize daily technical discussions with the Onsite team also including the individual offshore workstream leads and set expectations for offshore delivery.
• Involved in PoC for Big Data project to build data lakes to replace traditional Data Warehouse.
• Worked extensively with Sqoop for importing metadata from Oracle.
• Involved in creating Hive tables, and loading and analyzing data using hive queries.
• Developed Hive queries to process the data and generate the aggregated data for analytics.
• Implemented Partitioning, Dynamic Partitions, Buckets in HIVE.
• Consumed the data from Kafka using Apache spark.
• Implemented Real time Chang Data Capture (CDC) using Informatica Power Exchange.
• Implemented Chang Data Capture (CDC) using Informatica Power Exchange reading data from Oracle.
• Sourced transaction data being staged by Oracle Golden Gate tool CDC (Change Data Capture) through Informatica PowerCenter and loaded into the target based on the DML action indicated by Golden Gate.
• As a Senior Data Quality developer, have initiated the process of Data profiling by profiling different formats of data from sources like flat file and Oracle.
• Analysed the dimensions to find its actual structure and the rules which are implemented as part of Standardization.
• Validation, Standardization and Cleansing of data were done in the process of implementing the business rules.
• Created business rules in Informatica Developer and imported them to Informatica power center to load the standardized and good format of data to staging tables.
• Used Data processor transformation to read data from PDF and create xml file.
• Extensive experience in developing complex mappings from varied transformations like Source Qualifier, Connected and Unconnected lookups, Router, Filter, Sorter, Expression, Aggregator, Joiner, Union, Update Strategy, Sequence Generator, Java Transformation etc.
• Creation of Sessions and Workflows to schedule these mappings.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Creation of Unit Test cases and Integration test cases
• Perform unit testing of these Workflows from source to staging and staging to Warehouse of data warehouse
• Reconciliation and evidence creation.
• Analysis & fix on QA defects made by QA team.
• Involved in Unit testing and UAT defect fixing.
• Worked on sessions partitioning and mappings performance tuning.
• QA & Production deployment.
• Analyse the power shell scripting and covert the same to Informatica mappings.

Environment: Informatica 9.x and 10.x, Infromatica Data Quality,Oracle, PL/SQL, SQL Server 2014, Power Centre DVO, Data Flux, Toad, Remedy, HP Quality Center, VersionOne, Power Exchange Express CDC, Toad, FileZilla

Confidential, Newton, NJ

Informatica Designer &Technical Lead

Responsibilities:

• Drive key initiatives/projects to completion and ensure deliverables meet business needs.
• Involved in gathering business requirements and attended technical review meetings to understand the data warehouse model.
• Responsible for end-to-end ETL and Database design, modelling and Informatica design.
• Developed technical specifications of the ETL process flow.
• Interact with upstream and downstream application teams.
• Validation, Standardization and Cleansing of data were done in the process of implementing the business rules.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Designed reference data and data quality rules using IDQ and involved in cleaning the data using Informatica Data Quality environment.
• Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
• Implemented IDQ Address standardization mapplets to standardize, validate and format client’s addresses for marketing purposes.
• Used Data processor transformation to read data from relational and create JSON file.
• Provide on-going feedback and status of projects to IT and business areas, identifying any variances to plan and proposing solutions and alternatives for the variances.
• Provided technical leadership to the team in order to produce system designs for the framework and code that are scalable, robust, reusable and flexible.
• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.

Environment: Informatica 9. x and 10.x, PL/SQL, SQL Server 2008,2012, IBM Netezza, Informatica Data Quality (IDQ), Power Centre DVO, Zena, Toad, Remedy, HP Quality Center.

Confidential

Sr ETL Developer/ Project Lead

Responsibilities:

• Designed Source to Target Mapping specification Documents.
• Maintained Type II Slowing Changing Dimensions using Lookup Transformations and Update Strategy Transformations.
• Extensive use of SQL and PL/SQL in developing complex Stored Procedures and Functions
• Developed modules to extract, process & transfer the customer data using Teradata utilities.
• Performed all work within the Teradata RDBMS environment using Queryman 6.0.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Involved in loading of data into Teradata from legacy systems and flat files using complex scripts.
• Coordination with Admin Team for deploying code in all upper environments.
• Created mappings for various sources like Oracle, SQL server, flat files and Oracle Database to load and integrate data to warehouse.
• Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.
• Implemented lookups and different transformations in the mappings.
• Have implemented SCD (Slowly Changing Dimensions) Type I and II for data load.
• Worked with creating Dimensions and Fact tables for the data mart. Created Informatica mappings, sessions, workflows, etc., for loading fact and dimension tables for data mart presentation layer.
• Extensive use of SQL and PL/SQL in developing complex Stored Procedures and Functions
• Involved in Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, and Performance Testing.
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Provided production support by monitoring the processes running daily.
• Build, unit test and deployment automation to streamline a repeatable development & test process - regardless of technology.
• Build, Automate, unit test case using Power Centre Data Validation Option.
• Worked closely with reporting team and helped them whenever they had any ETL issues.
• Involved in Informatica upgrade from 8.x to 9.x
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.

Environment: Informatica PowerCenter 8.x and 9.x, Oracle 11g, Teradata, TOAD, Jira, Remedy PL/SQL, Flat files, Sybase, UNIX Shell Scripting and SAP Business Objects.

Confidential

Informatica Developer

Responsibilities:

• Analysis of Business & Technical Requirements.
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Coordination with on-site team to understand the requirements.
• Preparation of the estimates, time lines of the deliverables and project execution plan.
• Prepare and validate product architecture and design model.
• Coordinating with the support and development team by explaining them the business functionality and assisting them in coding and testing the application programs.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.
• Created complex workflows, with multiple sessions, Worklets with consecutive or concurrent sessions.
• Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.
• Used Informatica reusability at various levels of development.
• Resolve issues for team members through proper channels on time.
• Documented ETL test plans, test cases, test scripts and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• 24/7 Credit Risk Application support

Environment: Informatica PowerCenter 8.x and 9.x, Oracle 11g, Jira, Remedy, TOAD, PL/SQL, Flat files, Sybase, UNIX Shell Scripting and SAP Business Objects.

Confidential

Informatica Developer

Responsibilities:

• Involved in gathering requirements from key credit risk business stakeholders.
• Prepared technical and functional designs in collaboration with teams and business users.
• Maintained program documentation, operational procedures and user guidelines as per client requirements.
• Implemented Slowly Changing Dimension methodology for Historical data.
• Coordinated with technical team members for coordination and conducted system integration testing services.
• Developed data warehouse solutions and application by translation of business and functional needs.
• Developed Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Responsible for continuous integration and overnight builds in ETL and Database technology forte and working towards zero broken builds.
• Build, unit test and deployment automation to streamline a repeatable development & test process - regardless of technology.
• Provide on-going feedback and status of projects to IT and business areas, identifying any variances to plan and proposing solutions and alternatives for the variances.
• Worked with XML sources, used the XML Parser transformation.
• Responsible for end to end ETL batch process in all lower environments (Test & Development) and thereby ensuring environment availability to Testing team.
• Analysis of Data related queries from Business key stakeholders.
• 24/7 Credit Risk Application support

Environment: Informatica PowerCenter 8.x and 9.x, Oracle 11g, Jira,Remedy, TOAD, PL/SQL, Flat files, Sybase, UNIX Shell Scripting and SAP Business Objects.

Confidential

Informatica Developer

Responsibilities:

• Involved in developing mappings using ETL tool-Informatica for data flow from Source system to Target.
• Worked on Joiner, Filter, Router, Expression, Lookup and Aggregation transformations.
• Creating solution documents for developed mappings.
• Involved in requirement gathering, mapping the solutions as part of solution workshop, and testing the solutions.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Documented ETL test plans, test cases, test scripts and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• L3 support-monitoring the ETL jobs, send notification mails after completion of jobs, provide fix for the issues raised by users.
• Single point of contact for database related issue.
• Used Import and Export Utilities to maintain the data effectively.

Environment: Informatica PowerCenter 8.x, Oracle10g, Jira, Remedy, TOAD, PL/SQL, Flat files, Sybase, UNIX Shell