SUMMARY

• Over 8+years of IT experience in Banking, Insurance, Utility and Retail domains.
• 2 years of recent experience with Hadoop software tools which include Podium and Hue and hands on experience about various ecosystems pertaining to Hadoop like MapReduce, yarn, hive, pig, Sqoop, oozie.
• Certified professional on Talend Data Integration Developer v7 and Informatica PowerCenter Data Integration 9.x Developer.
• 4 years of experience as Data/Business Analyst and 4 years of experience as Data Modeller.
• Expertise in Project Management principals, Systems Design, ETL Process flow, Development, SDLC, System analysis, Agile development, Bug fixing, Documentation, Implementation, Maintenance and Integration of various data sources such as DB2, Oracle, MS SQL server, Fixed Width/Delimited flat files, Cobol & XML using Informatica Power Center 9.x/8.x/7.x on Windows and UNIX platforms.
• 2 years of recent experience in designing Sqoop Import jobs, designing Oozie workflows for sqoop jobs and deploying them to SIT using Jenkins.
• Experience with git commands to commit teh code using MobaXterm tool.
• Experience working with Solution Architects to determine feasibility of teh project and getting approval.
• Hands on experience with Developing and maintenance of hdfs files, loading and transforming data coming from hdfs files as source and Oracle Exadata as target and vice versa using Informatica BDE.
• 2 years of experience with performing integrating data/Data profiling/Complex Data Parsing on Hadoop using Informatica Big Data Edition.
• 4+ years of professional experience with Production Application Support with a practical understanding of Finance / Investments and Utility business.Built large DWH solutions on cutting edge technologies Netezza, Oracle Exadata and SQL Server.
• 2 years of experience building Oracle Data warehouse.
• 2 years of experience with creating business documents and technical documents like BRD, SSRS.
• Proficient in teh development of ETL (Extract, Transform, Load) processes with a very good understanding of source to target data mapping, ability to define, capture Metadata and Business rules. Expertise in error handling & debugging.Experienced in Star - Schema and Snow-Flake data modeling, Normalization, Data Profiling, Data Cleansing, Logical & Physical data model, Fact & Dimensional Data modeling using ERWIN.Designed and developed mappings using diverse transformations like Unconnected/Connected Static/Dynamic Lookup, Expression, Router, Rank, Joiner, Sorter, Aggregator, Stored Procedure, Normalizer, Transaction control, SQL, XML, Source Qualifier transformations.
• Experienced in developing complex business rules through Informatica transformations, Workflows/Worklets, Mappings/Mapplets, Test Plans, Test Strategies and Test Cases for Data Warehousing projects.
• Sound knowledge of RDBMS concepts, with hands on exposure in teh development of relational database environment using SQL, PL/SQL, Stored Procedures and UNIX shell scripting.
• Performance Tuning and extensive experience in SQL * Loader Imports/Exports, and Oracle utilities such as UTL FILE, SQL * Loader, Packages,
• Experienced in job scheduling using Autosys, Crontab/Windows Scheduler, and Informatica Scheduler on multiple platforms like windows NT/2000 and Linux environments. Co-ordination skills in handling of On-site and Offshore models.
• Created/modified jobs through teh GUI interface (scheduler console) and created JIL script files for job scheduling.
• Self motivated Team player and dynamic with exceptional oral and written communication skills.

TECHNICAL SKILLS

Languages: HQL, Pig, Python, SQL, PL/SQL, C, Java

Scripting: UNIX shell scripting, DOS Batch scripting

Databases: Hadoop, Netezza, Exadata, DB2, Oracle 11g/10g/9i, SQL Server 2012/2008

ETL Tools: Sqoop, Podium 3.0, Informatica PowerCenter v9.x/8.x/7.x, Informatica BDE, SSIS

BI Tools: Cognos Report/Query Studio, Framework Manager

Data Modeling Tools: Erwin Data Modeller, MS Visio

Other Tools: Jira, Sharepoint, TIBCO, IDQ, Autosys, SQL*Plus, MS Word, MS Excel, SQL * Loader, Toad, SQL Developer, MobaXterm.

