ETL Technical Lead & Onsite Coordinator Resume

SUMMARY

6+ years’ experience as ETL Technical Lead managing the offshore teams on various projects, responsible for meeting delivery commitments right from feasibility analysis to meeting delivery commitments
9 years’ experience in application development using Oracle and SQL Server as core components in the architecture.
Strong expertise in various phases of SDLC - System analysis, Requirement Gathering, Design, Construction, Transitioning
3 Major recent project implementations that integrated ETL data of billions scale with Cognos Dashboard Reports
Worked closely with Data Architects and Business Analysts in analysing data patterns/ data source specs and participated in modelling data structures and architecture and integration interfaces
Strong exposure to Hadoop Hive query / storage optimizations for CBO with Tez with the help of explain plan analysis and Tez execution summary analysis.
Exposure to performance benchmarking with Spark 2.3, Spark 1.6 and LLAP.
Strong exposure to CI/CD based automated deployment using Jenkins.
Domain Experience in Retail, Asset Care, Supply Chain
Strong Expertise in Data Warehousing, OLTP, OLAP concepts
Extensive Exposure to in Dimensional / Relational modelling
Experience in Implementing ETL Solutions using Agile methodology/DevOps
Strong experience in planning, estimation, coordination and Implementation of various project cycles on POC/DEV/QAT/PRE-PROD/PROD environments
Strong Experience in various databases like Netezza, SQL Server, Oracle, MySQL, Hadoop with HIVE-Tez/Beeline
Extensively worked on Database level optimizations (SQL fine tuning, Application Logic Optimizations and storage optimizations)
Strong experience in quality documentation required at various stages of SDLC cycle (Estimates, Source To Target Mapping, High Level Design, Detailed Design, Unit Test Cases, Supporting documentation for sustaining)
Personally motivated and trained new members into the team throughout the professional life time

TECHNICAL SKILLS

Oracle SQL, PL/SQL
SQL-PL/SQL Fine Tuning
Netezza Twinfin & Striper
SQL Server
Hadoop HDFS
Hadoop MapReduce/Tez on HDFS
Hive SQL Tuning / HDFS Storage Optimizations
Bash Shell Scripting
Python
PVCS, ClearCase, Bitbucket with SourceTree Client
CI/CD Based Deployments using Jenkins
Mainframe Based ESP
Powerbuilder and Visual Basic
ClearQuest from Rational Software Division, IBM
TestDirector from Mercury Interactive
MS Word, Excel, Visio, PowerPoint
Visual Basic for Applications, Excel Macros
Windows NT, Windows 7/10 /XP, Citrix Client, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential

ETL Technical Lead & Onsite Coordinator

Responsibilities:

Lead and coordinate activities of teams that are involved in designing, developing and delivering data warehousing solutions and enhancements to Confidential .
Analyze and gather business requirements;
Work as an onsite coordinator for the offshore team.
Responsible for providing regular status updates to the management at client side and also to my manager at the parent organization.
Manage delivery commitments as per project timelines.

Environment: Hadoop HDFS & Hive, MySQL, Sqoop Linux, Apache NiFi, IBM Infosphere DataStage, Netezza Database, Oracle, Unix, Linux

Confidential

Data Warehousing Solutions

Responsibilities:

Lead and coordinate activities of a team that is involved in developing and delivering data warehousing solutions and enhancement for Confidential .
Also performed as an individual contributor.

Environment: IBM Infosphere DataStage, Netezza Database, Oracle, Unix, Erwin Data Modeller

ETL Developer

Confidential

Responsibilities:

Leading the team
Client interaction for status reporting and issue resolution
Maintenance of EMPAC & INSITE - managing the Emergency Patch and General Patch delivery management.
Oracle Financials Loosely Coupled Integration implementation
Managing design, development and delivery of customizations.

Environment: Windows 2000, Oracle 9, 10g, 11g &PowerBuilder7, 9.0, 10.5 and 12, Visual Basic 6.0.

Confidential

IT Consultant

Responsibilities:

Preparation & Verification of Detail Design Documents based on Functional Specification
Design and Construction

Environment: Windows NT, Oracle 8i, PowerBuilder 8.0 with PFC, middle layer in Forte

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship