SUMMARY

• Around 12 years of software development experience in developing Data Warehousing Solutions
• Extensive Experience in working with Informatica Power Center versions 10.2,9.6,9.1, 8.6, 7.2, 6.5 Designer, Workflow Manager Workflow Monitor, and Repository Manager.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator, Transaction Control, HTTP Transformation and sequence generator transformation.
• Experience in design / development / Unit - Integration testing of Complex Mappings.
• Proficient in Performance Tuning / Optimization.
• Proficient in using Informatica workflow manager, Workflow monitor, Repository Manager to create, schedule and control workflows, tasks, and sessions
• Extensive experience in error handling and problem fixing in Informatica.
• Involved in Informatica Admin activities and Upgrade of Informatica from 9.6.1 to 10.2.
• Around 2 years of experience working with Big Data and Hadoop Eco Systems: HDFS, Hive SQL, Pig Scripts, SQOOP, HBase and Oziee
• Expertise in Pig Latin language, Hive data warehouse, Oozie workflow, Sqoop and Flume ecosystems.
• Performed Import and Export of data into HDFS and Hive using Sqoop and managed data coming from different sources
• Very good understanding of Partitions, Bucketing concepts in Hive and designed both Managed and External tables in Hive to optimize performance
• Extensive experience in writing Pig (version 0.11) scripts to transform raw data from several data sources into forming baseline data.
• Developed Oozie workflow for scheduling and orchestrating the ETL process
• Around 7+ years of Experience working with Teradata client v14.10, v13.10
• Actively involved in developing BTEQ’s and Teradata Utilities - MLoad, Fast Load, and Fast Export.
• Performance Tuning, Optimization of BTEQ Query and Query Debugging.
• Developed New Teradata Procedures to load the data to the newly designed tables based on the business requirement.
• Worked on Erwin Data Modeling Tool to create New Data Models that captures the latest modification on the database. Worked on Both Forward and Reverse Engineering to generate Data Models.
• Effectively worked in Teradata Query Grid
• Extensively worked in UC4 Job Scheduling - Creating Jobs, Job Plans, Events and scheduling the Job Plans based on the Business Needs.
• Extensive experience in Generating Reports using Tableau.
• Extensive experience in creating Analytics, Dashboards using Business Objects
• Effectively Interacted with Cross team and Worked as a Project Co-Ordinator and managed Onsite - Offshore Team

TECHNICAL SKILLS

Operating Systems: Windows 2000, Linux, Ubuntu

Languages: SQL, PL/SQL

Development Tools: Informatica Power Center 9.6,9.1,8.6, 7.2, 6.5, HDFS and Hadoop Eco Systems, Teradata Client 13.0, Tableau, BO Web Intelligence 6.5 / XI

Database Connectivity: ODBC

Databases: Oracle, Teradata,Sybase

Configuration Tools: VSS

Scheduling Tools: UC4, Autosys

PROFESSIONAL EXPERIENCE

Confidential

Senior Application Developer

Responsibilities:

• Developing new applications, maintaining and enhancing the previously deployed solutions.
• Translating business and technical requirements into well-engineered Data warehousing solutions.
• Participating in the full SDLC and L3 Support for software written in SQL / Oracle / Sybase Database, Informatica.
• Help Application teams and clients with technical solutions on potential areas.
• Interfacing with internal clients/end users and other developer teams.
• Review and analyze existing systems to upgrade the systems according to user requirements.
• Analysis, configuration, and implementation of system support objectives. Provide advanced basis system administration, performance tuning and security & database support.

Confidential

Senior Application Developer

Responsibilities:

• Coordinating with the different legacy and 3rd party team understanding the requirements and Functional Specification.
• Developing Informatica Complex Mappings, Sessions and Workflows
• Debugging and testing Complex Mappings.
• Provide technical Solutions to issues

Confidential

Project Lead / Big Data Hive developer

Responsibilities:

• Data sourcing through Hadoop - developed code for the same which includes (Capturing the metadata, DQ checks and Main Sourcing). This involves PIG scripting and we use HIVE database to store the data in staging layer for processing before loading into final target table.
• Have created HIVE managed and external tables and views (Schema on READ and WRITE) as part of reporting by sqooping the data from Oracle to HDFS cluster in the form of AVRO file format.
• Very good understanding of Partitions, Bucketing concepts in Hive
• Have created xml files to integrate with OOZIE workflows and execute Java, pig and hive actions based on decision nodes.
• Performed Import and Export of data into HDFS and Hive using Sqoop and managed data coming from different sources
• Good knowledge in NoSQL Databases like HBase.
• Handled the JSON data using Hive, Pig and filter the data based on query factor
• Loaded and transformed large sets of Structured and Semi Structured data