Operating Systems: AIX-UNIX, Solaris-Linux, Windows.

Methodologies: ER Modeling, Dimensional Modeling, Star Schema, Snow Flake Schema, Fact andDimensional Tables, Physical and Logical Data Modeling, Scrum, Agile, Waterfall.

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Gathering teh Business Requirements from Line of Business like Malcodes, SLA’s, Business logic, File format, Database connection string, etc.
• Working with Solution Architects, BAs to analyze data and to discuss teh feasibility of teh technology prior to documenting BRD, SSRS, dealing with data analytics on (capital markets) loans and cash flows.
• Scheduling meetings to sort out any issues regarding scope, format, technology to be used, etc. between internal team and LoB team.
• Conducted ad-hoc meetings with Stakeholders to discuss teh data gaps for example: null values coming up in teh downstream data, finding out root cause for data gaps and addressing them asap.
• Writing SSRS document based on teh requirements and getting signoffs.
• Designing teh jobs for ingestion into Enterprise Data Lake from various sources using ETL Podium tool.
• Extracting teh data using HQL, Pig and exporting to teh target databases.
• Designing Sqoop scripts for ingestion and teh related podium jobs.
• Working on teh python scripts to sequence teh jobs accordingly.
• Using Oozie to schedule teh ETL workflows as per teh sequence.
• Deploying teh code to SIT using Jenkins tool.
• Extensive usage of git commands to commit teh code using MobaXterm tool.
• Good usage of Confluence to document any technical information.
• Analyzing teh logic corresponding to a process mapping and also analyzing/examining teh data feeds coming through teh logics and creating business documents like SSRS based on BRD’s.
• Creating extracts based on business logic and exporting files to target systems based on sqoop-out to target databases.
• Creating extracts using BigData Podium Prepare extraction methodology for teh projects like Branch Score Card.
• Support SIT team during SIT phase of teh project regarding teh defects raised via Jira.
• Support Production team during PAT phase of teh project and handling PCR’s effectively.
• Giving good support to teh Project Manager of a project regarding teh technicalities of teh project and halping to set up realistic timelines for teh project.
• Worked on projects which require to Data model based on business requirements, putting forward referential integrity in place (Primary key/ Foreign key relation) and establishing relations between fact and dimensions using ERWIN tool.
• Very good working knowledge on Talend tool. (Talend was introduced to InfoEx at dat time).
• Worked on high profile projects which include Branch Score Card (Extraction), MBNA North, Enterprise Fraud Platform, IEM, MDM Glod and Silver projects, Phone Channel (Sqoop), TDI (Sqoop).

Environment: Hadoop 2.0.3 alpha, Podium 3.0, Hue, DB2, Oracle 11g, SQL Server 2008, flat files/XML, EBCDIC files, SQL, Sqoop, Oozie, HQL, Pig, Python 2.6.6, MS Word, MS excel, Confluence, MobaXterm 10.5, Talend v6, Erwin, MS Access.

Confidential

Data Consultant

Responsibilities:

• Create/Update ETL Informatica jobs to load data from external systems to load teh data warehouse. This process runs daily. Create warehouse tables and extend warehouse columns to bring in new source system changes. Built large Data Warehouse solutions on cutting edge technologies Oracle Exadata and SQL Server.
• Validate teh data in teh warehouse against teh source system. Use of Data Warehouse best practices in support of jobs in maintenance. Investigate and reconcile commercial customer payment/bidding system.
• Create new JIL files to include teh new Informatica jobs and build teh execution plan.
• Use of ETL processes to accommodate changes in source systems and new business user requirements.
• Designed and Implemented SCD’s type1 and type2 (Date Range) method for tracking current history and full history of transactions respectively.
• Designed and Implemented File List for dynamically creating files, with teh file name coming from a port name.
• Problems by reviewing design changes made to production systems and make corresponding changes to teh Repository.
• Programming experience in UNIX shell developing scripts to run Informatica workflows and micro jobs for near real time data.
• Designed and developed mappings using diverse transformations like Unconnected/Connected Static/Dynamic Lookup, Expression, Router, Rank, Joiner, Sorter, Aggregator, Stored Procedure, Normalizer, Transaction control, SQL, XML, Source Qualifier transformations.
• Performance tuning, involving identifying Bottle necks at source/transformation/target level, identifying teh issues wherever complex transformations like Aggregator are used in teh mapping and making necessary changes and fixing teh issues for better performance.
• Support infrastructure planned maintenance and outages. Work on refreshing Dev/SIT/UAT Informatica environments on regular basis as per teh project needs. Provide production support to ETL applications on rotation basis.
• Extracted hdfs files from Hadoop and performed data profiling/data quality/ complex data parsing using Informatica Big Data Edition tool and loaded into Target.
• Participated in defining standards and best practices for administration. Create and maintain connections (relational, application) and maintain existing. Rep Manager, Reporting Service, ODBC connections, etc.
• Assisted teh team in creating SQL server integration service (SISS) packages for initial loads.
• Worked with Shell scripts and pmcmd to interact with Informatica server from command mode.

