ETL Engineer - Nesco Resource
Plainview, NY
About the Job
Are you ready to revolutionize data integration in the heart of cutting-edge electronics manufacturing?
Join adynamic team ata trailblazer in the electronics industry, as an ETL Engineer. Dive into the forefront of innovation, where your expertise in SAP BODS will power the extraction and provisioning of data from a myriad of legacy systems, propelling our data-driven initiatives to new heights. Embark on a journey where you'll sculpt the digital backbone of our operations, optimizing ETL pipelines within our Enterprise Data Warehouse environment. With each line of code, you'll be shaping the future of electronics manufacturing, ensuring seamless data flows and timely insights that drive our competitive edge. If you're ready to harness the power of data in a vibrant, forward-thinking environment, this is the opportunity you've been waiting for. Let's redefine what's possible together.
Title: ETL Engineer
Job Description:
Job description
Experience in SAP BODS ETL design and implementation involving extraction and provisioning of data from a variety of legacy systems.
Experience in Data Conversion/Data Migration / Data Warehousing projects that include analysis and development of Dataflows, and mappings using needed transformations using BODS.
Develop Jobs, Workflows, and Data flows based on the specifications using various stages in BODS.
Experience in BODS Designer Components- Projects, Jobs, Workflow, Data Flow, Scripts, Data Stores, and Formats.
Experience validating the ETL code and doing Unit Testing by writing SQL queries
Exposure in BODS performance tuning techniques using parallel processing (Degree of Parallelism), Multithreading, Partitioning, and Database Throughputs to improve job performance
Hands-on exp in debugging execution errors using Data Services logs (trace, statics, and Error)
Should have work experience in different types of transformations like Query transformation, Merge, Case, Validations, Map- operation, History Preserving, and Table Comparison transformations.
Should have a clear understanding of DW Lifecycle and contribute in preparing technical design documents and test plans
Must require skill:
• Create, Manage and Enhance the ETL Pipeline build in EDWH environment using SAP Data Services
• Ensure risks, issues and dependencies are being recorded, monitored and proactively highlighted to the management
• Ensure to successful timely delivery
• Should be capable of delivering complex ETL requirements Knows about SAP DS architecture.
• Good hands-on experience in SAP Data Services
• Good understanding of RDBMS
Nice to have :
• Knowledge of integrating third-party APIs, how to use
• Knowledge of Python scripting language.
• Knowledge of the Sales Force backend is a strong plus
• Knowledge of Cloud Platform (GCP, AWS, Azure, etc..)
Professional Attributes :
• Good communication
• work in a team with good spirit
• Analytical skills
• presentation skills
• problem-solving skills.
Location:
Candidates can work remotely now unless the supervisor's instruction.
But they may have to go to the office depending on client's decision in the future.
Please note that we cannot guarantee candidates continue working remotely.
(There is a possibility that the candidate may be asked to come to the office if necessary to pick up equipment or other items.)
Candidates presented for this role must be authorized to work in the United States.
Nesco Resource provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.