Home

ETL DataStage Lead Developer OR Architect || Chicago, IL (Hybrid/ Onsite) || Long Term Contract at Chicago, Illinois, USA

Email: [email protected]

Only Local / Near to Chicago, IL || under 50 miles radius. Please mention Visa status and Current location while sharing resume Last rate $70/hr on C2C for Lead, $75/hr on C2C for Architect Job Title- ETL DataStage Lead Developer OR Architect Location: Chicago, IL (Hybrid/ Onsite) Type: : Long Term Contract Job 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 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) Knowledge of oracle SQL and PL/SQL (cursors, triggers, packages, stored procedures) Must have extensive Knowledge of Unix/Linux Commands and shell scripting Mandatory Skill DataStage Oracle Stored Procedures Your sincerely , Ajay Sharma | Sr. Technical Recruiter. Net 2Source Inc. Fax: (201) 221-8131 | Email: [email protected] Global HQ Address: 270 Davidson Ave, Suite 704, Somerset, NJ 08873, USA Web: www.net2source.com | Social: Facebook | Twitter | LinkedIn -- Keywords: message queue information technology procedural language Illinois New Jersey ETL DataStage Lead Developer OR Architect || Chicago, IL (Hybrid/ Onsite) || Long Term Contract [email protected]

[email protected] View all

Tue Aug 06 02:04:00 UTC 2024

To remove this job post send "job_kill 1630098" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.




Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 1

Location: ,