We provide IT Staff Augmentation Services!

Etl Lead/developer Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • Over 12 years of Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using IBM Data Stage 11.5/11.3/8.7/7. x/6.x/5.x (Info Sphere Information Server, Web Sphere, Ascential Data Stage).
  • Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server/Parallel jobs using Data Stage, creating Indexes, Aggregate tables and to populate tables in Data Warehouse and Data marts.
  • Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Switch, Salesforce plugin, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
  • Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
  • Experienced in integration of various data sources (DB2 - UDB,PL/SQL,Oracle, Netezza, Salesforce plugins,XMLand MS-Access) into data staging area.
  • Expert in working with Data Stage Manager, Designer, Administrator, and Director.
  • Experience in migrating Data Stage environment from 8.7 to 11.5.
  • Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.
  • Proficient in writing, implementation and testing of triggers, procedures and functions inPL/SQLandOracle.
  • Experienced in Database programming, proficient in dimensional modeling (Star Schema modeling, and Snowflake modeling).
  • Expertise in UNIX shell scripts using K-shell for the automation of processes and scheduling the Data Stage jobs using Autosys, Control - M.
  • Experience in using reporting tools like Cognos, Business Objects, Microstrategy, Tableau, other ETL tool like Talend and software configuration management tools like SVN for version control.
  • Expert in unit testing, system integration testing, implementation and maintenance of databases jobs.
  • Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.

TECHNICAL SKILLS:

Datawarehouse ETL: DATASTAGE 11.5 ORACLE RDMS NETEZZA DB2 UNIX

SHELL SCRIPTING: SQL PLSQL COGNOS

BUSINESS OBJECTS: AUTOSYS CONTROL - M Datawarehouse designing Data Analysis Data Integration Defect Management Data Testing Code Version Control Performance Tuning Onsite/Offshore coordination Team Management Project Implementation Banking and Finance domain Hi-Tech domain Retail domain Logistics domain Insurance / Credit Rating Training Microsoft Office Prioritization Reporting

TOOLS: Datastage 11.5 Salesforce - Plugin Oracle Unix Shell Scripting Netezza DB2 SQL PLSQL FNS TOAD DBeaver SQLPLUS Autosys Control-M HTML /CSS

PROFESSIONAL EXPERIENCE:

ETL Lead/Developer

Confidential

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.

ETL Data Stage Lead

Confidential

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.

ETL Datastage Developer

Confidential

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

ETL Lead /Developer

Confidential

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.

ETL Lead

Confidential

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.

We'd love your feedback!