SUMMARY:

• 6 years of experience in ETL implementation using Informatica Power Center, Informatica Power Exchange, Informatica Data Quality (IDQ), Web Services including installation and configuration in client server environment. Worked extensively on Data Warehouses, Data Marts, Operation Data Store (ODS), Data Extraction projects using Informatica tools.
• Worked in complete Software Development Life Cycle (SDLC) Implementation from Requirement Gathering, Analysis, Data Modeling, Design, Implementation, Testing, Implementation, Post Implementation Support and Maintenance.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational and dimensional modeling.
• Experience in creation of documents like Functional Specifications (FS), Business Requirement Documents (BRD), User Data Sheets (UDS), and Detailed design documents (DDD), ETL Specifications Documents, ETL Process Flow Charts and DFDs.
• Experienced on various databases like Oracle 12c/11g/10g/9i/, MS-SQL Server 2012/2008/2005 and DB2 with experience in Informatica Version Control.
• Expertise in importing data from Flat Files, XML files, CSV files and different relational sources like Oracle, DB2, Teradata, SQL Server.
• Experience in creating Mappings, Transformations, Sessions, workflows and worklets to extract data from various sources and load into targets using Informatica Power center.
• Experienced and handled various complexes joins by writing (SQL, T/SQL, Oracle PL/SQL command’s)
• Knowledge of EDI Transactions.
• Created Indexes, Views, Triggers, Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and Data Usage during ETL process.
• Expertise knowledge in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, views and other SQL joins and statements for applications using SQL Server 2008/2012.
• Experience in maintenance of SSIS by creating Jobs, Alerts, and SQL Mail Agent, schedule DTS / SSIS .
• Designed and Deployed several SSRS reports such as Drill down reports, Drill through reports, Cached reports, ad-hoc reports, Sub reports.
• Expert Developer skills in Teradata RDBMS, development and production DBA support use of FASTLOAD, MULTILOAD, TPUMP, and Teradata SQL and BTEQ Teradata utilities.
• Understanding of Ralph Kimball Data Warehouse methodologies and knowledge on the various data design models like Star Schema and Snowflake models
• Expertise in writing UNIX Shell Scripts and load schedule preparation.
• Develop, execute ETL test plans, Document ETL processing and generate required metadata
• Worked with Oracle and SQL Server Stored Procedures, Functions, Triggers, Index, SQL*Loader.
• Knowledge in developing reports using Business Intelligence tools like Business Objects and Cognos.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.
• Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, maintenance and production support.

TECHNICAL SKILLS:

Methodologies: Waterfall and Agile Methodologies

Requirement Management Tools: Rational Requisite Pro, JIRA, ALM, Rational Team.

Web Technologies: CICS, PL/SQL, T-SQL, C#.NET, C++, ASP.Net and HTML

Reporting Tools: SQL Server Reporting Services, MS Power pivot, Tabular, Share point, Dashboard.

Databases: MS SQL Server (2008, 2008R2, 2012), PSQL Oracle 9i/10g,11G SQL Server 2005, 2008, MS-Access Toad Oracle and MySQL and OLDB. Teradata. Mongo DB.

Tools /Methodologies: Rational Unified Process (RUP), UML MS Visio, MS Project, SQL Profiler, MS Office, PowerPoint presentation

DWH/BI Tools: SSIS (2005, 2008, 2012,), SSRS (2005, 2008, 2012)), Crystal Reports, Studio (BIDS), Visual Studio, Erwin Data Modeler. Dashboard

ETL Tools: Data Stage, Informatica Power Center, Informatica DVO, Query Surge, OBIEE

Office Tools & Applications: MS Office SharePoint, Word, Excel, PowerPoint, UML, Adobe Acrobat, Skype for Business, Enterprise Project Server Outlook

Application Servers: Apache Tomcat 7.053, WebLogic 2.0.59, JBOSS, WebSphere

Operating Systems: Mac OS, Unix Sun Solaris 5.1.0, Red Hat Linux 6.5, Windows20

PROFESSIONAL EXPERIENCE:

Confidential, FL

Informatica Developer

Role’s & Responsibilities:

• Worked in Agile development methodology environment and Interacted with the users, Business Analysts for collecting, understanding the business requirements.
• Worked on building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in the installation and configuration of Informatica Power Center 10.1 and evaluated Partition concepts in Power Center 10.1
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created stored procedures, views, user defined functions and common table expressions.
• Generated underlying data for the reports through SSIS exported cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in IDS Services like building Business logics, analyzing the structure and data quality, creating a single view of data etc.
• Worked on Informatica cloud for creating source and target objects, developed source to target mappings.
• Involved in importing the existing Power center workflows as Informatica Cloud Service tasks by utilizing Informatica Cloud Integration.
• Involved in Data integration, monitoring, auditing using Informatica Cloud Designer.
• Worked on Data Synchronization and Data Replication in Informatica cloud.
• Written PL/SQL scripts created stored procedures and functions and debugged them.
• Created Mapplets, reusable transformations and used them in different mappings. Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads and Developed reports based on issues related to the data warehouse.
• Used different Informatica Data Quality transformations in the Developer and Configured match properties match paths, fuzzy match key, fuzzy and exact match columns
• Created profiles, rules, scorecards for data profiling and quality using IDQ.
• Used Informatica Data Quality for addresses and names clean-ups and developed error handling & data quality checks to pull out the right data
• Used IDQ to cleanse and accuracy check the project data, check for duplicate or redundant records.
• Used debugger to test the mapping and fix the bugs and identified the bottlenecks in all levels to tune the performance and Resolved the production support tickets using remedy.
• Developed monitoring scripts in UNIX and moved Data Files to another server by using SCP on UNIX platform.
• Extensively used Teradata Utilities like Fast-Load, Multi-Load, BTEQ & Fast-Export.
• Created Teradata External loader connections such as M Load, Upsert and Update, Fast load while loading data into the target tables in Teradata Database.
• Involved creating the tables in Teradata and setting up the various environments like DEV, SIT, UAT and PROD.

