SUMMARY:

• Over 8 years of specialized IT experience in building Enterprise Data Warehouse, Data Marts, Operational data stores using Informatica Power center and developer
• Strong Expertise in working with Database systems like Oracle, Teradata, SQL Server, DB2, Netezza, MySQL and Sybase.
• Proficient in entire life cycle of DWH that includes System analysis, gathering requirements, data modeling, ETL Design, development, Unit / System testing, Production deployment and post go - live support.
• Strong experience in understanding Dimensional Data Modeling like star and snowflake schema.
• 5 Years of experience in building Enterprise Data Warehouse environment with Informatica extracting/loading data to/from Teradata and Oracle.
• Expertise in using Teradata database and utilities like TPT, FASTLOAD, MULTILOAD, and BTEQ scripts.
• Experience in Database administrative activities and query tuning.
• Experience in developing Complex SQL queries and PL/SQL Procedures.
• Experience in using Informatica Command Line Utilities pmcmd and pmrep.
• Worked with XML, Flat file, SAP and relational data sources.
• Developed mappings in Informatica using different transformations like Source Qualifier, Expression, filter, Router, Joiner, Rank, Lookup, Aggregate, Java, Update Strategy, data masking, stored procedure and HTTP.
• 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.
• Extensive experience in writing UNIX Shell scripts and automation of the ETL processes.
• 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.
• Experience in using Scheduling tools like Informatica Scheduler, Autosys, TWS and Control-M.
• Worked with different BI reporting tools like Tableau, Cognos, Share Point and Arc plan.
• Experience in planning production code deployment and implementing with no effect to the other scheduled jobs in the data warehouse environment.
• Experience in solving the technical and analytical issues within the SLAs defined in Service Now.
• Good communication skills with strong ability to interact with customers, business end-users and team members.
• Solid analytical and dynamic troubleshooting skills and Self-motivated and enjoy working in a technically challenging environment.
• Provided 24*7 on-call support while working on production environments and provided L3 and L2 technical support.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center and Informatica BDE 9.6.1

Reporting Tools: Tableau, Share Point, Cognos, SSRS, Arc Plan

Languages: Java, XML, UNIX Shell Scripting, SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Sr. Informatica developer

Confidential, Charlotte.NC

Responsibilities:

• Created the technical documentation of the architecture of the data warehouse, including the physical components and their functionality following the client standards.
• Performed the troubleshooting of the technical issues and incidents related to the Informatica, Teradata and Hadoop applications.
• Performed the query tuning and the code performance tuning during the testing phase of the project.
• Performed tests for evaluating the hardware and software needed to support the data warehouse that includes Informatica BDE, HDFS, and Teradata, data integration, BI and analytics.
• Analyzed the existing logic of Informatica & Teradata to understand the data loading patterns and designed the process to load the missing data.
• Performed Teradata Query tuning and utilized Primary and secondary indexes to improve the performance.
• Performed Teradata administrative activities such as user creation, database creation, memory allocation, Table and view creation using Teradata administrator.
• Used Teradata View Point for monitoring the query performance of the running sessions.
• Developed test cases for the UAT/QA testing before deploying the code to production environment.
• Developed Informatica code to extract the data from different SAP systems like ECC, BW, PLM and load into Hadoop database at HDFS and hive level.
• Maintained the user and system security of the Informatica and Teradata applications.
• Involved in upgrade of Informatica BDE from 9.6.1 to 9.6.1 Hot Fix 3 including the Hadoop upgrade from Horton Works 2.0 to 2.2.
• Worked on data masking of the confidential data for the unit and system integration testing.
• Interacted with vendor support to address technology and software issues related to Informatica and Hadoop.
• Involved in performing three Emergency Break Fixes on Informatica and one Emergency Break Fix on Hadoop to address an issue with the version that is being used.
• Extensively worked with different transformations such as Expression, Aggregator, Sorter, Joiner, Router, Lookup, Filter and Union in resolving the issues.
• Worked on Java transformation and java API methods commit, generate row, is Null and Rollback.
• Extensively worked with session logs, Profile logs and workflow logs in doing Error Handling and trouble shooting.
• Worked with the TWS (Tivoli Workload Scheduler) and Autosys scheduling team in scheduling Informatica Jobs as per the requirement and frequency.
• Implemented various Performance Tuning techniques by finding the bottle necks at source, target, mapping and session and optimizing them using the Debugger Wizard in the Power Center tool.
• Performed the system maintenance like scheduling the repository and domain backups, log cleanup using the shell scripts and weekly system checks for the capacity planning.
• Written UNIX shell scripts to run the daily data load jobs, ftp from the local servers and schedule the workflows.
• Worked with the Tableau team in creating dashboards, generating various reports and maintain the confidentiality of the different reports.
• Involved in preparing the Migration Documents and standards across all the platforms.
• Provides L3 On-call support for engineering related issues for the Information Management stack.

