We provide IT Staff Augmentation Services!

Sr. Datastage Developer Resume

SUMMARY

  • 8 years of Information Technology experience in Datastage 8.5,11.3&11.5 Technology on administration, Production support, design, development, and implementations of robust technology systems, with specialized expertise in Data Warehousing solutions. Able to understand business and technical requirements quickly; Excellent communications skills and work ethics; Able to work independently; Experience working with clients of all sizes in the healthcare, Insurance, Banking, Financial, Retail and manufacturing industries.
  • Worked as Technical Analyst and Senior Software Engineer of business requirements, Design and Development of ETL Applications, Architecture of Data warehouse, Documenting DLD’s Mock data and Test cases.
  • Strong experience in data modelling to translate business rules/requirements into conceptual/logical dimensional model and worked with complex deformalized and normalized data models
  • Thorough understanding of DW principles (Fact Tables, Dimensional Tables, Dimensional Data Modeling - Star Schema and Snow Flake Schema)
  • Expert in Data Warehousing techniques for Data Cleansing
  • Extensive experience in DataStage (ETL) and Data modeler. Technical knowledge using DataStage designer and Director, Developing Ds jobs, Uint testing and production Support.
  • Analysis on Business requirements
  • Discussion with BBIA (Bank Business Intelligence Administration) Team and Business Partners on
  • Business Requirements
  • Analysis on business developed and supported UDA’s (User Defined Applications) under each work stream in its current state
  • Analysis and Documentation of Trusted Data Sources
  • Agile: Modeling in Strategic Foundation and Information Data Layers
  • Development of ETL Components for Data Enrichment in Foundation data layer thatBODDH- Bank Operation Data Distribution HubHadoop- Big Data Strategic Data Infrastructure
  • Development of ETL Components for Data Enrichment in Information Data Layers that Include:GPM- Bank General Purpose Data MartSAM- Bank Subject Area Data Mart
  • Engage in Data Validation with BBIA SME and receive approval for implementation of developed infrastructure components.
  • Deployment and Maintenance of developed Data Infrastructure ETL and DB Components
  • Development/Enhancement of Tableau Reports that facilitate for exposure of Data from Strategic
  • Data Infrastructure layers
  • Work with BBIA partners to enable them in accessing Strategic Data Infrastructure layers and thereby eliminate need for maintenance of the UDA’s.
  • Documentation Delivery (Wiki and other project documentation)
  • Work on enhancement projects and monitor all data stage jobs and provide production support
  • DocuSign Envelope ID: C2286987-63C1-41A0-A8D8-2CE95A82B4B1
  • Lead and coordinate the work of an offshore data integration development team in India, including daily offshore sync calls with that team
  • Create and maintain adequate project and support documentation
  • Periodically review and enhance design and development standards and practices as needed in collaboration with ETL team
  • Strong understanding of data warehousing concepts, Schemas, Slowly Changing Dimensions,
  • Facts and Dimensions, and implementation of the same.
  • Develop and support Control M scripts and jobs to support projects and DW loads
  • Ability to balance multiple projects and work both independently and as part of a team
  • Facilitates root cause analysis of system issues to minimize impact and future occurrences
  • Migration from Data Mart On-Site Premises to cloud-based Data Marts (Snowflake Cloud
  • Computing)

TECHNICAL SKILLS

Languages: Java, python, C, C++, XML, PL/SQL, HTML.

File Systems: Main Frame Files, CSV, CFF

RDBMS: Oracle, DB2, SQL Server, Teradata, Netezza.

ETL Technologies: DataStage 8.5,11.3,11.5

Operating Systems: Ms-Dos, Microsoft Windows 98/2000/XP,MS XL, Unix

Data modeling: Erwin (CA), Data modeler

BI & Reporting Tools: Tableau, Qlik View, Qlik Sense

RPA Tools: Automation Anywhere

Other tools: Toad, Azure, SQL Developer, Putty, WINSCP, Service now, JIRA

PROFESSIONAL EXPERIENCE

Confidential

Sr. Datastage Developer

Responsibilities:

  • Analysis on Business Requirements.
  • Discussion with BBIA and Business Partners on Business Requirements.
  • Analysis on business developed and supported UDA s (User Defined Applications) under each work stream in its current state.
  • Analysis and Documentation of Trusted Data Sources.
  • Agile: Modeling in Strategic Foundation and Information Data Layers.
  • Development of ETL Components for Data Enrichment in Foundation Data Layer that include

Technologies/Platform Used: ETL DataStage, Netezza, UNIX, SAS, Tableau, Control M and Jira Agile Tool.

Confidential

Sr. ETL/ DataStage Developer

