Data Developer

Manasa Reddy

ETL/Informatica Developer

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

Phone: 248-***-****

Summary

* ***** ** *****-** development experience with Oracle Databases, SQL Server, MySQL, Informatica, SSIS, SSRS, Oracle Forms and Reports.

Experience working with MS SQL Server 2012+, teradata, Oracle 11g.

Extensive knowledge on the Powercenter components as Powercenter Designer, Powercenter Repository Manager, Workflow Manager and Workflow Monitor.

Extensive work experience on Oracle Exadata-Oracle 12c/11g/10g/9i/8i, SQL server databases on Unix, Linux and Windows enterprise platforms.

Created Microsoft SSIS packages to extract data from SQL server database to flat files.

Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).

Thorough knowledge in creating ETL’s to perform the data load from different data sources and good understanding in installation of Informatica.

Experience in integrating business application with Informatica MDM hub using Batch process, SIF and message queues.

Extensively developed Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving.

Worked on Application Production Support, receiving production calls on troubleshooting the application and resolving bugs.

Demonstrated experience with design and implementation of Informatica (IDQ v9.1), Data Quality applications for the business and technology users across the entire full development life-cycle.

Strong in SQL, PL/SQL, SQL*LOADER, SQL*PLUS, MS-SQL.

Experience with Data Cleansing, Data Profiling and Data analysis. UNIX Shell Scripting, perl Scripting, SQL and PL/SQL coding.

Involved in Testing, Test Plan Preparation and Process Improvement for the ETL developments with good exposure to development, testing, debugging, implementation, documentation, user training & production support.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Hands on experience in developing Stored Procedures, Functions, Views and Triggers, SQL queries using SQL Server and Oracle PL/SQL.

Worked a great extent with the design and development of Tableau and Power BI visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.

Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility

Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin, EMBARCADERO ERStudio.

Worked directly with non-IT business analysts throughout the development cycle, and provide production support for ETL.

Experience with industry Software development methodologies like Waterfall, Agile within the software development life cycle.

Drafting the business stories and technical stories in the Rally Tool.

Experienced in providing Tier 2 and 3 Production support to Autosys batch processes and perform trouble shooting using power center logs, LINUX/UNIX scripts and DB processes.

Trouble-shooting production incidents requiring detailed analysis of issues and used Autosys batch jobs, and databases.

Involved in understanding client Requirements, Analysis of Functional specification, Technical specification preparation and Review of Technical Specification.

Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle (SQL, PL/SQL), SQL Server and UNIX shell scripting to perform job scheduling.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Technical Expertise

Data Warehousing

Informatica Power Center 10/9.6/9.1/8.6.1/8.5/8.1.1/7.1.2/7.1.1/6.1/5.1.2, Power Connect, Power Exchange, Informatica PowerMart 6.2/5.1.2/5.1.1/5.0/4.7.2, Informatica MDM 10.1/9.X,,, SQL*Loader, Flat Files (Fixed, CSV, Tilde Delimited), MS SQL Server Integration Services (SSIS).

Data Modeling

Scheduling Tool

Reporting Tools

Dimensional Data Modeling, Star Schema Modeling, Erwin, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Autosys, Control M, CA WORKSTATION

SSRS, SSIS, Business Intelligence Tools, MS Access, Tableau

Database and related tools

Oracle 10g/9i/8i/8/7.x, MS SQL Server 2012/2008, Teradata, PL/SQL, AQT

Languages

SQL, PL/SQL, SQL*Plus, Unix Shell Scripting, Java

Web Technologies

HTML, XHTML and XML

Operating Systems

Cloud Technologies

Microsoft XP/NT/2000/98/95, UNIX, Sun Solaris 5

AWS, Azure, Informatica Cloud

Experience

ETL Developer – Zurich American Insurance, Chicago IL April 2019 to Till Date

Good Awareness on Datawarehouse and Designing mapping using Informatica PowerCenter.

Developed Mappings using PowerCenter tool 10.x to load the data into Netezza from DB2, flat file, SQL server using various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.

Responsible for writing autosys JILs and scheduling the Informatica workflows on the Autosys server.

Testing of informatica mappings and migrated data from one database to other through ETL process.

Scheduling the workflows and Loading the files and Monitoring the workflows very frequently to ensure data loading is done accordingly.

Coordinated with the team on testing the code involving debugging, identifying bugs and analyzing the data.

Actively participated in the daily status meetings for the production issues and resolving tickets.

Extensively interacted with the Business User and Business system analysts to understand the functionality and resolving the User Acceptance Test issues.

Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from staging tables to the target schema.

