We provide IT Staff Augmentation Services!

Senior Etl Consultant Resume

Tampa, FL


  • Experienced Software Engineer with almost 6 years of experience in the Healthcare and Financial industry, with proficiency in System Analysis, Design and Development in the fields of data Warehousing, Data Integration and Data Migration. Strong engineering professional with a Masters of Science focused in Computer Science from NYU Tandon School of Engineering.
  • Expertise in Extraction Transformation and Loading (ETL) processes using Data Stage ETL Tool, Parallel Extender, Quality Stage, and UNIX shell scripting.
  • Expertise in writing large/complex queries using SQL.
  • Expertise in OLTP/OLAP System Study, Analysis and Dimensional Modeling, E - R modeling. Involved in Designing Dimensional Model.
  • In depth knowledge in Data Warehousing concepts with emphasis on ETL and Software Development Life Cycle (SDLC), includes requirement analysis, design, development, testing and implementation.
  • Extensively used DataStage tools (Data Stage Designer, Data Stage Manager and Data Stage Director, DataStage Administrator).
  • Worked with Oracle PL/SQL Stored Procedures, Table Partitions, SQL queries, IBM SQL Procedural Language and loading data into Data Warehouse/Data Marts.
  • Strong experience with Star and Snowflake schema, Dimensional Data Modeling, Fact and Dimensional tables, Slowly Changing Dimensions (Type1, Type2 and Type3) and CDC (CDC Change Data Capture).
  • Implemented Data Cleansing, Transformation Scripts, Stored Procedures/Triggers and necessary test plans to ensure the successful execution of the data loading processes.
  • Involved in Performance Fine Tuning of ETL programs. Tuned DataStage and Stored procedures Code.


ETL tools: IBM InfoSphere DataStage, Microsoft SSIS

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer.

Databases: Oracle 10g/9i, Teradata, DB2

Programming: Unix Shell Scripting, SQL, PL/SQL

Other Tools: Control M, TWS (Tivoli Workload Scheduler), ITG, HPSM, Service Now, HP Quality Center, JIRA


Confidential,Tampa, FL

Senior ETL Consultant

  • Analyze and recommend changes to improve efficiency, and enhance quality of business applications.
  • Extensively Involved in reconciliation process and Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
  • Provide code fixes and support for issues raised in the production environment on the existing system.
  • Prepare Technical Specification Documents for the Jobs.
  • Schedule/Monitor Datastage job runs via Autosys.

Environment: IBM InfoSphere Datastage 11.3, HP UNIX, Oracle 11g, Autosys.


Senior Data Integration Consultant

  • Consult with System Analysts, Technical Leads, and Project Managers to establish specifications and estimates on projects of various sizes and efforts.
  • Write detailed descriptions of user needs, system design, program functions, and steps required to modify computer systems and ensure compliance.
  • Design, Develop and implement Data stage jobs to integrate data from external sources to Db2 Tables. Analyze and recommend changes to improve efficiency, and enhance quality of business applications.
  • Work with QA Leads and Business Users to develop and implement acceptance test plan to ensure product meets customer requirements and expectations.
  • Review code quality and drive automation process routines.
  • Schedule/Monitor the runs of datastage jobs via ROBOT Scheduler.

Environment: IBM InfoSphere Data stage 9.1, UNIX, DB2, ROBOT Scheduler, and Tortoise SVN code check-in.


IT - Data Analytics Consultant - Senior

  • Design, Develop and implement the Datastage jobs framework to load data from external source systems to internal data marts in Teradata.
  • Develop data stage reusable components/Jobs to run the same job and pull data from several sources (member/provider/customer repositories).
  • Prepared Technical Specification Documents, Production Review documents for the Jobs.
  • Building SQL's in Teradata Database to fetch as per the business requirement that could be further processed in Datastage.
  • Extensively worked on SCD2 type to capture the change data. Generated DAT files for the medical transactions and SFTP it over to their respective servers.
  • Extensively involved in Fine-tuning the jobs and reducing performance issue.
  • Developed user defined Routines and Transformations for implementing Complex business logic.
  • Support production deployment along with IBM Tivoli Workload Scheduler set up.
  • Provide warranty support until handover period.

Environment: IBM InfoSphere Datastage 9.1/8.7, UNIX, Teradata, IBM Tivoli Workload Scheduler, SVN code check-in


Datastage - ETL Developer

  • Extensively Involved in development phase meetings for and requirements document reviews.
  • Architect and model Data warehouse tables for reporting purpose.
  • Designed and developed Jobs that extract data from the Oracle database, cleanse it, transform it as per business requirement and populate it back into Oracle Database.
  • Developed and produced many outbound reports for Daily basis for every participant based on daily submission of trades.
  • Generated completion messages, status reports using capabilities of Job Control Sequence and UNIX.
  • Prepare Technical Specification Documents for the Jobs.
  • Write the shell scripts (CRON Tab) to automate the jobs in production server.

Environment: IBM InfoSphere Datastage 8.7, HP UNIX, Oracle 11g, PVCS, Secure CRT.

Hire Now