SUMMARY

• Over 8 plus Years of IT experience in Software Development Life Cycle (SDLC) which includes requirement gathering, designing, implementing, Maintenance and testing and Data Warehousing implementations across various domains.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• 6.5 years of Strong expertise in using ETL Tool Informatica Power Center 9.6.1/9.0.1/8. x/10.2 (Designer, Workflow Manager and Repository Manager
• Strong experience with Informatica tools for incremental load like Change Data Capture (CDC), MD5 etc.
• Performed the data profiling and analysisusing SQL.
• Worked with Teradata utilities like Fast Load, Multi Load, Tpump, Teradata Parallel transporter and highly experienced in Teradata SQL Programming.
• Experienced in Teradata Parallel Transporter (TPT). Frequently used full PDO on Teradata and worked with different Teradata load operators.
• Designing and developing Informatica mappings including slowly changing dimensions (SCD) type 1 and Type 2.
• Validating data files against their control files and performing technical data quality checks to certify source file usage.
• Very good in data modeling knowledge in ER and Dimensional Data modeling, Star / Snow - flake Schema, Fact/ Dimensions tables.
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Package, Functions, Triggers,Views, and Materialized Views.
• Experienced in using advanced concepts of Informatica like push down optimization (PDO).
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from different data sources like Multiple Relational Databases (ORACLE 12c/11g/10g, Teradata 14/13, Netezza, DB2, SQL server 2005/2012/2017 , Informix, MySQL, JSON,XML, Flat files
• Experience in using Automation Scheduling tools like Control-M, Autosys and Cisco Automation Workload
• Worked with various transformations like Normalizer, expression, rank, filter, aggregator, lookups, joiner, sequence generator, sorter, SQLT, stored procedure, Update strategy, Source Qualifier, Transaction Control, Union, CDC etc.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using Teradata bteq shell scripting.
• Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.
• Experience in preparing different types of project related document like ETL Specification, Source to Target Mapping, Test Case, Design document, scheduling, deployment, training document etc.,
• Experience in working with Agile environment for many years using Rally, Icescrum, JIRA etc.
• Excellent domain knowledge of HealthCare, Retails and Telecommunication.
• Good skills in defining standards, methodologies and performing technical design reviews.
• Committed team player. Ability to adapt to changing professional work environment to implement software solutions in an efficient manner.

TECHNICAL SKILLS

ETL Tools: Informatica 9.6.1/9.1/8.6.1/10.2

Data Modeling Tools / methodology: ERWIN 9.5.2/7.3/4.1 , MS - Visio. Ralph Kimball and Bill Inman Methodology

Databases: Oracle 11g/10g/9i, Teradata 14/13, MS SQL Server 2008/2005/2017 , DB2, MS Access 2008, Sybase

Environment: Windows family, UNIX

Job Scheduling: Control-M, Autosys, Cisco Automation Workload

Reporting Tools: Tableau 10/9x, Excel

SDLC: Waterfall, Agile, TD

Others: Notepad++, Teradata SQL Assistant, Teradata view point MS office, T-SQL, TOAD, SQL Developer, XML Files, Rally Icescrum, JIRA, PL/SQL Developer, Bugzilla, Toad, SQL Navigator

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton FL

Informatica Developer

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis and testing and project- coordination using interviews, document analysis, business process descriptions, scenarios and workflow analysis.
• Created Technical Design Document or Minor Release Document (MRD) from business requirements document (BRD) or Functional Requirement Document (FRD) business analyst based on business objectives, facilitated joint sessions.
• Analyzed business and system requirements to identify system impacts.
• Created the Detail Technical Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, Database changes, shell scripts etc. and conducted meetings with the business analysis, clients for the Approval of the process.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Created UNIX scripts to read/write and ftp files from and to windows servers and UNIX.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test and supported the UAT for the client.
• Performing ETL and database code migrations across environments using deployment groups.
• Populating the business rules using mappings into the target tables.
• Developed Informatica Data Quality Mappings, sessions, workflows, scripts and orchestration Schedules.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Worked in agile minor release cycles the designated database developer.
• Unit test and support QA and UAT testing for database changes.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production.

Environment: Informatica PowerCenter 9.5/10.2, SQL Developer 19.1.0, Oracle 11g, SQL Server 2005/2017, Cisco workload Automation, Sharepoint, winSCP 5.13.4, Servivenow,Putty, Linux 7.3, Shell Scripting, Notepad++

Confidential, Richardson, TX

Informatica Developer

Responsibilities:

• Involved in business requirement analysis and prepared functional requirement document.
• Involved in the ETL technical design discussions and prepared ETL high level technical design document.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Designed and developed ETL Informatica mappings. Scheduled and Managed Informatica sessions.
• Extracted large volumes of data form Mainframes systems to target DB2 database.
• Extensively worked on Performance tuning of queries. Complex SQL queries are used for data retrieval.
• Designed, Developed and Deployed UNIX shell scripts.
• Development & Implementation of a data warehousing project and production support for enhancements and maintenance.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Coordinated and worked closely with architects, operations, and business units to build and deploy.
• Implementing data quality management solutions that manage millions of customer transactions.
• Prepared BTEQ scripts to pull source data. Also used MLOAD scripts to load multiple static tables. For few large transactional tables wrote TPUMP scripts to load into Teradata database.
• Performed systems, data quality assurance, system testing, ensuring that software and systems perform to specification
• Established test environments and test data and advocate the use of common re-usable functions, services and data
• Participated in quality assurance activities like reviews, walkthroughs etc.
• Performed extensive risk assessment prior to production implementations and carried out validations for post implementation to ensure successful execution monitoring performance.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica PowerCenter 9.6.1, Tableau 10, Oracle 11g, Teradata 15.0, Teradata SQL Assistant, SQL Server 2012, DB2, Erwin 9.2, Control M, Putty, Shell Scripting, WinSCP, Notepad++, Rally, JIRA

Confidential,Irving, TX

ETL Informatica Developer

Responsibilities:

• Involved in business requirement analysis and prepared functional requirement document.
• Involved in the ETL technical design discussions and prepared ETL high level technical design document.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Worked on source analyzer, Ware House Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• Created mappings for initial load in PowerCenter Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in PowerCenter Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, and Union.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Involved in writing and implementing FastExport, Bteq, Multiload scripts for Teradata application. Oversee the technical design of the data warehouse, optimizing for scale and performance.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Responsibilities include creating the sessions and scheduling the sessions.
• Created various tasks to give various conditions in the workflows.
• Involving in extracting the data from Oracle and Flat Files Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Worklets and Workflows.
• Created parameters and variables for the reusable sessions.
• Analyzed the various bottlenecks at source, target, mapping and session level.
• Tuning of the mappings and SQL Scripts for a better performance.
• Designed the ETL processes using Informatica to load data from DB2, SQL Server and Flat files to the Target Database.
• Experience in analyzing business specification documents, developing test plans defining test cases, developing and XML test scripts.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica PowerCenter 8.6.1,Tableau 9.2,Cognos 9, SQL Server 2008, Oracle 11g, PL/SQL, TOAD, Putty, Autosys Scheduler, UNIX, Teradata 13, Erwin 7.5, WinSCP

Confidential

ETLInformatica Developer

Responsibilities:

• Analysis, requirements gathering, functional/technical specification, development, deploying and testing.
• Significant Multi-dimensional and Relational data modeling experience with modeling tool like ERWIN with a strong emphasis on data Warehouse/data Marts analysis, design, and implementation.
• Extensive use of Informatica Tools like Designer, Workflow Manger and Workflow Monitor.
• Extensively used Informatica client tools like Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, and Informatica Server Manager.
• Extracted source data from Oracle, SQL Server, Flat files and XML using Informatica, and loaded into Oracle or flat file targets.
• Used transformations like Aggregators, Sorter, Dynamic lookups, Connected & unconnected lookups, Filters, Expression, Router, Joiner, Source Qualifier, Update Strategy, sequence Generator.
• Developed, tested stored procedures, functions in PL/SQL
• Created reusable transformations and mapplets to use in multiple mappings
• Used Workflow Manager/Monitor for creating and monitoring workflows and worklets.
• Improved the session performance by pipe line partitioning
• Extensively used mapping parameters, mapping variables and parameter files
• Analyzed the query performance and designed the loading process schedules
• Created sessions and batches for various mappings and automated using UNIX shell scripts.
• Wrote the shell scripts to process the PL/SQL procedures and wrote the PL/SQL program units for data extracting, transforming and loading.
• Involved in troubleshooting the loading failure cases, including database problems.

Environment: Informatica Power Center 8.1, SQL, PL/SQL, UNIX, Shell Scripting, SQL Server 2008, Sybase, Oracle 11g, DB2, Control-M, MicroStrategy 9

Confidential, Irving, US

ETL Informatica Developer

Responsibilities:

• Understand the problem description stated in BRD and design and write ETL Specifications
• Designing the ETL jobs using Informatica tool to load data from ORACLE 9i to Netezza Database
• Designing and reviewing the ETL solutions in Informatica Power Center 8X
• Based on the requirements, created Functional design documents and Technical Design specification documents for ETL Process.
• Worked as ETL Developer involved in the development of ETL process using Informatica to load data from source oracle database into the target oracle database and flat files.
• Designing and optimizing the Mapping to load the data in Slowly Changing Dimensions.
• Involved in Performance Tuning at various levels including Target, Source and Mapping.
• Used Debugger to gain troubleshooting information from the mappings.
• Worked on Migration from Dev environment to Test Environment.
• Write Test Cases and perform integration testing
• Writing SQL queries to generate the data files for Testing/validation
• Assisted gathering business requirements and worked closely in various Applications with Business Analyst teams to develop Data Model, ETL procedures to design Data Warehouse.
• Designed and developed schema model for target database using Erwin Data modeling.
• Designed and developed Context for faster development, standardization and reusability purposes.
• Involved in pre and post session migration planning for optimizing data load performance.
• Understanding client process to work efficiently and deliver solutions in accordance with company standards and business practices and procedures.
• Have developed a level of competency, which helps to anticipate issues solve them in advance.
• Involved in analyzing, resolving and providing temporary fix for the Data Issuesalso had to interact with the business users to intimate and do the recovery steps if there is any problem in the process
• Deployment to various servers & Migration activities.

Environment: Informatica Power Center 8.1, SQL, Windows 2008, UNIX, SQL Server 2000, Oracle 9i, Netezza, Flat files, SQL *Plus, Business Objects 5.1.6