As a production on-call support, identified the root cause and resolved the job failures by going through the Autosys jobs, Unix shell scripts and corresponding pl/sql packages called inside the shell scripts.

Identify the bad data coming from the flat files and by error log tables, log files and communicated to the source system to resolve the job failures.

Involved in data migration from Production to test and created test data for analyzing problems, providing solution.

Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL PLus, SQL developer, and toad.

Have done the performance tuning on the long running queries.

Wrote the Unix scripts for scheduling or running the scripts for day to day transactions.

Experienced in writing scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.

Keep track of Change request for the production deployment & support document.

Interact with business, gathering requirements, co-ordinate with offshore team to deliver the code to client.

Developing Stored Procedures, Functions, Views and Triggers, SQL queries using SQL Server and Oracle PL/SQL.

Analyzed and resolves the data issues identified by business users, IT operations, or partners and captured the test results.

Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.

Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target datastructures.

Assigning work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle (SQL, PL/SQL), SQL Server and UNIX shell scripting to perform job scheduling.

Support the Client Reporting Production Environment as a first priority.

Provided production support to various manuals and deployment.

Automated loads by designing job sequencers, creating shell scripts and scheduling the loads as required.

Trouble-shooting production incidents requiring detailed analysis of issues and used Autosys batch jobs, and databases.

Analyze production issues to determine root cause and provides fix recommendations to the development team.

Provide on call 24/7 production support by identifying defects, documenting, resolving the issues and working with Change Management, DBA and other teams to come up with fixes.

Knowledge of SAP HANA security including User Management, Roles and Privileges.

Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.

Responsible for modelling security models in HANA specific to schemas, packages and analytical privileges.

Hands - on experience in creating Tables, Procedure, Decision Table, Table Function and various objects.

Environment : Informatica power center 10.2/9.6, Netezza, HP Quality Center, AQT, SQL, UNIX, Autosys, Oracle, PL/SQL, SAP Hana, SQL PLUS.

Informatica Developer – Nationwide Insurance,Columbus,Ohio June 2018 to Dec 2018

Used Informatica Power Center 10.x to Extract Transform and Load(ETL).

Developed mappings, workflows, Sessions using the ETL tools like workflow Manager, Task Developer and workflow designer and monitored the results.

Developed informatica mappings using ETL Tools to load the data into Netezza and Eagle from various sources like oracle and flatfile using various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.

Developed UNIX scripts to move the source files to Archive Directory using CICS Explorer.

Worked on Unix environment to extract the required data, triggered and run the job scheduling in dev, Test and preprod.

Developed UNIXShellscripts to automate repetitive databaseprocesses.

Created Microsoft SSIS packages to extract data from Sql Server database to flat files.

Extensively developed UNIX Shell scripts to transfer and archive account files.

Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.

Automated loads by designing job sequencers, creating shell scripts and scheduling the loads as required.

Experienced as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Extracted data from oracle database using Advanced Query language Tool(AQT).

Created packages and jobs using Changeman(CICS explorer) and Loading using CA Workstation.

Extensively used EXTERNAL TABLES for data conversion in staging area before loading the data into the respective dimensional tables and fact tables.

Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.

Responsible for modelling security models in HANA specific to schemas, packages and analytical privileges.

Extensively used INDEXES AND HINTS for better performance of queries.

Scheduled various daily and monthly ETL loads using ESP.

Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.

Used UTL_FILE an oracle built in function to transfer data from the source system to flat files to conversion staging area.

As a production on-call support, identified the root cause and resolved the job failures by going through the Autosys jobs, Unix shell scripts and corresponding pl/sql packages called inside the shell scripts.

Identify the bad data coming from the flat files and by error log tables, log files and communicated to the source system to resolve the job failures.

Coordinated with QA People to follow up the issues on testing to make the code perfect without any issues before migrating to the production.

Provided rotational L3 production support resolving production issues in ETL processes.

Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and evaluating transformations.

Experienced as a short term tester, tested code in dev, test and preprod environment.

Scheduling the workflows and Loading the files and Monitoring the workflows very frequently to ensure data loading is done accordingly.

Performed data validation after the successfull End to End tests and appropriate error handling in ETL processes.

Prepared SQL Queries to Validate the data both in sources and targets.

Created PL/SQL Stored Procedures, Functions, Packages utilizing Cursors, user-defined exceptions and reusing Oracle pre-defined packages.

Tested End to End to verify the failures in the mappings.

Developed Parameter files for passing values to the mappings for each type of client.

Involved in extracting data from the Flat Files and Relational databases into staging area.

Worked on design and development of informatica mappings, workflows to load data into staging area, datamarts in Oracle, Eagle and Netezza.

