PROFESSIONAL SUMMARY:

• Around 8.4 years of Professional experience in Information Technology with extensive experience in development of various projects using Data Warehousing tools like Informatica and Databases like Oracle, SQL Server and Teradata.
• Over 6 years of work experience using Informatica Power center, Repository Manager, Designer, Workflow manager, Work flow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Mapplets, Mappings, Workflows, Sessions, Re - Usable Transformations, Java, Java API, HTTP and web service consumer transformations.
• Over 2 experience in Teradata RDBMS using Fast load, Multiload, TeradataSQL Assistant, BTEQ utilities and Hadoop.
• Around 2 years of experience in Admin activities.
• Expertise in Extraction Transformation Loading (ETL) process, Dimensional Data Modeling experience using Data modeling, Star schema/ Snowflake modeling, Fact and Dimensions tables, Dimensional, Multidimensional modeling and De-normalization techniques.
• Good Knowledge on Hadoop 1.0/2.0, YARN, YARN Scheduler
• Experience in Sqoop, NFS.
• Extensive knowledge on Slowly Changing Dimensions (SCD) and implemented many type II SCD’s.
• Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Worked on various types of transformations like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregator, Rank, Router, Normalizer, Sorter, External Procedure, Sequence Generator and Source qualifier etc.
• Expertise in monitoring workflows, pipeline partitioning, configuring email.
• Involved in Performance Tuning of the Data Warehouses including the creation of materialized views, bitmapped indexes and partitions.
• Experienced in UNIX shell scripts to run Informatica workflows and controlling the ETL flow.
• Experience in using Automation Scheduling tools like Autosys, Tidal and Tivoli Maestro.
• Exclusive knowledge in Identification of User requirements, System Design, writing Program specifications, Coding and implementation of the Systems.
• Excellent communication and interpersonal skills, Proactive, Dedicated and Enjoy learning new Technologies and Tools.
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review process.
• Experience in Installation, patches & upgrades for Informatica.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x/

Databases: DB2, Oracle,Teradata, Mysql

Teradata Utilities: BTEQ, Fast Load, MultiLoad, Tpump, SQL Assistant

Data Modeling: Logical/Physical/Dimensional/3NF, Star/ ETL, OLAP, ROLAP

Scripting Languages: UNIX Shell Scripting, BTEQ

Other Tools: Hue, Jenkins, HP Viewpoint, Toad, Teradata Sql Assistant and Hadoop

Scheduling Tools: Autosys, Control-M, Tivoli Maestro & Tidal

Sql: Teradata SQL, PL SQL, T-SQL

Operating Systems: Windows 98/2000/XP, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Bothell WA

Informatica & Hadoop Admin

Responsibilities:

• Configures ETL jobs in Prod environment.
• Creates Users, folders in Repository & grant access to users
• Purging version logs and deleting daily logs
• Installations, Patches for Informatica
• Coordinating with teams while database & scheduling tools upgrade/patch/certificate installation.
• Continuously monitoring system health.
• Configuring Hadoop Jobs
• Involving in environmental planning and code migration walkthrough.
• Deploying Hadoop jobs in Cluster environment.
• Copying and Deploying files and directories from Accurev & Jenkins
• Configuring and running Hive QL scripts.
• Configuring PIG scripts.
• Deploying Hadoop Library files into hadoop HDFS.
• Setting up Environment related parameters in Edge node.

Environment: Informatica 9.5.1/9.5.6, Oracle, Teradata, Hue, Hive, UNIX, HP Viewpoint, Accurev, Jenkins, Tidal, Hadoop & Winscp

Confidential, Richardson, TX

Production Support Lead

Responsibilities:

• Worked with various claim adjudications systems like RxClaim, Recap, and RXAmerica which combines over 12 million records on a daily basis.
• Involved in creating extract programs for various clients including Aetna, HMS, Milliman, CNP, Pharmacy Advisor
• Worked with various claim adjudications systems like RXClaim, Recap, and RXAmerica which combines over 12 million records on a daily basis.
• Worked on tight Service Level Agreements with the downstream applications.
• Involved in developing complex mappings and responsible for migration from Informatica 8.6 to 9.1
• Involved in scheduling jobs to meet requirements on a defined SLA from clients from various adjudications in maestro.
• Handled multiple projects at the same time and provided support for the applications under warranty.
• Involved in fixing job failures faced due to various issues across the 26 applications and 16000 plus jobs
• Worked with Tivoli Maestro for scheduling purposes and fixing jobs using the logs from Maestro.
• Worked extensively in Unix Environment and Informatica to fix jobs.
• Involved in deployment of jobs to the production environment.
• Modification of existing jobs according to the new requirements.
• Involvement during outages due to major implementation and handling post upgrade situations.
• Involved in leading and training on claim extract and
• Worked on configuring SFTP protocols in Unix Servers.
• Involved in troubleshooting of various DB2 and Teradata errors due to data issues from the source.
• Worked with data movement across databases which includes oracle,DB2 and Teradata on a single instance
• Built UNIX Shell Scripts for processing/cleansing incoming text files, archive processed files after certain period of time.

