| ETL Datastage developer at Jersey City, NJ at Jersey City, New Jersey, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=514727&uid= From: Harsh Goyal, Tek inspirations [email protected] Reply to: [email protected] Job Description - Job Title: ETL Datastage developer Location: Hybrid, Jersey City, NJ need local Must have at least 2 Projects with Banking client **** Communication:*** Strong communication skills to collaborate with cross-functional teams and explain technical concepts to non-technical stakeholders. Job Responsibilities: Data Extraction, Transformation, and Loading (ETL): Design and develop ETL processes using Datastage to extract data from various source systems, transform it according to business rules, and load it into the target database or data warehouse. Data Mapping and Integration: Create data mappings between source and target systems, ensuring data consistency, accuracy, and integrity during the transformation and loading phases. Data Quality: Implement data quality checks and validation routines to ensure the reliability of the data being moved and processed through the ETL pipeline. Performance Optimization: Optimize ETL processes for performance, efficiency, and scalability. Monitor and enhance the performance of ETL jobs to meet processing time and data volume requirements. Error Handling and Debugging: Implement error handling mechanisms to identify and handle exceptions during the ETL process. Debug and troubleshoot issues to ensure smooth data flow. Documentation: Create technical documentation for ETL processes, data mappings, transformations, and workflows to ensure clarity and maintainability. Collaboration: Work closely with data analysts, business analysts, database administrators, and other team members to understand data requirements and translate them into effective ETL solutions. Technical Skills: Datastage: Proficiency in using IBM Datastage for designing and developing ETL processes. SQL: Strong SQL skills for data querying, manipulation, and transformation tasks. Data Warehousing Concepts: Understanding of data warehousing concepts, dimensional modeling, and ETL best practices. Database Skills: Familiarity with relational databases such as Oracle, SQL Server, or DB2. Scripting Languages: Knowledge of scripting languages like Shell scripting or Python for automation and data manipulation. Data Transformation: Experience in data transformation using tools within Datastage, such as Transformer stages. Performance Tuning: Ability to optimize ETL processes for performance, including indexing, partitioning, and parallel processing. Version Control: Proficiency in using version control tools for managing ETL code changes. Debugging Tools: Familiarity with debugging tools to identify and resolve issues in ETL jobs. Data Quality Tools: Understanding of data quality tools and techniques to ensure data accuracy and consistency. ETL Design Patterns: Knowledge of ETL design patterns and best practices for efficient data movement. Data Integration: Experience in integrating data from various sources, including APIs and external systems. Additional Info - undefined Keywords: information technology New Jersey http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=514727&uid= |
| [email protected] View All |
| 06:19 PM 11-Aug-23 |