SUMMARY

• A seasoned ETL developer with 9+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application system for Retail, Banking, Insurance & Manufacturing.
• Strong Data Warehousing ETL experience of using Informatica 10.0.1 /9.1/8.6.1/ PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experience with dimensional modelling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

PROFESSIONAL EXPERIENCE

Confidential, NJ

ETL Developer

Responsibilities:

• Worked with External vendors to understand the marketing needs and identify the source data for mapping the requirement.
• Setting up the SFTP connection between the external vendors and the Confidential security team to transfer the reports securely
• Data for Connected home reports are pulled using both Informatica/Pentaho ETL Tool.
• Created stored procedure and function to improve the Job performance
• Troubleshooting the job failure during the daily operation.
• Converting the Existing Informatica ETL jobs in to Pentaho Jobs.
• Participation in Performance tuning in database side, transformations, and jobs level.
• Creating Pentaho jobs for loading data sequentially & parallel for initial and incremental loads.
• Using various PDI steps in cleansing and load the data as per the business needs.
• Automating all the Excel Input using Pentaho Jobs for Dashboard reporting.
• Gathering data source for the various business requirement.
• Integrating data from API using Informatica.
• Created Jobs to Process JSON data obtained through API (App Annie).
• Created Jobs to integrate data from sales force API to our reporting database.
• Working with External vendors on the data needs and provision the data as per the needs.
• Worked in Agile environment, with daily scrum and ticket updates.
• Worked on complex ETL transformation and jobs including processing data from salesforce web services.

Environment: Informatica 10.0.1, Pentaho PDI 6.1, Auto-sys Scheduler & Winscp Language and DB: Oracle, SQL server2014, MSAccess

Confidential, NJ

Informatica Developer

Responsibilities:

• Creating new repositories from scratch, backup and restore.
• Performed Informatica upgrade from 9.0.1 to 9.5
• Created Groups, roles, privileges and assigned them to each user group.
• Code change migration from Dev to QA and QA to Production
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Used Pre session and Post Session to send e-mail to various business users through the Workflow Manager
• Leveraging the existing PL/SQL scripts for the daily ETL operation.
• Ensure that all support requests are properly approved, documented, and communicated using the MQC tool. Documenting common issues and resolution procedures
• Extensively used Informatica Client tools -PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, Flat Files.
• Developed complex mapping using Informatica PowerCenter tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformation, Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.
• Involved in analysing the existence of the source feed in existing CSDR database.
• Involved in converting the business requirement into technical design document.
• Documenting the macro logic and working closely with Business Analyst to prepare BRD.
• Involved in requirement gathering for procuring new source feeds.
• Involved in setting up SFTP setup with the internal bank management.
• Building Unix scripts in cleaning up the source files.
• Involved in loading all the sample source data using sql loader and scripts.
• Creating Informatica workflows to load the source data into CSDR.
• Involved in creating various Unix script used during ETL load process.
• Handling high volume of day to day informatica workflow migrations.
• Periodically cleaning up informatica repositories.
• Monitoring the daily load and handing over the stats with the QA Team.
• Creating new repositories from scratch, backup and restore
• Review of informatica ETL design documents and working closely with development to ensure correct standards are followed

Environment: Informatica Power Center 9.1.0/9.5, Flat Files, Oracle 11i, Oracle 11, Actimize, Autosys, Toad,MS Excel-Macro.

Confidential, NJ

ETL Developer

Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Performed Informatica upgrade from V9.1 to 9.5.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Documented the LDAP configuration process and worked closely with Informatica Technical support on some of the issues.
• Fixing all the workflows failure in unit testing and system testing.
• Scheduling all the ETL workflows for the parallel run comparison.
• Involved in preparing the migration list inventory.
• Involved in requirement gathering for redesign candidates
• Worked along with the Informatica professional to resolved Informatica upgrade issue.
• Monitoring the disk space issue and cleaning up the unwanted logs periodically.
• Worked with BA in the QA phase of testing.
• Worked on Informatica Schedulers to schedule the workflows.
• Scheduled batch jobs using Autosys to run the workflows.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of debugging tools to resolve problems.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, PL/SQL, Autosys, SQL, Teradata, SQL* LOADER, TOAD, Shell Scripting

Confidential, NJ

ETL Informatica developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implementedslowly changing dimensionmethodology for accessing the full history of accounts.
• Write Shell script running workflows in UNIX environment.
• Optimizing performance tuning at source, target,mapping and session level.
• Participated inweeklystatus meetings, and conducting internal andexternal reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica 8.6 .1,Oracle 11g

Confidential, Sterling, VA

ETL Informatica developer

Responsibilities:

• Extensively Worked with Data Modeler, Data Analysts and Business Users to gather, verify and validate various business requirements.
• Identified various source systems, connectivity, tables to ensure data availability to start the ETL process.
• Created Design Documents for source to target mappings
• Created Workflows, Tasks, database connections, FTP connections using Workflow Manager.
• Developed mappings to get the SAP source data
• Extensively developed various Mappings using different Transformations like Source Qualifier, Expression, Lookup (connected and unconnected), Update Strategy, Aggregator, Filter, Router, Joiner etc
• Used Workflow Manager for Creating, Validating, Testing and running the workflows, sessions and scheduling them to run at specified time.
• Created pre-session and post-session shell commands for performing various operations like sending an email to the business notifying them about any new dealer branches.
• Providing the Architecture/Domainknowledge toReport developerfor the creation of Dashboards and Reports.
• Performed Fine tuning ofSQL overrides for performance enhancements and tuned Informatica mappings and sessions for optimum performance.
• Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache and Dynamic Cache to improve the performance of the lookup transformations.
• Created Source definitions and Flat File Target definitions using the Informatica
• Used UNIX commands (Vi Editor) to perform the DB2 load operations.
• Created detail Unit test plans and performed error checking and testing of the ETL procedures using SQL queries, filtering out the missing rows into flat files at the mapping level.
• Scheduled the ETLs using ESP scheduler.

Environment: Informatica Power Center 8.6.1/8.1.1 , Oracle 11g, TOAD, SAP BOBJ 4.0,4.1, Tableau 9.2, UNIX, Autosys, SQL*Loader, PowerCenter Mapping Architect for Visio, Sybase Power Designer, IBM DB2, Flat files, SQL, putty, UltraEdit-32, shell Programming, Toad, Quest Central

Confidential, Charlotte, NC

Support Analyst

Responsibilities:

• Developed standard and re-usable mappings and mapplets with various transformations like expression, aggregator, joiner, source qualifier, filter, lookup, stored procedure and router.
• Involved in enhancement for the COBOL coding and promoting the code in to the production systems.
• Involved in scheduling jobs in scheduling tools.
• Coding COBOL, JCL, DB2 programs
• Handling Change Requests.
• Handling Ad-hoc requests.
• Involved in automated and manual FTP.
• Review of Programs
• Code walkthrough to ensure the programs are in accordance to ASA standards
• Enhancement, Testing and Documentation of projects.
• Handling failed jobs in production environment within SLA.

Environment: Mainframe, DB2, JCL,Oracle 10g, SQL, Informatica 8.6, Quality Center.