SUMMARY

• Over 14+ years of diversified experience in Data Warehousing, Data Modeling, ETL using Informatica, Pentaho, Talend, Hadoop, Databases using Oracle, Sybase, DB2, HBase, and Server using Unix, Linux and Windows in various industries
• Domain experience in Banking (Investment Banking), Supply chain management, Taxation and Government Benefit systems.
• Held Various roles like Scrum Master, Tech Lead and Developer.
• Highly Proficient in data extraction, transformation and loading data using Informatica PowerCenter 10.2/9.6/9.1/8.6/8.1.1 (Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Strong experience in Oracle 12c/11g/10g/9i, SQL, PL/SQL including Stored Procedures, Triggers, Dynamic SQL, and Query Tuning. Extensive experience in data analysis using SQL and good understanding of different source systems. Strong analytical and communication skills
• Good knowledge in Data Modeling using data Modelers, Star schema/Snow Flake schema, Fact & Dimensions tables, Physical & logical data modeling
• Experience in requirement gathering, designing architecture and ETL technical Specification document development
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses, Data Vault and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange.
• Handling Jira board, creation of stories, conducting all scrum ceremonies and in dept knowledge of Agile methodology.
• Experience in Performance tuning of targets, sources, mappings and sessions
• Worked extensively on stored procedures, Functions, Triggers and SQL Queries
• Experience with Unix Shell Programs, Integrating UNIX Shells with ETL jobs like Informatica Batches, Sessions, Command Task, and Workflows
• Developed shell scripts to automate the process.
• Analyzed the functional specs provided by the business analyst and created technical documents for the mappings
• Expertise in all phases of the Software Development Life Cycle(SDLC) including analysis, code development, testing, validation, implementing and maintenance Supported code/design analysis, strategy development and project planning
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills

TECHNICAL SKILLS

ETL Tools: Informatica, Pentaho, Talend

BIGDATA/HADOOP: Sqoop, HBASE, HDFS, Hive

Programming: Perl, Shell Script, Java

Database: Oracle, Sybase, DB2

DB Tools: SQL Developer, TOAD, SQL Loader

Operating System: UNIX/Linux, Solaris, Windows, DOS

Scheduling Tools: Control - M, DAC, Crontab and Tivoli Maestro

Version Control: SVN, GIT, PVCS, SCCS

BI Tools: Business Object, OBIEE

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer /Scrum Master

Responsibilities:

• Playing a scrum Master and Developer role in the AGILE methodology
• Involved in planning, estimation, design and requirement gathering for each sprint.
• Developed the complex Informatica mappings and the workflows.
• Involved in Performance tuning and the performance improvement activities.
• Developed and implemented the Data ware house using the HADOOP (Sqoop, HDFS, HBASE and Java).
• Developed shell scripts, which will get invoke from the Control-M job scheduler.
• Lead the Informatica up gradation project (from 8.6 to 9.5 versions).
• Part of the Informatica and data ware house trainer team.
• Involved in testing (Unit, Integration, system testing, Recursion testing and UAT).
• Developed the complex stored Procedures in Oracle.

Environment: ( Development/Production): Informatica Power Center 9.0.1, Oracle 11g, HADOOP (Sqoop, HDFS, HBASE,Pentaho and Scala), UNIX shell scripting and Control-M (Scheduling Tool)

Confidential

ETL& OLAP Developer

Responsibilities:

• Performed & Involved Requirements gathering activities to be able to design useful technical solutions.
• Assisting the Analysis team in designing, developing, testing and Implementation stages
• Created LLD for data warehouse design & Involved in LLD reviews
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Participated in derivation of logical requirements into physical requirements and in preparation of high level design document for ETL jobs.
• Performed admin activates like Creating, deleting, taking folder backups, comparing folders & repositories
• Providing testing support and coordinate with SIT and UAT team members to rectify Technical and functionality issues.

Confidential

Team Lead and ETL (Developer and Admin)

Responsibilities:

• Participated in project planning sessions with project managers, business analysts, Business User and team members to analyze business requirements and outline the proposed solution.
• Worked on SAP system interface mappings.
• Extensively worked on Data Analysis using source systems (SAP R/3 System, Seibel, RIM)
• Worked on Performance tuning at Mapping and workflow level.
• Involved in Live Support activities like resolving the defects, interacting with the clients and maintaining the Data warehouse systems
• Involved in Informatica admin activates like Creating, deleting, taking folder backups, comparing folders & repositories.
• As a Team Lead, responsibility of deliverables for any assignments assigned to off shores ETL and UNIX issues.
• Guiding & supporting the off shore and Onshore team members in different aspects.

Environment: (Development/Production): Informatica Power Center, Oracle, UNIX shell scripting, Toad 9.0.1, SAP

Confidential

ETL& OLAP Developer

Responsibilities:

• Created LLD for data warehouse design & Involved in LLD reviews
• Created BO-Universe for Work Management mart and created BO reports for MIS mart and Work Management mart
• Developed Universes and reports using Business Objects.
• Involved in the data migration and software migration activities.
• Developed shell scripts, which will invoke the DAC Execution Plans.
• Providing testing support and coordinate with SIT and UAT team members to rectify Technical and functionality issues.
• Involved in PGLS (Post Go Live support) activities.

Environment: (Development): Informatica Power Center, Business Objects, Oracle 10g, UNIX shell scripting, Toad 9.0.1, Tivoli -Maestro scheduler, PVCS dimension, Oracle developer

Confidential

ETL and UNIX Developer

Responsibilities:

• Developed shell scripts to automate the process.
• Resolving the issues (tickets) created by Users all over the GLOBE.
• Guiding & supporting the off shore and Onshore team members in different aspects.
• Involved in Optimization for various business queries and scripts.
• Finding the RCA for the Issues and solving the problems when job failed.
• Involved in writing the Unit Test Conditions and Execution of Unit Test Conditions
• Involved in automation of cron job implementation

Environment: (Live support): EDI Unix tool, Oracle, UNIX Shell Scripting, Toad 8.6, PVCS, Informatica Power Center, Oracle 9i, UNIX Shell Scripting, Toad 8.6

Confidential

Developer/Module Lead

Responsibilities:

• Participated in various phases of SDLC especially requirement analysis, design, development, testing and Performance Tuning.
• Designed the architecture for the DRC (Disaster Recovery Centre) which included the planning, development and implementation of the DRC process and wrote scripts to automate the process. Did the calculations of the sizes and the frequency of transfer. And was involved in all phases of the DRC activity.
• Business discussions and system study.
• Impact analysis and detailed design
• Development and Implementation3

Environment: (Development and Production support): UNIX shell script, XML, PVCS, Oracle, Banking Domain