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.