Data Engineer
Data Engineer (Contract)
Lake Mary, FL, United States (On-site)
Contract (8 months 17 days)
Published 4 hours ago
data engineer
PL - SQL
etl
Oracle SQL
GENERAL SUMMARY
Compass (within the Corporate Engineering) supports BNY?s critical business and risk management priorities by monitoring the design, implementation and operation of technology to address business needs. Compass Tools sits within Controls Engineering to automatically assess, monitor and report upon the operating effectiveness of key technology controls implemented to manage risk to BNY?s technology assets and services.
This is an individual contributor role, responsible for building a platform for automated Monitoring Routines. The individual will work in a cross-functional pod, closely with Control Analysts and Product management to design, develop and maintain critical technology and operational assets to support enterprise-wide automated Monitoring Routines.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Engage with Analysts for understanding platform requirements.
Develop software artifacts using Agile methodology and extend ownership by providing production support.
EDUCATION, QUALIFICATIONS & EXPERIENCE
Required
Bachelor's degree in computer science or a related discipline, or equivalent work experience required
5-7 years of experience as Data Engineer
Should be well versed/comfortable with the following technology stack, tools and processes:
Oracle SQL, PL-SQL, ETL Tools
GIT
Continuous integration
Gitlab
Experience in database development such as Oracle? SQL, PL-SQL and hands-on knowledge on ETL tool like alteryx/ pentaho preferred.
Dataware house like Snowflake or similar knowledge would be added advantage.
Perform data loading, cleansing, transformation using ETL tools.
Creating program views, indexes, functions, stored procedures, packages, triggers, analytical functions and complex queries.
Writing optimized SQL queries for integration with other applications.
Designing database tables and dictionaries.
Developing ddl, dml scripts, procedures and triggers for application development.
Maintaining data quality checks and performance tuning
Experience in batch set up, unix, scheduling tools
Has knowledge of the Software Development Life Cycle.
Teamwork, communication and organization skills and possess analytical thinking skills.
Fair understanding of agile methodology, jira, confluence, git pipelines
The pay range that the employer in good faith reasonably expects to pay for this position is $34.67/hour - $54.18/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.
Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.
Data Engineer (Contract)
Lake Mary, FL, United States (On-site)
Contract (8 months 17 days)
Published 4 hours ago
data engineer
PL - SQL
etl
Oracle SQL
GENERAL SUMMARY
Compass (within the Corporate Engineering) supports BNY?s critical business and risk management priorities by monitoring the design, implementation and operation of technology to address business needs. Compass Tools sits within Controls Engineering to automatically assess, monitor and report upon the operating effectiveness of key technology controls implemented to manage risk to BNY?s technology assets and services.
This is an individual contributor role, responsible for building a platform for automated Monitoring Routines. The individual will work in a cross-functional pod, closely with Control Analysts and Product management to design, develop and maintain critical technology and operational assets to support enterprise-wide automated Monitoring Routines.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Engage with Analysts for understanding platform requirements.
Develop software artifacts using Agile methodology and extend ownership by providing production support.
EDUCATION, QUALIFICATIONS & EXPERIENCE
Required
Bachelor's degree in computer science or a related discipline, or equivalent work experience required
5-7 years of experience as Data Engineer
Should be well versed/comfortable with the following technology stack, tools and processes:
Oracle SQL, PL-SQL, ETL Tools
GIT
Continuous integration
Gitlab
Experience in database development such as Oracle? SQL, PL-SQL and hands-on knowledge on ETL tool like alteryx/ pentaho preferred.
Dataware house like Snowflake or similar knowledge would be added advantage.
Perform data loading, cleansing, transformation using ETL tools.
Creating program views, indexes, functions, stored procedures, packages, triggers, analytical functions and complex queries.
Writing optimized SQL queries for integration with other applications.
Designing database tables and dictionaries.
Developing ddl, dml scripts, procedures and triggers for application development.
Maintaining data quality checks and performance tuning
Experience in batch set up, unix, scheduling tools
Has knowledge of the Software Development Life Cycle.
Teamwork, communication and organization skills and possess analytical thinking skills.
Fair understanding of agile methodology, jira, confluence, git pipelines
The pay range that the employer in good faith reasonably expects to pay for this position is $34.67/hour - $54.18/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.
Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.
