SUMMARY

• 9+ years of experience in IT, with proficiency in Data Warehouse development, Extract Transform Load processes using Informatica PowerCenter and Teradatain Healthcare, Retail, and financial domains as an ETL Informatica Teradata Developer/Tester.
• Having strong experience in data analysis, design, development, and implementation of data warehousing and data integration applications using Teradata, SQL Server, Oracle and Informatica PowerCenter as an ETL tool.
• Extensive experience in understanding requirements and build ETL mappings and UNIX scripts to integrate data using Informatica Power center and Teradata database.
• Strong experience on Teradata database and utilities like BTEQ, FASTLOAD, MUTLTILOAD, TPUMP, FASTEXPORT and TPT.
• Experience in data profiling, metadata and prioritizein maintaining high quality of data.
• Extensively used ETL methodologies for supporting data extraction, applying transformations, and loading data into the target process using Informatica PowerCenter.
• Knowledge of ETL concepts, facts, and dimensions tables, slowly changing dimensions, and Dimensional Modeling.
• Experience in using EXPLAIN PLAN to enhance complex queries in Teradata database.
• Experience in End - to-End testing forInformaticamappings, workflows, and outputs based on the business specifications.
• Expertise in using Automation Scheduling tools like Active batch, Tivoli, and Control-M.
• Knowledge of QA lifecycle and involve planning, implementation, assessment, reporting, and work on quality improvement to ensure that required data quality is in place.
• Managed and complied documentation for all ETL technical documents and provide a walkthrough to business.
• Experience in JIRA, Confluence, GIT,and other tools in various enterprises.
• Coordinated with offshore team on daily status and assigning the tasks andbe a liaison between clients and the offshore team to fill in gaps.
• Experience working in Agile-SCRUM, LESS, Kanban frameworks development environment.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr.ETL Teradata Developer

Responsibilities:

• Coordinated with business Analysts and business to gather all the requirements for initiating the Design and development process.
• Participated in Data Model review meeting in helping the business to provide better output for tables based on columns and Assist Business Analyst in design of mapping documents.
• Participated in PI meetings and plan on future sprint’s effort estimation for the next quarter.
• Participated actively in all sprint ceremonies like Daily standup to provide daily updates, sprint planning, Sprint retrospective to provide feedback etc.
• Analyzed the Mapping document and requirements to provide efficient outputs to setup design and development plan to offshore team.
• Extensively worked on Teradata as database to build and implement complex SQL queries using BTEQ scripts.
• Performed Data Profiling for large complex data sets in various areas of MedicareRevenue DataMart.
• Worked on Design documents like Approach, Technical Design Documents, Test cases and Test plan.
• Developed and optimized Teradata batch processing scripts and aggregating before loading into the data mart using BTEQ.
• Reviewed and improvised existing UNIX scripts for ETL processes for automation.
• Reviewed all the required documents with the business and provide inputs to the offshore team for any changes to align with the business requirement.
• Responsible for managing different sources and performing RCA in case of defects.
• Reviewed BTEQ scripts, FastExport, Multiloads and FastLoad scripts.
• Provided UAT support for business users and act as a bridge between Offshore team and users.
• Performed regression testing for defects fixed in UAT and PROD environments.
• Performed data copy operations from PROD to UAT for User Acceptance Testing.
• Followed entire Confidential processes for successful implementation from Development to Production and support.
• Participated in peer reviews and provided inputs to develop an efficient code and assist the team.
• Involved in Control M setup review meetings and get approval for CTM setup from Development to PROD.
• Agile - SCRUM methodology is followed by the team.

Environment: Informatica PowerCenter 10.1,Teradata SQL, Teradata Tools & Utilities,Control - M, JIRA, Confluence, UNIX

Confidential, Alpharetta, GA

Sr.ETL Developer/Tester

Responsibilities:

• Understanding business requirements to initiate the design phase to develop the ETL process according to client requirements.
• Developed UNIX scripts to automate ETL processes for loading data into the data warehouse.
• Used Hadoop data lake tables as the source and created similar views in Teradata.
• Performed data analysis to run queries on Hadoop data lake tables to validate the source and target data.
• Involved in designing and building Teradata EDW using Teradata as database and Informatica as an ETL tool.
• Perform Performance tuning by making efficient queries and fixing bad queries and to avoid spool space issues or skewing of data.
• Worked on Designing BTEQ scripts to embed complex SQL queries and perform testing as required to meet the business requirements.
• Used Teradata TPT for Data loading from various sources to Teradata warehouse.
• Responsible for managing data coming from different sources and providing support for users by debugging code in case of any defects and performing RCA.
• Prepare various documents (test execution plans, Test cases, and TES documents) for various phases like DEV, SIT, UAT, and PROD implementations.
• Performance tuning by enhancing Informatica Mappings for optimizing various ETL processes.
• Prepare various test artifacts like test cases for unit testing and provide a walkthrough to the business for sign-off.
• Involved in conducting peer reviews for critical ETL processes and providing feedback to make the process efficient and error-free.
• Tested the functionality of the systems in various phases in DEV, SIT, and UAT to make the implementation process smooth.
• Implemented various test cases in SIT the ETL process for data quality (Quality Assurance) as well as post-prod validation.
• Agile - SCRUM methodology followed.

