SUMMARY

• 11+ years of IT experience in Software Development Life Cycle - Requirement gathering, Analysis, Design, Development, Implementation, Testing and Maintenance of Data Warehouse applications across Telecom, Energy and Finance domains.
• Very strong in ETL-Informatica PowerCenter, Informatica Data Quality, Informatica Power Exchange (PWX), Informatica Cloud for PowerCenter, Database Design and Programming.
• Having knowledge on Hadoop, Spark, Hive, HBase, Sqoop, Apache Kafka, Mango DB.
• Good experience in developing UNIX scripts, Windows batch scripts.
• Experienced in SAP-Business Objects, IBM Cognos, 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 Telecom billing Systems, BSS, OSS, General Ledger and Banking domains.
• Experience in understanding theBusiness requirementsand translating them intodetailed designalong with Technical specifications.
• Developed several complex custom mappings in Informatica with a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping designer using the Informatica PowerCenter
• Experience inInformatica MetadataandRepository Management and was directly responsible for theExtraction, TransformationandLoadingof data from Multiple Sources to Data Warehouse.
• Having experience in InformaticaIDQ 9.6.1for Analysis, data cleansing, data matching, data conversion, exception handling, reporting and to complete initialdata profiling, matching/removing duplicate data. Implemented Address doctor validation using IDQ.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in Tortoise SVN, Clear Case 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 likeOracle, Tera data, SQL Server with different file systems likeFlat Files, COBOL VSAM files and XMLFiles both as Source and as well target.
• Checking data for inconsistencies throughData Validation Option (DVO) which is a ETL Testing tool which comes along with Power Center and enables to test and validate data.
• Developed Informatica Cloud mappings to extract the data for Amazon S3, Amazon RDS and load Amazon RedShift.
• Created theUnit Test Casedocument and performed various testing likeUnit Testing (UT) and System Integration Testing (SIT).
• Created theDeployment Planand made use of versioning toolTortoise SVN.
• Hands on experience in all aspects ofSoftware 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 Cloud, Informatica MDM

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

Languages: PL/SQL, SQL, UNIX Shell Scripting, Batch Scripting

Methodologies: SDLC, Agile

Big Data Technologies: Hadoop Framework (HDFS, Map Reduce implementation), YARNHive, Impala

Cloud Technologies: Amazon S3, EC2 and Redshift, Informatica Cloud, Salesforce

Tools: /Applications: SAP Power Designer, Erwin, Remedy, JIRA, Toad, Control-M, SQL*Loader

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 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.
• 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 creating source queries to read the data from data lake Hive tables and loading and analysing 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.
• 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.
• 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.
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Expertise inDynamic SQL, CollectionsandException handling.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Creation and review 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 10.x, Oracle, PL/SQL, Toad, JIRA,CA Agile, Hive, Impala

Confidential

Informatica Designer &Technical Lead

Responsibilities:

• Drive key initiatives/projects to completion and ensure deliverables meetbusiness 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.
• 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.
• Worked as technical module lead through all the phases such as data analysis, development, testing and production.
• Provided end-to-end solution for various modules that includes the Informatica flows and database implementation. ·
• Handing performance improvement tasks, which involved optimization at Informatica and database level. ·
• Designed and developed solution to pull data from various source systems such as OLTP and other legacy systems to load data into EDW (Enterprise Data warehouse) using Informatica tool. ·
• Taking care of the required communication with client/users related to the project development progress. Used to prepare IA (impact analysis) document, which includes effort estimation, and overall process flow/design.
• Defect Handling during UAT and postproduction support.

Confidential

Senior 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, timelines 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.
• Created Views, Stored Procedures, Queries and tables to create the reports.

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 tuned them for Optimum performance, Dependencies and Batch Design.
• Responsible for continuous integration and overnight builds in ETL andDatabase 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(Development &Test) 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, UNIX Shell Scripting and SAP Business Objects.

Confidential

Informatica Developer

Responsibilities:

• Development of ETL mappings and workflows.
• Worked on the Teradata Bteq scripts.
• Optimizing the mappings for increasing the performance by using the Teradata utilities as MLoad, TLoad and TPump.
• Analysis the issues that occurred during the ETL process and providing a detailed explanation to the business.
• Performing Unit test.
• Supporting the testing team with Integration testing and System Testing.
• Documentation of applications related to project
• Translated the business processes into Informatica mappings for building the data marts.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Involved in developing mappings using ETL tool-Informatica for data flow from Source system to Target.
• Creating solution documents for developed mappings.
• 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.
• Used Import and Export Utilities to maintain the data effectively.

Environment: Informatica PowerCenter 8.x, Teradata, Mainframe, UNIX Shell, Cognos