Position: Data stage Architect and Data Stage Lead
Location: Chicago, IL (Day 1 Onsite)
Description:
- Knowledge of IBM Infosphere DataStage ETL is required
- Knowledge on building and supporting ETL Code using Infosphere DataStage to load enterprise data warehouses using relational database (Oracle, DB2, Sybase) applying transformations and business rules as defined in requirements is a MUST.
- 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.
- Knowledge on Apache Kafka
- 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 orientated attitude with a focus on service delivery
Mandatory skills:
- DataStage
- Oracle
- Stored Procedures
Thanks & Regards
Rishu Kayal| Talent Acquisition Specialist
Amaze Systems Inc
USA: 8951 Cypress Waters Blvd, Suite 160, Dallas, TX 75019
Canada: 55 York Street, Suite 401, Toronto, ON M5J 1R7
D: +1 (469) 250-1448
E: [email protected] | www.amaze-systems.com/
USA | Canada | UK | India
Amaze Systems is an Equal Opportunity Employer (EOE), and does not discriminate based on age, gender, religion, disability, marital status, race and also adheres to laws relating to non-discrimination on the basis of national origin and citizenship status.