Sr. ETL Datastage Lead/Developer Resume

SUMMARY:

Over 12 years of IT experience in RDBMS & Data warehousing, experience in design, development, testing, implementation and support of enterprise data warehouse. I have worked primarily in the domain of Banking & financial services, retail, logistics and Hi - tech domain. My technological fortes are Datastage, Oracle 9i/10g/11g/12c, Netezza, DB2, ETL, AIX Unix/Linux, AutoSys.

TECHNICAL SKILLS:

Technology and Tools: 8085/8086 Micro processor Datastage 11.5/8.7/ 8.1/ 7.5 , BO,Cognos 8 ReportNet, FNS, UNIX Shell, SQL, PL/SQL, 8085/8086 Assembly language, HTML. Linux, UNIX HP/AIX and Windows 98/2K/XP Toad, DBeaver, SQLPLUS, VIM32, Datastage, Cognos, PLSQL Developer, Autosys, Control M

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Datastage Lead/Developer

Responsibilities:

Involved in the creation of dimensional schema design including dimension tables, fact tables and aggregate tables using DBeaver, DB2 SQL, IBM Datastage.
Analyzing source data, technical metadata, construct file structure and profile data sources to enable Business Intelligence solutions using tools like SQL, DBeaver and IBM Datastage.
Designing, developing code, application of best practices, building, testing and implementing data files, transform and load procedures using 18M Data Stage, DBeaver, DB2 SQL and UNIX shell scripting.
Created ETL IBM Datastage parallel jobs to create extract and reformat the source data so it can be loaded into the new data warehouse schema.
Execute processes for performance tuning of applications to meet operational production needs using IBM Datastage, UNIX and SQL tools.
Create shell scripts to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
Defect tracking, resolve defects and troubleshoot DS jobs and scripts while addressing production issues like data issues, ENV issues, root cause analysis, performance tuning and enhancements.
In corporate appropriate changes from production or test regions into the data warehouse environment using SQL, Stored procedures, Datastage and UNIX shell scripting tools.
Document ETL test plans, test cases, test scripts, pseudo code and validations based on design specifications for unit testing, system testing, functional testing, regression testing, integration testing and prepare test data for testing, error handling and analysis.

Solution Environment:Windows NT, UNIX AIX, DB2 database

Confidential

Sr. ETL Datastage Lead/Developer

Responsibilities:

Designed, developed Datastage mappings, enabling the extract, transport and loading of the data into target tables.
Involved in migration project from IBM Information server 8.7 to 11.5
Design and develop Information server packages, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
Train and manage developers, advising other groups in organization on data warehouse development, and ETL development best practices.
Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.

Environment: Windows NT, UNIX AIX, Oracle database

Confidential

Sr. ETL Datastage Lead/Developer

Responsibilities:

Gap analysis for the new DW changes
Optimizing the existing DB2 and Netezza queries and Pl/SQL
Handling the new enhancement for the production job
Interacting with the business and getting the requirements.
Serves as a point of escalation for complex issues

Solution Environment: Windows NT, UNIX AIX, Netezza, DB2 database

Confidential

Sr. ETL Datastage Lead/Developer

Responsibilities:

Involved in enhancement, performance improvement and maintenance of ODS.
Application tuning: Developing/Optimizing/Performance tuning of ETL jobs
Database: Oracle stored procedure development.
Use the quality stage address standardization to clean the address from source
Responsible for the interfacing with the database design team and performance tuning the data loads. Worked in PL/SQL and Complex SQL and Oracle hints.
Created project handbook for production support.

Environment: Windows NT, UNIX AIX, Oracle 10g database

Confidential

Sr. ETL Datastage/Unix/Plsql Developer/ Offshore-Onsite Coordinator

Responsibilities:

Responsible for reviewing and developing jobs in Datastage, PLSQL, SQL, incorporating complicated business logic used for ETL and Oracle related.
Design datawarehouse architecture and ETL process. Create system test plans.
Responsible for report development, testing using Cognos, BO and Microstrategy tools. Create Unix Shell script to extract data and format.
Responsible for completing and delivering daily, monthly and quarterly process activities within set deadlines.
Database and ETL performance tuning using TKPROF, AWR, ADDM, OEM reports.

Environment: Windows NT, UNIX AIX, Oracle 10g database

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship