We provide IT Staff Augmentation Services!

Sr. Etl Developer / Scrum Master Resume

PROFESSIONAL SUMMARY:

  • Over 14 years of diversified experience in Data Warehousing, Data Modeling, ETL using Informatica, Pentaho, 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 (Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor)
  • Strong experience in Oracle, 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 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange.
  • Experience in Big data tools like Sqoop (Extraction and Load from HDFS and to HDFS file system).
  • Experience in Big data tools like HBASE and HIVE (Store data in relational table structure).
  • 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 Unix shell scripts to automate the process.
  • Analyzed the functional specs provided by the business analyst and created technical documents for the mappings
  • Working knowledge of Cloud Services IaaS, PaaS, and SaaS and coming trends in the Cloud space
  • Serving as a hands - on subject matter expert for DevOps and Automation in a Cloud infrastructure environment
  • 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

SKILL:

ETL Tools: Informatica Power center, Power Exchange, Pentaho

BIGDATA/HADOOP: Sqoop, Hive, HBASE, HDFS, Kafka and Spark

Programming: Perl, Unix Shell Script, Java

Database: Oracle, Sybase, DB2, Teradata

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 EXPERIANCE:

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, Hive, HDFS, HBASE and Spark).
  • Developed Unix 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).
  • Involved in migrating the application to Cloud.
  • Part of the design and initiating team for the DevOps adoption across the LOB.
  • Developed the complex stored Procedures in Oracle.

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

Confidential

ETL& OLAP Developer

Environment: (Development): Informatica Power Center, OBIEE, Oracle, UNIX shell scripting, PL/SQL DAC (Oracle BI Data warehouse Administration Console 10.1.3).

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

Hire Now