SUMMARY:

• 6+ years of experience in Information technology with well - built background in development of various projects using Data Warehousing, ETL (Extract Transform Load) using Informatica Power center and Teradata.
• Experience in using the ETL Tool- Informatica Power center and Teradata development.
• Good exposure of Data Warehouse concepts and SDLC Life Cycle.
• Experience in Data Warehouse development, worked with Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Ascential Datastage.
• Involved in Data Migration between Teradata, MS SQL server and Oracle.
• Programming experience in BTEQ, Stored Procedures, Macros, and Triggers.
• Knowledge and experience in Data warehousing applications, responsible for Extraction, cleansing, Transformation and Loading of data from various sources to the data warehouse.
• Experience and knowledge in Teradata RDBMS using Fastload, Multiload, Tpump, Fast export, Multiload, Teradata SQL Assistant and BTEQ utilities.
• Good knowledge of concepts in Data Warehousing like Star Schema and Snowflake Schema, Slowing Changing Dimension(SCD), Surrogate Keys, Data Marts, Kimball Methodology in Relational, Dimensional, and Multidimensional data modelling.
• Good experience in working with types of SCD: SCD1 and SCD2 where SCD1 maintains the new history which will overwrite the original history and SCD2 maintains the both original and new history.
• Experience with Informatica tools - Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager, Workflow Manager, and Workflow Monitor.
• Experience in creating transformations and mappings using Informatica Designer.
• Strong experience in developing Sessions, Workflows, Worklets using the Workflow Manager Tool (Task developer, Workflow, and Worklet Designer).
• Working experience with Informatica performance tuning involving sources, target, sessions, and transformations.
• Working Experience on complex mappings using the Informatica transformations like Lookup, Rank, Normalizer, Sorter, Aggregator, Filter, Expression, Router, Source Qualifier, Update Strategy, SQL, and Joiner.
• Working experience in developing the ETL program for Data Extraction, Transformation and Loading using Informatica Powercenter.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Knowledge on Oracle database supporting OLTP and Data Warehouses.
• Good experience in developing SQL with various databases like Oracle, SQL server.
• Having good experience in using PL/SQL, Triggers, Functions, and Packages for the Oracle Database Development.
• Knowledge of Teradata RDBMS Architecture.
• Experience in UNIX working environment, writing UNIX shell scriptsto run theInformatica workflows and controlling the ETL flow.
• Experience on development of UNIX platforms and Windows XP.
• Basic Knowledge in Master Data Management(MDM) and Informatica Data Quality(IDQ).
• Having great Interpersonal and communication skills.
• Good problem solving, analytical, written, and oral communication skills.
• Ability to work both independently and as a team.
• Good decision-making capabilities, exceptional problem solving, alternative solutions, and confident, accurate, decision making.

PROFESSIONAL EXPERIENCE:

Confidential, IRVING TX

Informatica Developer

Responsibilities:

• Analyzed business documents and created system requirement specification.
• Extensively used Informatica power Center 10.2 for ETL (Extraction, Transformation and Loading), data from relational tables and flat files.
• Extensively worked on complex mappings, mapplets and workflow to meet the business needs and ensured they are reusable transformation to avoid duplications.
• Utilized the Informatica Data quality management suite (IDQ and IDE) to identify and merge customers and addresses.
• Performed data validation testing writing SQL queries
• Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.
• Involved in writing SQL scripts, stored procedures and functions and debugging.
• Involving in Functional Testing & Regression Testing
• Responsible for providing comments for user stories within an AGILE software development SCRUM environment.
• Created sessions and batches and tuned performance of Informatica sessions for large data files by increasing the block size, data cache size and target based commit interval.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Used debugger to test mapping at designer level.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier. setting up User Security Model in multi-tenant ETL/BDM platform
• Created configured and scheduled the sessions and Batches for different mappings using workflow manager and using UNIX scripts.
• Handling Issues during development and analyzing phase and Fixing Bugs

Environment: Informatica PowerCenter 10.2, Developer (IDQ), BDM, PL/SQL, Teradata 14.10, TPT, BTEQ, Fast Load, Multiload, Flat files, Oracle 12c, SQL Server, UNIX.

Confidential, Woonsocket, RI

ETL Developer

Responsibilities:

• Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD in Teradata 14.
• Wrote Teradata SQL, BTEQ, Multiload, Fastload, and FastExport for Ad-hoc queries, and build Unix shell script to perform ETL interfaces BTEQ, Fastload.
• For the implementation of the business rules and standards of source data from the many systems into the data warehouse we must Develop and design the mapping, transformation logic and transformation in the Informatica.
• Experience in using the Informatica Power Center and designed, Developed the Extraction, Transformation, and Load Process (ETL) for data migration.
• Responsible for Tuning the Performance of the ETL mappings.
• Designing the Workflows and Sessions using Workflow Monitor.
• Knowledge in Writing Unix scripts for the business needs.
• To load the data into the OLTP databases as per the business rules must create the Informatica workflows.
• Experience in working on creating the mappings which involves the slowly changing dimensions.
• Designed and developed various mappings using various transformations like Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter, and Sequence Generator transformations.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Track the status of work from time to time and provide timely updates to team members.
• Provided spontaneous response to the queries posted by business users and supporting teams.

