Role Description
Role Proficiency:Independently develops error free code with high quality validation of applications guides other developers and assists Lead 1 – Software Engineering
Outcomes
- Understand and provide input to the application/feature/component designs; developing the same in accordance with user stories/requirements.
- Code debug test document and communicate product/component/features at development stages.
- Select appropriate technical options for development such as reusing improving or reconfiguration of existing components.
- Optimise efficiency cost and quality by identifying opportunities for automation/process improvements and agile delivery models
- Mentor Developer 1 – Software Engineering and Developer 2 – Software Engineering to effectively perform in their roles
- Identify the problem patterns and improve the technical design of the application/system
- Proactively identify issues/defects/flaws in module/requirement implementation
- Assists Lead 1 – Software Engineering on Technical design. Review activities and begin demonstrating Lead 1 capabilities in making technical decisions
Measures Of Outcomes
- Adherence to engineering process and standards (coding standards)
- Adherence to schedule / timelines
- Adhere to SLAs where applicable
- Number of defects post delivery
- Number of non-compliance issues
- Reduction of reoccurrence of known defects
- Quick turnaround of production bugs
- Meet the defined productivity standards for project
- Number of reusable components created
- Completion of applicable technical/domain certifications
- Completion of all mandatory training requirements
Code
Outputs Expected:
- Develop code independently for the above
Configure
- Implement and monitor configuration process
Test
- Create and review unit test cases scenarios and execution
Domain Relevance
- Develop features and components with good understanding of the business problem being addressed for the client
Manage Project
- Manage module level activities
Manage Defects
- Perform defect RCA and mitigation
Estimate
- Estimate time effort resource dependence for one's own work and others' work including modules
Document
- Create documentation for own work as well as perform peer review of documentation of others' work
Manage Knowledge
- Consume and contribute to project related documents share point libraries and client universities
Status Reporting
- Report status of tasks assigned
- Comply with project related reporting standards/process
Release
Design
- LLD for multiple components
Mentoring
- Mentor juniors on the team
- Set FAST goals and provide feedback to FAST goals of mentees
Skill Examples
- Explain and communicate the design / development to the customer
- Perform and evaluate test results against product specifications
- Develop user interfaces business software components and embedded software components 5 Manage and guarantee high levels of cohesion and quality6 Use data models
- Estimate effort and resources required for developing / debugging features / components
- Perform and evaluate test in the customer or target environment
- Team Player
- Good written and verbal communication abilities
- Proactively ask for help and offer help
Knowledge Examples
- Appropriate software programs / modules
- Technical designing
- Programming languages
- DBMS
- Operating Systems and software platforms
- Integrated development environment (IDE)
- Agile methods
- Knowledge of customer domain and sub domain where problem is solved
Additional Comments
3+ Yrs highly skilled Python + SQL Optimization Developer to design, analyze, and optimize complex SQL queries, automate performance benchmarking using Python, and ensure efficient database operations across analytics and ETL pipelines. The ideal candidate will have a strong background in SQL tuning, Python scripting, and data engineering, with hands-on experience in profiling, indexing, and query performance analysis. - Analyze slow-running SQL queries and recommend improvements (indexes, joins, query rewrites)- Use EXPLAIN / EXPLAIN ANALYZE or query profiler tools to identify performance bottlenecks- Tune database objects (views, indexes, partitions, materialized views) - Develop Python scripts to automate SQL performance testing and benchmarking- Integrate with databases using libraries like sqlalchemy, pyodbc, psycopg2, or cx_Oracle- Create automated reports comparing execution times and resource usage - Capture and log query performance metrics automatically- Design scripts to run scheduled optimization checks- Build dashboards or reports (optional) to visualize performance over time - Collaborate with ETL and Data Engineering teams to integrate optimized SQL into production pipelines- Ensure optimized queries align with business logic and data model design - Work with DBAs to apply query hints, optimize statistics, and analyze database-level configurations- Support partitioning strategies and data distribution tuning - Maintain version control for SQL and Python scripts- Document query optimization patterns, benchmarks, and automation workflows- Train developers on optimization standards and automation usage
Skills
Sql,Python Scripting,Sql Optimization
