SUMMARY:

• 6 years of hands - on development experience with ETL tools (i.e Informatica), 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.
• 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.
• 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.
• Involved in understanding client Requirements, Analysis of Functional specification, Technical specification preparation and Review of Technical Specification.
• 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.
• Expertise in working in Agile Environment (Scrum), Waterfall.

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: Dimensional Data Modeling, Star Schema Modeling, Erwin, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling. Autosys, Control M, CA WORKSTATION, Tivoli Workload scheduler (TWS). SSRS, 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: Microsoft XP/NT/2000/98/95, UNIX, Sun Solaris 5 AWS, Azure, Informatica Cloud

EXPERIENCE:

ETL Developer

Confidential, Chicago, IL

Responsibilities:

• 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.
• Testing of informatica mappings and migrated data from one database to other through ETL process.
• Created new scheduling jobs using Autosys tool.
• Scheduling the workflows and Loading the files and Monitoring the workflows very frequently to ensure data loading is done accordingly.
• Designed and Developed the Netezza SQL Scripts as per the Customer requirements.
• Coordinated with the team on testing the code involving debugging, identifying bugs and analyzing the data.
• Create Functional design documents and technical design specification documents for ETL process.
• Applying SQL /PL SQL knowledge to write efficient SQL queries or Stored Procedures wherever required.
• Troubleshooting SQL Performance issues.
• Addressing production issues like performance tuning and enhancements.
• 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.
• 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.
• Trouble-shooting production incidents requiring detailed analysis of issues and used Autosys batch jobs, and databases.
• Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle (SQL, PL/SQL), SQL Server and UNIX shell scripting to perform job scheduling.
• Participated in Daily status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica power center 10.2/9.6, Netezza, HP Quality Center, AQT, SQL, UNIX, Autosys.

Informatica Developer

Confidential, Columbus, Ohio

Responsibilities:

• 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.
• Extracted data from oracle database using Advanced Query language Tool(AQT).
• Created packages and jobs using Changeman(CICS explorer) and Loading using CA Workstation.
• Scheduled various daily and monthly ETL loads using ESP.
• Experienced with Service Now Ticketing.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Coordinated with QA People to follow up the issues on testing to make the code perfect without any issues before migrating to the production.
• 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.
• 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 the 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.

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

ETL Developer

Confidential, Greensboro, NC

Responsibilities:

• Analyzed the business systems, gathered requirements from the users and documented business needs for decision support data.
• 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.
• 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

Confidential

Responsibilities:

• 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)