SUMMARY

• 9 Years of extensive experience in ETL, Business Requirements Analysis, Application Design, Development, Implementations and supporting of Data Warehousing and business systems.
• 5+ Years of Experience in finance domain, worked for Confidential ’s reward and rebates program.
• Experience in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing logic and transformations as per the requirement and creating mappings and loading the data into Data Warehouse.
• Strong Data Warehousing ETL experience using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Experience in creating Informatica Mappings, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experience in Informatica Data Quality (IDQ) transformations like Address Doctor, Parser, Labeler, Match, Exception, Associationand Standardizer.
• Extensive experience in developing Stored Procedures, Complex SQL queries using SQL Server and Oracle PL/SQL.
• Experience in creating Informatica Power Center Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mapping susing Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Strong Technical skills in range of technologies which includes Informatica ETL,Oracle,Teradata,Sybase,DB2,COBOL,UNIX, PL/SQL, Microsoft SQL server 2017, T-SQL.
• Successfully performance tuned and maintained ETL applications and SQL databases with significant reduction in the process run time and standardization of the process in production.
• Have worked with the parameter files at mapping and workflow level.
• Created Mapplets, reusable transformations and used them in different mappings.
• Experience in using Automation Scheduling tools like Control-M.
• Worked extensively with slowly changing dimensions.
• Review existing code to tweak and tune the performance of existing Informatica processes.
• Worked on Audit Balance jobs to ensurethe quality of transactions during the process using automated shell scripts to notify support team.
• Experience in converting high-level design specification to simple ETL coding and mapping standards.
• Extensively worked with Analytical SQL functions (RANK/SUM/AVG/COUNT/LEAD/LAG).
• Ability to handle cross functional teams and to drive the enterprise-wide improvement initiatives.

TECHNICAL SKILLS

Operating System: UNIX, Linux and Windows

ETL Tools: Informatica PowerCenter 10.2/9.x/8.x, Informatica PowerExchange.

Databases: Oracle11g/10g/9i, SQL Server, Teradata and Netezza

Scheduling tools: Informatica Scheduler, CA Scheduler (Autosys) and Control-M

SDLC Methodology: Agile and Waterfall

Other Tools: Oracle PL/SQL Developer, SQL Server Management Studio (2017), Toad 11.6 (Oracle), Teradata.

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Developed tactical and strategic plans to implementunemployment insurance conversion from legacy system to Data Warehouse.
• Build the ETL transformations and mapping to convert the data from VSAMsources.
• Used Informatica Power Exchange for Change Data Capture to covert the mainframe VSAM files into tables to generate reports.
• Created Data Maps / Extraction groups in Power Exchange Navigator.
• Created SCD type 2 mapping to have historical data with begin and end date.
• Created end to end structure for APPEALS, PAYMENTS, COLLECTIONS AND OVERPAYMENTS for unemployed claimants.
• Created UNIX Shell scripts and supported implementation of automated ETL solutions which included scheduling of jobs with Informatica PMCMD Commands.
• Created mapplets to use them in different mappings.
• Made use of parameters and variablesto reuse them across environments.
• Created the Architecture high level and ETL design documents for offshore.
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Involved in creating new table structures and modifying existing tables.
• Involved in Unit testing to check whether the data loads into target are accurate.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database for Testing Purposes.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.

Confidential, Phoenix, AZ

ETL Developer

Responsibilities:

• Designed and developed complex Informatica mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Built Informatica reusable transformations and mapplets wherever redundancy is needed.
• Extensively worked on the transformations like Aggregator - to get monthly, quarterly, yearly invoicing also used SQL override to filter the data.
• Analysis of our source data systems using the IDQ basic profiling features using the Informatica developer and the analyst tools before making any ETL Designs.
• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Developed mapping to load the data in slowly changing dimensions (SCD).
• Buildthe ETL source to Target specification documents by understanding the business requirements.
• Automated the production jobs using UNIX Shell scripting and worked to implement automated ETL solutions which include scheduling of jobs with Informatica infacmd Commands to remove manual dependencies.
• Identifiedareas of improvement, developed UNIX automation scripts to reduce manual effort by 40%, from 10hrs to 6hrs.
• Involved in Data Quality Analysis to determine the cleansing requirements.
• Experience in Informatica Data Quality transformations like Address Doctor, Parser, Labeler, Match, Exception, Association and Standardizer.
• Created Oracle Stored Procedureto implement complex business logic for better performance.
• Also Involved intuningthe mappings in the transformations by tracking the reader, writer, transformation threads in the session logs and used tracing level to verbose during development & only with very small data sets.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Worked on troubleshooting issues and quickly resolving them in an efficient manner that minimizes downtime.
• Worked with theflat filesin both the direct and indirect methods.
• Automate the production jobs using UNIX Shell scripting and worked to implement automated ETL solutions which include scheduling of jobs with Informatica infacmd Commands to remove manual dependencies.

Confidential, Phoneix, AZ

ETL Informatica Developer

Responsibilities:

• Created Informatica Mappings, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Coordinating with Business Teams / Functional Subject Matter Experts (SME) to gather Requirements and transforming them into technical specifications for the ETL Designs through which Implement ETL solutions using Informatica Power Center.
• Worked on data cleansing and standardization.
• Worked with Informatica Power Exchange for Change Data Capture.
• Build a re-usable staging area in Teradata for loading data from multiple source systems using template tables for profiling and cleansing in IDQ .
• Assisted in performance testing, data quality assessment, support & product deployments.
• Created automated shell scripts to transfer files among servers using FTP, SFTP protocols.
• Worked on Performance Tuning and Maintenance of ETL Applications and SQL databases with significant reduction in the process run time and standardization of the process in production which was appreciated by the users who were getting the data within 36 hours from 48 Hours.
• Invoked Informatica using utility from the UNIX script Teradata.
• Providing effective resolution to client reported issues on the daily and monthly basis.
• Experienced in deployment of the ETL jobs into the Production environment along with primary production support, handling Change Requests and Defect Resolution.
• Perform root cause analysis on all Informatica processes and resolve all production issues.
• Automated alert for data availability to business.
• Monitoring Scheduled jobs in CONTROL-M, troubleshooting job failures in Informatica.

Environment: Informatica 9.1, Oracle, Teradata and UNIX.

Confidential

ETL Informatica Developer

Responsibilities:

• Created UNIX shell scripts to run the Informatica workflows for controlling the ETL flow.
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Validate all data and perform routine tests on databases.
• Monitoring the Jobs and sever space availability and CPU Process.
• Perform root cause analysis, performance monitoring and application related issues
• Provided application support 24/7.
• Worked with business and functional teams to extract the requirements.

Environment: Informatica 9.1, Oracle, UNIX.