Centraprise
ETL Developer DataStage (Jersey City)
Centraprise, Jersey City, New Jersey, United States, 07390
Role: ETL Developer DataStage
Location: Jersey City, NJ / Charlotte, NC / Plano, TX (Onsite from Day 1)
Position: Fulltime
Job Description:
Core IBM DataStage ETL (Extract Transform Load) development for data movement, data quality, data cleansing and other ETL-related activities. Communicate with the Business Users and Solution Architects, for converting the ETL design into specific development activities Design, implement, and/or operate comprehensive process models, including sourcing, loading, transformation, and extraction Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow Troubleshoot ETL processes failures or warnings and provide technical support for all ETL related issues as well as Warehouse reports and analysis tools Provide technical expertise & knowledge of ETL solutions for data integration projects and other developers Prepare deployment packages, e.g. deployment documentation, DSX/ID exports Enables team(s)/applications with Continuous Integration/Continuous Development (CI/CD) capabilities and engages with other technical stakeholders pertaining to efficient functioning of CI- CD pipeline Guides and influences team(s) on design and best practices for high code performance e.g. pairing, code reviews Provides end-to-end delivery of complex features, including automation, for either a single team or multiple teams, at the program level Conducts research, design prototyping and other exploration activities such as evaluating new toolsets and components for release management, CI/CD, and features Works with stakeholders to establish high-level solution needs and with architects for technical requirements Experience working with SAP packs, high data volume and skills to do performance tuning in DataStage/Informatica is highly desired.
Job Description:
Core IBM DataStage ETL (Extract Transform Load) development for data movement, data quality, data cleansing and other ETL-related activities. Communicate with the Business Users and Solution Architects, for converting the ETL design into specific development activities Design, implement, and/or operate comprehensive process models, including sourcing, loading, transformation, and extraction Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow Troubleshoot ETL processes failures or warnings and provide technical support for all ETL related issues as well as Warehouse reports and analysis tools Provide technical expertise & knowledge of ETL solutions for data integration projects and other developers Prepare deployment packages, e.g. deployment documentation, DSX/ID exports Enables team(s)/applications with Continuous Integration/Continuous Development (CI/CD) capabilities and engages with other technical stakeholders pertaining to efficient functioning of CI- CD pipeline Guides and influences team(s) on design and best practices for high code performance e.g. pairing, code reviews Provides end-to-end delivery of complex features, including automation, for either a single team or multiple teams, at the program level Conducts research, design prototyping and other exploration activities such as evaluating new toolsets and components for release management, CI/CD, and features Works with stakeholders to establish high-level solution needs and with architects for technical requirements Experience working with SAP packs, high data volume and skills to do performance tuning in DataStage/Informatica is highly desired.