ETL DEVELOPER
- Location
- Roslyn, NY
- Listed
- Today
About the role
Our client in Roslyn NY has an immediate need for DATABASE DEVELOPER.
- Main skills: ORACLE 11,12, ENTERPRISE EDITION
- OLAP
- DWH
- LONG TERM CONTACT
General Summary
Provide expertise in many areas of data management including but not limited to data warehousing, data warehouse reporting, data analysis, data architecture and design, data access security, data availability standards and methods, and data integration Ability to provide support for OLAP reporting applications by designing and implementing ETL processes and staging database structures, OLAP database structures including fact and dimension tables, and process flow procedures, based on end-user requirements.
Essential Duties & Responsibilities
- Responsible for designing, developing, and maintaining data warehouse and analytics architecture to meet an enterprise's business analysis and reporting needs.
- Works with architects and business partners to fashion out the technical vision for applications in Customer Data Warehouses employing PL/SQL, SQL, Oracle EE database.
- Consolidate and optimize available data warehouse infrastructure
- Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients
- Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked
- Design and implement ETL processes and data architecture to ensure proper functioning of analytics in SAP BI, as well as client's reporting environments and dashboard
- Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization
- Carry out monitoring, tuning, and database performance analysis
- Perform the design and extension of data marts, meta data, and data models
- Ensure all data warehouse architecture codes are maintained in a version control system.
- Work closely with the Software Development Manager, Programmer/Analyst, and Project Management Office (PMO) to understand business requirements, source to target mappings, data models, and universe designs in order to develop highly efficient and highly scalable ETL processes and Universe data foundation ensuring delivery of business needs in a timely manner
- Provides production support for existing ETL and universes
- Responsible for learning, applying, refining established ETL development standards
- Other duties as assigned.
Education & Qualifications
- Bachelor's degree (B.S.) in computer science or related field plus required experience
- Minimum 3 years Data Warehousing/ETL experience
- Minimum 2 years experience using Oracle
- Demonstrated knowledge of database concepts of data modeling and mapping including normalization, dimensionality, referential integrity, indexes, keys, common dimensions, star and snowflake schemas, master data and metadata (MUST know how to read models and mappings)
- Experience in developing ETL processes for Data Warehouse, Data Marts and/or Operational Data Stores, as well as, in operationalization of ETL and all dependent processes
- Experience in identifying performance issues, SQL optimization, and designing high performing ETL processes
- Must possess a deep understanding of DW and BI concepts in a large organization using multiple applications and various data sources, as well as, knowledge of Data Modeling/ Analysis/Data Integration best practices
- Must be able to troubleshoot existing ETL code to resolve issues (e.g. join and performance issues)
- Experience working with transactional databases, MS Excel, Web Services, and various other formats as data sources
- Demonstrated experience across numerous data warehousing/data integration projects, as well as, the ability to work with other project team members and business users to resolve moderately complex data integration issues
- Must possess sound understanding of Software Development Life Cycle (SDLC)
- Strong SQL and Oracle PL/SQL skills. Must be able to read and write, and optimize SQL
- Proficient in a variety of computer programming languages in order to successfully complete the tasks of the role
- Familiarity working with source control tools, GIT preferred
- DBA or database development experience (a plus)
- Ability to multi-task with minimal supervision
- Knowledge of.NET (a plus)
Additional Information
All your information will be kept confidential according to EEO guidelines.
From Operation IT's careers page, first listed on Rolev.ai on November 18, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this ETL DEVELOPER role at Operation IT, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
- ETL Developer (Abinitio)Scout ET · Wilmington, DE
- ETL Developer - US Citizen OR Green Card OnlyMastech Digital · Dallas, TX
- ETL DeveloperGRVTY · McLean, VA
- ETL DeveloperGuidehouse · Remote (Any location) · $113k – $188k/yr
- ETL DeveloperLeidos · Bethesda, MD · $87.1k – $157k/yr
- ETL Developer - SMEAccenture Federal Services · Chantilly, VA
Common questions
Where is the ETL DEVELOPER job at Operation IT located?
This ETL DEVELOPER position at Operation IT is located in Roslyn, NY. Always check Operation IT's application page for specific state eligibility or relocation policies.
How do I apply for the ETL DEVELOPER position at Operation IT?
This listing links directly to Operation IT's SmartRecruiters application page. You can apply directly on Operation IT's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.