![Saxon Global](https://media.trabajo.org/img/noimg.jpg)
ETL Developer
2 months ago
Work Location: Prefer local to Chicago (Hybrid work schedule 3 days/week), but open to Remote for the right candidate
Project Overview:
Looking for an experienced DataStage ETL developer responsible for enhancing and supporting data ingest\egress integrations with Risk & Compliance Applications.
Contractors Role:
The role will revolve around the building and supporting of the DataStage ETL(s) as well as working with current application development team to drive superior business value, enhanced customer experience and compliance with NT standards.
Experience Level:
Senior resource: 5+ years
Qualifications:
• Strong in PL/SQL and UNIX shell scripting.
• Experience working with XML transformation and consumption of messages from queues will be a big plus.
• Hands-on improve operational stability via automation, such as autohealing where possible, and raise design changes to Data analyst, SMEs and/or architects, as well as opportunities to application /service managers.
• Work some off hours as demanded by projects, operations, and need of the on-shore team and stakeholders, such as release, testing and/or critical bug resolutions.
• Provide US/EMEA overnight support on critical processes in Financial Risk applications (Murex, Adenza) and/or risk program, such as data feed batch jobs, reports, etc in a follow the sun model, and able to address tickets escalated by L1/L2 teams.
• Expertise with the following skills:
1) Datastage
2) SQL, Oracle Stored Procedures
3) Python
4) Data Analysis
Nice to Haves:
Snowflake and PowerBI knowledge preferred.
Tasks and Responsibilities:
• Work with SME, Business Analyst to build new End-to-End solution, ensuring solutions meet all requirements, including operational SLAs.
• Write and debug complex SQL queries from databases (such as Oracle).
• Work with data analyst in mapping documents and design/build IBM DataStage jobs to the requirements.
• Participate in peer design reviews and provide recommendations.
• Construct DataStage jobs to implement the requirements:
o Extract the data from and to Oracle and other databases, flat files (csv, text, excel)
o Build JSON files using Hierarchical stage
o Perform structural validation
o Data type/allowable values validations and reporting
• Ensure all data mapping, data lineage, functional spec, and any other technical documentation are detailed and up to date.
• Ensure runbooks are fully up-to date and consistently improving the efficiency derived from automation.
• Ensure handover of issues region to region with precise and concise handover daily shift notes.
• Support incidents management during incident lifecycle by resolving service stoppage and remediation activities, as well as any postmortem actions.
• Support management in operational reporting on vendor issues, internal issues, and partner team issues, and respective root causes.
• Responsible for development and maintenance of ETL code using DataStage 11.7.
Required Skills : Word
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Other Project Type
Master Job Title :VMS Access Entry
Branch Code :Chicago
-
ETL Developer
2 months ago
Chicago, United States w3r Consulting Full timeDescription: Hands on experience in Ab Initio ETL Projects, Ab Initio solution design and development. Ab initio experience including GDE, Plans, EME, m-hub and DQE. Strong knowledge and hands-on experience in SQL, Unix shell scripting. Excellent grasp on all Components of Ab Initio - GDE, PSETS, PDL Programming, Meta Programming etc. Good understanding in...
-
ETL Developer- W2
3 months ago
Chicago, United States eTek IT Services, Inc. Full timeJob DescriptionJob DescriptionRole : ETL DeveloperLocation : Chicago ILExperience : 7+years& & & Job DescriptionProject Overview:Looking for an experienced Snowflake developer responsible for enhancing and supporting data ingest\egress integrations with Financial Risk Mart Solution.Contractors Role:The role will revolve around the building and supporting of...
-
ETL Developer- W2
3 months ago
Chicago, United States eTek IT Services, Inc. Full timeJob DescriptionJob DescriptionRole : ETL DeveloperLocation : Chicago ILExperience : 7+years& & & Job DescriptionProject Overview:Looking for an experienced Snowflake developer responsible for enhancing and supporting data ingest\egress integrations with Financial Risk Mart Solution.Contractors Role:The role will revolve around the building and supporting of...
-
ETL Developer
3 months ago
Chicago, United States Saxon Global Full timeWork Location: Prefer local to Chicago (Hybrid work schedule 3 days/week), but open to Remote for the right candidate Project Overview: Looking for an experienced DataStage ETL developer responsible for enhancing and supporting data ingestegress integrations with Risk & Compliance Applications. Contractors Role: The role will revolve around the building...
-
ETL DataStage Developer
1 week ago
Chicago, United States HCL Global Systems Full time+8 years of experience with back end RDBMS and data modeling / database design(Oracle and DB2 preferred) •5+ years of hands on experience in Design, Development & Build activities in IBM Datastage(v8.5 and above) ETL Projects •experience in software development life cycle •experience in DW/BI related technologies and tools - MUST •experience in...
-
ETL Developer- Chicago IL
2 months ago
Chicago, United States Georgia IT Inc Full timePosition- ETL Developer Location- Chicago IL Duration- Contract Rate- DOEDescription: We are looking for someone strong in SQL, Datawarehouse, ETL, and be local to Chicago. Strong Data warehouse concepts - Hands on experience working in a datawarehouse environment Strong Complex SQL - analyzing data sets & etc, data flow diagrams, ETL (python framework -...
-
ETL Developer
2 weeks ago
Chicago, United States Wipro Full timeETL DeveloperChicago, IL (Onsite 3 days/week)Full-timeJob Description:Minimum of 5+ years with Informatica Power Center 10.x and IDMC designing, developing, testing, and debugging.Minimum of 5+ years of development experience in Oracle, Oracle Exadata, SQL Server, or another industry accepted database platform.Minimum of 3+ years in Data Warehouse / Data...
-
Informatica Cloud ETL Developer with Snowflake
2 weeks ago
Chicago, United States Pegasus Knowledge Solutions, Inc. Full timeTitle: Informatica Cloud Developer with SnowflakeLocation: Prefer Chicago, IL (2 days onsite in downtown Chicago) or RemoteDuration: Until the end of the year.Required : Informatica PowerCenter and Informatica Cloud for ETL DevelopmentSnowflake database.Scope:Seeking a hands-on developer. This position requires expertise in Informatica ETL Development and...
-
Informatica Cloud ETL Developer with Snowflake
2 weeks ago
Chicago, United States Pegasus Knowledge Solutions, Inc. Full timeTitle: Informatica Cloud Developer with SnowflakeLocation: Prefer Chicago, IL (2 days onsite in downtown Chicago) or RemoteDuration: Until the end of the year.Required : Informatica PowerCenter and Informatica Cloud for ETL DevelopmentSnowflake database.Scope:Seeking a hands-on developer. This position requires expertise in Informatica ETL Development and...
-
ETL developer
3 weeks ago
Chicago, United States Diverse Lynx Full timeExperience with Database testing or knowledge about ETL jobsExperience with GitHub and Azure Test PlansExperience with Python ? This is required to use the internal NT ATR RCON frameworkExperience with Java Selenium ? This skill is required to map the resources for long term Digital : Microsoft Azure, IBM InfoSphere DataStage, Selenium Diverse Lynx LLC is...
-
ETL Informatica Developer
2 weeks ago
Chicago, United States Oreva Technologies, Inc. Full timeJob Title: Informatica ETL DesignerLocation: Hybrid role in Chicago, ILRequired Skills:Minimum 7 years of experienceExpert in Informatica PowerCenter and Cloud for ETL development, data warehousing and ETL theoryExpert in Snowflake databaseData architecture experience: familiar with relational and dimensional data model, able to design solution based on...
-
Ab Initio ETL Specialist
1 week ago
Chicago, Illinois, United States w3r Consulting Full timePosition OverviewWe are seeking a proficient ETL Developer with extensive experience in Ab Initio technologies. The ideal candidate will be responsible for designing and implementing robust ETL solutions that meet business requirements.Key ResponsibilitiesETL Development: Engage in hands-on development of ETL processes using Ab Initio, including GDE, Plans,...
-
Associate Informatica
2 months ago
Chicago, United States BlueCloud Full timeWe are looking for a candidate to provide Informatica PowerCenter development and production support, 2 years of Informatica Center experience Nice to have: Data Quality (IDQ), IICS,Control M, SSMS expertise to design and build the required Solutions for our Clients. Responsibilities Independently plans, designs, develop, executes and monitor complex data...
-
Sr. ETL/Data Engineer
2 months ago
Chicago, United States Saxon Global Full timeCIBC BankChicago IL (hybrid onsite, 2-days per week) Sr ETL/Data Engineer (Talend/SQL) What You'll Be Doing By joining company's Capital Markets Enterprise Solutions Group, you'll be at the heart of a team bringing innovative technology to life as part of our digital transformation. As a Senior Data Engineer/ETL Developer, you'll contribute to the technical...
-
Sr. ETL/Data Engineer
1 week ago
Chicago, United States Saxon Global Full timeCIBC BankChicago IL (hybrid onsite, 2-days per week) Sr ETL/Data Engineer (Talend/SQL) What You'll Be Doing By joining company's Capital Markets Enterprise Solutions Group, you'll be at the heart of a team bringing innovative technology to life as part of our digital transformation. As a Senior Data Engineer/ETL Developer, you'll contribute to the technical...
-
Business Analyst
1 month ago
Chicago, United States Vanator RPO Full timeVanator is a one-stop solution to Recruitment, Virtual Administrative and Digital process outsourcing, known to be a backbone of this industry.Collaborate with ETL Developers to design and implement ETL processes using tools such as Informatica, IBM DataStage, Talend, SSIS, or similar tools.Proven experience as a Business Analyst with a focus on ETL...
-
DataStage Developer
1 week ago
Chicago, United States Syntricate Technologies Full timeRequired Skills: Datastage lead and senior developers should have very good experience in Datastage, PL/SQL and Unix Demostrable experience as a Datastage developer Experience in ETL tools such as Informatica, Oracle ETL Knowledge of data modeling, database design and the warehousing ecosystem. Testing and troubleshooting problems in ETL system...
-
Datastage Developer
2 weeks ago
Chicago, United States Lorven Technologies Inc. Full timeRole: Datastage DeveloperLocation: CHICAGO IL (Onsite)JD: Technology : Datastage ETL, SQL, GCP, PySpark, BigQueryUnderstand requirements from business in terms of Data Mapping and convert the data mapping into technical solutions.Extract the data from Source systems using SQL, Transform using Datastage ETL Tool as per business provided Mapping and get it...
-
Datastage Developer
2 weeks ago
Chicago, United States Lorven Technologies Inc. Full timeRole: Datastage DeveloperLocation: CHICAGO IL (Onsite)JD: Technology : Datastage ETL, SQL, GCP, PySpark, BigQueryUnderstand requirements from business in terms of Data Mapping and convert the data mapping into technical solutions.Extract the data from Source systems using SQL, Transform using Datastage ETL Tool as per business provided Mapping and get it...
-
DataStage Lead Developer
4 weeks ago
Chicago, United States Calabitek Full timeJob DescriptionJob DescriptionJob Title: DataStage Lead DeveloperLocation: Chicago, IL (Need Local Profiles)Duration: 12+ MonthsSkills:Datastage lead and senior developers should have very good experience in Datastage, PL/SQL and Unix Demonstrable experience as a Datastage developer Experience in ETL tools such as Informatica, Oracle ETL Knowledge of data...