SQL/Hadoop Developer

Developer III - Software Engineering

SQL/Hadoop Developer

Independently develops error free code with high quality validation of applications guides other developers and assists Lead 1 - Software Engineering

Outcomes:

1. Understand and provide input to the application/feature/component designs; developing the same in accordance with user stories/requirements.
2. Code debug test document and communicate product/component/features at development stages.
3. Select appropriate technical options for development such as reusing improving or reconfiguration of existing components.
4. Optimise efficiency cost and quality by identifying opportunities for automation/process improvements and agile delivery models
5. Mentor Developer 1 - Software Engineering and Developer 2 - Software Engineering to effectively perform in their roles
6. Identify the problem patterns and improve the technical design of the application/system
7. Proactively identify issues/defects/flaws in module/requirement implementation
8. Assists Lead 1 - Software Engineering on Technical design. Review activities and begin demonstrating Lead 1 capabilities in making technical decisions

Measures of Outcomes:

1. Adherence to engineering process and standards (coding standards)
2. Adherence to schedule / timelines
3. Adhere to SLAs where applicable
4. Number of defects post delivery
5. Number of non-compliance issues
6. Reduction of reoccurrence of known defects
7. Quick turnaround of production bugs
8. Meet the defined productivity standards for project
9. Number of reusable components created
10. Completion of applicable technical/domain certifications
11. Completion of all mandatory training requirements

Outputs Expected:

Code:

1. Develop code independently for the above

Configure:

1. Implement and monitor configuration process

Test:

1. Create and review unit test cases
   scenarios and execution

Domain relevance:

1. Develop features and components with good understanding of the business problem being addressed for the client

Manage Project:

1. Manage module level activities

Manage Defects:

1. Perform defect RCA and mitigation

Estimate:

1. Estimate time
   effort
   resource dependence for ones own work and others work
   including modules

Document:

1. Create documentation for own work as well as perform peer review of documentation of others work

Manage knowledge:

1. Consume and contribute to project related documents
   share point
   libraries and client universities

Status Reporting:

1. Report status of tasks assigned
2. Comply with project related reporting standards/process

Release:

1. Execute release process

Design:

1. LLD for multiple components

Mentoring:

1. Mentor juniors on the team
2. Set FAST goals and provide feedback to FAST goals of mentees

Skill Examples:

1. Explain and communicate the design / development to the customer
2. Perform and evaluate test results against product specifications
3. Develop user interfaces business software components and embedded software components 5 Manage and guarantee high levels of cohesion and quality6 Use data models
4. Estimate effort and resources required for developing / debugging features / components
5. Perform and evaluate test in the customer or target environment
6. Team Player
7. Good written and verbal communication abilities
8. Proactively ask for help and offer help

Knowledge Examples:

• Appropriate software programs / modules
  1. Technical designing
  2. Programming languages
  3. DBMS
  4. Operating Systems and software platforms
  5. Integrated development environment (IDE)
  6. Agile methods
  7. Knowledge of customer domain and sub domain where problem is solved
  
  

  Job Description: We are seeking an experienced SQL/Hadoop Developer with 5-6 years of experience to design, develop, and maintain our data infrastructure. The ideal candidate will have a strong background in SQL and Hadoop, with the ability to handle large datasets and complex data processing tasks. Key Responsibilities: Design, develop, and maintain SQL and Hadoop-based data solutions. Write complex SQL queries to extract, transform, and load (ETL) data. Develop and optimize Hadoop-based data processing workflows. Collaborate with data analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions. Ensure data quality, integrity, and security across all data platforms. Monitor and troubleshoot data processing jobs to ensure timely and accurate data delivery. Perform data analysis and generate reports to support business decision-making. Stay updated with the latest industry trends and technologies in SQL and Hadoop. Qualifications: 5-6 years of experience in SQL and Hadoop development. Tableau knowledge is preferred. Proficiency in writing complex SQL queries and optimizing SQL performance. Experience with data integration tools and ETL processes. Knowledge of data warehousing concepts and best practices. Familiarity with big data technologies and frameworks. Strong problem-solving skills and attention to detail. Optimization and strong debugging skills