MS SQL Developer

Purpose of Job:
We are looking for an exceptionally talented senior data engineer who has exposure in implementing AWS services to build data pipelines, api
integration and designing data warehouse.

Job Responsibilities:
• Total 4+ years of experience as a Data Engineer
• Have minimum 3 years of AWS Cloud experience.
• Well versed in languages such as Python, PySpark, SQL, NodeJS etc
• Has extensive experience in Spark ecosystem and has
worked on both real time and batch processing
• Have experience in AWS Glue, EMR, DMS, Lambda, S3, DynamoDB, Step functions, Airflow, RDS, Aurora etc.
• Experience with modern Database systems such as
Redshift, Presto, Hive etc.
• Worked on building data lakes in the past on S3 or
Apache Hudi • Solid understanding of Data Warehousing Concepts
• Good to have experience on tools such as Kafka or Kinesis
• Good to have AWS Developer Associate or Solutions Architect Associate Certification

Qualifications:
At least a bachelor’s degree in Science, Engineering, Applied
Mathematics. Other Requirements: Learning Attitude, Ownership skills

Hi,

I am HR from Janapriya school , Miyapur , Hyderabad , Telangana.

Currently we are looking for a primary computer teacher .

the teacher should have atleast 2 years experience in teaching computers .

Intrested candidates can apply to the above posting.

• 8+ years of experience building Web applications, APIs, Service based platforms
• Excellent command on Java/J2EE and/or Spring/Hibernate
• Strong command over REST based services and micro-services
• Good knowledge of databases such as MySQL
• Good knowledge of creating and maintaining Dev ops infrastructure on AWS or similar platforms
• Good knowledge of code repo software such as git and build management tools

• The opportunity to take on some of the world’s most meaningful challenges, helping customers achieve clean water, safe food, abundant energy, and healthy environments
• The ability to make an impact and shape your career with a company that is passionate about growth
• The support of an organization that believes it is vital to include and engage diverse people, perspectives, and ideas to achieve our best
• Thrive in a company that values sustainability, drives a safety-focused culture, and has been recognized as one of the most ethical companies in the world
• Comprehensive benefits package starting day 1 of employment- medical, dental, vision, matching 401k, company-paid pension, stock purchase plan, tuition reimbursement, and more!

What You Will Do:

• Gather and process raw data at scale (including writing scripts, web scraping, calling APIs, write SQL queries, manage PI data, etc.).
• Devise and deploy the core automated processes that pre-process, clean, and present the required data for further processing.
• Develop and implement standard quality checks/algorithms and continuously improve upon these in collaboration with software and marketing teams.
• Develop and deploy metrics, dashboards, and visualizations characterizing both individual accounts and corporate enterprises in analytically insightful and visually compelling ways
• Apply engineering knowledge in developing data-driven algorithms for anomaly detection, failure prediction, and optimization.
• Work closely with our field sales, marketing, and industry technical consultants to configure data aggregation and visualization platforms and sustain those platforms over time.
• Process unstructured data into a form suitable for analysis – and then do the analysis.
• Support business decisions with ad hoc analysis as needed. Work closely with the leadership team to create dashboards (such as Power BI) to drive agile decision-making.
• To develop prototypes and proof of concepts for the selected solutions.
• Work with our customers to develop data exchange technologies

Minimum Qualifications:

• Education: B.S. (Masters’ preferred) in Computer Engineering, Applied Mathematics, Engineering, Information Technology or any other technology-related field. An equivalent of this educational requirement in working experience is also acceptable.
• Candidates must have 2 – 5 years of experience working as a PI Developer and/or PI System Manager, in a fast-paced environment and complex business setting.
• Knowledge in: Excel macros & JSON for our Refined Knowledge & CrudeFlex applications, PI AF templates, and PI Cloud Connect, PI WebAPI, C# to send data from OSIsoft PI to Microsoft SQL, APIs and web programming, Python or R languages
• The candidate must have a demonstrated experience in building and maintaining reliable and scalable ETL on big data platforms as well as experience working with varied forms of data infrastructure inclusive of relational databases such as Microsoft SQL (on-prem & Azure), Oracle, & OSIsoft PI.
• The PI Developer must further have exceptional skills in SQL server reporting services, analysis services, Salesforce, integration services, Power BI, or any other data visualization tools.

Preferred Qualifications:

• Experience in analytics in the oil & gas industry is a plus.
• Experience in the Microsoft Azure stack including data factories, data gateways, & Power BI.  Experience in PI Integrator for Business Analytics is desirable.  Experience in Hadoop, Spark and other analytic technologies is a plus. Digital-enabled technology experience and passion.
• Communication Skills: Excellent communication skills in both verbal and written form. The PI Developer works closely with other functional teams in the CDS organization.  Communication skills are also imperative for the PI Developer in his collaborative role where he will have to interact cross-functionally with non-technical departments. To enable effective collaborations, the PI Developer will have an exceptional ability to convey complex messages in a clear, simplified, and understandable manner. The candidate will also be required to draft reports and prepare presentations for Director – Commercial Digital Solutions (CDS) and Director – CDS Operation. These reports and presentations must be clear, concise, unambiguous, engaging, and convincing, which will demand exceptional communication skills on the PI Developer’s part.
• Microsoft Office/Software: A candidate for this position must be highly proficient in the use of MS Word, MS Excel, PowerPoint, and Outlook, which will all be necessary for the creation of both visually and verbally engaging reports and presentations, for leadership.
• Interpersonal Skills: The PI Developer will be a result-driven individual, be passionate and a self-starter, be proactive requiring minimal supervision, be highly organized, have an ability to handle multiple tasks and meet tight deadlines, be a creative and strategic thinker, work comfortably in a collaborative setting, work comfortably with senior departmental leadership, and demonstrate an ability to remain calm during times of uncertainty and stress, inspiring the same in his team.
• People Skill: The candidate must be a people person who is able to form strong, meaningful, and lasting connections with others, enabling smooth and continued collaborative relationships, earning him the trust, and gaining the confidence of the Director – CDS Operation team, and other team members across the company.

Mandatory Requirement/ Preference:

- 4 years of experience for delivering enterprise solutions or products using full SDLC 

- 4 years of work experience with enterprise solutions for Microsoft platform (SQL Server, stored procedures, WCF, C#.net, Entity Framework) 

- Extensive knowledge and experience with creating and maintaining stored procedure in MS SQL Server.

- Working with WEB API added advantage