Required Skills:
· Development, maintenance, and
enhancement of Data Pipelines (ETL/ELT) and processes with thorough knowledge
of star/snowflake schemas
· Hands on experience in
PowerCenter/IDMC/IICS.
· Developing
complex SQL queries and SQL optimization
· Development experience must be full Life Cycle
experience including business requirements gathering, data sourcing,
testing/data reconciliation, and deployment within Business Intelligence/Data
Warehousing Architecture.
· Designing and implementing data security
· Monitoring and optimizing data storage and data
processing
· Delivering Data Solutions using Cloud Technologies
· Advanced SQL skills and experience with relational
databases and database design like Oracle and SQLSERVER.
· Significant experience working with cloud Data
Warehouse and Data Lake solutions (e.g., Snowflake, Redshift, BigQuery, Azure
Data Lake Storage, Amazon S3, etc.)
· Experience working with data ingestion tools such as
Fivetran, stitch, or Matillion.
· Working knowledge of Cloud-based solutions (e.g.,
Azure, AWS and GCP).
· Experience building and deploying machine learning
models in production.
· Strong proficiency in object-oriented languages:
Python, Java, C++, Scala.
· Strong proficiency in scripting languages like Bash.
· Strong proficiency in data pipeline and workflow
management tools (e.g., Airflow, Azkaban).
· Familiarity with big data frameworks such as Apache
Hadoop and Apache Spark
· Strong project management and organizational skills.
· Excellent problem-solving, communication, and
organizational skills.
· Demonstrated leadership experience and skills
· Ability to communicate effectively and influence technical and business
stakeholders at all levels of the organization
Requirements
Experience in Supply Chain and
Manufacturing Domains - understand the data, the use cases, and the
value it drives rather than just the code"
- Procurement
/ Supplier data
- Inventory
and warehouse management data
- Demand
planning and forecasting
- Production
orders, BOMs, routings
- Shop
floor / MES data
- Quality
systems (defects, CAPA, nonconformance)
Skills Required
- Development, maintenance, and enhancement of Data Pipelines (ETL/ELT) and knowledge of star/snowflake schemas
- Hands-on experience in PowerCenter/IDMC/IICS (Informatica)
- Developing complex SQL queries and SQL optimization
- Full life cycle development experience including requirements gathering, data sourcing, testing/reconciliation, and deployment within BI/Data Warehousing
- Designing and implementing data security
- Monitoring and optimizing data storage and data processing
- Delivering data solutions using cloud technologies
- Advanced SQL skills and experience with relational databases and database design (Oracle, SQL Server)
- Experience with cloud Data Warehouse and Data Lake solutions (Snowflake, Redshift, BigQuery, Azure Data Lake Storage, Amazon S3)
- Experience with data ingestion tools such as Fivetran, Stitch, or Matillion
- Working knowledge of cloud providers (Azure, AWS, GCP)
- Experience building and deploying machine learning models in production
- Proficiency in object-oriented languages: Python, Java, C++, Scala
- Proficiency in scripting languages like Bash
- Proficiency with data pipeline and workflow management tools (Airflow, Azkaban)
- Familiarity with big data frameworks such as Apache Hadoop and Apache Spark
- Strong project management, communication, organizational, and leadership skills
- Experience in Supply Chain and Manufacturing domains (procurement/supplier, inventory/warehouse, demand planning, production orders/BOMs/routings, shop floor/MES, quality systems)
What We Do
Excelencia Consulting is a US-based, ISO 27001:2022-certified technology services provider specializing in Oracle solutions and Digital Engineering. The company provides on-site, offshore, and near-shore software technologies and ERP solutions to small and mid-sized enterprises globally. With a physical presence in the USA, UK, Canada, and India, Excelencia enables smarter operations and future-ready business transformations through its expertise in digital engineering services.








