Senior Software Engineer I - SQL Developer
- Optum
- 3 - 6 years
- Chennai
- 3 days ago
- Email to a friend
- Report this job
Job Description
- Develop solid scalable and reusable Data pipelines to Extract, load and transform data into cloud based Datawarehouse Snowflake
- Develop complex SQL queries (using joins, analytic functions, aggregation functions, windows functions), ETL Jobs, Reports/Dashboards to meet complex business requirements and data needs
- GitHub Copilot usage in software development Promote AI-first mindset in product development
- Collaborate with cross-functional teams to improve code quality, development practices, and processes
- Maintain development standards, perform critical development, and release operations Maintain Zero security violation (x-ray scan etc), Zero code vulnerabilities
- Troubleshoot and debug complex technical issues
- Conduct code reviews and provide constructive feedback
- Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so
- AI-Powered Solutions Development - Experience in developing and deploying AI-powered solutions using no-code, low-code, and advanced platforms, translating business needs into scalable solutions
- Good understanding of Database concepts
- Expert/ln-depth knowledge Of SQL: Building, debugging and tuning complex queries, business rules engines
- Knowledge in Dimensional Data Modelling and Semantic layer building for DWH, Reporting and Analytics
Technical Skills
Solid knowledge of:
- SQL,
- Datawarehouse
- ETL
- Database concepts
- SQL performance tuning
- Reporting and Analytics
- Cloud platform
- Agile methodologies
Familiar with:
- Cloud based Datawarehouse (Preferred Snowflake)
- Cloud based Reporting/Analytics platform (Preferred Looker)
- ETL and Integration tools (Preferred Snaplogic)
- Ansible and Jenkins for CICD
- Cloud platform (Preferred Azure)
- AI technologies
- Demonstrated ability to create big complex SQL queries (using joins, analytic functions, aggregration functions, windows functions) to load, transform and present data to downstream consumers to meet business data needs
- Demonstrated ability to prepare data as part Of an ETL or ELT process, and perform transform-load in cloud based Datawarehouse
- Proven efficient at resource optimization, analytics, and SQL performance tuning
- Proven solid programming and algorithmic skills
Job Classification
Industry: RetailFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse DeveloperEmployement Type: Full timeContact Details:
Company: OptumLocation(s): Chennai
Keyskills: software engineer snowflake github software development data pipelines ai elt cloud platform sql ansible analytics integration tools looker product development jenkins agile methodologies debugging agile etl programming azure
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in