SUMMARY

• Around 7 + years of IT experience with experience in Design, Development, and Implementation of Data warehouses as an ETL Developer.
• Expertise in Designing & Developing complex Extract, Transform and Load (ETL) applications using Informatica Power Center.
• Around 1 year of experience in Informatica BDM 10.4.1 Worked in ingestion of data into Hive for various applications like Stream AFS, CIF, SVN, PL. (Relational DB’s, Flat files)
• Extensively worked in Extraction, Transformation and Loading of data from non - relational databases such as Flat files and other relational sources such as Oracle and SQL Server into Data Warehouse.
• Worked extensively in various kinds of queries such as Sub-Queries and Union Queries for Query tuning.
• Expertise in creating mappings, mapplets and reusable Transformations using Informatica Designer.
• Extensively used Informatica Client Tools - Designer, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Extensively created and tuned mappings using Informatica power Center 8.x,9.x
• Proficiency in design and developing the ETL objects using Informatica Power center with various Transformations like Joiner, Aggregate, Expression, SQL, Lookup, Filter, Update Strategy, Stored Procedures, Router, Rank, normalizer transformations etc.
• Extensively used Mapping Variables, Mapping Parameters, and Dynamic Parameter Files for improved performance and increased flexibility.
• Experience in UNIX commands & Shell Scripts.
• Developed slowly changing (TYPE 1 and 2) dimensions mappings to keep history.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Peer reviews and system testing and developing complex mappings.
• Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Experienced in Agile Scrum Methodology

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9x/8x, Repository Manger, Designer, Workflow Manager and Workflow Monitor, Informatica BDM 10.4.1

Databases: Oracle 11g, SQL Server and DB2, Hive

Operating System: Windows & Unix

Language: PL/SQL, COBOL, JCL

Scheduling Tools: CA, Autosys, ESP

Defect Tracking Tools: PVCS, Quality Center

Other Tools: Oracle TOAD, PL/SQL Developer, MS-Office, SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Worked on Agile Methodology and tracked using Rally board.
• Worked on ingesting data into hive from various sources like flat file, mainframe and relational database.
• Actively involved in peer code review and mappings.
• Worked on Unit test cases and Defect fixes.
• Involved in configuring and deploying code to different environments.
• Worked in GitLab to deploy code to QA/PROD.
• Worked on PROD release documents and did post validation once code is delivered to prod.
• Involved in meeting with Hadoop admin team for issues related to migration and deployment.
• Worked with PSO team to analyze the failures in prod.
• Worked as BAU resource (Business As Usual) and provided solutions to prod code changes.

Environment: Informatica BDM 10.4.1, WinSCP, Putty, Oracle 11g, PL/SQL, UNIX, GIT, ESP, Rally.

Confidential - Miami, Florida

Senior Informatica Developer

Responsibilities:

• Load monitoring and reporting on SLAs and data availability.
• Worked On call support (phone support)
• Troubleshoot the issues faced by business on priority, analyze and fix the issue.
• Acknowledge the tickets, contacting the source team for source data issue, resolve the issues in constraint violation in loading data into table
• FTPing files and rerunning the Data warehouse job after required fix is done.
• Responded to the Data Center call for failures in data warehouse jobs and fixing the failures on time.
• Created Informatica mapping for defect fixing in production
• Interacted with business user and decision support team to resolve the issues faced in production.
• Co-ordinated with offshore team and provided timely support in resolving their queries.
• Scheduled the data warehouse jobs using Informatica scheduler, crontab, OPCON through UNIX shell scripting.
• Taken care of outages and scheduled downtime management.
• Troubleshooting data discrepancy and missing data issues.
• Ran adhoc jobs as per using requirement and specification.
• Worked on clear quest cases for defect fixing.

Environment: Informatica Power Center 9.6, Oracle 11g TOAD, PL/SQL and UNIX, OPCON, Clear Quest, SNAP

Confidential

Informatica Developer

Responsibilities:

• Worked on the requirements gathering and analysis for implementing the Data Warehouse and providing estimates.
• Preparing design documents and creating Informatica mappings, ORACLE Stored procedures.
• Extensive experience in implementation of Data Cleanup Procedures, Transformation, Scripts
• Stored Procedures and execution of Test plans for loading the data successfully into Targets.
• Experience in PL/SQL development and SQL Query Tuning for better performance.
• Responsible for the Dimensional Data Modeling.
• Understand the business needs and implement the same into a functional database design.
• Providing resolution for the issues faced by client on a daily basis.
• Giving transition for on boarding the new resources.

Environment: Informatica 9.1, Oracle, MS SQL, Autosys

Confidential

Informatica Developer

Responsibilities:

• Done Proof of Concept for the materialized views concept to be used for optimization.
• Preparation of Design document for the implementation through Informatica mapping involving materialized view.
• Extensively used Informatica debugger to figure out the problems in the mapping. Also involved in troubleshooting existing ETL bugs.
• Unit Testing the functionality.
• System Testing support.

Environment: Informatica 8.6, Oracle, Unix, Control M

Confidential

Informatica Developer

Responsibilities:

• Analysis of the stored procedure and the application for dependency.
• Design the Informatica mappings, sessions and workflow.
• Involved in the batch run and testing of Unit, Integration and user acceptance Testing.
• Production and post-production support.

Environment: Informatica Power Center 8.6, Sybase, VSS