03 Sep
|
GBIT (Global Bridge InfoTech
|
Hyderabad
03 Sep
GBIT (Global Bridge InfoTech
Hyderabad
Job Description
Job Summary:
n
We are looking for an experienced PostGress / SQL Data Engineer who possesses strong SQL/PostgreSQL expertise, and can build scalable, high‑performance DB Queries. The ideal candidate should be able to understand complex stored procedure logic, write optimized SQL queries, create advanced DAX calculations.
n
n
Interested? Please send your updated resumes at
[email protected]
n
n
Key Responsibilities:
n
PostgreSQL / SQL Development
n
n
- Write complex SQL queries, window functions, CTEs, aggregations, and transformations.
n
- Design, develop, and maintain scalable data pipelines and ETL/ELT workflows to ingest, transform, and deliver data from multiple sources.
n
- Understand, validate, and optimize existing stored procedures and functions.
n
- Apply PostgreSQL performance optimization techniques including index tuning,
n
- Write complex, high-performance SQL queries, stored procedures, triggers, functions, and views in PostgreSQL to support business logic and reporting needs.
n
- EXPLAIN/ANALYZE, partitioning, minimizing sequential scans, optimizing analytical queries.
n
- Work with product owners, analysts, and business users to understand reporting and data needs.
n
- Convert business logic into efficient SQL
n
- Maintain documentation for SQL scripts, DAX logic, data models, and development standards.
n
- Implement and maintain complex joins (inner, outer, cross, self), CTEs, window functions, and advanced aggregations to support analytical use cases.
n
- Participate in sprint discussions, requirement finalizations, and production validations.
n
n
Required Skills
n
Data engineer
n
n
- 7+ years hands‑on experience as a Data Engineer
n
- Strong skills in DAX, data modeling, Power Query, and performance tuning.
n
- Experience with RLS, and dataflows.
n
n
SQL / PostgreSQL
n
n
- 5+ years SQL experience, specifically PostgreSQL.
n
- Ability to interpret and improve complex stored procedure logic.
n
- Expertise in SPs, UDFs, analytical queries, and performance tuning.
n
n
Tools & Practices
n
n
- Experience with Git/version control.
n
- Familiar with AI‑assisted development (GitHub Copilot in VS Code) and writing effective prompts.
n
n
Other Skills
n
n
- Strong analytical and problem‑solving abilities.
n
- Good communication and documentation skills.
n
- Experience working in Agile/Scrum settings.
n
n
Years of Experience
n
n
- Overall Experience: 6 to 9 years
n
- SQL/PostgreSQL: 5+ years
n
n
Valuable‑to‑Have Skills
n
n
- Knowledge of Microsoft Fabric components.
n
- Familiarity with ETL/ELT processes.
n
- Exposure to CI/CD pipelines for BI solutions.
n
- Experience with streaming data technologies such as Apache Kafka or AWS Kinesis.
n
- Exposure to NoSQL databases (MongoDB, Cassandra, DynamoDB).
n
- Knowledge of data governance, lineage, and cataloging tools.
n
- Experience in Agile/Scrum environments.
n
- Familiarity with containerization tools like Docker and Kubernetes.
n
n
📌 Postgres / SQL Data Engineer (Hyderabad)
🏢 GBIT (Global Bridge InfoTech
📍 Hyderabad