We provide IT Staff Augmentation Services!

Etl/ Datastage Developement Lead Resume

Windsor, ConnecticuT

PROFESSIONAL SUMMARY:

  • 9 years of IT experience in Data Stage, Data Analysis, Dataware house Implementation, Data migration, Data Conversion, SQL, PL/SQL
  • Extensive experience in IBM DataStage 11.3/ 9.1/8.7/8.5/8.0.1/7.5. x using Components like DataS tage Designer, DataS tage Manager, DataStage Director, DataS tage Administrator, DataS tage Console , Information server and Parallel Extender.
  • Experience in data profiling using IBM Information Analyzer.
  • Experience in data cleansing using Quality Stage. knowledge and experience in Data Warehouse Development life cycle.
  • Executed software projects for Insurance, Retail and Healthcare industry.
  • Extensive experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Mart using DataStage 8.5x , 9.1x and 11.3.
  • Involved in developing the project plan for my team applications by analyzing the effort, time and dependencies among applications.
  • Worked on different kinds of DataStage Stages like Xml, Change Capture, MQ stage , Complex Flat File, Dataset, Lookup, Oracle Connector, ODBC Connector, Lookup, Join, Aggregator, Sort, Merge, Filter, Transformer and Funnel.
  • Experience in integration of various data sources like Oracle, DB2 UDB, Teradata, XML and Flat files into the Staging Area.
  • Experience working in onsite and offshore model.
  • Good experience in designing, implementing and performance tuning SQL queries.
  • Expert in Unit testing, System testing, Integration testing, UAT and implementation.
  • Member of Confidential ETL Production Support team of 5 members for 1 year with outstanding client admirations and provided maintenance for around 2500 jobs(v 7.5x,8.1x,9.1x) on 24*7 shift basis.
  • Familiar with Version management tool like SVN.
  • Created and deployed Work orders and resolved problem request tickets on HPSM /Remedy Management tool to track the incident.
  • Used ALM tool to track the Defects.
  • Good knowledge in understanding Customer Business Requirements.
  • Extensive experience in loading high volume data, and performance tuning.
  • Hands - on with database client tools like Oracle PL/SQL developer and TOAD.
  • Received appreciation at organisation level while dealing with most demanding customers.
  • Expertise in utilising Secured Shell Client tool for interacting with UNIX operating system, Citrix Client and VPN for remote server connectivity.
  • Exceptional verbal and written communication skills, excellent team player.
  • Experience working in both Agile and Waterfall model.
  • Worked on migrating all the old jobs from 7.5.2, 8.0.1 to 9.1.2 version.

SKILLS SUMMARY:

Operating Systems: UNIX , Linux, Windows XP, Windows7 , Windows 10.

Databases: Oracle 10g, MS SQL Server, DB2,Teradata .

Tools: MS Power Point, Visio, Word, OneNote, Excel, Share Point, Putty, T OAD, SQL Developer , Connect Direct, Address Standardization and validation

Master Data Management: Standard Edition, Inspector, Rally.

Scheduling: ESP, CA7 Workstation .

Programming Languages: SQL, UNIX .

ETL Tool: IBM InfoSphere DataStage and Quality Stage (version 11.3) IBM Information Analyzer (version 11.3), IBM InfoSphere DataStage and Quality Stage (version 9.1), IBM WebSphere DataStage and QualityStage(Version 8.1), Ascential Datastage(Ver7.5x)(Manager,Administrator,Designer,Director)

Version management Tools: SVN

Bundle/Package Creation & Deployment: Jenkins(Build tool)- to create and upload Packages or Bundles, UDeploy (Deployment tool) - to deploy the Packages or Bundles.

ETL Job Control: Jobs Monitoring, Verify logs, Handling job Parameters/variables, Tables, Delta dates, Records Statistics each stage level. Pull/push Files from different servers using Connect direct method. Job listing, Directory Creation, File Maintenance, File Clean-up, Reset/Restart jobs

PROFESSIONAL EXPERIENCE:

Confidential, Windsor, Connecticut

ETL/ DataStage Developement Lead

Responsibilities:

  • Using ETL Job control, Jenkins, deploy.
  • Involved in analysing business requirements and design documents.
  • Designed and developed jobs using Datastage 9.1x for loading the data into Tables.
  • Performing analytics on the ODS and Registry to determine fallout of a particular SR ticket.
  • Performing data clean-up activities based on SR tickets.
  • Running scheduled maintenance tasks
  • Involved in development of DataStage Jobs with required Transformations like MQ Stages, XML Stages, Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort and Transformer.
  • Developed processes to extract the source data from different sources, integrated and populated the extracts after cleansing, transforms and integrating.
  • Created pattern and data overrides to override the data values that are not handled by the rule sets.
  • Used Complex Queries for data extraction from Source and Staging.
  • Responsible for preparing comprehensive test plans and thorough testing of the system keeping the business users involved in the UAT.
  • Involved in Unit Testing and Integration Testing.
  • Involved in Tuning and Performance Testing.
  • Used Shared Containers for code reuse and implementing complex business logic which increased the productivity of work.
  • Extensively worked on Job sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
  • Involved in fixes for bugs identified during production runs within the existing functional requirements.
  • Creating UNIX scripts in support of ETLs.
  • Involved in preparation of ESP/CA7 scripts to schedule the jobs and ETL Job Controls.
  • Attended daily Scrum meetings.

