ETL Developer/Data architect

4 weeks ago

Chicago, United States SPECTRAFORCE Full time

Title: ETL Engineer/Data Architect

Work Location: Chicago, IL

Duration: 12 Months


Project Overview:

Project and related application development are part the bank's providing management and regulatory reporting functionality in the areas of risk and compliance. Operational Risk Reporting application is beginning development and two Credit Risk application projects are nearing design phase.


Contractor's Role:

This position will work closely with these projects and follow-on risk application development participating in full project life cycle. The candidate would have the opportunity to be involved in the design and development of many aspects of the Corporate Risk Data Warehouse utilizing Oracle sql and pl/sql, data warehouse / ETL tools and Unix Scripts. In addition to design and development, this candidate is expected to be a lead technical resource for this division helping to set standards and practices for production support and maintenance of technical disciplines such as these that are new to this department. Ideally this candidate will also have previous well rounded experience with business application development as well as recent solid concentration on data warehouses, ETL processing and business intelligence tools. The data warehouse ETL processes will interface with numerous Northern Trust corporate transaction systems to gather information for the warehouse.


Qualifications:

> Experienced both in the specific business domain and the software engineering domain. These candidates are not only technology intensive but also possess experience of the specific business area.

> Have worked on similar projects and have a proven history of delivering high impact business solutions in the specific business area. Responsible for the technical vision, high-level architecture, design, and implementation of complex systems and applications.

> Ability to interact and communicate effectively with senior level business teams to ensure optimal results.

> Aside from the business specific knowledge, the individuals will also possess a complete understanding and mastery of the enterprise software development lifecycle.


Tasks & Responsibilities:

Specifically, this candidate should be able to perform in the following activities:

1. Strong in SQL and Data warehouse concepts – Hands on experience working in a datawarehouse environment

a. Write complex SQLs to analyze/profile datasets and identify patterns

b. Recommend solutions based on data analysis

c. Demonstrate strong analytical and problem solving skills and be quick to identify design related concerns


2. Provide Data Requirements

a. Collaborate with Subject Matter experts and Business partners in gathering data requirements

b. Work independently and demonstrate strong understanding of existing Datamodel and ETL processes

c. Experience providing data flow diagram, table structure and ETL specifications including transformation rules required for source to target mapping

d. Identify ETL dependencies and help orchestrate a sequence of data loads in the ETL pipeline

e. Demonstrate good communication and presentation skills with the ability to articulate data requirements, design concerns, etc.

f. Demonstrate strong negotiation skills while working with developers, architects to solution the data needs.


3. Validate the accuracy, integrity and quality of Data developed


4. Support defects triage

a. Participate in the SIT, UAT defects triage and help set up a defect resolution path

b. Assess defects on their impacts and help set up priorities


