What are the responsibilities and job description for the ETL Developer position at Insight Global?
Job Description
Insight Global is hiring an ETL Developer for a contract opportunity supporting our largest financial client in the Cincinnati, Ohio area. There is a strong preference is to have these individuals hybrid onsite in Cincinnati but will consider remote for an all-star candidate.
This individual will design, build, test, and maintain databases. They will play an important part of the development team to tests, designs, and debugs the entire database system before it is implemented.
Primary Responsibilities :
Coordinate with ETL team to implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.
Perform tests and provide updates to all ETL activities within schedule and provide support to all large data volumes and assist in data processing.
Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.
Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analysts to validate all requirements, perform interviews with all users and developers.
Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.
Provide support to all ETL schedules and maintain compliance to the same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity / affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and / or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy : .
Skills and Requirements
5 years of experience within data engineering and ETL development
Snowflake for ETL
Migrating data from legacy platform to new solutions
Building pipelines
Oracle and SQL
Automation experience for ETL deployment and testing Banking / Finance industry experience, specifically payment processing or ACH / wire transfers
Java (language and run time environment)
Kafka
Datastage
Archer null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity / affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and / or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.
