PROFESSIONAL SUMMARY:

• Over 8 years of IT experience and technical proficiency in the field of Data Warehousing teamed with Data Analysis, Business Requirements Analysis, Application Design, Development & testing, and full life cycle Implementation of Data Warehouse.
• Set up design procedures for implementation teams and act as gatekeeper for quality standards.
• Establish standards and guidelines for implementations using Informatica and Teradata.
• Experienced in various Teradata utilities like Fastload , Multiload , BTEQ , Terdata SQL Assistant , Teradata Viewpoint.
• Extensive experience in Performance Tuning in Informatica, Teradata V2R6, 13.10 environments.
• Experienced in Hadoop Technologies Apache Nifi,Impala,Sqoop and Hue.
• Establishing and documenting best practices on Teradata, Informatica and Teradata with Informatica.
• Strong Data Warehousing experience in Application development & Quality Assurance testing using Informatica Power Center 9.6 (Designer, Workflow Manager, Workflow Monitor).
• Experience in creating complex Informatica Mappings using Source Qualifier, Expression, Router, Aggregator, Lookup, and other transformations in Informatica.
• Excellent experience in gathering requirements and Creating Use Cases
• Extensive experience in writing Use Cases, Functional specifications, Scenarios, Business processes, Workflows, Process flows, Test cases and Test Plans.
• Experience in creating efficient and effective BRD (Business requirement document), TAD (Technical Architecture document) and TDD (Technical design document) involving data mappings.
• Experience in designing error and exception handling procedures to identify, record and report errors.
• Hands on experience in using the MS Office Suite.
• Thorough experience in scripting using Unix Shell.
• Strong knowledge in various SDLC processes and standards. Good Team Leadership & Collaboration Skills.

TECHNICAL SKILLS:

Operating Systems: Windows NT, Windows 2000, Unix

Databases: Teradata V2R6:, 13.10

Languages: SQL, Unix Shell scripting

ETL Tools: Informatica 9.x (Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Designer, Workflow Monitor, Workflow Manager), Toad, Visio, SQL Developer, TOAD, Teradata SQL Assistant, Putty

Packages: MS Office (MS Excel, MS Outlook, MS Power point)

Technologies: Apache Nifi,Impala,Hue

PROFESSIONAL EXPERIENCE:

ETL Developer

Confidential, Dallas, TX

Responsibilities:

• Estimate efforts required for design, development of new tables in Hadoop environment and Provide estimates based on degree of complexity and number of processors used in Apache Nifi
• Create TDD to define the detailed data load design, Nifi flows to load the data into hadoop
• Closely worked with the data architects in developing the integration process
• Building the data flow using Nifi to get the data from API calls and load it into Hadoop environment i.e HDFS and into Impala tables
• Building the sqoop jobs to export the data from sql server to Hadoop/impala tables
• Building the data flow using informatica from Hadoop Impala tables to Teradata warehouse for reporting requirements
• Migrating the Apache Nifi, Impala Objects from development to production

Confidential

Responsibilities:

• Estimate efforts required for design, development of ETL components and modules for multiple releases and enhancements. Provide estimates based on degree of complexity and number of transformations used in and ETL.
• Create TDD to define the detailed ETL design, Design ETL flows to load the data model.
• Closely worked with the architect in developing the dimensional model for loyalty with all the dimensions and facts.
• Building the data warehouse in Teradata and creating ETL process to load the data into warehouse with type 2 dimensions
• Building a process to load all the facts on an incremental basis to warehouse. Also used exception tables to maintain audits of records that fell out and that were processed.
• Perform peer review on design, code
• Design and develop ETL’s for different releases: Used Informatica to extract data from MS SQL server and load into Teradata target tables
• Perform Unit testing of mappings and validate all possible cases
• Migration of ETL’s across various environments
• Support the existing production code

Tools: Teradata V13.10 (MLOAD, TPUMP, FLOAD, Teradata SQL Assistant, Teradata Viewpoint ), Informatica 9 .x, Windows, SQL Server

Technical Project Lead

Confidential

Responsibilities:

• Estimate efforts required for design, development of ETL components and modules for multiple releases and enhancements. Provide estimates based on degree of complexity and number of transformations used in and ETL.
• Create TDD to define the detailed ETL design, Design ETL flows to load the data model for each customer.
• Define custom formats to accommodate each customer using a single Integrated ETL.
• Defined and designed the ETL Loading strategy
• Closely worked with the Development team in Designing scripts, Mappings, Mapplets, Session Tasks, Workflows, command tasks, indicator files with Informatica components like Mapping Designer, Workflow Manager
• Recommendations on PIs, PPIs, secondary Indexes
• Perform peer review on design, code
• Design and develop ETL’s for different releases: Used Informatica to extract data from MS SQL server and load into Teradata target tables. Also used flat file targets to maintain audits of records that fell out and that were processed. In other releases used flat file and oracle sources and Teradata target tables
• Perform Unit testing of mappings and validate all possible cases
• Migration of ETL’s across various environments.
• Work with development teams to determine usage of fastload, multiload, BTEQ scripts and Informatica mappings.

Tools: Teradata V13.10 (MLOAD, TPUMP, FLOAD, Teradata SQL Assistant, Teradata Administrator), Informatica 9 .x, Linux, Windows, SQL Server

Confidential

Responsibilities:

• As an offshore lead was responsible for all deliverables and to co - ordinate with the onsite team and come up with the effort estimation and design and test cases of code and make sure that the code is defect free.
• Collection of requirements from business users and analyzed based on the requirements
• Worked in data Extraction, Transformation and Loading from source to target system using BTEQ, FastLoad, TPump and MultiLoad
• Involved in preparation of loading & extracting scripts using Teradata utilities
• Review of Security standards and customize BTEQ and Loader scripts, usage of Parameter files and variables, handling error tables and locks in Teradata DB
• Also involved in Extensive Performance Tuning and Optimization to current production process with a view of 30/60/90 days plan.
• Effectively facilitated regular project meetings and follows up with team members as required to focus on business and operational issues or technical issues.
• Define and create unit test strategy.
• Facilitate migration of code from Dev to QA and QA to Prod.
• Facilitate SIT and UAT of the developed code.
• Create production transition of the developed code to the production support team.
• Work on any production issues, enhancements post production.
• Support the existing production code.

Tools: Teradata V13.10 (MLOAD, TPUMP, FLOAD, Teradata SQL Assistant, Teradata Administrator), Informatica 9 .x, Linux, Windows, SQL Server

Confidential

Responsibilities:

• Developed a GUI based tool to copy the data from one teradata server to other teradata server.
• Avoids effort in creating target definitions, source definitions, mappings, sessions and workflows totally.
• No risk of copying data to production table as target connection is restricted only to CERTIFICATION environment. There by saves time in connection objects verification.
• There would not be any issues of any failure on Informatica due to tool issues and teradata utility failures.
• Saves repository space by avoiding creating Informatica objects.
• No dependency on Informatica server availability.

ETL Developer

Confidential

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Designers and Developers, Project Manager and all the stakeholders to get a better understanding of the Business Processes
• Recommendations of usage of the right combination of Informatica & Teradata
• Defined and designed the ETL Loading strategy
• Review and Modify the TAD (Technical Architecture document), TDD (Technical Design Document) with the database implementation strategy
• Closely worked with the Development team in Designing Mappings, Mapplets, Session Tasks, Workflows, command tasks, indicator files with Informatica components like Mapping Designer, Workflow Manager
• Developing and manages all appropriate project management documents, including, project schedule, change control, and periodic status reports
• Effectively facilitated regular project meetings and follows up with team members as required to focus on business and operational issues or technical issues.
• Suggest and review Use of appropriate connections and its settings (eg., use of loader utilities, check points, min/max sessions), Scheduler and Events usage.

Tools: Oracle 9i/8i, Teradata V2R6 (MLOAD, TPUMP, FLOAD, Teradata SQL Assistant, TPT, Teradata Administrator), Informatica 8.x, Edit Plus, Linux

Confidential

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Designers and Developers, Project Manager and all the stakeholders to get a better understanding of the Business Processes
• Involved in creation of detailed ETL mapping design document for development
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server and flat files to perform mappings based on requirements and load into Oracle tables
• Involved in impact analysis at database/Bteq scripts/ETL level for the existing ETL jobs were modified to bridge new fields from source to targets and come up with a Solution document for the same
• Involved in slowly changing dimensions and Fact loading mappings
• Involved in parameter files generation for all staging mappings
• Involved in Unit test preparation
• Review Performance options in Customization of transformations, Cache & Buffer allocations, Error Handling and logging strategies.
• Worked on the fine-tuning and performance improvement of some of the existing Informatica mappings and sessions
• Defined the Informatica Performance Standards when used on top of Teradata
• Review of usage of Pre & Post SQL/Command/Email, appropriate & optimal usage of tasks, run statistics and throughput optimization.
• Review and Modify the TAD (Technical Architecture document), TDD (Technical Design Document) with the database implementation strategy

Tools: Oracle 9i/8i, Teradata V2R6 (MLOAD, TPUMP, FLOAD, Teradata SQL Assistant, TPT, Teradata Administrator), Informatica 8.x, Edit Plus, Linux

ETL Developer

Confidential

Responsibilities:

• Regular collaboration with the technical team to validate the System operability and data consistency
• Creating Report Specification Documents, Design documents.
• Creating SSRS Reports & SSIS Jobs updating all documentation for existing and updated changes to SSRS Reports and SSIS Jobs
• Communication with all business in case of any failures or outages
• Unit Testing the Reports and Deploying Reports to Report server

Tools: /Utilities/Environment: SSIS, SSRS, Sql Server