We provide IT Staff Augmentation Services!

Senior Etl (talend / Ab Initio) Consultant Resume

Deerfield, IL

SUMMARY

  • 14 Years of IT Experience in data integration, data analysis, data migration and end to end ETL implementation of Data Warehousing Applications
  • 10+ years of strong experience in InfoSphere IBM DataStage 11.5/9.1/8.5/7.5 (Parallel Extender & Server and Quality Stage)
  • 10+ years of experience in Unix Shell Scripting and 5+ of PL/SQL development
  • 10+ years of experience of Data Warehouse Design, Development, Testing, Deployment and production support.
  • 13+ years of expertise in writing complex SQL queries, performance tuning and worked on different databases (Oracle, DB2, SQL Server, Teradata and Netezza)
  • 4+ years of experience Netezza and 2+ in Oracle Exadata
  • 3+ years in Talend DI/ Data Mapper / Big Data (6.4.1) and 6 months in Ab Initio
  • Working knowledge of Bigdata, Hadoop and Hive, AWS and 1 year of experience working on it.
  • Writing simple to complex Source to mappings and implementing them with the help of various ETL tools like DataStage, Talend and Ab Initio.
  • Worked on Regulatory reporting applications (Basel II, Basel III, CCAR and Liquidity reporting) for Confidential and Confidential
  • Working Knowledge of R, Spark, Python and Machine Learning
  • Defined and Implemented ITIL Best Practices for Production Support Projects in Incident, Problem and Change Management
  • Logical/Physical Data Modeling and Data Warehouse Design & implementation
  • Bridging the gap between business and technology and End to End Implementation of Business Requests
  • ETL Process automation using Shell scripting and Control M
  • Worked on PL/SQL procedures, functions and packages, NZSQL procedures, TSQL procedures
  • Lead onshore/off shore development/support team in Deutsche and Confidential regulatory reporting projects
  • Lead IT repatriation Program for Confidential from Planning to successful Implementation

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere DataStage v 11.5/9.1/8.5/7.5, Talend 6.4.1, Ab Initio

Programming: SQL, PL/SQL, Unix shell scripting, NZPLSQL, T - SQL

Testing Tools: iCEDQ

RDBMS/Utilities: Oracle Exadata, Netezza 7.2, DB2, Teradata, Oracle SQL Developer, TOAD, Aginity Workbench, IBM MDM, IBM InfoSphere BigInsights

OS: Windows 2000/XP/7, Unix, Linux

Scheduling Tools: Control M, Unix Cron, DBArtos, DataStage Scheduler

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

Senior ETL (Talend / Ab Initio) Consultant

Responsibilities:

  • Working on technical design, development, testing, deployment and Support of ETL processes using Talend
  • Developed complex ETL mappings using the Talend DI, Talend Data Mapper and Talend Big Data tools
  • Handled EBCDIC, XML, CSV files using Talend and Performance tuning of the Talend jobs
  • Data Extraction and Loading using Oracle and AS400 components and its performance tuning
  • Unit Testing and Comparison with Ab Initio by updating and execution of Ab initio Graphs
  • Unix Scripting for Talend jobs and creation of plan for ESP scheduler
  • Documentation of changes and support in QA cycles and production.
  • Working on of TAC and GIT/Stash and Working in AGILE environment.

Environment: Talend DI, Talend Data Mapper, Talend Big Data (6.4.1), Oracle 11g, Oracle PL/SQL Developer, SQL, Unix shell scripting, Ab Initio, Stash, TAC

Confidential, Springfield, MO

Senior ETL Consultant

Responsibilities:

  • Interacted with business to ensure that their business requirements are understood and documented correctly for Marketing Campaign and Cabela’s Merger
  • Working on Data warehouse which is built on Netezza appliance
  • Working on technical design, development, testing, deployment and Support of ETL processes using DataStage and QualityStage(v11.5) and Netezza 7.2 as database
  • Develop different data stage jobs using Netezza connector stage to write data to database
  • Develop different data stage jobs to extract data using Netezza connector stage, Hierarchical XML and SCD stage
  • Develop/ update of existing Netezza procedures and functions as per business requirements
  • Development of Unix shell scripts to automate the ETL process.
  • Analysis, troubleshooting, re-creation and diagnosis of business-critical incidents along with RCA
  • Created Talend DI ETL jobs for Marketing Module

Environment: IBM InfoSphere DataStage and QualityStage(v11.5), Netezza 7.2, Aginity Workbench, SQL, Unix shell scripting, Talend DI 6.3, IBM MDM

Confidential, Stamford, CT

Senior ETL Data Analyst

Responsibilities:

  • Interacted with client operations to ensure that their data requirements are understood
  • Worked on the development of Talend and DataStage during the migration
  • Used Validation, Checksum, Reconciliation techniques in testing source(Netezza) and targets (Red Shift)
  • Ensuring that data is successfully migrated to new database by different automated methods
  • Responsible for writing detailed SQL queries to analyze current system requirement or create new functionality for development of tool using Hadoop to enhance the performance
  • Creation of procedure and function in PL/SQL and TSQL for new feature for iCEDQ

Environment: Datastage 11.5, Netezza 7.2, Aginity Workbench, Talend DI 6.3, iCEDQ, SQL, PL/SQL, QC, Unix shell scripting, Amazon Redshift, Bigdata, Hadoop

Confidential

Data warehouse SME

Responsibilities:

  • Analysis, troubleshooting, and diagnosis of business-critical incidents along with RCA
  • Shouldering the role of Technical Subject Matter Expertise for regulatory reporting applications
  • Worked in ITIL Environment and instrumental part in setting up standard processes
  • Develop Talend DI jobs to extract data using Netezza connector stage
  • Written Hive queries for data analysis to meet the business requirements.
  • Creating Hive tables and working on them using Hive QL.
  • Importing and exporting data into HDFS and Hive using Talend.
  • Experienced in defining job flows and execution
  • Creating PoCs using Control M, DataStage, Talend for better system performance

Environment: Oracle Exadata, SQL, PL/SQL, Netezza, Aginity Workbench, PL/SQL Developer, Unix shell scripting, DataStage 9.1, Talend DI 6.3, Bigdata, Hadoop, Hive

Confidential

Senior ETL Consultant Specialist

Responsibilities:

  • Technical SME for handling critical issues and business user queries
  • Mainly worked on Data Analysis and how issues are reported by the Business/Sites
  • Analysis, troubleshooting, re-creation and diagnosis of business-critical incidents along with RCA
  • Develop different data stage components like Funnel, Transformer, Sort, join, Lookup, Merge, Filter, Change Capture, Aggregator, Copy, Pivot, Remove Duplicates, Surrogate Key, Dataset and Sequential File etc.
  • Develop different data stage jobs using Netezza connector stage to write data to database
  • Integrated Big Data Components in DataStage and created jobs using DB2, Oracle connector stages
  • Create PL/SQL procedures, functions and packages and trained different teams on Datastage DB2 and PL/SQL

Environment: DataStage v7.5/8.5/9.1, Oracle 9i, Netezza 6.0, DB2, Unix Shell Scripting, Ctrl-M, SQL, PL/SQL, Unix, GSD, ITIL, IBM InfoSphere BigInsights, Hadoop

Confidential

Datastage Specialist

Responsibilities:

  • Worked on technical design, development, testing, deployment and Support of ETL processes using DataStage
  • Design, build plans, resource allocation done for the task and reviews
  • Develop different data stage components like Funnel, Transformer, Sort, join, Lookup, Merge, Filter, Change Capture, Aggregator, Copy, Pivot, Remove Duplicates, Surrogate Key, Dataset and Sequential File etc.
  • For system improvements and change requests, handled team of 7-8 persons
  • Worked on implementation of Business change requests end to end.

Environment: DataStage v7.5, 8.5, Unix Shell Scripting, Ctrl-M, SQL, PL/SQL, Unix Shell, QlikView, DB2, Oracle, Teradata

Confidential

DataStage Developer

Responsibilities:

  • Analyze and design ETL solutions for new requirements and Production issues.
  • Interact with business users and understand the requirements, and analyze and come up with optimal technology solutions to business requirements
  • Design, Develop, & Implement various ETL solutions using DataStage ETL tool
  • Hands on development experience ETL processes to acquire and load data from internal and external sources
  • Conduct technical impact analysis and work estimate for new tasks, system improvements and bug fixes
  • Write high level and low-level design documents, Documents of understanding, Conduct peer code review
  • Liaison between the business team (Business Analysts), Development team & Management.

Environment: IBM InfoSphere DataStage v7.5, Ctrl-M, SQL, PL/SQL, Unix Shell Scripting, DB2, Oracle, Teradata, Unix

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Creation stored packages, procedures, functions and triggers.
  • Design, Development, Testing unit and Integration testing of PL/SQL packages
  • Worked on SQL Loader to load the huge data in database and worked on performance issues while migration
  • Performed source analysis and target analysis, and prepared data mapping and process flow documents.

Environment: SQL, PL/SQL, Oracle 8i/9i, TOAD, PLSQL Developer

Confidential

PL/SQL Developer

Responsibilities:

  • Analysis of the specifications provided by the clients
  • Design, Development, Unit Testing and Integration testing of DB packages, PL/SQL programming.
  • Basic GUI development using Oracle forms 6i and reports 6i
  • Appreciation by Clients on resolving key issues in switch bill and reporting

Environment: SQL, PL/SQL, Oracle 8i/9i, TOAD, PLSQL Developer, Oracle Forms 6i, reports

Hire Now