
Lead Data Warehouse Engineers
17 hours ago
Company Description
Systech Solutions, Inc. is an all-inclusive data and analytics firm specializing in cloud, data engineering, AI, and machine learning solutions. With over 30 years of experience and a global reach, we provide efficient, cost-effective strategies to solve complex business problems at the intersection of data, business, and digital technologies. Our tailored solutions have garnered a customer retention rate of over 90% in the past five years. We excel in various sectors, including finance, retail, manufacturing, healthcare, and insurance, enhancing operations, increasing revenue, and boosting customer satisfaction. Recognized by Inc. Magazine, our skilled team turns challenges into growth opportunities through insightful data and technology practices.
Responsibilities
- Architecting and maintaining the Operational data stores (ODS), Enterprise Data Warehouse (EDW) and associated data intelligence environments including data lakes, data marts, and metadata repositories
- Designing and implementing high performance data movement pipelines using multiple ETL tools (Informatica, Azure Data Factory, SQL Packages, etc) with batch and real-time event data streams
- Developing scalable and re-usable frameworks for ingestion of structured and semi-structured data; and implementing various large-scale settlement and reconciliation frameworks
- Gathering business and information requirements from various product owners across various functional units
- Designing and creating data architecture and data flow diagrams and collaborating with peers to translate requirements into logical and physical data models.
- Conducting design review sessions and communicating design artifacts with stakeholders.
- Ensures database features and capabilities are incorporated into data model designs to optimize performance, resiliency, and scalability.
- Delivering and presenting proofs of concept to of key technology components to project stakeholders and internal technology leaders
- Developing scalable and re-usable frameworks for ingestion of structured and semi-structured data; and implementing various large-scale settlement and reconciliation frameworks
- Leading and coordinating the design and operationalization of Master Data Management and Data Governance initiatives including custom developed solutions.
- Working with other members of the project team to support delivery of additional project components associated with cloud data platform.
- Problem-solving of Data warehouse and ODS application issues and production errors, including high level critical production issues that require immediate attention.
- Perform other duties as assigned including major new project initiatives.
Qualifications
- Bachelor's and/or Master's degree in Computer Science, Computer Engineering or related field preferred
- 8+ years of overall software development experience is required primarily with Data warehouse applications.
· years of hands-on development experience in Cloud-based data warehouse platform – primarily AWS Redshift
· yrs of development experience with ETL tools (Informatica, Azure Data Factory, etc)
· years of development experience with Python scripting experience
· years of hands-on development experience with Relational DBs (MS SQL Server, PostgreSQL, Oracle, etc.); experience with complex stored procedures and functions using SQL
· Strong knowledge and experience in OLAP data modeling & design
· Demonstrated expertise in performance tuning in various DB environments with large volumes of data.
· Experience building and scaling distributed, high available systems in cloud env (Azure / AWS)
- Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
- Communication and professional skills and the ability to navigate relationships across business units.
Pluses:
- Financial technology domain knowledge
- Knowledge of NoSQL DBs (MongoDB / Cassandra / Azure Cosmos DB or similar)
- Microsoft Azure Data Engineer/services related experience (ADF, Databricks, CosmosDB, Azure SQL, etc)
-
Senior Data Warehouse Engineer
2 days ago
Chennai, Tamil Nadu, India Pando Full time ₹ 20,00,000 - ₹ 25,00,000 per yearSenior Data Warehouse EngineerPando ) is pioneering the future of autonomous logistics with innovative AI capabilities. Trusted by Fortune 500 enterprises with global customers across North America, Europe, and Asia Pacific regions, we are leading the global disruption of supply chain software, with our AI-powered, no-code, & unified platform empowering...
-
Snowflake Data Warehouse Engineers
6 days ago
Chennai, Tamil Nadu, India IDESLABS PRIVATE LIMITED Full time ₹ 15,00,000 - ₹ 25,00,000 per yearWe need an experienced, collaborative Snowflake Data Warehouse Engineers with5+ Yrs of experience in developing Snowflake data models, data ingestion, views, Stored procedures, complex queriesGood experience in SQLExperience in Informatica Powercenter IICS ETL toolsTesting and clearly document implementations, so others can easily understand the...
-
Snowflake Data Warehouse
18 hours ago
Chennai, Tamil Nadu, India ZettaMine Labs Pvt. Ltd. Full time ₹ 15,00,000 - ₹ 25,00,000 per yearHello,Greeting's fromZettaMineJob Title:Application Lead – Snowflake Data WarehouseLocation:Chennai, IndiaExperience:Minimum 5 years in Snowflake Data WarehouseJob SummaryWe are seeking an experiencedApplication Leadwith strong expertise inSnowflake Data Warehouseto lead the design, development, and configuration of applications. As the primary point of...
-
Data Engineer
14 hours ago
Chennai, Tamil Nadu, India CustomerLabs ❤️ 1P Data OPs Full time ₹ 5,00,000 - ₹ 15,00,000 per yearAs a Data Engineer (GCP) at CustomerLabs Inc., you will play a crucial role in designing, developing, and maintaining our data infrastructure on Google Cloud Platform. You will be responsible for ensuring the reliability, scalability, and efficiency of our data pipelines to support our analytics and machine learning initiatives.Key ResponsibilitiesDesign and...
-
Data Engineering Lead
2 days ago
Chennai, Tamil Nadu, India Star Health Insurance Full time ₹ 15,00,000 - ₹ 25,00,000 per yearData Engineering Lead:Design and implement scalable data pipelines using technologies such as Apache Spark, Kafka, and AWS Glue.Develop and maintain ETL processes to ingest, transform, and store structured and unstructured data.Optimize data storage solutions, including data lakes, data warehouses, and relational databases.Collaborate with cross functional...
-
Lead Data Engineer
6 days ago
Chennai, Tamil Nadu, India AABM Cloud Data Solutions Full time ₹ 12,00,000 - ₹ 18,00,000 per yearAbout the RoleWe are seeking a Lead Data Engineer to join our team. In this role, you will be crucial in designing, building, and maintaining our data infrastructure. This is a hands-on position requiring a strong foundation in data warehousing, ETL processes, and database management. The ideal candidate will have a keen eye for detail and the ability to...
-
Lead, Data Integration Engineer
2 days ago
Chennai, Tamil Nadu, India Chatham Financial Full time ₹ 9,00,000 - ₹ 12,00,000 per yearOverviewWe don't simply hire employees. We invest in them. When you work at Chatham, we empower you — offering professional development opportunities to help you grow in your career, no matter if you've been here for five months or 15 years. Chatham has worked hard to create a distinct work environment that values people, teamwork, integrity, and client...
-
Enterprise Data Warehouse Architect
4 weeks ago
Chennai, Tamil Nadu, India Fiserv Full timeCalling all innovators - find your future at Fiserv Were Fiserv a global leader in Fintech and payments and we move money and information in a way that moves the world We connect financial institutions corporations merchants and consumers to one another millions of times a day - quickly reliably and securely Any time you swipe your credit card pay...
-
GCP Data Engineer
3 weeks ago
Chennai, Tamil Nadu, India CustomerLabs 1P Data OPs Full timePosition Overview:"Yesterday is history, tomorrow is a mystery, but today is a gift. That's why we call itthe present." - Master OogwayJoin CustomerLabs' dynamic data team as a Data Engineer and play a pivotal role intransforming raw marketing data into actionable insights that power our digitalmarketing platform. As a key member of our data infrastructure...
-
Senior data engineer
4 weeks ago
Chennai, Tamil Nadu, India Tredence Inc. Full timeRole: Senior ETL developerExperience: 5+ yearsLocation: Chennai, Pune, KolkakaAbout Tredence:Tredence focuses on last-mile delivery of powerful insights into profitable actions by uniting its strengths in business analytics, data science and software engineering. The largest companies across industries are engaging with us and deploying their prediction and...