Required Skills

Data Engineer ETL SQL SSIS Kafka

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 23rd Feb 2024

JOB DETAIL

Must Have Skills:  Apache NiFi, Databases: - (Oracle 8i/9i/10g, IBM DB2, SQL Server, Other DW-BI, Snowflake, PostgreSQL), ETL, SQL, SSIS, Kafka

 

 

We are seeking a skilled Data Engineer with a strong background in mortgage banking to join our IT team. The candidate will be instrumental in constructing, testing, and maintaining our mortgage banking data architecture. This includes optimizing data flow and collection to ultimately support data analysis and decision-making processes.

 

Responsibilities:

  • Design, construct, install, test, and maintain highly scalable data management systems.
  • Ensure systems meet business requirements and industry practices for mortgage banking.
  • Build high-performance algorithms, prototypes, predictive models, and proof of concepts.
  • Translate complex functional and technical requirements into detailed architecture, design, and high-performing software.
  • Integrate new data management technologies and software engineering tools into existing structures.
  • Create data tools for analytics and line of business that assist them in building and optimizing our product into an innovative industry leader.
  • Work with data and analytics experts to strive for greater functionality in our data systems.
  • Maintain a secure and compliant data processing environment in line with industry regulations.

 

Qualifications:

  • Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
  • Proven experience as a Data Engineer, preferably in the mortgage banking industry.
  • Strong knowledge of data warehousing solutions and relational SQL and NoSQL databases, Snowflake, MS SQL Server
  • STRONG experience in ETL, leveraging MS SSIS
  • Experience with AWS cloud services: EC2, RDS, MSK, Lambda
  • Experience with object-oriented/object function scripting languages a plus
  • Solid analytical skills and the ability to understand complex business requirements.
  • Familiarity with data pipeline and workflow management tools: dbt, Apache Kafka, Snowflake data pipeline/streams
  • Knowledge of financial and mortgage banking principles.
  • Strong organizational and interpersonal skills, with the ability to manage tasks and timelines effectively.

Company Information