Post Job Free

Resume

Sign in

Etl Developer Sql

Location:
Hyderabad, Telangana, India
Posted:
April 06, 2022

Contact this candidate

Resume:

Shalthaf Hussain Shaik

adqpar@r.postjobfree.com

812-***-****

Professional Summary

• 3 years of experience in information technology industry expertise in the Development Data Ware housing application using IBM Info sphere Data stage 8.7,9.1,11.5 Data Stage parallel versions.

• Working on different environments like Development, ETL Testing and operation support system

• Working on various domains like telecom and sales

• Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.

• Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Dataset, Lookup, Aggregator

• Expertise knowledge on Datawarehouse concepts star, snowflake, fact and dimension tables

• Flexible and versatile to adapt new environment and ready to work on any Project

• Involved in performance tuning activity

• Knowledge on UNIX

• Expertise in working with SQL and relational Databases SQL server

• Participate in Design reviews, Test Case reviews, and Production Support readiness reviews for new releases, provide inputs for Go/No Go decision

• Coordinating ETL strategies with other areas to ensure consistency across the enterprise

• Performs moderately complex modification, testing and debugging tasks on vendor-supplied utilities and packages to ensure fit with current operating environment Client Name Vodafone

Project Name VodafoneEssar–INDIA

Project Duration (From & To in Month/Year

Format)

Aug/2019 to Till date

Role/Title Datastage Devoloper(ETL developer)

Work Location India

Project Description

Vodafone Essar is the largest service providers of GSM cellular service in India. It provides pre-

paid, post-paid and value-added services like

shalthaf hussain shaik f

2

GPRS, WAP, EDGE, News etc. to its customers.

Vodafone Essar now has operations in 23 circles

with over 200 million subscriber base, have

implemented a DWH solution as part of BI

Strategy.

Atos is one of the leading Outsourcing

Business Partner in the area of Data

Warehousing, Business Intelligence, Telecom

and IT Architecture.

Responsibilities

Expert in designing Parallel jobs using

various stages like Join, Merge, Lookup,

Remove duplicates, Filter, Dataset, Lookup,

Modify, Aggregator.

Excellent Experience in Designing,

Developing, Documenting, Testing of ETL

jobs and mappings in Server and Parallel

jobs using Data Stage to populate tables in

Data Warehouse and Data marts.

Designed and Developed Data stage Jobs to

Extract data from heterogeneous sources,

Applied transform logics to extracted data

and Loaded into Data Warehouse Databases

Used the Data Stage Director and its run-time

engine to schedule running the solution,

testing and debugging its components, and

monitoring the resulting executable versions

on ad hoc or scheduled basis.

Performed performance tuning of the jobs by

interpreting performance statistics of the jobs

developed.

Documented ETL test plans, test cases, test

scripts, and validations based on design

specifications for unit testing, system testing,

functional testing, prepared test data for

testing, error handling and analysis.

Involved in performance tuning activity.

Involved in client meeting and updated the

daily task to the client/onsite member.

Involved in UAT Phase having direct

interaction with client to solve the issues.

Involved in tracking of incidents.

Involved in data analysis for new demands.

Identifying and solving the post production

issues.

Operating Systems Linux

shalthaf hussain shaik f

3

Hardware

Software / Special Tools Datastage IBM Netezza

Languages Putty, SQL Developer, Aginity(Netezza)

Operating Systems Windows and Linux

Hardware Oracle

Software / Special Tools

SQL Developer, Putty, WinScp, Datastage,Control

M

Languages SQL, Oracle

Education

Professional Organizations

Prior Work Experience Details

Organization’s Name Designation

Dates of Employment

Location (City

& State)

Explanation for

Interruption / gap

(If Any)

From

(DD-MON-

YYYY)

To

(DD-MON-

YYYY)

Varisoft Technologies

India Pvt Ltd

Software

Engineer

09-Aug-

2019

Till date Hyderabad NA

Educational Record (In Reverse Chorological Order Starting Highest Degree) Course of

Study

Specialization Name of University Address of University Year of Completion Bachelor of

commerce

(B.Com

computers)

Computers Chaudharya charan singh

university

CCS University 2019

12th Board MPC NIOS NIOS 2016

10th Board General School secondary Board Ravindra high school 2014



Contact this candidate