Manager Data
Resume:
SHARATH M
Informatica Developer
E-mail: ac19uw@r.postjobfree.com
SUMMARY:
Around 7+ years of work experience in Information Technology including Requirements Analysis, Design, Development, Application Maintenance, Enhancement and Production Support of Business Applications using Data Warehousing tools of Business Intelligence (BI).
Expertise in developing ETL mappings using Informatica Power Center versions 9.5/ 8.6.1 using Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor.
Experienced in creating various transformations and mappings using Informatica Designer and tasks using workflow manager to apply business logics and move to data from multiple sources into targets.
Experience in Database using Oracle, SQL, PL/SQL, Toad.
Experienced in preparing Technical Design Document, Mapping Documents, Detail Design Document for the Source/Target mapping.
Excellent experience in designing, modelling, performance tuning and analysis, implementing processes using ETL tool Informatica Power enter for Data Extraction, Transformation and Loading processes.
Expert-level mastery in designing and developing complex Mappings using transformations like Source Qualifier, Aggregator, Expression, Connected &Unconnected Lookup, Filter, Joiner, Sequence generator, Sorter, Router, Normalizer and Update Strategy.
Experience with high volume datasets from various sources like Oracle, Flat Files, SQL Server and XML.
Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modelling Language (UML).
Expertise in design and implementation of Informatica (IDQ v9.1), Data Quality applications for the business and technology users across the entire full development life-cycle.
Familiar with Agile Project Management, exposed to corporation IT environments and communicating with professional manners.
Strong experience in client requirement analysis, physical, logical design development, resource planning, coding, debugging, testing, deployment, support and maintenance of business intelligence applications.
Responsible for creating the parameter files in order to connect to the right environment and data base. Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions.
Handled Production Support for the monitoring of daily and Monthly jobs. Part of the implementation team.
Involved in creating data mappings, data quality and loading different type of sources into Oracle target database. Worked on Stored Procedure transformations.
Writing the SQL queries for the incremental logic. Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions.
Wrote UNIX Shell Scripts to perform operations on text files. Developed SQL Overrides for the Source Qualifiers Based on the Business Requirements.
Positive work attitude, good communication skills, working under pressure, self-motivated to work independently and also to lead and motivate the team to build a good working environment.
TECHNICAL SKILLS:
Programming Languages
Unix Shell Scripting, SQL, JDBC, PL/SQL, COBOL, UNIX, Linux, Shell scripts, SOAP UI, Web Services, Java Script, HTML, XML/XSD, Eclipse.
Web Technologies
HTML5, CSS3, XML.
Databases
Oracle, SQL Server, MySQL, IBM DB2, Mongo DB.
ETL Tools
Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor, Repository Manager).
Data Modeling
Kimball & Inmon Methodologies.
Methodologies
Star Schema, Snowflake Schema, Galaxy Schema.
Reporting Tools
OBIEE - Oracle Business Intelligence 10.1.3.X, Oracle BI Publisher, MS Word.
Database Tools
SQL Developer, SQL*Plus, TOAD.
Operating Systems
All Version of Microsoft Windows, UNIX and LINUX, MAC.
PROFESSIONAL EXPERIENCE:
Informatica ETL Developer Aug 2016 – Till Date
Fannie Mae Hendon, VA
Responsibilities:
Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
Efficient in creating source, target databases and developing strategies for Extraction, transformation and loading (ETL) mechanism using Informatica PowerCenter Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
Experience with all components of Infromatica PowerCenter such as Source Analyzer, Target designer, Transformation, Mappings Designer, Mapplets.
Experience with complex mappings using different transformations such as Source Qualifier, Expression, Filter, Joiner, Router, Update Strategy, Union, Rank, Normalizer, Unconnected / Connected Lookup, JAVA, Sorter, Sequence Generator and Aggregator.
Preparation of technical specification document for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards
Estimates and planning of development work using Agile Software Development.
Good experience on Agile Methodology and the scrum process.
Ensured performance metrics are met and tracked.
Processes to generate Daily, Weekly and Monthly data extracts were developed and the data files were sent across to the downstream applications.
Involved in Data modeling review sessions - E/R diagrams, normalization and de-normalization as per business requirements.
Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management and Data transportation.
Experience in Performance tuning of Source SQL queries and Teradata Queries.
Created mappings by using Joiner, Expression, Aggregator, Data masking, Router, Lookup, SQL transformation, Update Strategy and Sequence Generator.
Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems such as Oracle, Oracle GG, Flat files, XML, My Sql.
Configured tasks and workflows using workflow manager.
Involved in the creation of Oracle Sql and PL/SQL stored procedures and functions.
Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
Tuned the Sessions for better performance by eliminating various performance bottlenecks.
Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
Writing Unix & Perl script to load data from sources to staging tables, to create indirect file list, generate parameter files for respective paths.
Used SVN for version control and Autosys for Job scheduling.
Applied Agile methodology throughout the development life cycle of application.
Environment: Informatica Power Center, Oracle, Business Objects xi, TOAD, SQL server, Windows, UNIX.
Informatica ETL Developer Dec 2015 – Aug 2016
Parallon Nashville, TN
Responsibilities:
Involved in understanding requirements, analyze new and current systems to quickly identify required Sources and Targets.
Analyzed business requirements to build a Data Mart for various business processes conformed to the business rules.
Analyzed the Functional Specs provided by the Data Architect.
Designed Technical specification document based on the FSD.
Created Mapping Design document based on FSD.
Extensively used Informatica for extracting, transforming, loading databases from Oracle, flat files and DB2.
Created PL/SQL Procedures and Functions for scrubbing the data.
Developed Transformation logic and designed various complex Mappings in the Designer.
Designed and developed various mappings in Mapping Designer, sessions & workflows in Workflow Manager to extract data from flat files, Oracle and DB2 sources and load to Oracle.
Created, launched & scheduled sessions. Configured email notification
Implemented the best practices for the creation of Mappings, sessions, Workflows and performance optimization.
Implemented Pipeline partitioning to improve session performance.
Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
Wrote Queries, Procedures and Functions that are used as part of different application modules.
Performed Data Quality Analysis to determine cleansing requirements.
Created scripts to update the parameter files to establish delta extraction.
Wrote various shell scripts for pre-processing of data and scheduling of jobs
Wrote Unix Shell Scripts for Informatica Pre-Session, Post-Session to schedule the ETL jobs (work flows).
Prepared Test Data and loaded it for Testing, Error handling and Analysis.
Involved in preparing ETL design documents and Unit Test Plans for Mappings.
Prepared the code migration document and worked with release team in Migrating the code (Informatica Objects, Unix Scripts) from Development to Test and Production environments.
Interacted with Users for analyzing various Reports.
Involved in answering the change request as part of the interaction testing.
Deployed ETL components code into multiple environments as per the approval received.
Provided Production Support by executing the sessions, diagnose problems and fix the mappings for changes in business logic.
Environment: Informatica PowerCenter, Windows, Oracle, DB2 SQL, PL/SQL, TOAD, Delimited Flat Files, UNIX Shell Scripting.
Informatica ETL Developer Apr 2014 – Oct 2015
KAISER PERMANENTE Pleasanton, CA
Description: Kaiser Permanente is an integrated managed care organization, is the largest health care organization in the United States. The Health Plan and Hospitals operate under state and federal non-profit tax status, while the Medical Groups operate as for-profit partnerships or professional corporations in their respective regions. The project was to design, develop and maintain a data warehouse for their vendor's data, internal reference data and work with their DBA to ensure that the physical build adheres to the model blueprint.
Responsibilities:
Involved in creating Detail Design Documentation to describe program development, logic, coding, testing, changes and corrections.
Extensively involved in writing ETL specifications for development and conversion projects.
Involved in requirement definition and analysis in support of Data Warehouse.
Designed complex ETL mappings and Oracle Sql scripts.
Developed Informatica mappings, transformations, reusable objects by using mapping designer, and transformation developer and mapplet designer in Informatica Power Center.
Created Reusable Transformations and Mapplets and used them in mappings.
Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
Created complex mappings in Power Center Designer using different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Sequence Generator, Router, Update Strategy, Sorter, Normalizer, Lookup, Joiner and Stored procedure transformations.
Defined and worked with mapping parameters and variables.
Designed and developed transformation rules (business logic) to generate consolidated (fact/summary) data using Informatica ETL tool.
Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problems.
Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
Designed and Deployed UNIX Shell Scripts.
Experienced in performance tuning in Informatica.
Coordinated with testing team to make testing team understand business and transformation rules being used throughout ETL process.
Production & On Call Support.
Involved in collection layer development.
Environment: Informatica PowerCenter, Flat files, Oracle, Oracle Golden Gate CDC, DB2, Sybase, Sql, PL/SQL, UNIX, Windows.
Informatica ETL Developer Dec 2012 – Mar 2014
ABBOTT VASCULAR Inc. Santa Clara, CA
Description: The Key objective of this project was to capture the Mitraclip patient referral information from doctors and compare this data with operations performed based on the referrals. Other module in this project was to compare Mitraclip sales with third party market data to identify the opportunity. This project was done to provide analytical foundation for the AV business analysts to evaluate market size share and other sales force productivity.
Responsibilities:
Worked on the requirements gathering and analysis for implementing the Data Warehouse.
Worked closely with data population Developers, multiple business units and a data solutions engineer to identify key information for implementing the Data warehouses.
Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
Parsed high-level design spec to simple ETL coding and mapping standards
Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources
Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
Developed and tested all the backend programs, Informatica mappings and update processes.
Created and used the Normalizer Transformation to normalize the flat files in the source data.
Extensively used the Slowly Changing Dimensions in various mappings.
Extensive experience in Error and Exception Handling, Problem Fixing, Performance tuning and usage of Debugger in Informatica.
Created Stored Procedures for data transformation purpose
Handled initial (i.e. history) and incremental loads in target database using mapping variables.
Worked with Workflow Manager for maintaining Sessions by performing tasks such as monitoring, editing, scheduling, copying, aborting, and deleting.
Troubleshooting problems in Informatica, Teradata, Unix and Oracle code.
Worked with Teradata utilities (Fload/Mload/B TEQ) to load files into Teradata tables.
Generated elaborate Test Cases and Test Plans to verify mapping using valid business scenarios.
Unit testing for the entire payroll application.
Coordinated with the testers and helped in the process of integration testing.
Worked with other team members and performed the knowledge transfer.
Environment: Informatica PowerCenter, UNIX, Informatica Data Quality (IDQ), Oracle, Toad, Teradata, Windows XP, MS Office, Delimited Files.
Oracle/Informatica Developer Mar 2011 – Oct 2012
AXIS BANK Bangalore, India
Description: The objective of the project is, to make the dashboard as Integrated Portal where a user will review the status of operational requests (Money Transfers, New Accounts, Corporate Actions, Account Transfers, etc.), read new alerts and messages, receive a cross view of broker activity, and review a history of past alerts, status updates, and other firm messages.
Responsibilities:
Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
Involved in creating Logical and Physical Data Models and creating Star Schema models.
Assisted in designing Star Schema to design dimension and fact tables.
Worked on Informatica Power center - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
Created Complex mappings using Unconnected and connected Lookups and Aggregate and Router transformations for populating target table in efficient manner.
Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
Used sorter transformation and newly changed dynamic lookup. Created Schema objects like Indexes, Views and Sequences.
Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
Created Stored Procedures, Functions and Indexes Using Oracle. Worked on batch processing and file transfer protocols.
Performance tuning of the workflow which are taking time. Developed mappings for policy, claims dimension tables.
Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
Simulated real time transaction feed by fabricating transactions required for UAT & manually calculating expected results to generate expectancy for testing process.
Environment: Informatica Power Center, Power Exchange, PL/SQL, Oracle, SQL Server, Windows, UNIX, Control-M, Toad
Jr Data Warehouse/ Informatica Developer June 2009 – Jan 2011
Micro Land Technologies Bangalore, India
Responsibilities:
Performed Requirements Analysis, Process Design, Data Design, Development, Testing and Implementation of load processes and Data transformation processes.
Created Technical Specification documents using MS Visio and maintained Technical specification documents throughout development lifecycle.
Extensively used ETL processes to load data from various source systems such as PeopleSoft, Oracle, DB2, COBOL and Flat Files into target systems Oracle, Siebel, DB2 and Flat files, by applying business logic on transformation mapping for inserting and updating records when loaded.
Extensively used the Designer to import source and target definitions into the repository and to build mappings.
Extensively used Informatica Workflow Manager and Workflow Monitor to develop, manage and monitor workflows, tasks and sessions.
Extensively used Expression, Filter, Joiner, Lookup, Router, Aggregator and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs.
Simplified the data flow by using a Router transformation to check multiple conditions at the same time.
Developed SQL/Perl scripts for the daily flat file extraction.
Experience in using FirstLogic to standardized names, addresses, and deduping process.
Applied Performance Tuning logic at mapping and session level.
Developed PL/SQL stored Procedures and Functions to enhance backend functionality.
Wrote Shell scripts to schedule the jobs.
Provided primary on-call production support for all enterprise Informatica environments.
Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
Environment: Informatica PowerCenter, PowerExchange, PowerChannel, Oracle, Sunopsis Data Integrator,DB2, Peoplesoft, Siebel, MS Access, FirstLogic, PL/SQL,, Shell Script, Perl, Cobol, Toad, QMF, Windows, Mainframe, MS Visio.
Contact this candidate