Environment: Informatica PowerCenter 10.1, TWS Tivoli,GIT Extension, Teradata SQL, JIRA

Confidential, Nashville, TN

Sr.ETL Developer/Tester

Responsibilities:

• Understanding business requirements and analyzing data to formulate the design phase to develop the ETL process according to client requirements.
• Worked on data Extraction, Transformation, and loading from source to target system using BTEQ, Fast Load, and Multiload.
• Design process-oriented UNIX scripts and ETL processes for loading data into the data warehouse.
• Error handling and performance tuning in Teradata queries and utilities.
• Prepare various test cases for unit testing and provide a walkthrough to the lead for signoff.
• Followed ETL coding, and mapping standards.
• Prepare test plan, Test cases, and Test execution summary documents for various phases like DEV, SIT, UAT, and PROD implementations.
• Implemented various test cases from end to end throughout the ETL process for data quality (Quality Assurance) and tested the functionality of the systems in various phases in DEV, SIT, and UAT.
• Designed the complete workflows for all the extracts mappings to serve the business requirements with dependency hierarchy.
• Performance tuning for a huge volume of data using Informatica and Teradata.
• Responsible to manage data coming from different sources and provide support fora Production system.
• Used External Loaders like MultiLoad and FastLoad to load data into the Teradata database.
• Debugging code in case of any defects and performingRCA.
• Followed Agile - SCRUM methodology.

Environment: Informatica PowerCenter 10.1, Active batch, Oracle 19c, GitHub, Teradata SQL, TOAD, JIRA

Confidential, Plano, TX

Sr. ETL Developer

Responsibilities:

• Analysis of the Jira story and Developed transformations on top of it as per the business rules using Informatica PowerCenter and TERADATA SQL.
• Performed enhancements on Informatica mappings and transformations using Informatica PowerCenter.
• Performed SQL tuning as a part of the Teradata optimization process.
• Implemented Push down approach for Informatica optimization process.
• Worked on slowly changing dimensions, indexes, partitioning, compression, and stored procedures.
• Performed data profiling for Unit testing/ SIT Testing using SQL Assistant and UNIX.
• Assisted business with UAT Testing and PROD deployment for different releases.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections, and relational connections.
• Extensively used ETL Tool Informatica to load data from heterogeneous sources like Flat Files, Oracle, Teradata, etc.
• Developed data mappings between source systems and target systems using Informatica Mapping Designer.
• Worked on AutoSys to develop and schedule jobs as per the requirement.
• Developed Informatica shared folder architecture for the projectwith reusable Mapplets and Transformations.
• Maintained Informatica version-based environment and used deployment groups to migrate the objects to higher environments.
• Design test strategy, Test Plan, and test cases and provide a walkthrough to business.
• Used debugger in identifying bugs in existing mappings by analyzing data flow andevaluating transformations.
• Performed regression testing for complex data systems and implement changes within the timeline.
• Optimizing performance of ETL by enhancing source, target, mapping, and at the session level.
• Worked in an Agile development environment and actively involved in daily Scrum and other design-related meetings.

Environment: Informatica PowerCenter9.x, SQL Server 2018, Control M, Oracle 18c, Teradata, SQL, UNIX Shell Script, TOAD, MS Visio, JIRA, Autosys.

Confidential, Richmond, VA

Sr. ETL Developer & Test Lead

Responsibilities:

• Actively involved in the development, testing, Deployment, and enhancements of existing and introduced processes.
• Used Informatica PowerCenter for (ETL) extraction, transformation, and loading of data from heterogeneous source systems into the target database.
• Developed and tested complex Teradata BTEQ scripts to maintain high data quality.
• Performed MutliLoad, FastLoad and BTEQ for bulk data loads.
• Created complex Informatica mappings using Informatica PowerCenter Designer.
• Extensively used ETL processes to load data from various sources.
• Developed and performed unit test case scenarios for new enhancements.
• Automated ETL jobs to run daily with features like email notifications for any failures.
• Involved in data extracting from various sources like Flat Files and databases into the staging area to perform transformations.
• Developed Informatica Mappings by the usage of transformations like Aggregator, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Followed complete QA lifecycle to handle defects and performed regression for complex systems.
• Enhanced existing queries and develop the performance of the queries for tuning.
• Imported various heterogeneous files using Informatica PowerCenter10.x/9.x Source Analyzer.
• Used Autosys to manage and run the complex automated process and track them.
• Worked on preparing Technical Design documents and Test cases.

