ETL DataStage Developer Resume Syracuse, NY - Hire IT People

SUMMARY

ETL developer with over 10+ years of extensive IT industry experience in the areas of Data Architecture and Integration using IBM Infosphere DataStage.
Involved in completeSoftware Development life cycle of various projects,including Requirements gathering, System Designing,andETL design, development, Production Enhancements, Defect tracking, Support andMaintenance for Equitable Life Insurance Company middleware application.

TECHNICAL SKILLS

Data Integration Tools: IBM Infosphere DataStage 8.1, 8.5, 8.7,11.5,11.7

Programming Languages: UNIX Shell Scripting, SQL, PL/SQL

Databases: Oracle, SQL Server, DB2, Sybase, Snowflake

Scheduler: Stonebranch

Reporting Tools: SQL Server Reporting Services

Other Software/ Technologies: Azure Cloud, Salesforce, XML, JSON, REST API, JAVA

PROFESSIONAL EXPERIENCE

ETL DataStage Developer

Confidential, Syracuse, NY

Responsibilities:

Developed DataStage parallel/server jobs to load data from multiple source applications using IBM Infosphere DataStage 11.5 and 11.7
Experience in creating routines and shared containers
Created UNIX shell scripts for file handling within DataStage
Strong understanding of the principles ofData Warehousingusingfact tables,dimension tablesandstar/snowflake schema modeling
Worked on troubleshooting, performance tuning, performance monitoring and enhancement of DataStage jobs
Performed Unit testing, System integration testing and User acceptance testing
Experience in SQL Server Management Studio and Toad for Oracle for handling SQL queries
Experience in DataStage parallel processing and partitioning methods
Knowledge of Extracting/Loading data into Snowflake data warehouse.
Experience in handling salesforce and XML data in DataStage
Knowledge and experience with Agile methodology & CI/CD process
Experience in SQL Server Reporting Services
Experience in Insurance domain
Experience in ServiceNow Incident Management
Familiar in using Stonebranch Scheduler
Strong knowledge of business and system workflow documentation methods
Experience and working exposure in Cloud environment
Knowledge of Integrating Azure File Storage and Azure BLOB in DataStage
Experience in handling real time data using Kafka, Java Integration stages
Experience working with large scale applications with large amount of data
Knowledge of XML and relational databases (Oracle, SQL Server, DB2, Sybase)
Ability to resolve complex ETL problems by proposing and implementing long - term solutions
Experience in JAVA and REST API
Extensive experience with Hierarchical stage using JSON format
Expert in Data Integration and Metadata Management
Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement
Analyze performance and monitor work with capacity planning
Experience in defining new architectures and ability to drive an independent project from an architectural standpoint
Basic understanding of Python Scripting

ETL DataStage Developer

Confidential

Responsibilities:

Involved as primary ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere DataStage 8.1 and 8.5
Experience in Implementation of ETL systems that are operationally stable, efficient and automated
Handled multiple file formats like COBOL/ASCII and XML/JSON using appropriate stages.
Familiar in using highly scalable parallel processing infrastructure using parallel jobs and multiple node configuration files
DesignedData masking techniquesto mask sensitive information
Experience in SCRUM and KANBAN framework
Extensive Knowledge of Unix/Linux Commands and scripting
Experience performing analytics to solve complex business problems
Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed
Assisted in analysis of source data, technical metadata, file structure and profile data sources
Provided technical assistance and support to IT analysts and business community
Ability to work both independently and with minimal guidance, as well as with a team

We provide IT Staff Augmentation Services!

Etl Datastage Developer Resume

Syracuse, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship