PROFESSIONAL SUMMARY:

• A forward thinking, capable and committed Senior Data warehouse consultant having over 10 years of experience in implementing Data warehousing and Data lake applications, Data Virtualization Applications and Metadata Manager with different tools and multiple backend databases. Good knowledge of Finance and Insurance domain.
• Well versed with Data warehousing concepts and good understanding data lake concepts and architecture.
• Expertise in the data analysis for source and target systems and Data architecture.
• Expertise in designing and implementing ETL environments using tools like Informatica and backend databases oracle and Greenplum.
• Member of the Data Lake strategy team responsible for inclusion of metadata in the strategy.
• Worked with Informatica Metadata Manager.
• Coordinated with data stake holders to capture technical metadata and lineage.
• Helped to implement data lineage strategy consistently across all covered Information Domains.
• Work closely with IT counterparts to update data models.
• Assisted in documenting source to target data mapping, transformations and controls.
• Collaborate with business and technical stakeholders on maintaining metadata repository.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes.
• Experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Power center 9.6.1/9.1/8.6.1/ 7. x/6.2
• Had experience in doing Gap analysis between source feeds and master data
• Had experience in Devops environment and understanding of operational challenges
• Strong understanding of data warehousing - Star/Snowflake schema
• Preparing logical and physical data models using ER studio
• Implemented performance-tuning techniques at application, database and system levels.
• Having good exposure in UNIX shell scripts with Informatica.
• Experience in dealing with a software development process from requirements through implementation
• Wide range of IT industry experience with Banking/Finance with strong analytical, problem-solving, Organizational, communication, learning and team skills.
• Experienced with coordinating cross-functional teams.
• Excellent communication and interpersonal skills. Ability to work effectively as a team lead as well as an Individual.
• Good understanding on collateral management and Confidential investment domain terminology.
• Ability to quickly adapt to changing priorities, requests, and environments.
• Adept in UNIX operating system commands & Shell Scripting.
• Experience with scheduling tools Control-m, Appworx. and window scheduler
• Experience in implementing data virtualization projects
• Strong development experience in Informatica power center 7.1.4, 8.1.1, 8.6.1, 9.1.1, 9.5.1 and 10.2 Extensively Worked on Informatica Designer Components- Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Strong experience in creating transformations like Expression, Router, Joiner, Lookup, Update Strategy and Sequence Generator are mainly.
• Experience on Informatica Metadata Manager.
• Assisted in documenting source to target data mapping, transformations and controls.
• Hands on experience working with reading data thru XML sources and Targets, working thru web services, Configuring Informatica workflows to read thru Web services.
• Experience in implementing Informatica change data capture (CDC).
• Involved in the installation and administration of Informatica server.
• Used Informatica Metadata Manager and Metadata Exchange exhaustively to maintain and document metadata.
• Strong experience in programming using SQL.
• Good understanding of green plum databases and capable of writing complex sql’ s and functions
• Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, and
• Indexes with Query optimizations as part of ETL Development process.
• Expertise in designing data lake environments using HVR and Pivotal Green plum.
• Experience in loading data from different sources into Greenplum system.
• Implemented parallel data unloading and loading using external table with gpfdist utility.
• Experience in performance tuning.
• Implemented some of the etl processes using linux shell scripting and PL/pgSQL language.
• Good understanding of data distribution, table partitioning and compressions in Greenplum.
• Experience in designing data models.
• Experience in implementing Enterprise Data Warehouse using Greenplum as Target system.
• Involved in designing and creating reports in Denodo platform
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL/Denodo processes.
• Hands-on experience in creating the Denodo views through using JDBC, ODBC, Delimited files and
• SOAP/REST Web services
• Creating Denodo views and derived views in VDP with connecting multiple data source systems.
• Creating and Scheduling the Denodo jobs with Web scheduler.
• Monitoring overall data quality for assigned data entities and capturing DQ rules for the same.

TECHNICAL SKILLS:

Operating Systems: UNIX (RHEL, Sun Solaris, Fedora), Windows.

Languages: SQL, PL/SQL, UNIX Shell Scripting, XML, Webservices.

Databases: Greenplum , Oracle 11g/10g/9i, PostgreSQL, Teradata,MySQL, MS SQL SERVER, Netezza

GUI: Informatica Power Center 10.2/9.x/8.x

Web Related: Informatica Metadata Manager

Data Virtualization: Denodo 5.5 and 6.0, Denodo Administration

Data Modeling Tools: ER studio 9.0

Tools & Utilities: SQL Developer, PL/SQL-Developer, Toad, Textpad, Navicat, WinSCP, Putty.

