SQL Developer

The Sr. Analytics Engineer would provide technical expertise in needs identification, data modeling, data movement, and transformation mapping (source to target), automation and testing strategies, translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective.

Understands and leverages best-fit technologies (e.g., traditional star schema structures, cloud, Hadoop, NoSQL, etc.) and approaches to address business and environmental challenges.

Provides data understanding and coordinates data-related activities with other data management groups such as master data management, data governance, and metadata management.

Actively participates with other consultants in problem-solving and approach development.

Responsibilities :

Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, conceptual, logical, and physical data models based on those needs.

Perform data analysis to validate data models and to confirm the ability to meet business needs.

Assist with and support setting the data architecture direction, ensuring data architecture deliverables are developed, ensuring compliance to standards and guidelines, implementing the data architecture, and supporting technical developers at a project or business unit level.

Coordinate and consult with the Data Architect, project manager, client business staff, client technical staff and project developers in data architecture best practices and anything else that is data related at the project or business unit levels.

Work closely with Business Analysts and Solution Architects to design the data model satisfying the business needs and adhering to Enterprise Architecture.

Coordinate with Data Architects, Program Managers and participate in recurring meetings.

Help and mentor team members to understand the data model and subject areas.

Ensure that the team adheres to best practices and guidelines.

Requirements :

- Strong working knowledge of at least 3 years of Spark, Java/Scala/Pyspark, Kafka, Git, Unix / Linux, and ETL pipeline designing.

- Experience with Spark optimization/tuning/resource allocations

- Excellent understanding of IN memory distributed computing frameworks like Spark and its parameter tuning, writing optimized workflow sequences.

- Experience of relational databases (e.g., PostgreSQL, MySQL) and NoSQL databases (e.g., Redshift, Bigquery, Cassandra, etc).

- Familiarity with Docker, Kubernetes, Azure Data Lake/Blob storage, AWS S3, Google Cloud storage, etc.

- Have a deep understanding of the various stacks and components of the Big Data ecosystem.

- Hands-on experience with Python is a huge plus

• Strong hands-on code development experience in JAVA 14+, Restful Service, Spring Boot, JDBC Template.
• Experience in SQL scripting
• Experienced in developing and deploying web applications using Spring MVC and Spring boot.
•  Hands on experience in one of the IDE’s – Eclipse or IntelliJ
• Experience with Tools- Maven, Jenkins
• Experience in entire software development life cycle from analysis, coding, testing, debugging and publishing using GIT
•  AWS Services will be an added advantage
• Experience Kafka, K8s and Containers will be an added advantag.

WHO YOU ARE

To be successful in this role, you’ll need to have the following skills:

·         Love for coding: A fanatic about writing beautiful and scalable code.

·         A sense of analytics: Strong analytical and troubleshooting skills. Should be resourceful, innovative and inventive.

·         Dynamic: Should be comfortable in dealing with lots of moving pieces. Have exquisite attention to detail, and are comfortable learning new technologies and systems. 

·         Team player: Knack for influencing without being authoritative. Pitch in wherever the team needs help, from writing blog posts to supporting customers.

·         Accountability: High sense of ownership for your code and relentlessness to deliver projects with high business impact. 

KEY QUALIFICATIONS

·         BE/BTech in Computer Science or related field. 

·         5+ years of professional production and development experience with leading-edge server and database technologies (e.g., Python, Java, Node.js, Scala, Spring Boot, MySQL, and NoSQL databases).

KEY SKILLS

·         Strong computer system analysis and design skills in current methodologies and patterns Experience with professional production cloud (AWS preferred).

·         Experience with RESTful Services and APIs.

Hi,
I am having an ajob opportunity for the role of "Node Js developer" permanent work from home.

Please find the below JD 

Responsibilities:

 We are looking for a candidate who possesses a passion for pushing technologies to the limits and will work with our team of talented engineers to design and build the next generation applications. 