Tuned Performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.

Involved in unit testing and documentation of teh ETL process.

Participated in Daily status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Creating database objects like SQL queries, tables, joins stored procedures using Oracle utilities like PL/SQL, SQL plus, SQL server.

Environment: Informatica power center 10.2/9.6, Netezza, Eagle,AQT,SQL,Oracle 11/10g, PL/SQL, UNIX,ESP,CA Workstation.

ETL Developer – ITGBrands, Greensboro,NC June 2016 to May 2018

Analyzed the business systems, gathered requirements from the users and documented business needs for decision support data.

Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.

Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.

Created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.

Prepared technical documentation to map source to target.

As a production on-call support, identified the root cause and resolved the job failures by going through the Autosys jobs, Unix shell scripts and corresponding pl/sql packages called inside the shell scripts.

Identify the bad data coming from the flat files and by error log tables, log files and communicated to the source system to resolve the job failures.

Designed, Developed, Deployed and implemented ETL mappings using Informatica

Responsible for loading data files from various external sources like ORACLE into staging area.

Involved in migrating Workflows, Mappings, and other repository objects from Development to QA and then to production.

Developed Jobs and monitoring, managing loads using Control – M Scheduling tool.

Extracted data from Oracle and SQL Server then used Teradata for data warehousing.

Participated in the development and implementation of the MDM decommissioning project using Informatica PowerCenter that reduced the cost and time of implementation and development.

Used SQL Assistant to querying Teradata tables.

Responsible for performance tuning at all levels of the Data warehouse.

Created Informatica sessions in workflow manager to load the data from staging to Target database.

Prepared technical design/specifications for data Extraction, Transformation and Loading.

Using Aggregator transformation calculated SUM, AVG of monthly sales for different products.

Designed the Mapping Design documents and the Deployment Documents.

Designed and Developed several mappings to Load the Dimensions and the fact tables.

Created Informatica mappings to extract data from sources and staged in Oracle and populated the warehouse.

Extensively used various transformations like Union, Expression, Filter, Aggregator, Lookup and Router Transformations etc.

Worked with various look-up caches.

Worked with connected and unconnected look-up for implementing complex logic.

Used key range partitioning, hash partitioning for performance tuning.

Identified the bottle necks and tuned the mappings and sessions to improve performance.

Created sessions and workflows for processing and to populate the dimensions and facts in the star schema.

Created Test cases for the mappings developed and then created integration Testing Document.

Used the advanced features of PL/SQL like Records, Tables and Object types.

Responsible for writing procedures drop and create partitions of large volume tables for the archival process.

Worked with QA team on daily basis to follow up on the bugs and made sure the code is bug free before migrating to Production.

Wrote SQL, scripts code for extracting data from system.

Performed integration testing for various mappings. Tested the data and data integrity among various sources and targets

Environment: Informatica PowerCenter 9.6, Informatica MDM, Teradata12, ETL, Shell scripting, Flat files, Oracle 11g, MS SQL Server 2012, PL/SQL, Autosys, SQL * Loader, Excel and Unix, Control M.

ETL Developer-ApolloMicroSystems, Hyderabad, India June 2013 to Dec 2014

Designed/implemented new capabilities in support of Enterprise ETL Solutions. Extraction, Transform and load activities.

Developed mappings, sessions and workflows and other tasks.

Works closely on business requirement changes.

Investigated and resolve ETL issues and provide necessary communications regarding progress, performance, issues and risks.

Collaborates with other teams to address upstream and downstream integration dependencies.

Responsible for Informatica code and database objects migration.

Scheduling ETL jobs, Monitor ETL loads/ Informatica jobs availability and reliability.

Required project documentation for development and change requests.

Informatica performance tuning methods.

Writing medium to complex SQL queries.

Created Technical Specification and Data Mapping documents by gathering functional requirements from Business Analysts.

Developed Informatica mappings and workflows to create intermediate data files by integrating data from feeds and database.

Used SQL Loader to load data from delimited files into Oracle tables.

Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.

Maintained versions of code and supporting documents in Clear Case (UNIX)

Prepared and deployed build from DEV to other environments.

Created Parameter files and UNIX Environmental files.

Coordinated with QA, development teams during System Integration and User Acceptance Testing to accurately resolve the issues.

Conducted Knowledge sharing sessions with the Development team.

Environment: Informatica Power Center 8.6, UNIX Shell Scripting, Oracle 9i, PL/SQL, Clear case (in UNIX)

Education

MS: Information Technology : Lawrence technological university, Southfield, MI 2016

References

Available on request

Contact this candidate