What are the responsibilities and job description for the ETL Technical Lead position at Stanley David and Associates?
Must Have Technical/Functional Skills
• Strong hands-on experience with Business Objects Data Services (BODS)
• Expertise in ETL architecture, design, development, and optimization
• Strong SQL proficiency with hands-on experience in Oracle and SQL Server
• Solid understanding of Data Warehousing concepts and Data Modeling
• Experience in data integration, migration, and transformation
• Hands-on experience in Unix / Shell scripting
• Strong understanding of data quality, validation, and governance practices
• Experience working in Agile / Scrum environments
Roles & Responsibilities
• Lead end-to-end ETL development initiatives using BODS
• Collaborate independently with business users, product owners, and stakeholders
to understand data requirements and translate them into ETL solutions
• Analyze existing ETL solutions and identify, implement, and optimize code changes
• Troubleshoot, debug, and optimize ETL jobs to ensure data accuracy,
performance, and reliability
• Design and implement efficient data models and transformation logic
• Work extensively with Oracle databases for querying, tuning, and performance optimization
• Develop and maintain Unix scripts to automate ETL operations and batch jobs
• Ensure data security, integrity, and compliance with organizational standards
• Coordinate with data warehouse and downstream application teams to ensure
smooth data integration
• Document ETL designs, technical specifications, and operational procedures.
• Provide ongoing support, maintenance, and enhancements to ETL processes.
• Act as a Scrum Master / ETL Lead, ensuring Agile best practices, sprint execution,
and delivery quality.
Salary : $120,000 - $125,000