- You will work closely with our product and design teams to build the backend engine and implement web services using the latest principles.

- Candidates should have working knowledge of NodeJS latest versions. Candidates with additional knowledge of technologies like JAVA, CAKEPHP will be preferred more.

Skills Required :

NodeJS, REST API, JSON Data Format, Integrating Third Party Libraries, MYSQL/MONGODB Databases and similar.

- Affinity for backend technologies.

- Experience in writing modular/reusable code using node frameworks

- Deep technical Knowledge and Good problem solving abilities.

- Good communication skills and solid interpersonal skills.

- Team Management skills is must

-Qualification Required : MCA/B.Tech Candidate Only

Must-Have:

• Core Java (Must be good in Core Java concepts, Java programming practices, Clean coding.)
• Spring Framework(Must have working experience in Spring Core)
• Any SQL framework(hands-on working experience in any of these: Hibernate/JPA/MyBatis/Spring Data/Others)
• Hands-on experience in REST API
• Hands-on experienceSQL Database(any of the databases: Oracle/MySQL/PostgreSQL/SQLServer)
• Must have working experience with basic GIT
• Maven or Gradle (Must have working experience in building Java projects using maven or Gradle.)
• Should be able to work independently under someone's guidance.

Good to have:

• Advanced Java(Threading, Performance optimization)
• Spring Boot
• Other Spring frameworks(Spring Security, Spring Batch, Others)
• Microservices - Any NoSQL database(MongoDB, Cassandra, others)
• Application designing concepts.

We are looking for an experienced Back-end developer to join our IT team! As a Back-end Developer, you will be responsible for the server-side web application logic as well as for the integration of the front-end part. 

• Be involved and participate in the overall application lifecycle
• Main focus on coding and debugging
• Collaborate with Front-end developers 
• Define and communicate technical and design requirements
• Provide training, help and support to other team members
• Build high-quality reusable code that can be used in thew future
• Develop functional and sustainable web applications with clean codes
• Troubleshoot and debug applications
• Learn about new technologies
• Stay up to date with current best practices
• Conduct UI tests and optimize performance
• Manage cutting-edge technologies to improve applications
• Collaborate with multidisciplinary team of designers, developers and system administrators
• Follow new and emerging technologies

• Creating, designing and developing data models
• Prepare plans for all ETL (Extract/Transformation/Load) procedures and architectures
• Validating results and creating business reports
• Monitoring and tuning data loads and queries
• Develop and prepare a schedule for a new data warehouse
• Analyze large databases and recommend appropriate optimization for the same
• Administer all requirements and design various functional specifications for data
• Provide support to the Software Development Life cycle
• Prepare various code designs and ensure efficient implementation of the same
• Evaluate all codes and ensure the quality of all project deliverables
• Monitor data warehouse work and provide subject matter expertise
• Hands-on BI practices, data structures, data modeling, SQL skills

Hard Skills for a Data Warehouse Developer:

• Hands-on experience with ETL tools e.g., DataStage, Informatica, Pentaho, Talend
• Sound knowledge of https://www.freelancermap.com/it-projects/sql-1084" target="_blank">SQL
• Experience with SQL databases such as Oracle, DB2, and SQL
• Experience using Data Warehouse platforms e.g., SAP, Birst
• Experience designing, developing, and implementing Data Warehouse solutions
• Project management and system development methodology
• Ability to proactively research solutions and best practices

Soft Skills for Data Warehouse Developers:

• Excellent Analytical skills
• Excellent verbal and written communications
• Strong organization skills
• Ability to work on a team, as well as independently

- Working on Architecture and Standards team to validate designs and standards.

- Perform coding, bug verification, unit testing, and integration testing.

Job Role – SDE2

Duration – 12 months

Location – HYD

Key Skills:

• 3- 5 years
• Understanding databases and building reports
• Ideal candidate should have experience in Cosmos, Kusto and powerbi
• Mandatory experience in some Database query language(such as SQL)