Domain Knowledge: Insurance, Finance domain - Banking & Finance, Shipping.

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Hive and Spark.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, Ohio

ETL Developer and Metadata Analyst

Environment: Tools: Denodo 5.0 and 6.0, Informatica PowerCenter 10.2, Informatica Metadata Manager

Database: Oracle 12c / Exadata, Sql Server, Netezza.

Responsibilities:

• Design, Development and implementation of Informatica Mappings for the sources.
• Tuning the performance of mappings and sessions in informatica and at database level.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements.
• Coordinate with data stake holders to capture technical metadata and lineage.
• Responsible for implementation of data virtualization service solutions for the project. Responsible for new environment setup for the solution.
• Creating data source connections for Oracle, Netezza, Sql Server etc.
• Creating Denodo views and derived views in VDP with connecting multiple data source systems.
• Publishing the denodo derived views with REST / SOAP APIs.
• Experience working with caching approaches and technologies.
• Involved in Denodo Query Optimizations and Cache Performance Optimization for the Data Warehouse creation and Scheduling the Denodo jobs for Cache refresh.

Confidential, Norwalk

Lead ETL -Denodo Developer/ Metadata Analyst

Environment: Database: Greenplum, Oracle Exadata

Tools: Informatica PowerCenter 10.2, Informatica Metadata Manager, Denodo 5.5/6.0

O/s: Unix, Windows 10 Enterprise

Responsibilities:

• Participating in user meetings, gathering requirements, discussing the data issues with end users.
• Responsible for data analysis of source feeds and file feeds
• Coordinate with data stake holders to capture technical metadata and lineage.
• Helped to implement data lineage strategy consistently across all covered Information Domains.
• Work closely with IT counterparts to update data models.
• Collaborate with business and technical stakeholders on maintaining metadata repository.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes.
• Preparing High Level technical design documents.
• Preparing logical and physical data models using ER studio.
• Member of the Data Lake strategy team responsible for inclusion of metadata in the strategy.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Experience in writing functions in pivotal green plum
• Proven experience in writing complex sql queries and functions in oracle and Greenplum
• Involved in creation of denodo views and schedules
• Creating Denodo views and derived views in VDP with connecting multiple data source systems
• Involved in designing and creating reports in Denodo platform
• Code review of all technical specs like informatica mappings, sessions and scripts and responsible for deliverables.
• Tuning the performance of mappings and sessions in informatica and at database level
• Design, Development and implementation of Informatica Developer Mappings for data cleansing using Address validator, Labeler, Association, Parser, Expression, Filter, Router, Lookup transformations etc.
• Used Informatica Address Doctor for global address verification across an organization
• Done extensive testing and wrote queries in SQL for push down optimization
• Responsible for change management and ensuring the quality of the deliverables.
• Participating in UAT meetings and co-ordinating with Business to receive business sign-off.
• Preparing improvements plans in BI and value adds to the project
• Ability to quickly learn applications & Process with minimal documentation
• Leading the technical team and guiding the team on technical challenges.
• Supervising day to day activities completed by team and updating customer on daily basis
• Strong influencing and technical Communication skills.

Confidential

Team Lead

Environment: Database: Teradata 13

Tools: Informatica PowerCenter 9.5.1

O/s: Windows 7 Enterprise

Responsibilities:

• Coding using Informatica PowerCenter 9.5.1
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.

Confidential, New York City

Sr. Systems Analyst / Informatica Developer.

Environment: Database: Oracle 10g, Sql Server 2008, Mysql Server 5.5

Tools: Informatica PowerCenter 9.1

O/s: Windows 7 Enterprise

Responsibilities:

• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, expression, aggregator, joiner, filter, normalizer, rank and router transformations.
• Worked Informatica power center tools like source analyzer, mapping designer, mapplet and transformations.
• Developed Informatica mappings and also tuned for better performance.
• Extensively used Informatica to load data from flat files, Oracle, MySQL database.
• Responsible for Performance Tuning at the Mapping Level and Session level.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Extensively worked with both Connected and Unconnected Lookup Transformations.

Confidential

Informatica Developer

Environment: Database: Oracle 10g, Sql Server 2008, Mysql Server 5.5

Tools: Informatica PowerCenter 9.1

O/s: Windows 7 Enterprise

Responsibilities:

• Interacted with the Business Users to analyze the Business Requirements and transform the business requirements into the technical requirements.
• Extracted data from various heterogeneous sources like Oracle, MYSQL and Flat Files.
• Worked on Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Analyzed business process workflows and developed ETL procedures to move data from various source systems to target systems.
• Created PL/SQL procedures to transform data from staging to Data Warehouse Fact and summary tables.