SUMMARY:

• Around 8years of experience as experience in building Enterprise Data Warehouse, Data Marts, Operational data stores in various domains like Healthcare, Insurance, Finance, Telecom and Retail using Informatica Power centre and developer.
• Experience with Informatica Power Centre 10.4.0 , 9.x, 8.x IDQ 9.6.1, 10.1.1 MDM and Teradata, SQL server, oracle databases.
• Expertise in using Teradata database and utilities like TPT, FASTLOAD, MULTILOAD , and BTEQ scripts.
• Experience in Analysis and collecting statics on teradata tables and Columns to improve performance Database
• Experience in developing Complex SQL queries and PL/SQL Procedures.
• Experienced in debugging and Performance tuning of the Informatica mappings,sessions and workflows.
• Performed Unit testing /SIT testing and prepared testing documents as required by the client.
• Experienced in designing/understanding of the existing/new LDM/PDM(Logical/ Physical data model) and STM (Source to Target Mapping) documents.
• Basic Knowledge in Informatica MDM, Informatica Data Quality, Informatica Cloud and Informatica DT Studio implementation.
• Acquired experience with all the aspects of SDLC (Software Development Life Cycle) like Planning, Analysis Design, Deployment, Testing, Integration and Support.
• Experience in working with slowly changing dimensions and change data capture.
• Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL .
• Efficiently helped in the Software Development Life Cycle ( SDLC ) processes including Analysis, Design, Programming, Testing, and Documentation.
• Experience in Agile methodologies. Good experience in Programming language/ Structural query language ( PL/SQL ).
• Experience in Creating and Updating Clustered and Non - Clustered Indexes to keep up the SQL Server Performance.
• Provided 24*7 on-call support while working on production environments and provided L3 and L2 technical support.

TECHNICAL SKILLS:

Rdbms: MS SQL Server,Oracle and Teradata

Language: T- SQL, SQL,PL\SQL

Tools: SQL Server Management Studio (SSMS), Visual Studio, Toad, Jenkins, Udeploy.

ETL Tools: Informatica Power Center 10.4.0/10.1.1/9.6.1/9.5.1/8.6.1/7.1.1 and Informatica BDE 9.6.1

Microsoft BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Crystal Reports 10.0 & Excel Power Pivot, Power BI, Tableau

EXPERIENCE:

Teradata/ Informatica Developer

Confidential, Nashville, TN

Responsibilities:

• Involved in Business meetings to understand the business requirement specifications and implemented the ETL jobs using Informatica.
• Involved in developing the source to target process and mapping documentation.
• Participated in the review and approval of the technical transformation requirements document used to design and build the ETL modules in Informatica Designer .
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup, Filter, Update Strategy, Stored Procedure, etc.
• Prepared a best practice document to use when designing jobs to gain optimum performance by using appropriate partitioning techniques.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs .
• Created Understanding documentation and Release testing documentation on the tickets handled, and documented the issues found in a central repository.
• Involved in the code reviews prepared by the teams.
• Written Unit test cases and integration test cases for the developed code.
• Code migrations from one environment ( DEV-QA-UAT-PROD ) to another environment like ( DDL’s, SP’s,DML VIEWS ).
• Documented the Unit and System Integration test results as per the team standards.
• Developed and implemented strategies for slowly changing dimensions, surrogate key generation and for incremental data loading
• Performed performance tuning of jobs to improve the extraction, transformation and loading time of data.

Environment: Informatica Power Center 10.4.0/10.1.1/9.6.1 HF4, Teradata SQL Assistant, Toad for DB2, Oracle SQL Developer, SQL Server Management Studio, Cognos, Putty, WinSCP, Notepad++, Jenkins, deploy.

Confidential, Newport Beach, CA

Teradata/Informatica Developer

Responsibilities:

• Responsible for gathering and defining user report requirements and developing appropriate interfaces for the reporting infrastructure environment to meet customer business needs, based on business processes and data entities between various systems.
• Design and develop ETL mappings and workflows using Informatica Power Center.
• Write complex SQL queries for validating the data against different kinds of reports
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Experienced in writing Unix Shell Scripts for different purposes such as scheduling jobs and moving the files from remote server to local informatica server.
• Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
• Written Unit test cases and integration test cases for the developed code.
• Documented the Unit and System Integration test results as per the team standards.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer .
• Optimizing performance tuning at source, target, mapping and session level.
• Performed debugger testing for the developed code to check if the data is populated as defined in the design document.
• Worked with Teradata, Oracle, and SQL Server and DB2 databases.
• Worked with the Cognos team in building the base data layer for the reporting needs.
• Provided off hours support when required.
• Designed and developed the reports according to the requirements using Tableau and Power Map .

Environment: Informatica Power Center 9.6.1, Teradata SQL Assistant, Oracle SQL Developer, SQL Server Management Studio, Cognos, Putty, Notepad++.

Confidential, Fort, Washington

Informatica Developer

Responsibilities:

• Installed and Configured the Informatica Client tools.
• Worked on loading of data from several flat files to XML Targets.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Developed, modified, and optimized complex queries for data retrieval and modification. Optimized and Tuned SQL Queries by running Explain plans.
• Used advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Created tables with complex constraints applicable to the business rules.
• Wrote control files for data loading using SQL*Loader .

SQL developer

Confidential

Responsibilities:

• Participated in the installation of Oracle Database.
• Creation of Database Objects: Tables, Stored Procedure, Views, Triggers, Index, and Function.
• Expertise in SQL Queries writing.
• Taken part in Database design for different modules.
• Configured, tuned, Upgraded and maintained database servers.
• Experience with PL/SQL and MYSQL on Linux, and Windows.
• Experience in data migration, integration tools like Talend, Toad.
• Designing a database model using Erwin/toad.
• Involved in Testing of forms and Reports during up gradation of Oracle apps 11i to R12.