Data Engineer (Data Stage)Visa status: U.S. Citizens and those authorized to work in the U.S. are encouraged to apply.
Tax Terms: W2, 1099 Corp-Corp or 3rd Parties: Yes San Antonio, TX Long TermAbout the Data Stage RoleYou are a savvy Data Engineer eager to join a growing team of analytics experts. In this role, you will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. You will support our software developers, database architects, data analysts and data scientists on initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.
You are self-directed and comfortable supporting the data needs of multiple teams, systems and products. You are excited by the prospect of optimizing and innovating existing data architecture to support the next generation of products and data initiatives.ResponsibilitiesDeveloping Data stage code ETL/ELT to DB2 and Netezza platforms. This requires understanding of the existing ETL and ELT standards along with thorough understanding of the databases and strong SQL skills.
Leverage existing capabilities and enhance them for faster loads.Development of applications running on AWS Cloud part of Migration from MPP (Netezza) to Snowflake.Build detailed technical design, conduct analysis, development of applications and proof of concepts.Responsible for translating functional ETL requirements into a technical design document, building the DataStage jobs and sequences to pull data from the source into staging tables, from staging tables into historical tables using Change Data Capture methodologies, and then from historical tables into dimensional data marts for reporting.Communicate progress across organization and levels from individual contributor to senior executive. Identify and clarify issues/problems that need action and drive appropriate decisions and actions relating to system integrations, compatibility, and multiple platforms.Research, test, build, and coordinate the conversion and/or integration of new products based on client requirements. Design and develop new software products or major enhancements to existing software.Overseeing the testing, implementation, maintenance, and enhancement of the applications.Consult with project teams and end users to identify any further application requirements.Perform feasibility analysis on potential future projects to management.Assist in the evaluation and recommendation of application software packages, application integration and testing tools.Troubleshoot and resolve software issues and respond to suggestions for improvements and enhancements.Instruct, assigns, directs, and checks the work of other software developers on development team.Participate in development of software user manuals.Design and build applications as per the given requirement adhering to the guidelines.Ensure consistent unit testing and support the technology infrastructure team implementation.Notify clients once updates have been made.RequirementsBachelor's Degree or master's degree in Computer Science, Mathematics, Statistics.Previous experience as a DataStage Developer.Comfortable working in a fast-paced environment.Able to identify risks and mitigation.Good mathematical and problem-solving skills.Good communication and team-working skills.