Environment: Informatica PowerCenter 10.2,Teradata 16.10, TPT, BTEQ, FastLoad,Control M, Multiload, Flat files, PL/SQL, UNIX Shell Scripting.

Confidential - Woonsocket, RI

Sr.ETL Developer/Tester

Responsibilities:

• Understanding the specific business requirements and analyzing data according to client requirements.
• Worked on loading data from several flat-file sources using Teradata.
• Used Teradata SQL, BTEQ, Multiload, FastLoad, and FastExport for various Ad-hoc queries.
• Build Unix shell script to perform ETL interfaces BTEQ, FastLoad.
• Implementation of business rules and standards of source data from the many systems in the data warehouse.
• Develop and design the mapping, transformation logic, and transformation inInformatica.
• Experience in using theInformatica PowerCenter and designing, Developed the Extraction, Transformation, and Load Process (ETL) for data migration.
• Tuning the Performance of various ETL processes at the Informatica mapping level.
• Designed unit test cases for newly designed data modules and enhancements made to the system.
• Knowledge in Writing various Unix scripts for business needs.
• Experience in working on creating the mappings which involve the slowly changing dimensions.
• Designed and developed various mappings using various transformations like Aggregator, Filter, Router, Source Qualifier, Expression transformation, Sorter, and Sequence Generator transformations.

Environment: Informatica PowerCenter 10.x, Teradata 16.10, Teradata Utilities Multiload, FastLoad, Fast Export, BTEQ, TPump,TPT, BTEQ, Oracle, SQL Server, UNIX

Confidential - Foster City, CA

ETL Developer/Tester

Responsibilities:

• Analyzed the functional specifications provided by the data architect and involved in preparing Technical System Design Documents and Source to Target mapping documents.
• Involved in designing Staging and Datamart environments and built DDL scripts to reverse engineer the logical/physical data model using Erwin.
• Implemented pushdown, pipeline partition, and persistence cache for better performance.
• Worked on implementing SCD Slowly Changing Dimensions methodology to keep track of historical data.
• Used various Teradata Utilities such as MLoad, FastLoad, and TPump.
• Involved in the complete cycle from ETL Extraction, Transformation, and Loading of data using Informatica best practices.
• Performed various Data Quality checks by interacting with the business users.
• Performing Unit Testing and tuning the mappings for better performance.
• Extracted data from various heterogeneous sources like DB2, Teradata, and Flat Files using Informatica PowerCenter and loaded data into target.
• Created test artifacts like test plans, test cases with test scripts, and TES documents.
• Provided test artifacts walkthrough to business and get signoff from the business.
• Created UNIX Shell Scripts for various data cleansing scripts and automated file validation process.
• Responsible for code migration and code reviews.
• Worked on creating test plans, and test scripts, as part of Unit/Integrations testing, and UAT testing.

Environment: Informatica PowerCenter9.5.x, Oracle 12c, PL/SQL, TOAD, MS SQL SERVER 12.0, XML, UNIX, Teradata.

Confidential - Charlotte, NC

ETL Developer

Responsibilities:

• Involved in complete SDLC from requirement gathering, design, development, testing, Production, user training, and support for the production environment.
• Extensively used Informatica PowerCenter 9.5.x and Teradata for data loading.
• Design various mappings usingInformatica PowerCenter Designer like Source Analyzer, Mapplet Designer, and Mapping Designer complex Business Logic to load data to target.
• Used Informatica PowerCenter reusability at various areas of development.
• Performed Informatica Transformations on data like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Joiner, Router, Sorter, and Union.
• Developed Workflow using Informatica PowerCenter Workflow Manager using task developer
• Worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Implemented SCD’s slowly changing dimension methodology for accessing the full history of accounts.
• Developed Unix Shell scripts running workflows in the UNIX environment.
• Participated in weekly status meetings andconducted internal and external reviews as well as formal walk-throughs among various teams and documented the proceedings.

Environment: Informatica PowerCenter9.5.x, UNIX, Teradata SQL, MS SQL SERVER 12.0, UNIX

Confidential

Jr.ETL Developer

Responsibilities:

• Developed an ETL Process that is consistent across all applications and systems.
• Worked on developing SQL scripts and optimizing the performance of existing scripts.
• Analyzed Business Requirement Document (BRD) and Functional Specification document (FSD) to develop detailed Test Plan and Test Cases.
• Created Indexes to speed up the queries.
• Worked on Technical Specifications and Testcase, Test plan Documents.

Environment: Informatica PowerCenter9.1, Oracle 11g,PL/SQL, JIRA, LINUX/UNIX, PUTTY, TOAD