| ETL Developer : 333 S Wabash Ave, Chicago, IL : LOCAL ONLY at Wabash, Indiana, USA |
| Email: [email protected] |
| From: vivek paliwal, kpg99 [email protected] Reply to: [email protected] Mention visa and location Local to IL Role : ETL Developer Location : 333 S Wabash Ave, Chicago, IL 60604, United States Duration : Long term Visa : No h1 Job Description: Must be local to Chicago My call with the hiring manager is on Friday at 1/5 at 12:30 pm CST Major Duties: 1. Ensure near-zero downtime with monitoring and alerting, self-healing automation, and continuous improvement 2. Leads troubleshooting, analysis, and solution of unexpected systems behaviors that impact the quality of service 3. Provide a proactive approach to our clients workloads, anticipating failures, automating tasks, ensuring availability, and providing a great customer experience 4. Communicate issue/resolution status (written and verbal) to project team and management 5. Work with senior staff and management on service delivery improvements 6. Partner with the development team, business support and end users to support and implement end to end solutions. 7. Use the IBM DataStage and PL/SQL to create or modify scripts and programs. 8. Constantly look for better ways of solving technical problems and designing the solution by not being afraid of challenging the status quo. 9. Support existing software systems and platforms and hook in applications to applicable data sources 10. Create and maintain Disaster Recovery plans and participate in DR Testing and Infra patching. Knowledge/Skills: Extensive knowledge of IBM Infosphere DataStage ETL is required Extensive knowledge on building and supporting ETL Code using Infosphere DataStage to load enterprise data warehouses using relational databases (Oracle, DB2, Sybase) applying transformations and business rules as defined in requirements is a MUST. Extensive Knowledge of oracle SQL and PL/SQL (cursors, triggers, packages, stored procedures) Knowledge in integrating data from multiple sources- MQ, Solace, XML, Excel files, unstructured data and loading them into staging/warehouse tables Understanding of dimensional data modeling - star schema and snowflake schema Extensive experience in creating jobs, routines and sequences to create end to end ETL framework in DataStage Experienced in maintaining DataStage code version using Github/Microsoft Azure Knowledge of code migration and production deployment using automated migration process Experienced in performance tuning DataStage ETL processes using appropriate data partitioning algorithms Must have extensive Knowledge of Unix/Linux Commands and shell scripting Knowledge on scheduling tools like Control-M. Knowledge on Azure DevOps and Agile methodology. Nice to have some knowledge on Service now and ITSM concepts. Understanding of enterprise architecture patterns and best practices Excellent oral and written communication skills are required Analytical and problem solving skills A positive goal oriented attitude with a focus on service delivery Experience Required: A College or University degree in Computer Science and/or relevant 6-8 years proven work experience. Related Industry qualification is preferred. Keywords: message queue procedural language Illinois |
| [email protected] View all |
| Fri Jan 05 04:04:00 UTC 2024 |