5. Guide the production support team on unforeseen issues, ETL abends

  • ETL Architect

    6 days ago

    Chicago, United States DCM INFOTECH LIMITED Full time

    Title : ETL Architect Location : Schaumberg, IL Start Date : ASAP FTE Only (DCM employee) Job Description: Minimum of 12 years of experience with Informatica ETL, Database technologies Design, develop, test, and implement ETL processes using Informatica PowerCenter to extract, transform, and load data from various sources into data warehouses or target...

  • Ab Initio ETL developer

    21 hours ago

    Chicago, United States Deltaclass Technology Solutions Limited Full time

    Ab Initio ETL developerLocation: Chicago, IL Type: OnsiteDesign, develop, and implement ETL solutions using Ab Initio technologies to meet business requirements and ensure data integrity.Collaborate with business analysts, data architects, and other stakeholders to understand data requirements and translate them into technical specifications.Develop and...

  • ETL Informatica IICS Developer

    7 days ago

    Chicago, United States Diverse Lynx Full time

    Job Title: ETL Informatica IICS Developer Location: Chicago, IL/REMOTE Position Type: Full Time role 8 - 10 years of experience Job Function TECHNOLOGY Desired Skills Informatica | Unix Shell Scripting Job Description: Skill: ETL informatica IICS • Hands-on exp with Informatica 9.6 and above • 2 plus years of hands-on exp with cloud ETL (pre with IICS)...

  • Data Warehouse Architect

    2 weeks ago

    Chicago, United States Avance Consulting Full time

    Job DescriptionJob DescriptionWe need a Senior DW Architect who can guide the impact analysis and the solutioningRelevant Experience: 11-12 yearsWe are looking for a solid Data Warehouse architect with the following experience:-1) Experience with Star Schema dimensional modeling2) Experience with Data Warehouse ETL Architecture3) Experience with Semantic...

  • ETL Developer

    1 week ago

    Chicago, United States Hirewell Full time

    Senior ETL Developer Job DescriptionWe are seeking an experienced Senior ETL Developer to design, implement, and optimize ETL processes for multiple data sources using SQL, SSIS, or similar ETL tools. The ideal candidate will have strong communication, analytical, and problem-solving skills to ensure successful project outcomes within specified timelines.Key...

  • ETL Developer

    1 week ago

    Chicago, United States Hirewell Full time

    Senior ETL Developer Job DescriptionWe are seeking an experienced Senior ETL Developer to design, implement, and optimize ETL processes for multiple data sources using SQL, SSIS, or similar ETL tools. The ideal candidate will have strong communication, analytical, and problem-solving skills to ensure successful project outcomes within specified timelines.Key...

  • ETL Developer

    6 days ago

    Chicago, United States Hirewell Full time

    Senior ETL Developer Job Description We are seeking an experienced Senior ETL Developer to design, implement, and optimize ETL processes for multiple data sources using SQL, SSIS, or similar ETL tools. The ideal candidate will have strong communication, analytical, and problem-solving skills to ensure successful project outcomes within specified timelines....

  • ETL Developer

    1 week ago

    Chicago, United States Hirewell Full time

    Senior ETL Developer Job DescriptionWe are seeking an experienced Senior ETL Developer to design, implement, and optimize ETL processes for multiple data sources using SQL, SSIS, or similar ETL tools. The ideal candidate will have strong communication, analytical, and problem-solving skills to ensure successful project outcomes within specified timelines.Key...

  • Sr . ETL Informatica IICS developer

    7 days ago

    Chicago, United States Diverse Lynx Full time

    Role: Sr . ETL Informatica IICS developer Location: Chicago, IL (Remote) Duration: Full-time(No C2C/C2H) JD Job Description Skill: ETL informatica IICS • Hands-on exp with Informatica 9.6 and above • 2 plus years of hands-on exp with cloud ETL (pre with IICS) • Hands-on exp in unix commend and scripting • Develop data pipelines to ingest...

  • Data Architect

    1 month ago

    Chicago, United States TD Synnex - SHI for Chicago Public Schools (Central Office) Full time

    Chicago Public Schools (CPS) is one of the largest school districts in the United States, serving over 320,000 students in 600+ schools and employing approximately 40,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, in every school and every neighborhood, has access to a world-class learning experience that...

  • Snowflake ETL Developer

    4 days ago

    Chicago, United States Daltics Full time

    We are seeking an experienced ETL Developer with a strong background in Snowflake and IBM DataStage to join our dynamic team. The ideal candidate will have proven expertise in designing and implementing end-to-end solutions, writing and debugging complex SQL queries, and constructing DataStage jobs. If you are a detail-oriented professional with a passion...

  • Snowflake ETL Developer

    4 days ago

    Chicago, United States Daltics Full time

    We are seeking an experienced ETL Developer with a strong background in Snowflake and IBM DataStage to join our dynamic team. The ideal candidate will have proven expertise in designing and implementing end-to-end solutions, writing and debugging complex SQL queries, and constructing DataStage jobs. If you are a detail-oriented professional with a passion...

  • Snowflake ETL Developer

    5 days ago

    Chicago, United States Daltics Full time

    We are seeking an experienced ETL Developer with a strong background in Snowflake and IBM DataStage to join our dynamic team. The ideal candidate will have proven expertise in designing and implementing end-to-end solutions, writing and debugging complex SQL queries, and constructing DataStage jobs. If you are a detail-oriented professional with a passion...

  • Snowflake ETL Developer

    2 days ago

    Chicago, United States Daltics Full time

    We are seeking an experienced ETL Developer with a strong background in Snowflake and IBM DataStage to join our dynamic team. The ideal candidate will have proven expertise in designing and implementing end-to-end solutions, writing and debugging complex SQL queries, and constructing DataStage jobs. If you are a detail-oriented professional with a passion...

  • Sr. ETL Developer

    3 hours ago

    Chicago, United States Ageatia Global Solutions Full time

    Senior ETL Developer The Senior ETL Developer will be held accountable for the following responsibilities: Maintain and Manage the existing Client Enterprise Data Warehouse and ODS builds. Model extensions to the existing Data Warehouse Builds ETL components according to ETL specifications. Code must address performance,dependency, auditing, error...

  • Informatica Developer

    1 month ago

    Chicago, United States Cogent Data Solutions Full time

    Informatica Developer Job Description We are looking for the persons who has minimum one of year of experience and interested to work as a Informatica PowerCenter developer to develop and enhance mappings (ETL&39;s) from various sources into an Oracle /Teradata Data Warehouse. Responsibilities - Develop Informatica workflows to collect data from multiple...

  • Informatica Developer

    1 month ago

    Chicago, Illinois, United States Cogent Data Solutions Full time

    Informatica Developer Job Description We are looking for the persons who has minimum one of year of experience and interested to work as a Informatica PowerCenter developer to develop and enhance mappings (ETL&39;s) from various sources into an Oracle /Teradata Data Warehouse. Responsibilities Develop Informatica workflows to collect data from multiple data...

  • Senior Data Architect

    1 month ago

    Chicago, United States Atlantic Partners Corporation Full time

    A large Asset Management firm is looking for a Data Architect with financial services exp.This person will l design and implement best-in-class data management solutions for metadata, master data and data quality management to enable data analytics capabilities across the Firm. Serving as subject matter expert on Microsoft SQL Server and Azure Data...

  • Senior Data Architect

    5 days ago

    Chicago, United States Atlantic Partners Corporation Full time

    A large Asset Management firm is looking for a Data Architect with financial services exp.This person will l design and implement best-in-class data management solutions for metadata, master data and data quality management to enable data analytics capabilities across the Firm. Serving as subject matter expert on Microsoft SQL Server and Azure Data...

  • Etl Developer

    6 days ago

    Chicago, United States Vanator Full time

    **ETL Developer [ONLY W2 Remote]** **Description**: - 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...