SUMMARY

• 13 + years of IT experience as Sr. Data Warehouse/Data Migration/ETL Developer in Requirements gathering, analysis, design, coding, documentation and implementation, Testing and support of Data Warehouse applications using Informatica Power Center.
• Implemented data warehousing methodologies for Extraction, Transformation, and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor.
• Extensively worked on ETL Informatica Transformations effectively including - Joiner, Aggregator, Lookup, Filter, Router, Normalizer, Update Strategy, Stored Procedure, Sorter, SQL Transformation, Union, Source Qualifier, Java, XML Generator and created complex mappings.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database, Oracle, SQL Server and DB2.
• Highly proficient in performance analysis, monitoring and SQL/Postgre SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL.
• Extensive experience with Informatica IDQ for performing Data Analysis, Data Profiling and Data Governance and for Implementing IDQ plans for standardization and matching user data.
• Strong experience working with XML, Flat Files along with loading and retrieving data from different sources using SCD Type1/Type2/Type3 in PowerCenter.
• Extensive experience in Oracle SQL development to create tables, Views, Triggers, Indexes and Stored Procedures.
• Strong knowledge of XML, XML Schema, XSD.
• Working Knowledge in Python.
• Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.
• Good Experience in creating complex SQL Queries and Complex Joins for data analysis.
• Strong knowledge of software development life cycle methodologies such as Agile and Waterfall.
• Experience in Production Support and change management.
• Involved in source profiling, data analysis and performance tuning of existing SQL queries.
• Expertise in Data modeling techniques like Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Skills in creating Test Plan from Functional Specification, and Detailed Design Documents and thorough with Deployment process from DEV to QA to UAT to PROD.
• Extensive hands on experience on Informatica Mapping performance tuning, identifying, and removing performance bottlenecks and in coordinating with source system owners for day-to- day ETL progress monitoring, ETL Technical documentation, and Maintenance.
• Experienced in working with Onshore - Offshore communication model.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Independently perform complex troubleshooting, root-cause analysis, and solution development.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Understand the business rules completely based on High-Level document specifications and implements the data transformation methodologies.

TECHNICAL SKILLS

ETL: Informatica Power Center 8.X/9.X/10.X

Databases: Oracle 11g/12c, DB2, MS SQL Server 2008, Teradata, Greenplum, Postgre SQL

Languages: XML, SQL,PL/SQL

Scripting: UNIX Scripting

Operating Systems: Windows XP, Windows 7/8/10, Linux

Scheduler: Autosys, Informatica Scheduler, ZENA, TIVOLI

Other Tools: HP Quality Center

PROFESSIONAL EXPERIENCE

Confidential

Data Governance Analyst

Responsibilities:

• Involved in gathering requirements with business users.
• Responsible for profiling, cleansing, and standardizing the data.
• Responsible for adding enrichment columns based on business logic given.
• Responsible for unit testing and creating migration package for deploying in higher environment.
• Co-ordinated with different teams to perform end-to-end testing.

Confidential, Edgewood, NY

Sr Informatica ETL Developer and Designer

Responsibilities:

• Involved in gathering requirements with business users.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center and database objects in Postgre SQL.
• Coordinated with source application team.
• Involved in customers form correction activities.
• Extensively used all the features of Informatica Versions 10.x including Designer, Workflow manager, Workflow monitor and Repository Manager.
• Extract data from flat files, VSAM and load the data into the target database (Greenplum).
• Developed reusable transformations and mapplets, which can be used for multiple mappings.
• Developed complex mappings using corresponding Source, Targets and Transformations like Filter, Router, Update strategy, lookup, stored procedure, Normalizer, SQL, XML Generator in extracting data in compliance with the business logic.
• Wrote functions in Greenplum and UNIX Scripts for automated execution of jobs.
• Involved in Unit and System Testing of ETL Code (Mappings and Workflows).
• Understand the different types of sources involved and relationship between the tables.