SUMMARY

• Informatica and Teradata Certified Professional with 12+ years of IT experience as Lead ETL - IDQ Developer.
• Implemented Informatica ETL methodology for designing and developing extraction, transformation and load processes
• Provided input to the software engineering manager for estimates, resource needs, milestones and risks. Get task assignments from the Software Engineering Manager. Defines work breakdown structure. Plans and leads task execution by assigning software engineers to tasks, ensuring effective delegation, monitoring tasks, identifying risks and handling mitigation and escalations.
• Provided hands-on technical and functional input to design, maintenance, build, integration and testing of complex software components according to functional and technical design specifications. Reviewed and provided feedback and suggests solutions including operability perspective. Performed code review and participates in test reviews.
• Design and development of MDM Data Model for Master Data using MDM Hub.
• Design the Match and Merge rules for Data Consolidation Process using Informatica MDM Hub.
• Implement Hierarchy and Affiliation relationships between Customers and Providers.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules,Mergeproperties and BatchGroupcreation.
• Excellenthands-on MDM,IDQ,DataTransformation,
• Hands on Experience in Profile Objects, Design DQ Rules, Implement DQ rules.
• Worked withInformaticaData Quality 9.x (IDQ) Developer for data cleansing, data matching, data conversion, exception handling and monitoring capabilities.
• Identified and eliminated duplicates in datasets thorough IDQ 9.x components of Edit Distance, Jaro Distance. It enables the creation of a single view of customers.
• Design and develop process to create and maintain reference data - Asset Class, Currency and Country codes
• Worked with Complex quality rules, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception, notification and reporting with ETL and Real-Time consideration.
• Data quality monitoring and profiling tool for the enterprise wide data elements.
• Good knowledge on Informatica Data Services (IDS) Informatica Analyst and Informatica Developer
• Lead overall ETL processes ( architecture, performed build, tested and deployed activities
• Good Understanding on the Teradata Architecture and extensively worked on Teradata Sql Queries and Utilities (Bteq, Fast load and Multiload).
• Worked on Teradata RDBMS architecture such as Shared Nothing, Nodes, AMPs, BYNET, Partitioning, Primary Indexes etc. Extensively used different features of Teradata such as BTEQ, Fastload, Multiload, Fast export, TPT, Teradata SQL Assistant
• Experienced in converting the Oracle Queries into Teradata Queries to support the Migration support projects.
• Very Good Experience in Understanding the Join Processing, Collect States and Partitioning concepts Confidential Teradata.
• Created tables, indexes, views, functions, procedures and sequences in Oracle backend
• Created Physical and Logical data models using Erwin.
• Good knowledge in developing PL/SQL Stored Procedures, functions to ensure successful execution of the ETL processes
• Worked on Agile and Waterfall methodologies.
• Translate and document business requirements into system and product level requirements
• Coordinate defects in quality center and work on enhancement and implementation projects throughout requirement gathering, delivery, and production phases
• Interacted with various Business users in gathering requirements to build the data models and schemas
• Good Knowledge of SDLC( Software Development Life Cycle)
• Lead a team
• Developed Design Documentation for all development efforts
• Worked on the JMS Message Queues and Web Services using Informatica
• Received Customer Appreciation Certification for successfully delivering the projects without any defects within scheduled time.
• Used Debugger in Informatica Power Center Designer to check the errors in mapping. Done Error Handling for dimension tables Confidential Informatica Power Center
• Successful track record in implementing and scheduling workflows and tasks using Informatica Power Center Workflow Manager and Workflow Monitor
• Extensively worked with Informatica objects using Push down Optimization.
• Prepared the Scheduling information for information based and analyzed the dependencies between informatica objects.
• Extensively worked on External loaders (TPT) and Partitioning with informatica.
• Developed scripts using Teradata Utilities ie.MLOAD, FLOAD, BTEQ, TPT etc.
• Good knowledge in extracting data from Flat Files and transforming and loading into Oracle database and vice versa
• Developed UNIX Shell Scripts to ensure successful execution of the ETL processes
• Created, maintained and stored manual Test cases, Test plans using Microsoft Word and HP Quality Center
• Involved in Unit testing, System testing while moving the code from development to production.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.1/9.0.1/8. x, Informatica Power Exchange, Metadata Manager, Web Services, Informatica Data Quality v9.1.0, Informatica MDM Hub v10

Reporting Tools: Business Objects 8.1

Data Modeling Tools: ER Studio 8, ERWIN 4.0, MS Visio

Scheduling Tools: Autosys, Tivoli

Databases: DB2 10.2/9.7, Oracle 11g/9i/8i, MS SQL Server 2008/2012, DB2, Teradata V13.1

Database Utilities: Toad for Oracle10g, SQL*Loader, Embraced Rapid SQL,SQL Navigator

QA Test Tools: HP Quality Center 9.2

Bug Tracking Tools: HP Quality Center, Jira, Enterprise Tester

Languages: TSL, JCL, JAVA, Visual Basic, C, C++, XML, SQL, PL/SQL, HTML, Shell Scripts, JavaScript, SQL *Plus

Helpdesk Tools: Remedy, CCAT,ISQ

Operating Systems: UNIX, LINUX, OS/390, Windows 2000/98/NT/95/XP/Serve, DOS, Sun Solaris 2.6/2.8, IBM AIX-UNIX

Web Technologies: JSP, ASP, ASP.Net, CGI/PERL, JavaScript, VB Script, XML, HTML

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Lead ETL Developer

Responsibilities:

• Translate and document business requirements into system and product level requirements
• Provided input to the software engineering manager for estimates, resource needs, milestones and risks.
• Get task assignments from the Software Engineering Manager. Defined work breakdown structure. Planed and lead task execution by assigning software engineers to tasks, ensuring effective delegation, monitoring tasks, identifying risks and handling mitigation and escalations.
• Worked as a part of architect team to develop snowflake schema for the project
• Added source definitions to the repository
• Created targets and added their definitions to the repository
• Extracted data from Flat Files and transformed and loaded into Oracle database and vice versa
• Good working knowledge of various transformations such as: filter, router, sorter, aggregator, lookup, expression, update strategy, joiner transformations etc.
• Successfully created mappings and mapplets in Power center Designer
• Used Debugger in Informatica Power Center Designer to check the errors in mapping
• Successfully managed workflows and tasks using Informatica Power Center Workflow Manager and Workflow Monitor
• Implemented Shell Scripts to ensure successful execution of the ETL processes
• Ensured compliance with standard software development practices, processes and enterprise standards
• Created, maintained and stored manual Test cases, Test plans using Mercury Test Director
• Involved in unit testing and system testing while the code is moved to production
• Developed design documentation for all development efforts Design and develop process to create and maintain reference data - Asset Class, Currency and Country codes
• Worked on Match, Associate, Consolidated, Key Generator, Address Validator, Classifier, Standazier, Exception, Update Strategy, Lookup, Joiner, Expression Transformation.
• Created the Parameter file for executing of the workflows.
• Created Physical. Logical data objects, Rules, Profiles, Mapplets, Mapping, Workflows
• Deployed the Applications.
• Responsible for standards when creating mapplets and code migration from development thru test.
• The DQ Developer must also document Confidential a functional level how the procedures work within the data quality applications.
• Deploy IDQ Objects to Power center 9.6 version
• Validated the Addresses using the Address Doctor Transformations.
• Tuned various queries by COLLECTING STATISTICS on columns in the WHERE and JOIN expressions
• Performance tuning for Teradata SQL statements using Teradata EXPLAIN
• Created BTEQ scripts, views to build the semantic layer.
• Scheduled jobs for batch processing using Tivoli
• Worked on Waterfall and Agile Methodologies
• Efficiently investigated production issues
• Diligently performed code reviews on fixes
• Effectively coordinated team efforts to ensure timely and successful project completion
• Fine-tuned the Oracle queries to improve the performance
• Coordinated team efforts to ensure timely and successful completion of the project
• Implemented Informatica ETL methodology for designing and developing extraction, transformation and load processes
• Developed scripts using Teradata Utilities ie.MLOAD, FLOAD, BTEQ, TPT
• Created, maintained and stored manual Test cases, Test plans using HP Quality Center
• Involved in unit testing and system testing while the code is moved to production
• Helped BI team to create the views which can be used for their reporting purpose.

Environment: ERWIN 7.2, Informatica Power Center v9.6/9.1, Informatica Data Quality 9.x, Teradata 14v, UNIX, DB2 10.5 HP Quality Center 10.0, Rally.

Confidential

Lead ETL Developer

Responsibilities:

• Make high-level design and established technical standards (for example, software coding standards, tools, and platforms).
• Builds relationships with internal customers/stakeholders. Represent the team in front of the customer.
• Worked extensively on forward and reverse engineering processes in ERWIN. Created DDL scripts for implementing Data Modeling changes. Also created ERWIN reports in PDF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes
• Get task assignments from the Software Engineering Manager. Defined work breakdown structure. Planed and lead task execution by assigning software engineers to tasks, ensuring effective delegation, monitoring tasks, identifying risks and handling mitigation and escalations.
• Re-designed the whole data model to support various systems.
• Profile the Customized Data objects.
• Analyzed the Profile Results and discussed with Data Steward.
• Develop DQ Plans, Test the Plans, Deploy plans.
• Deploy IDQ objects to Power center 9.5.1
• Maintain data matching logic and Address Doctor dictionaries.
• Helping to support the Data Governance to improve the quality and value of information assets.
• Partner with Enterprise Information Quality and business data stewards to provide summary results of data quality analysis, which will be used to make decisions regarding how to measure business rules and quality of the data.
• The DQ Developer must also document Confidential a functional level how the procedures work within the data quality applications.
• Provide Data Quality Scorecards, Dash-Boards and Ad-Hoc reporting
• Changed architecture and mappings as needed to improve performance
• Created tables, views, synonyms, procedures, functions in Oracle backend
• Interacted with various Business users in gathering requirements to build the data models and schemas.
• Fine-tuned the Oracle queries to improve the performance.
• Developed design documentation for all development efforts
• Coordinated team efforts to ensure timely and successful completion of the project
• Implemented Informatica ETL methodology for designing and developing extraction, transformation and load processes
• Successfully created mappings and mapplets in Informatica Power center Designer
• Used Debugger in Informatica Power Center Designer to check the errors in mapping
• Thorough knowledge in creating tasks (session, command, event wait, even raise etc.), workflows and worklets in Workflow Manager
• Successfully managed workflows and tasks using Informatica Power Center Workflow Manager and Workflow Monitor
• Created, maintained and stored manual Test cases, Test plans using Mercury Test Director.
• Involved in unit testing and system testing while the code is moved to production

Environment: Teradata 12v, DB2 9.7 UNIX, Informatica Power Center v9.1, Informatica Data Quality 9.1.0

Confidential

ETL Lead Developer

Responsibilities:

• Translate and document business requirements into system and product level requirements
• Make high-level design and established technical standards (for example, software coding standards, tools, and platforms).
• Builds relationships with internal customers/stakeholders. Represent the team in front of the customer.
• Successfully applied ETL in a Data Warehouse setting
• Received Customer Appreciation Certificates for successfully executing the project within scheduled time
• Demonstrated expertise in Informatica Power Center product
• Worked as a part of architect team to develop star schema for the project
• Implemented Informatica ETL methodology for designing and developing extraction, transformation and load processes
• Added source definitions to the repository
• Created targets and added their definitions to the repository
• Extracted data from Flat Files and transformed and loaded into Oracle database and vice versa
• Utilized mapping parameters and variables in a mapping to incrementally extract data
• Good working knowledge of various transformations such as: filter, router, sorter, aggregator, lookup, expression, update strategy, joiner transformations etc.
• Successfully created mappings and mapplets in Power center Designer
• Successfully managed workflows and tasks using Informatica Power Center Workflow Manager and Workflow Monitor
• Implemented Shell Scripts and PL/SQL Stored Procedures to ensure successful execution of the ETL processes
• Created, maintained and stored manual Test cases, Test plans using Mercury Test Director.
• Involved in unit testing and system testing while the code is moved to production

Environment: Informatica Power Center (v 8.1.1), Oracle 10g (SQL, PL/SQL), Microsoft SQL Server 2005, T-SQL, UNIX, TOAD

Confidential

Lead ETL Developer

Responsibilities:

• Worked as a part of architect team to develop snowflake schema for the project
• Added source definitions to the repository
• Created targets and added their definitions to the repository
• Extracted data from Flat Files and transformed and loaded into Oracle database and vice versa
• Good working knowledge of various transformations such as: filter, router, sorter, aggregator, lookup, expression, update strategy, joiner transformations etc.
• Successfully created mappings and mapplets in Power center Designer
• Used Debugger in Informatica Power Center Designer to check the errors in mapping
• Successfully managed workflows and tasks using Informatica PowerCenter Workflow Manager and Workflow Monitor
• Implemented Shell Scripts to ensure successful execution of the ETL processes
• Ensured compliance with standard software development practices, processes and enterprise standards
• Created, maintained and stored manual Test cases, Test plans using Mercury Test Director
• Involved in unit testing and system testing while the code is moved to production
• Developed design documentation for all development efforts

Environment: Informatica Power Center v 7.1, Oracle 9i (SQL, PL/SQL), UNIX

Confidential, New York

ETL Developer

Responsibilities:

• Understand the Business Documents and convert it into the Technical specification documents.
• Created the Low level Document for Change Requests.
• Draft the ETL Design Documents for review.
• Good working knowledge of various transformations such as: filter, router, sorter, aggregator, lookup, expression, update strategy, joiner transformations etc.
• Created the Oracle Procedures to load the data into the Sybase environment.
• Created the Various Mapping using Power Center and scheduled the Jobs using Autosys.
• Define the Error logging and Error Handling methods.
• Analyzed the Production issues and provide the fixes with in the time.
• Defined the different ETL load Strategies for Performance improvement.
• Enhanced the support process with the help of Unix Scripting.
• Created the Various Unix scripts to handle files Confidential Informatica.
• Design and developed the ETL Mappings to load the data from indirect file systems.
• Created the Various Mappings to extract the data from xml files and load the data into the relations tables.