Environment : Informatica Power Center 10.1, Oracle12C, Informatica Cloud, IDS 9.6.1, IDQ 9.6.1 Teradata 14.0, SQL Server 2014, Teradata Data Mover, Autosys Scheduler Tool, Netezza, UNIX, Toad, PL/SQL, SSIS, Power Connect, DB2, Business Objects XI3.5.

Confidential, Minneapolis

ETL Developer

Role’s & Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements
• Communicated with business customers to discuss the issues and requirements
• Created shell scripts to fine tune the ETL flow of the Informatica workflows
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• 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.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica 8.6.1 ,SQL Server 2008 R2, HP-UX, MS SQL Server 2008 and 2012,Power BI, SQL Server Integration Services, MSSQL Server 2008R2/2012. SQL Server Management Studio 2012 (SSIS, SSRS, SSAS), Microsoft Visual Studio 2008, 2012 T/SQL MS Access, Informatica PowerCenter Designer 8.6/8.1, Informatica Repository

Confidential, IL

BI/ETL Developer

Role’s & Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specification
• Created complex mappings that involved implementation of Business Logic to load data in to staging area
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Write Shell script running workflows in Unix environment.
• Optimizing performance tuning at source, target, mapping and session level
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica 8.6 .1,Oracle 11g, SQL Server 2005, HP-UX.

Cerner, KS

ETL Tester

Roles & Responsibilities:

• Used TOAD to write SQL and validate the backend
• Used SQL Teradata Assistant for data retrieval from Teradata
• Identified bugs and interacted with team lead and developers to resolve the bugs
• Used Back-end testing using SQL queries to validate the data in the back-end Oracle Database
• Test several ETL Ab Initio graphs against ETL transformation rules.
• Maintained the test matrices and reported bugs using Rational Clear Case
• Created Test Strategy and Test plan for the testing effort
• Conducted Smoke, Non-Functional, Functional, System and Integration testing.
• Developed SQL and Stored procedures to achieve the data transformations
• Performed back-end testing on the Oracle database by writing SQL queries
• Conducted backend testing using Toad
• Participated in weekly meetings with the management team
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Performed the back-end testing by using SQL Queries and verified the data integrity.
• Coordinated with the developers to resolve defects.
• Involved in documentation to maintain and run scripts for future enhancements.

Environment: Ab Initio (GDE 1.12, Co>Op 2.12), Autosys, SQL, T-SQL, SQL Server 2000/2005, Teradata V2R4, Test Director, MS Office Suite, IE, ASP, Crystal Reports, HTML, JAVA, JSP, JavaScript Windows NT/XP/2000, Rational Clear Quest/Clear Case.

Confidential

ETL Informatica Developer

Roles & Responsibilities:

• Interacted with business partners and gathered the requirements
• Assisted in designing logical and physical data modeling
• Developed Informatica mappings to extract the data from flat files and DB2 tables
• Created complex mappings using different transformations like Filter, Connected/Un-connected lookups, stored procedures, aggregator, joiner, router and update strategy
• Created SCD (Slowly Changing Dimension) type 1 and 2 mappings
• Created Informatica mapplets to reuse the same functionality in multiple mappings
• Created workflows and modified worklets to run the new/modified sessions
• Developed shell scripts to run the Informatica workflows
• Worked with DBAs to review the changed/new SQLs and made code changes as per their recommendations
• Performed unit testing and validated the data according to source to target mappings
• Documented the test results and shared to project for reviews
• Identified the bottlenecks and tuned the performance
• Implemented the code to production and supported for one-month

Environment: Informatica Power Center, DB2, Unix Shell Scripting, WinSQL

Confidential

Oracle PL/SQL Developer

Roles & Responsibilities:

• Extensively Performed back end database development tasks such as PL/SQL, Trigger, SQL Queries, Functions and Packages.
• Involved in performance tuning and monitoring, tuned SQL queries using Explain plan.
• Added hints, indexes and parallel processing techniques for the queries.
• Created SQL to delete the duplicate values from the datable table.
• Developed several procedures and functions using advanced Oracle concepts such as REF CURSORS and BULK COLLECTS, INDEX BY TABLES and FORALL statements to improve performance in insert and update statements.
• Performed unit and integration testing of the applications created using PL/SQL modules and used PVCS for version control in team development.
• Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
• Created PL/SQL Packages for easier application design and improved Performance.
• Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables (Nested Tables and Arrays) and performed Error Handling.
• Extensively used Cursors, Ref Cursors, Dynamic SQL and Functions.
• Participated in Performance Tuning using Explain Plan.

Environment: MS Suite's Windows 2008 enterprise, SQL Server 08/ SQL Integration Services (SSIS), SQL Reporting Services (SSRS), and Dashboard. MS -Share point, T - SQL MS Access, .Net /Windows 2008/ XP.