Environment: Informatica PowerCenter 9.6/9.5, Informatica Big Data Edition, IDQ, DB2, Oracle 11g Exadata DW,SQL Server 2008, flat files/XML, hdfs files, Erwin R9, SQL, PL/SQL, SQL*PLUS, Shell Scripting, Autosys, Unix-AIX, Cognos 10.1, SQL Developer, SQL*Loader, UTL File, TOAD.

Confidential

ETL Developer

Responsibilities:

• Worked with Stakeholders and Business Analysts regarding business requirements, functional specifications and enhancements, based on teh business needs created technical design and functional specification
• Developed and assisted data modeler in designing logical and physical data models dat capture currentstate/future state data elements, data flows and work flows using Erwin and MS-Visio.
• Developed Complex data Mappings in Informatica using Power Center transformations (Lookup, Joiner, and Rank, Source Qualifier, Sorter, Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations), Mapping Parameters, Mapping Variables, and Mapplets and Parameter files.
• Scheduled teh Workflows to run on a daily and weekly basis using Autosys Scheduling tool.
• Maintained workflow logs, target databases, code backups and also performed operational support and maintenance of ETL bug fixes and defects.
• Involved in assigning teh ticket to theInformaticaproduction support based on teh error and also worked on solving issues pertaining to teh ticket issued.
• Supported migration of code between production and testing environments and also maintained teh code backups.
• Performed tuning of teh Informatica mappings using dynamic Cache, round-robin and PL/SQL scripts.
• Actively coordinated with testing team in writing test cases and performing them and halped teh team to understand teh dependency chain of teh whole project.
• Provided Knowledge Transfer and created extensive documentation on teh design, development, and implementation of daily loads and workflows for teh designed mappings.

Environment: Informatica PowerCenter 8.6, Netezza, SQL Server 2008, flat files/XML, Erwin R7, SQL, PL/SQL, SQL*PLUS, Shell Scripting, Autosys, Unix System, Micro strategy.

Confidential

Database Analyst

Responsibilities:

• Assisted Business Analyst on teh project in Requirements Elicitation process to develop a detailed Software Requirement Specification (SRS).
• Worked with teh joint application development teams to maintain teh updates and produce teh Technical Design Documents (TDD).
• Involved in teh communication process regarding business needs to all stake-holders regarding new products & initiatives.
• Involved in Designing Logical and Physical Database using ERWIN 4.x, Star-Schema, dimensional modelling of Facts and Dimensions.
• Reverse engineered teh physical model with Erwin to generate teh logical model for as of state of teh project documentation. Performed unit testing and documented teh results.
• Created complex Queries for ad-hoc reporting including OLAP environment. Designed and developed simple and complex logical and materialized view queries for simplifying report requirements and data governance.
• Developed PL/SQL Stored Procedures, Functions and UNIX scripts to implement business logic.
• Provided valuable contribution in all phases of SDLC including production support.
• Undergone corporate for Informatica tool set.
• Programming experience in UNIX shell developing scripts to run Informatica workflows.

Environment: Informatica Power Center 7.1, Oracle 10g/9i, Toad, Windows NT, SQL*Plus, PL/SQL, Flat files, MS SQL Server.