Environment: Informatica Power Center 9.6.1/9.6.1 HF3, Informatica developer 9.6.1 HF3, Informatica Analyst, IDQ, MDM, Teradata 14, Teradata DBA tools, DB2, SAP,XML, Flat Files, SQL Assistant, Unix shell scripting, Horton Works 2.2/2.0, Tableau 9.3/8.3, SSRS, OLAP, Arc Plan 8.

Sr. ETL Informatica developer

Confidential,Dallas,TX

• Developed internal and external Interfaces to send the data in regular intervals to Data warehouse systems.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Involved in discussion of user and business requirements with business team.
• Involved in upgrade of Informatica from 9.1 to 9.5.
• Created complex mappings using Unconnected Lookup, Sorter, and Aggregator, HTTP and Router transformations for populating target tables in efficient manner.
• Attended the meetings with business integrators to discuss in-depth analysis of design level issues.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.
• Extensively worked on performance tuning of the Informatica ETL mappings by using the caches, overriding the SQL queries and also by using Parameter files.
• Reviewed the existing logic and made some enhancements to improve the performance at the Informatica and database level.
• Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements and extensively used Teradata Utilities like M - load, F- Load, TPT, BTEQ and Fast Export.
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps.
• Created transformations like Expression, Lookup, Joiner, Rank, Update Strategy and Source Qualifier Transformation using the Informatica designer.
• Utilized the grep command to identify the data defect and modify the data in the flat files on the server.
• Involved in Teradata upgrade from TD12 to TD14 for analysis, testing and document preparation.
• Worked on Flat Files and XML, DB2, Oracle as sources.
• Worked on Informatica B2B data transformation using Informatica Data Transformation Studio.
• Written PL/SQL Procedures and functions and involved in change data capture (CDC) ETL process.
• Worked with BI team for the report design and development using Cognos.
• Worked on encoding the sensitive production data using the Informatica Data Masking trasnformation.
• Provided support for the data related issues during the Cognos report development by the analytics team.
• Implemented Slowly Changing Dimension Type II for different Dimensions.
• Involved in Informatica, Teradata and oracle upgrade process and testing the environment while up gradation.
• Worked with Informatica version Control excessively.
• Written Unit test scripts to test the developed interfaces.
• Performed data sub setting and data masking for the testing needs.
• Worked under Agile methodology and used version one to track the tasks.
• Provided L2/L3 support for the production jobs.
• Provided support for the production deployments in handling the data warehouse.

Environment: Informatica Power Center 9.6.1/9.5.1, Informatica DT Studio, Teradata 14/12, Oracle 10g, DB2, XML, Flat Files, SQL Assistant, Toad, PL/SQL, Unix shell scripting, Cognos 8.3.

ETL Informatica Developer

Confidential,Dallas,TX

• Maintain Data Flow Diagrams (DFD's) and ETL Technical Specs or lower level design documents for all the source applications.
• Involved in Requirement analysis in support of Data Warehousing efforts.
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations.
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input and Mapplet Output transformations.
• Worked with source databases like Oracle, SQL Server and Flat Files.
• Extensively worked with Teradata utilities BTEQ, F-Load, M-load & TPT to load data in to ware house.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts.
• Created complex mappings using Unconnected and Connected Lookup Transformations.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture.
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache.
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Auditing is captured in the audit table and EOD snapshot of daily entry is sent to the distributed list to analyze if there are any abnormalities.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval.
• Provided 24*7 supports for Production environment for Extraction, Loading and transformation of data by remote monitoring.
• Monitoring the Extraction and loading processes of data and Involved in writing UNIX shell scripting for automating the jobs.

Environment: Informatica Power Center 9.1.1, Oracle, SQL server, My SQL, Flat Files, Teradata 12, Cognos 8.2, Unix AIX and Windows XP.

Jr. ETL Developer/Internship

Confidential, New Tazewell,TN

• Maintained user roles and privileges at the database level including enrolling users, maintaining the system security, controlling and monitoring user access.
• Involved in designing and developing the database for the business division of Creative Eye at Focus for effectively managing manufacturing processes.
• Designed and developed database views and stored procedures, Packages and Functions.
• Used SQL to extract the data from the database and also using views on the tables.
• Worked with Development Life Cycle teams in performing the Data Movement.
• Wrote stored procedures, functions &Packages and used in many Forms and Reports.
• Wrote database triggers for automatic updating the tables and views.
• Designed and developed forms and reports.
• Involved in the creation of jobs using Informatica workflow manager to validate schedule run and monitor jobs using Workflow Monitor.
• Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated.
• Created detailed system design specifications to serve as a guide for system and the program development.
• Wrote triggers and packages by using PL/SQL for giving security privileges.

Environment: Informatica Power Center 7.1.1, Oracle, Reports 25, SQL, PL/SQL, Windows NT, Erwin, UNIX