Sandhya Chigurala
Email: [email protected]
Number: +1 469-444-0104
Over 8+ years of IT experience, ETL Designer and Developer, using Informatica Power Center 9.6.1, 9.5, 9.1, 9.0.1/ 8.6.1/7.x /6.x and Oracle Developer using Oracle 11i/10g/9i.
Experience in coordinating and collaborating with offshore development teams.
Hands on experience in Supply Chain Management, Banking, Health, Financial domains.
Expertise in using Informatica (Repository Manager, Server Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Transformation Developer, Source Analyzer) and DAC (Data ware house Application Console).
Experience in software development, maintenance, testing and troubleshooting on Master Data Management (MDM), Metadata management, data quality, data integration and Oracle database environment.
Strong knowledge of Data warehouse concepts - Star Schema, Snowflake and Slowly Changing Dimensions.
Involved in Full Life Cycle Development of building a Data Warehouse including agile and waterfall methodologies.
Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
Developed complex mappings using various transformation logic like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Joiner, Union, Connected/Unconnected lookups, Update Strategy and Normalizer and loaded data into different target types from different sources like Flat files (Delimited files and Fixed width files) like text files or CSV files, XML, Oracle, IBM Mainframe, Cobol files, SQL server, DB2, Teradata, Salesforce.com and Netezza.
Experience in integration of various data sources like Oracle, SQL, PL/SQL, Netezza, SQL server and MS access into staging area.
Extensively worked on BTEQ, MULTILOAD and FASTLOAD, FAST EXPORT, PDO utilities in Teradata.
Extensively worked on BTEQ scripts in Teradata using UNIX to override the Informatica code which causing performance issues.
Have good hands on experience in tuning Teradata scripts by using explain plans.
Implement Change Data Capture (CDC) techniques like slowly changing target (type1, type2), Simple Pass Through mapping.
Experienced in Performance of Mapping Optimizations in Informatica.
Extensively used Informatica Repository Manager and Workflow Monitor.
Experience in integration of various data sources with Multiple Relational Databases like Oracle, Teradata, SQL Server including SQL Server Integration Services (SSIS) and Worked on integrating data from flat files like fixed width and delimited.
Hands on experience in scheduling UNIX scripts, Teradata BTEQ scripts and Informatica workflows.
Good knowledge on Teradata Macros, BTEQ scripts & Utilities like Multi load, Fast load, etc.
Worked extensively with OLAP / BI tools such as Business Objects XI R2/R3/4.0/4.1(Web Intelligence, Universe Designer, Crystal Reports 2008/2011, Dashboards, Xcelsius 2008).
Good knowledge of Data Warehousing Concepts, SQL, PL/SQL and Teradata tools.
Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
Technical Skills:
ETL Informatica, Power Center 9.6.1, 9.5, 9.1, 9.0.1/8.6.1/7.x/6.x, power Exchange, Power Center Connect for Siebel CRM & SAP R/3.
Database Teradata, Oracle 11i/10g/9i/8i, SQL Server, IBM-DB2, MS-Access, SQL
Data Modeling Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling, ROLAP/OLAP/MOLAP
Programming SQL, PL/SQL, Java, C, C++, COBOL, Shell Scripting.
Tools SQL* Plus, Oracle designer, Erwin4.1, Toad, FTP Tools
Operating Systems UNIX, Windows (98, 2000, NT, XP)
Job scheduling tools Autosys, Control-M, Appworx, PCRON
Reporting tools OBIEE, Crystal reports, Business Objects
Professional Experience:
Charter Communications, St. Louis, Missouri Aug’2015-till date
Teradata/ETL Developer
Responsibilities:
Involved in analysis & Functional specification phase of the project.
Played coordination role between onshore and offshore.
Involved in loading the data from Teradata and file sources to the Stage and Core layers of EDW.
Involved in designing and developing ETL solutions to meet complex business requirements.
Worked closely with the Data Analysts, Teradata DBAs and BI Developers to ensure accurate and timely delivery of solutions.
Prepared the detailed design or technical design of the project phase by phase.
Interacted with the client to discuss day-to-day matters, issues, design walkthroughs, change request implementations and its effects and coordinating on a daily basis for status update.
Created tables, views, macros, functions and Procedures in Teradata SQL Assistant.
Used TPT (Teradata Parallel Transporter) configured for Fastload and Mload to load data.
Utilized pre and post session command tasks to invoke BTEQ scripts to insert/update Audit tables.
Extensively worked on indexes in Teradata and Creation of proper Primary Index (PI) talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
Responsible for SQL tuning and optimization using Analyze, Explain Plan and optimizer hints.
Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and the Target Data.
Owned all the code migrations/reviews includes Informatica, unix shell scripts, DB objects and Appworx migrations.
Created chains in Appworx for scheduling Informatica workflows, Stored procedures and Teradata jobs.
Created Run Books and Turnover documents for the scheduling team to schedule jobs on Appworx.
Created Business Requirement Documents, Technical Design documents and Implementation Plans for migration of code to various environments.
Environment: Informatica Power Center 9.6.1, Teradata SQL Assistant 14.0, Teradata Studio 14.0, Flat Files, UNIX Shell Scripting, Appworx
Northwestern Mutual, Milwaukee, Wisconsin Dec’2014- July’2015
Informatica developer
Responsibilities:
Analyzed all functional specifications and map documents and performed troubleshooting on all development processes.
Exported mappings and workflows from the repository manager and then imported them back to the destination folder. Source, target and transformations were exported in the xml format.
Modified, designed and developed the existing mappings using transformation logics like lookup, Router, Filter, Expression, Aggregator, Joiner and Update Strategy according to the business requirement.
Extracted data from source systems like DB2 and flat files and loaded into the data warehouse and flat files.
Created tables and flat files as per the requirement and imported them to the repository.
Implemented Type I & Type II slowly changing dimensions in Informatica mappings.
Integrated new mapplets into the existing mappings according to the client specifications.
Created sessions, workflows and worklets for proper execution of mappings using workflow manager.
Performed unit testing, configuring and troubleshooting all Informatica processes as required and validated the results with end users.
Implemented performance tuning logic on Targets, Sources, mappings, sessions for maximum efficiency and performance.
Extensively used Autosys as a job scheduler tool to schedule UNIX scripts and the informatica jobs.
Environment: Informatica Power Center 9.5, DB2, Flat Files, UNIX Shell Scripting, Autosys
JP Morgan Chase & Co, Dublin, Ohio Jan’2014- Nov’ 2014
Informatica developer
Responsibilities:
Involved in requirements gathering and analysis to define functional specifications.
Extensively worked on Process Design, Development, Testing and Implementation of the Project.
Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
Developed ETL processes to load data from different source systems such as Oracle and Flat Files into target systems i.e. Oracle and Flat files.
Extracted the data from Oracle10g, Netezza, XML, Flat files, DB2 load the data in to Oracle warehouse.
Extensively worked on Informatica Power Center – Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations to import source and target definitions into the repository and to build mappings.
Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
Defined Target Load Order Plan for loading data into Target Tables.
Used Informatica’s features to implement Type II changes in slowly changing dimension tables.
Created tables, views, primary keys, indexes, constraints and sequences.
Involved in developing optimized code using PL/SQL for Server related Packages to centralize the application through procedures, functions and packages.
Different database triggers containing PL/SQL were created and stored in the database and fired off when contents of database were changed.
Used debugger to test the mapping and fixed the bugs.
Created and configured workflows, Worklets & Sessions to transport the data to target systems using Informatica Workflow Manager.
Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
Involved in the architecture and management of data governance with Business Intelligence team.
Used Control-M Tool to schedule shell scripts and Informatica jobs.
Performed Unit, Grid Integration, Testing and validate results with end users.
Environment: Informatica Power Center 9.1, Oracle 10g, SQL Server, PL/SQL, MS Visio, UNIX Solaris/AIX, WINSCP.
Hyundai Information Services of North America (HISNA), Irvine, CA Aug’2013 to Dec’2013
ETL Developer
Responsibilities:
Involved in providing an efficient interface with brand for all processes across various platforms.
Evaluated all functional requirements and map documents and perform troubleshoot on all development processes.
Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner and Update Strategy
Created sessions, sequential and concurrent batches for proper execution of mappings using server manager.
Ensured that the data integration design aligns with the established information standards.
Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
Worked with Change Data Capture (CDC).
Worked on Agile methodology.
Worked with autosys for scheduling the informatica jobs.
Prepared required test cases according to the client requirement and specifications.
Environment: Informatica Power Center 8.6.1, Oracle SQL server, SSIS, PL/SQL, Windows XP.
Lincoln Financial Group, Philadelphia, PA April’12 to June’13
ETL Developer
Responsibilities:
Involved in Full Life Cycle Development of building a Data Warehouse.
Participated in the Data Model design according to the Business Requirements.
Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
Developed DDD and Mapping Document to present to client for the Informatica process for the Salesforce objects.
Developed data Mappings, Transformations between source systems and warehouse and Performed Type1 and Type2 mappings.
Creating connection to databases like SQL Server, oracle, Netezza and application connections.
Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
Developing/Modifying the Teradata Objects like Tables, views, Business Views and Indices to implement the required changes. Model Data warehouse is implemented in Teradata.
Extracted data from various source systems like Oracle, SQL Server, XML and flat files and loaded into relational data warehouse and flat files.
Designed and developed mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and created sessions for proper execution of mappings using server manager.
Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
Worked on Master Data Management (MDM/Reference data, Customer Information File (CIF), Customer Data Integration (CDI) project in the financial services.
Modified the existing Worklets and workflows to accommodate for these new sessions and mappings. Created the break points in the designer and worked with debugger.
Worked on Data Cleansing, Data conversion and process implementation.
Worked on agile & scrum methodologies.
Used Business Objects Designer to implement Universe, Linkages between Tables, create prompts and queries, and parse the Universes, applied Contexts and Alias Tables to remove cyclic dependencies.
Formatted Reports as per the user requirements using extensive functionalities in Business Objects, which allows the users to analyze the data.
Created the webi reports using BEX Queries as source and implemented Scope of Analysis, Hyperlink, Drill down, functions, Cross Tab, Charts, Master/Detail, User Response and Formulae etc.
Created few financial reports using Crystal reports and used functionalities like sub-reports, Custom parameters, variables and charts.
Included data from different sources like Oracle Stored Procedures and Personal data files in the same report.
Responsible for issue resolution, work closely to perform data quality & analysis and monitoring of data load.
Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Warehouse.
Environment: Informatica Power Center 9.1, Salesforce.com, Oracle 10g, Business Objects 5.1, BO Designer, MS SQL Server, TOAD, PL/SQL, Erwin, Flat Files, COBOL, SQL *Loader, UNIX Shell Scripting, Windows XP.
Capital One, McLean, VA Aug’10 to Mar’12
Informatica Consultant
Responsibilities:
Analysis of the specifications provided by the clients.
Used data from various sources (Flat Files, Oracle, XML, SQL Server) using different kinds of transformations like Router, Sorter, Stored Procedure, Source Qualifier, Joiner, Aggregator, lookup, Expression, XML, Connected and Unconnected Lookups, Sequence Generator, Union, Update Strategy to load data into target tables.
Worked on Data Cleansing, Data conversion and process implementation.
Worked on Incremental Aggregations for improving performance in Mappings and Sessions.
Created Mappings for Populating data to dimensions and fact tables.
Worked with Memory cache for static and dynamic cache for better throughput of sessions containing Lookup, Joiner, and Aggregator and Rank transformations.
For Mappings we have created Sessions, Tasks, Work lets, Workflows.
Extracted sources from XMLs and load them into Flat Files, Oracle and Teradata.
Utilizing Teradata Explain and Visual Explain to analyze and improve query performance. Redesigning and write new Teradata SQL for higher Performance.
Used Type 1 SCD (discard previous versions of dimensions in the target table) and type 2 SCD (maintain history) mapping to update slowly changing dimension tables.
Performed Informatica administrative tasks such as stopping/starting Informatica Repository and Server processes, performing code migration, backup and restoring of Informatica Repository, upgrades and security administration.
Involved in Data Profiling using Data Explorer.
Extensively used Power Center 8.6.1 to extract the data from XML and flat files and other RDBMS databases like Oracle and DB2, into staging area and then populate the data warehouse.
Implemented Change Data Capture using the Power Exchange.
Worked on waterfall methodology.
Extensively used Power Connect to import data from different External Sources.
Developed Stored Procedures, Functions, Triggers, Indexes and Views.
Redesigned some of the mappings in the system to meet new functionality.
Extensively used PL/SQL, TOAD for creating views and stored procedures and indexes on the table for performance tuning.
Did the Performance tuning in Oracle to run the queries faster in the application Dash board.
Worked on Batch Processing or Scheduling and Shell Scripting.
Environment: Informatica Power Center 8.6.1, Teradata, Oracle 10g, SQL, PL/SQL, XML, UNIX, Toad, Windows XP.
Assurant Solutions, Miami, FL Jan’09 to July’10
Informatica Consultant
Responsibilities:
Co-ordinate with the Business Analysts and users to understand business and functional needs and implement the same into an ETL design document.
Extensively worked on Informatica Power Center Designer (Source Analyzer, Warehouse designer, Transformation Developer, Mapping Designer and Mapplet Designer).
Prepared high-level design specification document, Informatica Mapping specification documents for all the Transformations used in the project.
Developed Informatica mappings using heterogeneous sources like flat files and different relational databases, Mapplets, Mappings using Power center Designer.
Teradata Fastload, Mload and BTEQ utilities were used to load Sources data form flat files and apply business logic to load them into final target database.
Implemented Type 2 and Type 3 Slowly Changing Dimensions in mappings as per the business requirements.
Developed and Implemented UNIX shell scripts through command task to handle requirements like dropping and building indexes, flat file archiving/dropping process etc.
Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
Scheduled Workflows based on demand, run on time, run only once using Informatica Workflow Manager and shell scripts.
Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
Extensively worked in the performance tuning for the mappings and ETL Procedures both at designer and session level.
At session level tuned the mapping by setting the buffer size, cache size, increasing commit intervals.
Environment: Teradata, Informatica Power Center 6.2, Oracle 9i, Flat files, SQL Server 2000, DB2, SQL *Plus, Windows 98, Sun Solaris, TOAD
ICICI Bank, India June’07 to Dec’08
Oracle Developer
Responsibilities:
Analyzed all business functionality related to back end database interfaces.
Wrote Event Triggers, PL/SQL Program Units for Reports for Client Validations.
Designed and developed Reports.
Formatting, Testing and rerunning the existing reports.
Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the design documents.
Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
Generated sequences that can be shared by multiple users to generate unique integers.
Implemented PL/SQL scripts in accordance with the necessary business rules and requirements.
Developed user documentation for all the application modules.
Responsible for monitoring the performance and stability of the software during performance test prior to going- live and after going-live continued to monitor as part of the post-production support.
Environment: SQL, PL/SQL, Oracle9i, Ms Word, Ms Access, SQL*Plus.
Tags: recruitercareerdrivellconmicrosoftcom, number, chigurala, email, professional, sandhya, 4694440104, summary