Manager Data
Resume:
ROOPA G
*****.****@*****.***
Phone: 248-***-****
Summary:
A dynamic ETL developer with 7 years of Software Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support of Data Warehouse Applications.Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
Professional Summary:
Extensive experience in ETL/Informatica Power Center and data integration experience in developing ETL mappings and scripts using Informatica Power Center10.x/9.x/8.x/7.x.,Informatica Intelligent Cloud Services (IICS)
Have clear understanding of Data Warehousing and BI concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
Extensive experience delivering Data warehousing implementations, Data migration and ETL processes to integrate data across multiple sources using Informatica PowerCenter and Informatica Cloud Services
Experience working with Agile and Waterfall methodologies
Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snowflake Schema).
Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, Java, SQL, Stored Procedure, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
Good understanding of relational database management systems like Oracle, DB2, SQL Server and worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
Extensive experience working on Informatica Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Normalizer, Update Strategy, Aggregator, Sorter, Sequence Generator, Intelligent Structure Designer, and Structure Parser
Extensively worked on the ETL mappings, analysis and documentation of OLAP reportsrequirements. Solid understanding of OLAP concepts and challenges with large data sets.
Expertise in designing and developing Workflows, Sessions and tasks using Informatica Workflow manager tools, Task Developer, Workflow and Worklet Designer to handle different load scenarios
Expertise in Data Warehousing Concepts such as Star Schema, Snow Flake Schema, Fact Table and Dimension Table
Experience with Snowflake Multi-Cluster Warehouses .
Experience with Snowflake Virtual Warehouses.
Experience in building Snow pipe.
In-depth knowledge of Data Sharing in Snowflake
Experience in creating High Level Design and Detailed Design in the Design phase.
Experience in UNIX shell scripting, job scheduling and server communication.
Extensively worked on Dimensional Modeling, Data Migration, Data Cleansing, and Data staging for operational sources using ETL and data mining features for data warehouses.
Excellent Data Processing skills including designing and implementing Data Mart applications
Extensive database experience and highly skilled in SQL Server, Oracle, DB2, XML Files, Flat Files, MS Access.
Extensively created Mapplets, common functions, reusable transformations, look-ups for better usability.
Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
Involved in Unit testing, System testing to check whether the data loads into target are accurate.
Developed Unix scripts for Backend testing and executed system processes for business validation, perform data consistency check
Proficient in using various delivery tools including Rational ClearQuest, ClearCase, DOORS, ALM for Test Reporting and Defect/Change management
Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
Excellent communication skills and result-oriented with minimum supervision, problem solving skills and team player.
Technical skills:
ETL Tools
Informatica 10.1/9.6/9.1/8.6.1/8.1, Source Analyzer, Mapping Designer, Workflow Monitor, Workflow Manager, Data Cleansing, Data Quality, Repository, Metadata, Data Mart, OLAP, OLTP, SQL Server SSIS.
Data modeling tools
Erwin,PowerDesigner
Databases
Oracle 11g/10g/9i/8i, IBM-DB2, MSSQL Server
Other Tools
Toad, SQL Developer, Crystal Reports, SQL Assistant
Programming Languages
SQL, PL/SQL, T-SQL, UNIX Shell Scripting
Job scheduling
Shell Scripting, Autosys, Tidal, Control-M
Environment
MS Windows 2012/2008/2005, UNIX
Cloud
Informatica Intelligent Cloud Services (IICS)
Professional Experience:
VERIZON, IRVING,TEXAS Jan2020 – TillDate
ETL/Informatica Developer
Responsibilities:
Design and develop end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup,Expression, Router, Joiner, Normalizer, Aggregator, Sequence Generator and Rank.
Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
Involved in creating data models using Erwin.
Worked with Business Analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
Worked on InformaticaPower Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
Worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer.
Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
Developed data warehouse model in Snowflake for over 100 datasets using whereScape.
Designed, Developed and Implemented ETL processes using IICS Data integration
Created IICS connections using various cloud connectors in IICS administrator
Installed and configured Windows Secure Agent register with IICS org
Heavily involved in testing Snowflake to understand best possible way to use the cloud resource
Used Snowflake functions to perform semi structures data parsing entirely with SQL statements.
Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
Responsibilities include creating the sessions and scheduling the sessions.
Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
Prepared SQL Queries to validate the data in both source and target databases.
Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
Performed loads into Snowflake instance using Snowflake connector in IICS for a separate project to support data analytics and insight use case for Sales team
Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
Designed and developed the ETL processes using Informatica to load data from Oracle, Flat files and XML files to target Oracle Data warehouse.
Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
Leveraged workflow manager for session management, database connection management and scheduling of jobs.
Created Test cases and Test Plans for unit testing.
Extensively used ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database.
Supported during QA/UAT/PROD deployments and bug fixes.
Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.
Documented and presented the production/support documents for the components developed, when handling over the application to the product support team.
Actively participated in Scrum Meetings.
Environment: Informatica Power Center 10.1, MDM, Oracle 11g,UNIX, PL/SQL, SQL* PLUS, TOAD, MS Excel.
ABB, Plano, Texas May 2019 - Dec2019
ETL/ Informatica Developer
Responsibilities:
Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers and data flow management into multiple targets using Router.
Developed the Informaticamappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, People Soft, Excel files, CSV files etc.
Developed various mapping and tuning using Oracle and SQL*Plus in the ETL process.
With the users and making changes to Informatica mappings according to the Business requirements.
Handled technical and functional call across the teams.
Developed the audit activity for all the Informatica Intelligent Cloud Services (IICS) mappings.
Automated/Scheduled the Informatica Intelligent Cloud Services (IICS) jobs to run daily with email notifications for any failures.
Optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
Worked on complex mappings, Mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
Developed data warehouse model in Snowflake for over 100 datasets using whereScape.
Involved in Dimensional modeling by identifying the fact and dimension tables and design start/snow flake schemas for the Sql Server Analysis services.
Used Snowflake functions to perform semi structures data parsing entirely with SQL statements.
Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
Extensively used ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database.
Worked with several facets of the Informatica Power Center tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.
Leveraged workflow manager for session management, database connection management and scheduling of jobs.
Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.
Heavily involved in testing Snowflake to understand best possible way to use the cloud resource
Experience in scheduling of ETL jobs using Autosys, Tidal, Control-M.
Actively participated in Scrum Meetings.
Created Test cases and Test Plans for unit testing.
Supported during QA/UAT/PROD deployments and bug fixes.
Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.
Environment: Informatica Power Center 9.5.1, IDQ, Oracle 11g, UNIX, PL/SQL, SQL* PLUS, TOAD, MS Excel.
United HealthGroup, Hyderabad, India Jul2017–Dec 2018
ETL/Informatica Developer
Responsibilities:
Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
Created mapping documents to outline data flow from sources to targets.
Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
Developed rules and Mapplets that are commonly used in different mappings.
Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
Prepared SQL Queries to validate the data in both source and target databases.
Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
Worked on complex mappings, Mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
Involved in Dimensional modeling by identifying the fact and dimension tables and design start/snow flake schemas for the Sql Server Analysis services.
Parsed high-level design specification to simple ETL coding and mapping standards.
Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
Extensively used ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database.
Used Address validator transformation for validating various customers address from various countries by using SOAP interface.
Experience in scheduling of ETL jobs using Autosys, Tidal, Control-M.
Supported during QA/UAT/PROD deployments and bug fixes.
Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.
Environment: Informatica Power Center 9.6, Oracle 11g, UNIX, PL/SQL, IDQ, SQL* PLUS, TOAD, MS Excel.
Prolific, Hyderabad, India Jun 2015 – Jun 2017
ETL Developer
Responsibilities:
Created mapplets and reusable transformations to use across different mappings.
Created transformations like Aggregate, Expression, Filter, Sequence Generator, Joiner, and Stored procedure transformations.
Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.
Developed sessions using Server Manager and improved the performance details.
Created reusable transformations called mapplets and used them in mappings in case of reuse of the transformations in different mappings.
Designed and coded maps, which extracted data from existing, source systems into the data warehouse.
Involved in creating Technical Specification Document (TSD) for the project.
Used Informatica for loading the historical data from various tables for different departments.
Involved in the development of Data Mart and populating the data marts using Informatica.
Created and maintained metadata and ETL documentation that supported business rules and detailed source to target data mappings.
Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
Managed migration in a multi-vendor supported Server and Database environments.
Environment: Oracle RDBMS 9i, Informatica, JAVA, SQL*Plus Reports, SQL*Loader, XML, Toad
Etouch Systems, Mumbai. May 2013 -Mar 2015
ETL Developer
GE Healthcare provides transformational medical technologies and services that are shaping a new age of patient care. GE expertise in medical imaging and information technologies, medical diagnostics, patient monitoring systems, drug discovery, biopharmaceutical manufacturing technologies, performance improvement and performance solutions services help our customers to deliver better care to more people around the world at a lower cost
Responsibilities:
Involved in design, development and implementation of the Enterprise Data Warehouse (EDW) and Data Mart.
Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
Enhanced existing UNIX shell scripts as part of the ETL process to schedule tasks/sessions.
Carried out unit and integration testing for Informatica mappings, sessions and workflows.
Used Autosys as a scheduling tool for triggering jobs.
Optimized Query Performance, Session Performance and Reliability, did performance tuning of Informatica components for daily and monthly incremental loading tables.
Designed ETL process to translate the business requirements into Mappings using Informatica Power Center - Source Analyzer, Warehouse designer, Mapping Designer, Workflow Manager/Monitor.
Effective Communication with data architects, designers, application developers and senior management in order to collaborate on projects that involve multiple teams in a vitally time-sensitive environment.
Effectively involved in allocation & review of various development activities / task with onshore counter apart.
Understanding the business logic behind every piece of code and documenting requirements in a reverse engineering fashion
Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Workflow Manager.
Used Workflow Manager for creating validating, testing and running sequential batches.
Using Perforce as a versioning tool for maintaining revision history for code.
Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.
Environment: Informatica Power Center 7.X/8.1,Oracle10g/9i, MS SQL server 2005,Business Objects, Autosys,Toad 7.6, SQL, PL/SQL, Unix Shell Scripting,Windows.
Contact this candidate