Environment: Informatica Power Center 9.5.1, Teradata 14.10, TPT, Bteq, Fastload, Multiload,BDM, Flat files, Oracle 12c, SQL Server, UNIX.

Confidential, AUSTIN TX

ETL/Informatica Developer

Responsibilities:

• Involved in the business meetings to understand their requirements.
• Responsible for technical Design Document and Details mapping document
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Responsible for creating Source to Target data mapping.
• Interacting with the onsite people and resolving the offshore issues.
• Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.
• Implemented Informatica error handling, dynamic parameter file generations and coding best practices
• Used Informatica reusability at various levels of development.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Designed and developed Informatica mappings for data sharing between interfaces utilizing SCD type 2 methodologies
• Creation of re-usable mapplets, Transformations using various transformations of Informatica.
• Implementing incremental logic for data extract from ERP system.
• Scheduling the session’s tasks comprising of different mappings for data conversion, extractions in order to load data into oracle database.
• Develop informatica mappings and workflows for new change requests.
• Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Extensively used Informatica Power Center and created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data

Environment: Informatica 9.1, IDQ, UNIX, Oracle 11g, DAC

Confidential, Boca Raton, FL

ETL/ Informatica Developer

Responsibilities:

• Developed code to load the data from Flat File to stage and stage to DWH.
• Involved in Data Extraction, Transformation and Loading using BTEQ and Stored Procedures.
• Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD in Teradata 14.
• Wrote Teradata SQL, BTEQ, Multiload, Fastload, and FastExport for Ad-hoc queries, and build Unix shell script to perform ETL interfaces BTEQ, Fastload.
• Developed mappings with ORACLE as target and formatting the target data according to the requirement.
• Designed and developed Informatica mappings for data loads and data cleansing and created mappings to in corporate Incremental loads.
• Developed the reusable Mapplets to include the Audit rules.
• Worked with Business analysts to understand business requirements.
• Helps to transform business requirements into effective technology solutions by creating the technical Specifications (Source to Target Documents) for the ETL from the Functional Specifications.
• While coding the mapping to implement the complex logics, worked mostly on transformations like Lookup, Aggregator, and Expression Transformations.
• Worked with Rank, Lookup, Joiner, Sorter, and Aggregator transformations for the better throughput of sessions with Memory cache for static and dynamic cache.
• Migrating objects between different Environments using XML Export/Import (using Repository Manager).
• Involved in creating Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions and Target Data.
• Solely responsible for the daily loads.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Creating stored procedures and sequences to insert key into the database table.
• Involved in few database scripts to be executed from UNIX.
• Development of scripts for loading the data into the base tables in EDW and to load the data from source to staging and staging area to target tables using Fast Load, Multiload of Teradata.
• Experience in performance tuning and query optimization of the TeradataSQLs.
• Created tables, views in Teradata according to the requirements in all environments.
• Extensively Used UNIX Scripting for the business needs.
• Guided the testing team and the development team and monitored the Implementation.
• Provided support for the Nightly jobs.

Environment: Informatica Power Center 9.5.1, Teradata 14.10, TPT, Bteq, Fastload, Multiload, Flat files, Oracle 11g, SQL Server, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Implement procedures to maintain, monitor, backup and recovery operations for ETL environment.
• Conduct ETL optimization, troubleshooting and debugging.
• Maintain ownership of release activities interacting with ETL projects.
• Create and maintain data models working with the Data Architect.
• Created mapping documents for data mart deliverables.
• Involved in using Framework Manager to build models, packages and publish packages to the ReportNet Server
• Created the Data flow Diagrams for the full run and the reprocess partial run for the workflows to be created in Informatica taking into point the dependencies using Microsoft Visio.
• Maintained mapping documents throughout development lifecycle.
• Stored reformatted data from relational, flat file, XML files using Informatica (ETL).
• Developed mapping to load the data in slowly changing dimension.
• Wrote UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Extensively migrated the Informatica code from the version 7.1.4 to 8.1.1 and did testing to maintain its results.
• Worked on Dimensional modelling to design and develop STAR schemas using ER-win 4.0, Identifying Fact and Dimension Tables.
• Created the Data flow Diagrams for the full run and the reprocess partial run for the workflows to be created in Informatica taking into point the dependencies using Microsoft Visio.
• Analyzed data relationships graphically and changed displays using Cognos Power Play functionality by means of drill down, slice and dice, rank, sort, forecast, and nest information to gain greater insight into trends, causes, and effects.
• Loaded consolidated data using SQL*Loader in parallel and direct mode.
• Documenteduser requirements translated requirements into system solutions and develop implementation plan and schedule.
• Implemented best practices in ETL Design and development and ability to load data into highly normalized tables and star schemas.
• Identified all the confirmed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Involved in creation of Informatica users and repository backup using Server Manager.
• Generated reports for end client using various Query tools like Cognos.

Environment: Informatica Power Center 8.x/ 7.x, PowerBuilder, Oracle 9i/10g, Sybase, Oracle SQL Developer, Cognos, Quest-Toad, Siebel, Shell Scripts, SQL*Loader, UNIX (IBM AIX, Solaris), DB2 UDB, and Windows 2000.