Environment: IBM InfoSphere DataStage and QualityStage (version 9.1x),MQ Series 7.0.1, Oracle 12c, Teradata, UNIX/Linux.

Confidential, Providence, Rhode Island

Sr. ETL/DataStage Supervisor

Responsibilities:

  • Involved in analysing business requirements and design documents.
  • Attend SCRUM meetings to discuss what was done since the previous meeting, what will be done today and until the next meeting and if there are any blockers.
  • Performed Column Analysis, Primary Key Analysis, Foreign Key Analysis and Cross Domain Analysis using IBM Information Analyzer.
  • Designed and developed jobs using DataStage/Quality Stage 11.3 for loading the data into Dimension and Fact Tables.
  • Provide solution for the Customer Service Requests and ad-hoc cases, requiring application related attention.
  • Developed DataStage jobs using Change Capture Stage to compare the data changes between source tables and DataMart tables.
  • Involved in development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Remove Duplicates, Surrogate Key Generator, Sort and Transformer etc.
  • Extensively involved in developing data cleansing procedures using Quality Stage to standardize names, addresses and area.
  • Created pattern and data overrides to override the data values that are not handled by the rule sets.
  • Created PL/SQL procedures/Packages to implement complex business logic and calculations for loading the Fact Tables.
  • Used Complex Queries for data extraction from Source and Staging.
  • Responsible for preparing comprehensive test plans and thorough testing of the system keeping the business users involved in the UAT.
  • Involved in Unit Testing and Integration Testing.
  • Involved in fixes for bugs identified during production runs within the existing functional requirements.
  • Worked on conversion of all old jobs from SAS to 11.3 version DataStage.

Environment: IBM InfoSphere DataStage and Quality Stage (version 11.3), IBM Information Analyzer (v 11.3), Sql server, Teradata, UNIX/Linux, Flat Files and MSN Reports.

Confidential, Bloomfield, Connecticut

ETL/DataStage

Responsibilities:

  • Using ETL Job control, Jenkins, deploy.
  • Involved in analysing business requirements and design documents.
  • Designed and developed jobs using Datastage 9.1x for loading the data into Dimension and Fact Tables.
  • Worked in an onsite-offshore model and explained the ETL developers on the mapping and business rules.
  • Involved in development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort and Transformer etc.
  • Developed processes to extract the source data from different sources, integrated and populated the extracts after cleansing, transforms and integrating.
  • Used Complex Queries for data extraction from Source and Staging.
  • Involved in Unit Testing and Integration Testing.
  • Involved in Tuning and Performance Testing.
  • Involved in fixes for bugs identified during production runs within the existing functional requirements.
  • Worked on migrating all the old jobs from 7.5.2 to 9.1.2 version plus new development on v9.
  • Involved in preparation of ESP/CA7 scripts to schedule the jobs and ETL Job Controls.
  • Using and giving KT on Jenkins and Udeploy for code migration.

Environment: IBM InfoSphere DataStage and QualityStage (version 9.1x), IBM, Ascential DataStage (Ver7.5x), Oracle 10G, Sql server, IBMDB2, Teradata, UNIX/Linux.

Confidential, Irving, Texas

Software Engineer

Responsibilities:

  • Understanding the existing business model and Translating Business Requirements into ETL jobs.
  • Implemented Extract, Transformation, and Load functionality for Enterprise Data Warehouse and Data Marts using DataStage designer.
  • Performed Complex Transformations of large volumes of Data from multiple Data sources using DataStage Designer.
  • Extensively used the Sequential File stage, Dataset, Filter, Funnel, JOIN, Lookup, Copy, Aggregator, during ETL development.
  • Worked with DataStage Director to Run jobs, Monitor and check log files.
  • Implemented type II slowly changing dimension techniques on changing attributes in different data marts.
  • Worked on different Partitions in DataStage to Optimize DataStage jobs.

Environment: DataStage 7.0, Oracle, UNIX/Linux and MS Windows.

Confidential

Jr Programmer

Responsibilities:

  • Understanding and analyzing project requirement and translating it into specifications and programming deliverables.
  • Testing and debugging the product in controlled, real situations.
  • Maintaining the systems and updating as per requirements.
  • Data Extraction, Transformation and Loading from different Source system.

Hire Now