SUMMARY

• 14 Years of IT Experience in data integration, data analysis, data migration, data ingestion and end to end ETL implementation of Data Warehousing Applications using ETL tools like Talend, DataStage and Ab Initio
• 10+ years of extensive experience in Data Warehouse project life cycle and worked in Requirement gathering, Design, Development, Testing, Deployment and production support stages
• 10+ years of strong experience in InfoSphere IBM DataStage 11.5/9.1/8.5/7.5 (Parallel Extender & Server and Quality Stage)
• 3+ years in Talend Data Integration / Big Data Integration / Apache Spark (v6.4.1) for high volume processing
• 10+ years of experience in Unix Shell Scripting and 5+ of PL/SQL development
• 2+ years in Hadoop, HDFS, Hive, Sqoop for processing huge volumes of data
• Expertise in writing complex SQL queries, performance tuning and worked on different databases (Oracle, DB2, SQL Server, Teradata and Netezza)
• 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

RDBMS/Utilities: Oracle Exadata, Netezza 7.2, DB2, Teradata, Oracle SQL Developer, TOAD, Aginity Workbench, JIRA

OS, Platforms: Windows 2000/XP/7, Unix, Linux, CDH, IBM InfoSphere BigInsights

Scheduling Tools: Control M, ESP, Unix Crontab, DBArtos, DataStage Scheduler

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

Senior ETL

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 AS400 and Netezza components
• 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
• Performed high volume processing on Hadoop Distributed File System (HDFS)
• 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, JIRA

Confidential, Springfield, MO

Senior ETL Consultant

Responsibilities:

• 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

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

Responsibilities:

• Analysis, troubleshooting, and diagnosis of business-critical incidents along with RCA
• Shouldering the role of Technical Subject Matter Expertise for regulatory reporting applications
• Oracle Exadata, PL/SQL design/ development for regulator reporting
• 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, Sqoop

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