Environment: Informatica 9.5.1, Oracle, Teradata SQL Assistant, UNIX, Toad, Tivoli Maestro, HPSM & Heat

Confidential

Informatica Senior Developer

Responsibilities:

• Co-ordinated with business users and come up with functional requirements.
• This included creating ETL Specification Document.
• Participating in the review meetings of Application Overview Meetings with Onsite team.
• Responsible for UAT team meetings for Release Sign Offs.
• Responsible for creating/review of Business Requirement documents and analysis with Business team on the given requirements.
• Participated in code review meetings.
• Worked on Informatica development, created tables, views and stats in DEV and UAT using Teradata.
• Requirement analysis for new enhancements.
• Development, Coding and Unit testing for new enhancements, maintenance work and defect fixing.
• Peer reviews.
• Code migration from DEV to QA and QA to UAT.
• Java, Java API, HTTP and web service consumer transformations
• Code deployment to UAT loading and resolving issues.
• Prepared Run book and production package for production install.
• Created SSR using BMC Remedy user for Prod install.
• Ensured quality deliverable.
• Maintained project timelines and deliverables.
• Responsible for Collect Statics on FACT tables.
• Implemented Slowly Changing Dimensions (SCD) using Bteq scripts/Stored procedures.
• Built UNIX Shell Scripts for processing/cleansing incoming text files, archive processed files after certain period of time.
• Created proper Primary Index taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Created complexity mappings using Aggregator, connected, unconnected and dynamic Lookup, Joiner and created reusable transformations and mapplets in the mappings.
• Using Sequence generator for Surrogate keys in the dimensions to reduce the complexity and for improving the performance of composite keys.
• Worked on Workflow Manager to Schedule the workflows and run the sessions according to job dependency.

Environment: Informatica 9.1, Teradata SQL Assistant, UNIX, PL SQL, T-SQL

Confidential

Production Support Analyst

Responsibilities:

• Responsible for reviewing of Business requirement documents and analysis with Business team on the given requirements.
• Participated in code review meetings.
• Involved in support and maintenance activities of the Data warehouse, datamart Applications and Informatica upgradation from 8.6 to 9.1
• Handled autosys/scripts changes for different internal systems
• Maintained quickest zero defect deliverable.
• Because of our efforts we have received customer satisfactory rating (CSAT) 7 out of 7.
• Work included interaction with the Production control team, support team and third party vendors and continuous monitoring the production jobs.
• Worked Fine-tuned existing Informatica mappings for performance optimization.
• Involved in design of simple and little bit complex mappings and shell scripts in an optimized manner.
• Worked on bug fixes with an improved design to avoid any re-occurrences of the bug.
• Worked on re-running the jobs in case of data issues.
• Streamlined UAT cycle to sync with production.

Environment: Informatica Power Center 8.6/9.1, Oracle, Autosys, Flat files, UNIX, Windows 2008

Confidential

Informatica Developer

Responsibilities:

• Involved in analysis, requirement gathering, and testing and project coordination.
• Worked with power center tools like Designer, WorkflowManager, Workflow Monitor, and RepositoryManager.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Extensively used Various DataCleansing and DataConversion Functions in various transformations.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Developed ETL mappings, transformations using InformaticaPowerCenter 8.6
• Deployed the Informatica code and worked on code merge between two difference development teams.
• Worked on Java, Java API, HTTP and web service consumer transformations
• Built many UNIX shell scripts to schedule ETL jobs.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Created automated scripts to perform data cleansing and data loading.
• Performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed jobs into the production environment.
• Extensively involved in unit, integration, and performance testing.

Environment: Informatica Power Center 8.6, SAP LSMW, UNIX, Oracle, Window 2008, Flat files, PL SQL