Informatica Developer

Location:

Harrisburg, PA

Posted:

April 10, 2018

Contact this candidate

Resume:

SINDHU PATLOLLA

Email: ******.***********@*****.***

Contact: 919-***-****

Summary

•7+ years of experience in Data Warehousing Technology and ETL methodologies includes Requirement gathering, writing the functional specifications, Requirement Analysis, Data Analysis, Application Design, Development and Testing in Data Warehouse.

•Good Understanding of Ralph Kimball and Bil Inmon approaches and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and Dimension tables, Physical and Logical data modeling.

•Involved in the client meetings to get mapping rule and transformation logics for the development process.

•Excellent hands-on ETL Informatica Power Center (Source Analyzer, Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation Developer) and Repository Manager, Workflow Monitor and Repository Server Admin Console with strong business understanding in different domains.

•Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.

•Created complex mapplets for reusable purposes.

•Expert in Extraction, Transforming and Loading (ETL) data flows using Informatica Powercenter. Creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.

•Proficient in Performance tuning of sources, transformations, targets, mappings, worklets, workflows and sessions.

•Involved in Unit testing, User Acceptance Testing and provided complete Production support.

•Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

•Experience in designing SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all etc..

•Strong experience on Informatica Metadata Manager, Involved in pulling metadata from multiple sources such as Informatica Powercenter, ERStudio, OBIEE into Metadata Manager to run the end to end Data Lineage.

•Strong Oracle database experience using Indexes, Cursors, Constraints, Triggers, Indexes and Views. Highly proficient in large volume data migration to Enterprise Data Warehouse using Data pump, Oracle Export, Import, SQL*Loader modules.

•Proficient in requirements gathering, systems design, user-interface design, application architecture. Strong experience in Performance Tuning.

•Exposure to Relational, Data Marts and Star/Snowflake Schema design concepts and experienced in Data Requirement Analysis and Implementation of Business Applications.

•Good understanding of relational database management systems like Oracle, SQL Server and Teradata, DB2, Sybase and extensively worked on Data Integration and Migration using Informatica for the Extraction transformation and loading of data from various database source systems.

•Good understanding on Cloud based technologies such as AWS Redshift, Apache Spark, Amazon S3.

•Good knowledge on migrating data from on premises to Amazon S3.

•Experience in agile Software development and JIRA.

•Familiar with database analysis, design, architecture and programming.

•Extensive Knowledge in writing UNIX shell scripts, PL/SQL procedures, Views, Functions and JIL scripts to automate jobs using Automated tools like Autosys, Control M

•Using information gathered to write up detailed reports and draw conclusions.

•Developing a clear understanding of existing business functions and processes.

•Preparing PowerPoint presentations and Excel spreadsheets for business meetings.

•Identifying areas for business improvement.

Technical Competencies

Data Warehousing

Informatica Power Center 10.x/9.x/8.x/7.x/6.1 (Source Analyzer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow Manager), SSIS, Informatica Power Mart 6.x/5.x, Power Exchange, Power Connect, Power Analyzer Data Profiling, Data Migration and Data cleaning, Flat file system (Fixed width, Delimiter)

Dimensional Modeling Tools

Dimensional Data Modeling, Star Schema, Snow –Flake Modeling, FACT and Dimensions tables.

Database

Oracle 10g/9i/8i, MS SQL Server 2005/2000, DB2 UDB 9, MS Access 2000, Tera Data.

Other Tools

TOAD 8.6, SQL * Loader, SQL * Plus, Autosys.

Internet Technologies and Microsoft tools

HTML, XML, MS Office toolset ( Word, Excel, Visio, Power point, Share point)

Languages

C, C++, SQL, PL/SQL, Unix Shell Scripting, Java

Operating Systems

Windows XP/NT/2000, Windows Vista, Unix, Sun Solaris 8.0/9.0

Professional Experience

Deloitte, Mechanicsburg, PA

State of PA Feb’18-Till date

Informatica Developer

Responsibilities

•Involved in gathering the requirements, performing scope analysis.

•Identifying areas for business improvement.

•Developing maps and flowcharts of current and future business processes

•Migrated data from legacy system to Data Warehouse using ETL methodologies.

•Developed Complex ETL (Extract/Transform/Load) procedures to convert data from Mainframes to open systems (Oracle).

•Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

•Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

•Used Oracle checksum function to compare data between two mainframe files.

•Used Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.

•Developed mapping using parameters and Variables.

•Used Workflow Manager for creating validating, testing and running sequential and concurrent batches.

•Creating and running Sessions & Batches using Work flow Manager to load the data into the Target Database.

•Worked on Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems and flat files, which includes fixed-length as well as delimited files.

•Involved in providing feedback and recommendations for managing metadata from the various metadata sources and incorporate Velocity standards for Metadata Management.

•Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.

•Using information gathered to write up detailed reports and draw conclusions.

•Developing a clear understanding of existing business functions and processes.

•Preparing PowerPoint presentations and Excel spreadsheets for business meetings.

•Used Jira to log defects in order to track the development and testing process

•Generated process flow designs

•Drafted standard operation procedures

•Developed and implemented strategies for the handling of errors by the ETL team

•Conducted tuning for SQL and PL procedures Informatica objects and Views.

Environment

Informatica Power Center 10.x, Oracle 11g, Cognos 8.0, Autosys, UNIX, Toad, Windows XP, PLSQL.

Deloitte, Mechanicsburg, PA

State of Illinois Apr’15-Jan’18

ETL Developer

Responsibilities

•Worked with analysts, using work sessions, to translating business requirements into technical user specifications, including data, process and interface specifications.

•Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings

•Imported Source/Target Tables from the respective databases and build the code using various transformations, reusable transformations, Mapplet by creating Mappings using Designer module of Informatica.

•Migrated data from legacy system to Data Warehouse using ETL methodologies.

•Developed Complex ETL procedures to provide a way to update/insert/delete data from multiple heterogeneous sources.

•Tuning Informatica Mappings and Sessions for optimum performance and designed and implements the error handling strategy for ETL team.

•Used Jira to log defects in order to track the development and testing process.

•Involved in the client meetings to get mapping rule and transformation logics for the development process.

•Worked with the client to get the logic for analyzed issues.

•Involved in data analysis to identify gaps between Source, Target and Application systems.

•Load process is a onetime process through Informatica. Performed Monthly mock runs to provide data to the client.

•Involved in data reconciliation to make sure number of Source records is equal to number of Target and Exceptional records.

•Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio in the project for State of Virginia.

•Involved in Unit testing in SSIS Packages, Query verification in SSRS, Stored Procedure

•Creating and running Sessions & Batches using Work flow Manager to load the data into the Target Database

•Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc to extract, transfer and load (ETL) data from OLTP to OLAP databases

•Did performance tuning of Informatica components for daily and monthly incremental loading.

•Involved in migrating ETL code from DEV to QA and QA to PROD by using Import/Export method.

•Tested the target data against source system tables by writing some QA Procedures, Functional and regression testing for deploying applications.

•Involved in Unit testing, User Acceptance Testing and provided complete Production support

•Provide written status reports to management regarding project status, task and issues.

•Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

•Coordinate with onshore business team and offshore development team to implement the project.

•Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.

•Using information gathered to write up detailed reports and draw conclusions.

•Developing a clear understanding of existing business functions and processes.

•Preparing PowerPoint presentations and Excel spreadsheets for business meetings.

Environment

Informatica Power Center 9.5, SSIS 2014,Oracle 11g, Cognos 8.0, Autosys, UNIX, Toad, Windows XP.

Common Wealth of Pennsylvania, Camp hill, PA Apr’14-Feb’15

Deloitte

Informatica Developer

Child welfare system receive and investigate reports of possible child abuse and neglect; provide services to families that need assistance in the protection. The project was involved in designing and development of ETL process to build the Data Warehouse.

Responsibilities

•Involved in gathering the requirements, performing scope analysis.

•Identifying areas for business improvement.

•Developing maps and flowcharts of current and future business processes

•Migrated data from legacy system to Data Warehouse using ETL methodologies.

•Developed Complex ETL (Extract/Transform/Load) procedures to provide a way to update/insert/delete data from multiple heterogeneous sources.

•Used Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.

•Developed mapping using parameters and Variables.

•Used Workflow Manager for creating validating, testing and running sequential and concurrent batches.

•Creating and running Sessions & Batches using Work flow Manager to load the data into the Target Database.

•Created Stored Procedures for data transformation purpose.

•Tuning Informatica Mappings and Sessions for optimum performance and designed and implements the error handling strategy for ETL team.

•Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions, Batch Jobs/Worklets and Workflows.

•Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions.

•Created a shell script to copy files from one folder to another and developed UNIX shell scripts using PMCMD utility to scheduled ETL load.

•Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.

•Involved in Unit testing, User Acceptance Testing and provided complete Production support

•Provide written status reports to management regarding project status, task and issues.

•Scheduling of sessions and workflow and loaded data into data marts on a daily basis.

Environment

Informatica Power Center 9.5, Oracle 11g, Cognos 8.0, Autosys, UNIX, Toad, Windows XP.

American Express, Phoenix, AZ Jan’11-Feb’14

Informatica Developer

American Express is an American multinational financial services corporation. The project was involved in designing and development of ETL process to build the Data Warehouse.

Responsibilities

•Involved in gathering the requirements, performing scope analysis.

•Created Data-driven Packages in SSIS as part of the automating the process for the Referral Process.

•Involved in requirements gathering, functional/technical specification, Designing and development of End-to-end ETL process for Sales Data Warehouse.

•Worked on Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems and flat files, which includes fixed-length as well as delimited files.

•Involved in providing feedback and recommendations for managing metadata from the various metadata sources and incorporate Velocity standards for Metadata Management.

•Created complex workflows, with multiple sessions, worklets with consecutive or concurrent sessions and other tasks like Timer, Event Raise, Event Wait, Decisions and Email to transport the data to data warehouse tables using Informatica Workflow Manager.

•Worked on various issues on existing Informatica Mappings to produce correct output and used ETL debugger extensively to identify the performance bottlenecks within the mappings.

•Created Stored Procedures for data transformation purpose.

•Tuning Informatica Mappings and Sessions for optimum performance and designed and implements the error handling strategy for ETL team.

•Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions.

•Created a shell script to copy files from one folder to another and developed UNIX shell scripts using PMCMD utility to scheduled ETL load.,

•Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica work flow manager.

•Responsible for writing unit test cases and performing the unit testing for data validity based on business rules.

•Active member in providing on-call support for daily and weekly batch loads and helped with troubleshooting of ETL connectivity and response time issues.

•Involved in writing test scripts, unit testing, system testing and documentation.

Environment

Informatica Power Center 9.1 and 9.5, Informatica Metadata Manager, Oracle 11g, Cognos 8.0, Autosys, UNIX, Toad, Windows XP, Erwin.

Education

Bachelor Degree in Computer Science – Jawaharlal Nehru Technological University

Master Degree in Computer Science – Stratford University

Contact this candidate