Responsibilities:

  • Analyzing and understanding business requirements.
  • Developing design documents for each project Specific.
  • Deploying and testing the project into various UNIX test regions.
  • Working on the production issues.
  • Design and development of ETL Applications.
  • Developed test cases to test the developed rules.
  • Understanding and writing the Performance testing scenario documents.
  • Independent Unit Testing of the DataStage processes.
  • Estimation and effort tracking to aid the management of the application.
  • Data analysis to provide insights to business for further decision making.
  • Involved in Design/Code reviews.
  • Preparing unit test cases and mock data.
  • Working on bot inbound and outbound process.
  • Created and implemented ER models and dimensional models (star schemas)
  • Generated SQL scripts
  • Assisted DBA’s in the development of physical database
  • Assisted Data modeler Architect’s in the development of physical database and understanding the logical database.
  • Participated in requirement gathering session with business users and sponsors to understand and document the business requirements.
  • Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Developed a Conceptual model using Erwin and Visio based on requirements analysis.
  • Responsible for designing the data Architecture, designing Conceptual, logical and Physical data models and maintaining the data Dictionary as for the Standards.
  • Designed Source to Target mapping document with transformation rules, physical naming standards, datatypes and domain definitions for ETL team.
  • Code and test highly complex ETL processing the support of data warehouses and/ or operational data stores.
  • Determine the appropriate code for ETL applications based on information gathered including data sources, data targets, data definitions, data relationships, and business rules.
  • Work closely with project management, analysts, data modelers and the existing ETL design and developers to understand project requirements and contribute to the project solution.
  • Provide technical expertise on ETL design, Data modeling, Data Warehousing, and Data integration
  • Partner with Business Intelligence and business operational teams to understand data sources and implement new requirements.
  • Analyze and summarize data to facilitate Business Intelligent decisions.
  • Supporting the system and integration testing to ensure the correct functionality of the system and its interfaces with various test scenarios and review of Test Cases and Test Results.
  • Identify, track defects and analyze root cause of defects and provide maintenance and enhancement support for the deliverables that are being done.
  • Coordinating with Business Analysts and users to understand the new proposals and their impact on the existing systems if any.
  • Evaluate business requirements, perform gap analysis and identify the design alternatives and finalize the approach for the implementation.
  • Analyzing the existing system if any to find out the reusable components, dependencies and document the same

Tools: & Technology: DataStage 11.5, Teradata, UNIX, Control-M, CA Erwin Data Modeler, RTC, WInSCP, Servicenow

Confidential

Sr. ETL/ DataStage Developer

Responsibilities:

  • Gathering and analyzing business requirements.
  • Developed the DataStage jobs using DataStage designer.
  • Design and development of ETL Applications.
  • Independent Unit Testing of the DataStage processes.
  • Estimation and effort tracking to aid the management of the application.
  • Data analysis to provide insights to business for further decision making.
  • Involved in Design/Code reviews.
  • Performed the design and code reviews.
  • Determine the appropriate code for ETL applications based on information gathered including data sources, data targets, data definitions, data relationships, and business rules.
  • Work closely with project management, analysts, data modelers and the existing ETL design and developers to understand project requirements and contribute to the project solution.
  • Provide technical expertise on ETL design, Data modeling, Data Warehousing, and Data integration
  • Partner with Business Intelligence and business operational teams to understand data sources and implement new requirements.
  • Analyze and summarize data to facilitate Business Intelligent decisions.
  • Worked with DataStage manager for importing the metadata for database source.
  • Design and review of the DataStage Jobs and routines which are created sequential files sourcesandtargets.
  • Designed, developed and deployed DataStage jobs using various stages like Join, Transformer, Lookup, Aggregator, Funnel, Modify, Filter, Change Data Capture, Change Apply, Remove Duplicate, Sort, Surrogate Key stages etc.
  • Supporting the system and integration testing to ensure the correct functionality of the system and its interfaces with various test scenarios and review of Test Cases and Test Results.
  • Identify, track defects and analyze root cause of defects and provide maintenance and enhancement support for the deliverables that are being done.
  • Preparation of implementation plan and all the relevant supporting documents.
  • Migration of jobs from Development to QA and to Production Environments.

Tools: & Technology: DataStage 11.3, DB2, Oracle, UNIX, Autosys, Flat files, CA Erwin Data Modeler, RTC, WInSCP, Servicenow, JCL, Mainframe Files

Confidential, Parsippany, NJ

ETL/ DataStage Developer

Responsibilities:

  • Providing support to L2 team, Handling the new requirements and code fixes
  • Understanding the Functional Specifications.
  • Analyze Mapping Documents and Design Specifications.
  • Coordinating with the client to ensure product compliance
  • Developing solutions for Complex Problems using the stages like Lookup, Join, Transformer, Sort, Aggregator, Sequential file, funnel and filter for developing jobs
  • Understands the Complex processes and implemented the logic in DataStage jobs
  • Created Extract and Load jobs for transforming and loading the data.
  • Designed the jobs according to the business requirements.
  • Involved in keeping track of Error Handling for rejected records
  • Involved in Unit Testing, Integration Testing
  • Understanding and writing the Performance testing scenario documents.
  • Independent Unit Testing of the DataStage processes.
  • Estimation and effort tracking to aid the management of the application.
  • Data analysis to provide insights to business for further decision making.
  • Involved in Design/Code reviews.
  • Preparing unit test cases and mock data.
  • Working on bot inbound and outbound process.
  • Created and implemented ER models and dimensional models (star schemas) Generated SQL scripts
  • Supporting the system and integration testing to ensure the correct functionality of the system and its interfaces with various test scenarios and review of Test Cases and Test Results.
  • Identify, track defects and analyze root cause of defects and provide maintenance and enhancement support for the deliverables that are being done.
  • Designed, developed and deployed DataStage jobs using various stages like Join, Transformer, Lookup, Aggregator, Funnel, Modify, Filter, Change Data Capture, Change Apply, Remove Duplicate, Sort, Surrogate Key stages etc.
  • Preparation of implementation plan and all the relevant supporting documents.
  • Migration of jobs from Development to QA and to Production Environments.

Tools: & Technology: DataStage 8.5, Oracle, SQL Server, Flatfiles, CA Erwin Data Modeler, RTC, WInSCP, Servicenow

Hire Now